Course 10: Learn Advanced T – SQL Course
15 STUDENTS ENROLLED
The following course will take you step by step in learning Advanced Transact-SQL (T-SQL) language which is mandatory for anyone who is responsible for SQL Server. The course will cover the following:
- What are stored procedures?
- Where they are stored
- The advantages of using stored procedures
- Creating and understanding the ‘chunks’ of SQL code that make up a stored procedure
- Executing the stored procedure and much more
- By the end of this course, the student will gain a better understanding of how to read and apply sprocs
- Prerequisite for this course is Course 2: Learn T – SQL From Scratch!
Course Curriculum
1. Learn Advanced T-SQL Docs & Scripts | |||
Learn Advanced T-SQL Docs & Scripts | 00:00:00 | ||
2. Table of Contents | |||
Table of Contents | 00:00:00 | ||
3. Download all Software Needed | |||
Download all Software Needed | 00:00:00 | ||
4. Installing Windows Server OS | |||
Installing Windows Server OS | 00:00:00 | ||
5. Configuring Shared Folders | |||
Configuring Shared Folders | 00:00:00 | ||
6. Installing SQL 2014 | |||
Installing SQL 2014 | 00:00:00 | ||
7. Installing Adventure Works Database | |||
Installing Adventure Works Database | 00:00:00 | ||
8. What is a Stored Procedures? | |||
What is a Stored Procedures? | 00:00:00 | ||
9. Modifying and Deleting a Stored Procedure | |||
Modifying and Deleting a Stored Procedure | 00:00:00 | ||
10. Using a Single Input Parameter | |||
Using a Single Input Parameter | 00:00:00 | ||
11. Using Multiple Input Parameter | |||
Using Multiple Input Parameter | 00:00:00 | ||
12. Blocks Multiple SQL Statements | |||
Blocks Multiple SQL Statements | 00:00:00 | ||
13. What are Variables? | |||
What are Variables? | 00:00:00 | ||
14. Demo of Sproc Using Update | |||
Demo of Sproc Using Update | 00:00:00 | ||
15. Demo of Sproc Insert, Print, IF Else, Set Nocount on | |||
Demo of Sproc Insert, Print, IF Else and Set Nocount on | 00:00:00 | ||
16. Demo of IF Else | |||
Demo of IF Else | 00:00:00 | ||
17. Reading a Nested if else Statement | |||
Reading a Nested if else Statement | 00:00:00 | ||
18. SQL While loop | |||
SQL While loop | 00:00:00 | ||
19. SQL Cursors | |||
SQL Cursors | 00:00:00 | ||
20. SQL Transactions | |||
SQL Transactions | 00:00:00 | ||
21. SQL Error Handling | |||
SQL Error Handling | 00:00:00 | ||
22. SQL Table Variables | |||
SQL Table Variables | 00:00:00 | ||
23. SQL Derived Tables | |||
SQL Derived Tables | 00:00:00 | ||
24. SQL Views | |||
SQL Views | 00:00:00 | ||
25. An important Excel Formula | |||
An important Excel Formula | 00:00:00 | ||
26. Introduction to CTE | |||
Introduction to CTE | 00:00:00 | ||
27. Multiple CTEs | |||
Multiple CTEs | 00:00:00 | ||
28. Aggregate CTE | |||
Aggregate CTE | 00:00:00 | ||
29. Insert Delete Update CTE | |||
Insert Delete Update CTE | 00:00:00 | ||
30. CTE and Sproc | |||
CTE and Sproc | 00:00:00 | ||
31. Recursive CTE | |||
Recursive CTE | 00:00:00 | ||
32. An Important Excel VLOOKUP Formula | |||
An Important Excel VLOOKUP Formula | 00:00:00 | ||
33. Reviewing Sprocs | |||
Reviewing Sprocs | 00:00:00 | ||
34. Stored Procedure Permissions | |||
Stored Procedure Permissions | 00:00:00 | ||
35. What is Power BI? | |||
What is Power BI? | 00:00:00 |