Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Learn Advanced T-SQL For SQL Server Administrator

Getting to understand stored procedures
4.4
4.4/5
(694 reviews)
4,649 students
Created by

7.3

CourseMarks Score®

3.8

Freshness

8.7

Feedback

8.9

Content

Platform: Udemy
Video: 5h 15m
Language: English
Next start: On Demand

Table of contents

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.

You will 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.

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.

This course is for

• Any student who want to learn about advanced SQL commands and want to understand development in a little more detail
Production SQL Database Administrator
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.
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 5h 15m
Language: English
Next start: On Demand

Students are also interested in