Learn Advanced T-SQL For SQL Server Administrator
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
- Preview07:19
- Preview10:54
- 13:372 Installing Windows Server OS
- 06:343 Shared folders
- 18:153a Installing SQL 2014
- 04:574 Installing Adventureworks database
- 15:355 What is a Stored Procedures
- 04:066 Modifying and deleting a sproc
- 07:147 Using a single input parameter
- 06:488 Multiple parameters
- 06:349 Blocks multiple sql statements
- 11:4210 what is a variable
- 12:0711 Demo of Sproc using update.
- 14:1312 Demo of Sproc Insert, Print, IF Else and Set Nocount on
- 11:3113 Demo of IF Else
- 12:4514 Reading a nested if else statement
- 11:1415 While loop
- 13:5916 Cursors
- 08:5817 Transactions
- 14:1318 Error handling
- 09:0919 Table variables
- 06:0620 Derived tables
- 08:5621 Views
- 05:2122 Excel formula
- 11:0623 Intro to CTE
- 05:1524 Multiple CTEs
- 04:4725 Aggregate cte
- 07:2526 Insert delete Update CTE
- 05:1627 CTE and sproc
- 08:3228 Recursive CTE
- 08:0729 vlookup
- 07:4830 reviewing sprocs
- 10:5831 Stored Procedure permissions
- 03:5532 What is Power BI
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
Instructor
Worked as a Production SQL Database Administrator and developer for over 15 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.