YoVDO

Learn Advanced T-SQL For SQL Server Administrator

Offered By: Udemy

Tags

SQL Courses Relational Databases Courses Stored Procedures Courses T-SQL Courses Temporary Tables Courses

Course Description

Overview

Getting to understand stored procedures

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.

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.


Taught by

Raphael Asghar

Related Courses

Improving Query Performance in PostgreSQL
DataCamp
Advanced SQL Tutorials
Alex the Analyst via YouTube
Procedimientos almacenados en PostgreSQL (PL/PgSQL)
Udemy
Curso de Base de Datos MariaDB Server
Udemy
Curso de Base de Datos Oracle Database
Udemy