Setup Menus in Admin Panel

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
top
© Copyright by Rafacademy@2016