Building and executing stored procedure in SQL

Learn SQL Server programming from scratch and create useful and powerful stored procedures

Created by: Enrique Valencia
Student at Udemy

What Will I Learn?

• Stored procedure fundamentals
• Using parameters in stored procedure
• variables
• Output parameters and return values
• IF statements
• WHILE loops
• User defined functions
• Temporary tables
• Table variables
• Table valued functions
• Common table expressions
• Dynamic SQL
• Transactions
• DML triggers
• DDL triggers

Requirements

• You will need to have SQL Server installed (2012 or above).
• You will need to restore AdventureWorks sample database (any OLTP versions)
• A familiarity with Microsoft SQL Server
• Basic SQL Querying
• No programming experience needed

Target audience

• Database Developers
• Database Administrators
• Anyone who wants to learn SQL Programming