Learn Advanced T-SQL For SQL Server Administrator
4.3 (31 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
302 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Advanced T-SQL For SQL Server Administrator to your Wishlist.

Add to Wishlist

Learn Advanced T-SQL For SQL Server Administrator

Getting to understand stored procedures
Best Selling
4.3 (31 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
302 students enrolled
Created by Raphael Asghar
Last updated 4/2017
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
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 is the target audience?
  • Any student who want to learn about advanced SQL commands and want to understand development in a little more detail
Students Who Viewed This Course Also Viewed
Curriculum For This Course
34 Lectures
05:15:16
+
This course in designed for students who want to learn about stored procedures
34 Lectures 05:15:16


2 Installing Windows Server OS
13:37

3 Shared folders
06:34

3a Installing SQL 2014
18:15

4 Installing Adventureworks database
04:57

5 What is a Stored Procedures
15:35

6 Modifying and deleting a sproc
04:06

7 Using a single input parameter
07:14

8 Multiple parameters
06:48

9 Blocks multiple sql statements
06:34

10 what is a variable
11:42

11 Demo of Sproc using update.
12:07

12 Demo of Sproc Insert, Print, IF Else and Set Nocount on
14:13

13 Demo of IF Else
11:31

14 Reading a nested if else statement
12:45

15 While loop
11:14

16 Cursors
13:59

17 Transactions
08:58

18 Error handling
14:13

19 Table variables
09:09

20 Derived tables
06:06

21 Views
08:56

22 Excel formula
05:21

23 Intro to CTE
11:06

24 Multiple CTEs
05:15

25 Aggregate cte
04:47

26 Insert delete Update CTE
07:25

27 CTE and sproc
05:16

28 Recursive CTE
08:32

29 vlookup
08:07

30 reviewing sprocs
07:48

31 Stored Procedure permissions
10:58

32 What is Power BI
03:55
About the Instructor
Raphael Asghar
4.6 Average rating
2,131 Reviews
23,117 Students
13 Courses
Production SQL Database Administrator

Worked as a Production SQL Database Administrator for over 12 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA.  I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.