MS SQL

Teacher

admin

Practical Excercises

1. Mini project - create website for realestate

2. Create a Content Type such as EmployeeDetailsCT and add the EmployeeSalaryDetailSC

3. Create a link list to store your Links

4. Create Data Sheet View

5. Enable List Item ranking via Likes and Rating Scales

6. Business Connectivity Services and External Content Types

7. Explore External Content Types

8. Create a new External Content Type

9. Create an External List

10. Setup and Configure Permissions for External List

11. Add items to an External List

12. Create a list for Team Meeting

13. Start Time ?

14. End Time ?

15. Description ?

16. Category ?

17. Recurrence ?

18. Create Multiple item with different events and timimgs

19. Create Calendar named Holidays with at least 1 event in it

20. Create Calendar named Meetings with at least 1 event in it

21. Roll up your project calendar with other project calendars and even color-code

22. Create a Weekend Holiday Calendar List and repeat it for all the weekends

23. Create a task list

24. How to display a task list on a master calendar

25. View your tasks with GANTT chart view

26. Subscribe your item with RSS Feed

27. Creating Promoted Links App

28. Set Images for each Promoted Links

29. Create a Document Library

30. Create Documents and Folders

31. Explore Callouts

32. Uploading Documents

33. Create a version each time you edit an item in the list.

34. Limit the number of versions and drafts to retain.

35. Set who can see draft items in the list.

36. Find out how to copy files from Windows Explorer to the folder of the SharePoint Document library

37.

Description
Curriculum

Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. It’s one of the three market-leading database technologies, along with Oracle Database and IBM’s DB2.
Like other RDBMS software, Microsoft SQL Server is built on top of SQL, a standardized programming language that database administrators (DBAs) and other IT professionals use to manage databases and query the data they contain. SQL Server is tied to Transact-SQL (T-SQL), an implementation of SQL from Microsoft that adds a set of proprietary programming extensions to the standard language.

Between 1995 and 2016, Microsoft released 10 versions of SQL Server. Early versions were aimed primarily at departmental and workgroup applications, but Microsoft expanded SQL Server’s capabilities in subsequent ones, turning it into an enterprise-class relational DBMS that could compete with Oracle Database, DB2 and other rival platforms for high-end database uses. Over the years, Microsoft has also incorporated various data management and data analytics tools into SQL Server, as well as functionality to support new technologies that emerged, including the web, cloud computing and mobile devices.

Take our SQL Server courses – and take your skills to a whole new level as how to implement and manage database solutions, migrate to the cloud with the ability to scale on demand, work with powerful reporting features, and see how SQL Server integrates with SharePoint and Other Technologies.

Course Features

Lectures 13 hours
Duration 6h 20m
Practical 24 hours
Language English

SQL Query Fundamentals 0/4
- Lecture1.1
  
  A history of SQL and T-SQL
  
  3m
  
  Locked
- Lecture1.2
  
  An introduction to relational theory
  
  3m
  
  Locked
- Lecture1.3
  
  To use standards or not
  
  2m
  
  Locked
- Lecture1.4
  
  Understanding processing stages
  
  6m
  
  Locked
Query the Database 0/4
- Lecture2.1
  
  Querying a table with SELECT
  
  9m
  
  Locked
- Lecture2.2
  
  Using aliases in your SELECT statements
  
  5m
  
  Locked
- Lecture2.3
  
  Using string concatenation
  
  8m
  
  Locked
- Lecture2.4
  
  Using CASE expressions
  
  5m
  
  Locked
Filtering Results 0/5
- Lecture3.1
  
  Filtering duplicates with DISTINCT
  
  5m
  
  Locked
- Lecture3.2
  
  Introducing the WHERE clause
  
  6m
  
  Locked
- Lecture3.3
  
  WHERE clause relational operators
  
  8m
  
  Locked
- Lecture3.4
  
  Filtering text
  
  7m
  
  Locked
- Lecture3.5
  
  Working with NULL
  
  7m
  
  Locked
Querying Multiple Tables 0/4
- Lecture4.1
  
  Understanding normalization
  
  7m
  
  Locked
- Lecture4.2
  
  Understanding table relationships
  
  5m
  
  Locked
- Lecture4.3
  
  Understanding joins
  
  5m
  
  Locked
- Lecture4.4
  
  Using joins in a query
  
  9m
  
  Locked
Grouping and Sorting 0/5
- Lecture5.1
  
  Understanding order
  
  5m
  
  Locked
- Lecture5.2
  
  Sorting results with ORDER BY
  
  10m
  
  Locked
- Lecture5.3
  
  Grouping results with GROUP BY
  
  10m
  
  Locked
- Lecture5.4
  
  Using the TOP option
  
  11m
  
  Locked
- Lecture5.5
  
  Using aggregates
  
  10m
  
  Locked
Querying with Data Type Considerations 0/3
- Lecture6.1
  
  Queries using date and time
  
  17m
  
  Locked
- Lecture6.2
  
  Queries using character data types
  
  9m
  
  Locked
- Lecture6.3
  
  Queries using character functions
  
  17m
  
  Locked
Subqueries and Table Expressions 0/4
- Lecture7.1
  
  Writing subqueries
  
  9m
  
  Locked
- Lecture7.2
  
  Using EXISTS
  
  5m
  
  Locked
- Lecture7.3
  
  Introducing views
  
  9m
  
  Locked
- Lecture7.4
  
  Introducing common table expressions
  
  7m
  
  Locked
Programming with T-SQL 0/4
- Lecture8.1
  
  Understanding stored procedures
  
  9m
  
  Locked
- Lecture8.2
  
  Understanding T-SQL programming elements
  
  17m
  
  Locked
- Lecture8.3
  
  Implementing transactions
  
  7m
  
  Locked
- Lecture8.4
  
  Error handling
  
  8m
  
  Locked
Query Performance 0/2
- Lecture9.1
  
  Introducing query execution plans
  
  9m
  
  Locked
- Lecture9.2
  
  Viewing index usage and statistics
  
  10m
  
  Locked
Uses of triggers function and procedure 0/4
- Lecture10.1
  
  Comparing triggers, functions, and procedures
  
  3m
  
  Locked
- Lecture10.2
  
  Why use a stored procedure-
  
  5m
  
  Locked
- Lecture10.3
  
  Why use functions-
  
  1m
  
  Locked
- Lecture10.4
  
  Why use triggers-
  
  1m
  
  Locked
Stored Procedures 0/7
- Lecture11.1
  
  Creating a stored procedure
  
  3m
  
  Locked
- Lecture11.2
  
  Modifying a stored procedure
  
  3m
  
  Locked
- Lecture11.3
  
  Returning data using data sets
  
  4m
  
  Locked
- Lecture11.4
  
  Using input and output parameters
  
  5m
  
  Locked
- Lecture11.5
  
  Returning data using cursors
  
  3m
  
  Locked
- Lecture11.6
  
  Using security and permissions
  
  5m
  
  Locked
- Lecture11.7
  
  Using transactions
  
  3m
  
  Locked
User-Defined Functions 0/3
- Lecture12.1
  
  Creating a user-defined function
  
  5m
  
  Locked
- Lecture12.2
  
  Exploring single-value functions
  
  4m
  
  Locked
- Lecture12.3
  
  Exploring table value functions
  
  3m
  
  Locked
Triggers 0/4
- Lecture13.1
  
  Using -after- triggers
  
  4m
  
  Locked
- Lecture13.2
  
  Using -instead of- triggers
  
  2m
  
  Locked
- Lecture13.3
  
  Using nested triggers
  
  2m
  
  Locked
- Lecture13.4
  
  Using database-level triggers
  
  2m
  
  Locked
T-SQL statement 0/3
- Lecture14.1
  
  Exploring a real-world INSERT procedure
  
  5m
  
  Locked
- Lecture14.2
  
  Exploring a real-world UPDATE procedure
  
  3m
  
  Locked
- Lecture14.3
  
  Implementing logging on DELETE
  
  4m
  
  Locked
Using CLR Assemblies 0/5
- Lecture15.1
  
  Understanding the Common Language Runtime (CLR) and the .NET framework
  
  2m
  
  Locked
- Lecture15.2
  
  Using CLR with SQL Server 2012
  
  4m
  
  Locked
- Lecture15.3
  
  Writing stored procedures with C# .NET
  
  5m
  
  Locked
- Lecture15.4
  
  Writing functions with .NET
  
  5m
  
  Locked
- Lecture15.5
  
  Choosing between T-SQL vs. CLR
  
  3m
  
  Locked
Exploring an ASP.NET Web Application 0/4
- Lecture16.1
  
  Creating a basic web form and connecting to a database
  
  3m
  
  Locked
- Lecture16.2
  
  Executing a stored procedure
  
  2m
  
  Locked
- Lecture16.3
  
  Passing parameters
  
  4m
  
  Locked
- Lecture16.4
  
  Getting return values
  
  3m
  
  Locked