Setup Menus in Admin Panel

Home
Course
Course 10: Learn Advanced T – SQL Course

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