Learn Advanced T-SQL For SQL Server Administrator

Name: Learn Advanced T-SQL For SQL Server Administrator
Rating: 4.3 (1046 reviews)

Getting to understand stored procedures

Created byRaphael Asghar

Last updated 4/2017

English

What you'll learn

The student will learn about stored procedures, If Else, While Loop, cursors, derived tables, CTEs, sproc permissions, temp tables, sproc parameters and much more. The student at the end of this course will gain valuable information about sprocs and how to read and follow them in the production environment.

Course content

1 section • 34 lectures • 5h 15m total length

Table of contents7:19
1 Download all software needed10:54
2 Installing Windows Server OS13:37
3 Shared folders6:34
3a Installing SQL 201418:15
4 Installing Adventureworks database4:57
5 What is a Stored Procedures15:35
6 Modifying and deleting a sproc4:06
7 Using a single input parameter7:14
8 Multiple parameters6:48
9 Blocks multiple sql statements6:34
10 what is a variable11:42
11 Demo of Sproc using update.12:07
12 Demo of Sproc Insert, Print, IF Else and Set Nocount on14:13
13 Demo of IF Else11:31
14 Reading a nested if else statement12:45
15 While loop11:14
16 Cursors13:59
17 Transactions8:58
18 Error handling14:13
19 Table variables9:09
20 Derived tables6:06
21 Views8:56
22 Excel formula5:21
23 Intro to CTE11:06
24 Multiple CTEs5:15
25 Aggregate cte4:47
26 Insert delete Update CTE7:25
27 CTE and sproc5:16
28 Recursive CTE8:32
29 vlookup8:07
30 reviewing sprocs7:48
31 Stored Procedure permissions10:58
32 What is Power BI3:55

Requirements

Before taking this course, you must take the prerequisite Learn T-SQL from Scratch. While not mandatory, you should take the FREE Ultimate in Becoming a SQL DBA course as this will help you set up the environment.

Description

The student will learn about stored procedures, If Else, While Loop, cursors, derived tables, CTEs, sproc permissions, temp tables, sproc parameters and much more. The student at the end of this course will gain valuable information about sprocs and how to read and follow them in the production environment. In addition, the student will be given examples of block statements, transactions commands, recursive CTEs, error handling, variables, and much more. This course will greatly help those students that want to understand how to read, modify, and execute from simple to complex stored procedures. By creating stored procedures, the developer has greater control in the execution of SQL commands, permissions, and greater flexibility in updating the sproc.

Who this course is for:

Any student who want to learn about advanced SQL commands and want to understand development in a little more detail