Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

SQL SERVER Procedures&Concepts - Raise Above Beginner Level

Name: SQL SERVER Procedures&Concepts - Raise Above Beginner Level
Rating: 4.5 (203 reviews)

Build Stored Procedures, Dynamic Queries, Clauses, Pivot Operator, XML parsing, building Database templates and others

Created byStan Silviu Valentin

Last updated 1/2025

English

What you'll learn

Understand the concept of a Stored Procedure in a practical manner and embed inside of it other concepts like:
Cursors, Dynamic Queries, Pivots, XML Parsing, Clauses and others
Gain programming creativity
Build self-confidence in working with Stored Procedures and advanced concepts

Course content

15 sections • 79 lectures • 5h 37m total length

Introduction4:02
Develop practical sql server procedures by building from scratch, explaining syntax and functionality, and wiring a three-table relational database with a junction table for many-to-many relationships.

What is Dynamic Query3:26
Procedure 1 Scenario1:01
Visualizing data1:25
Creating the logic of the procedure2:41
Creating the logic of the procedure - 21:35
Setting up body of the Procedure2:30
Setting up input parameters1:04
Create IF ELSE Block3:56
Completing our IF ELSE Logic2:26
Setting up Dynamic Query2:11
Placing Parameter inside Dynamic Query1:29
Learn to TRIM your input parameters2:44
Bind Parameter and execute Dynamic Query3:08
Testing the final product2:09

What is a temporary table ?5:23
Discover how temporary tables in SQL Server act as regular tables with short lifetimes, created with a hashtag, populated via select into, and reused for holding limited results.
What is a Cursor ?4:10
Procedure 3 - Scenario1:18
Setting up the steps of the Procedure2:39
Learn to set up a SQL Server procedure by creating a temporary table and a normal table for cursor output, plus a dynamic query with fixed and dynamic parts.
Understanding comparison operators inside XML3:16
Setting up our #tempTables1:38
Data structure and JOINS for our Dynamic Query5:12
Create variables for Cursor3:44
Creating the body of the Cursor10:50
Setting up Cursor4:47
Setting up Dynamic Query inside the Cursor6:00
Understanding quotes inside dynamic query10:29
Learn how to build and execute dynamic SQL in SQL Server, escape quotes, and manage string literals within a dynamic query using variables and placeholders.
Testing our procedure with Debug Mode8:06
Explain SQL Injection in relation to Dynamic Query6:11

Procedure 4 Scenario2:03
Create a SQL Server procedure to delete old transactions by date, archive them in a temp table, and capture the highest stock quantity for each deleted row using outer apply.
Setting up the steps of the Procedure3:16
Create a five-step SQL Server procedure to select data older than transaction date, populate temp tables, declare a cursor, delete records, and fetch the highest stock quantity via outer apply.
Selecting data with input parameter - learn CONVERT()3:37
Setting body of the Cursor2:24
Use OUTPUT clause inside Cursor5:03
Learning OUTER APPLY concept7:16
Testing final product and more about OUTER and CROSS APPLY5:31

Requirements

Basic SQL knowledge
SQL Server 2014
MS SQL SERVER Management Studio
Adventure Works Database

Description

Join this course and learn the concepts below by building 8 Stored Procedures.

First of all, learn how to build Stored Procedures, then, slowly add logic and functionality according to real-life scenarios that you are asked to complete as an SQL Server Developer.

The entire course is designed so that it explains every line of code that is written and also get a good knowledge of all the added Transact constructs, in a practical approach.

More or less, the T-SQL concepts that we will be working with and the constructs (like Stored Procedures) are probably the main features that you'll be using in your planned career either you choose to become a SQL developer or a Web Developer/App Developer.

Not the last, the 8th Stored Procedure will create with a click of a button a fully Many-to-Many relational database, so that means will also be dealing with concepts like PK, FK and Identity Incrementation.

As a summary, please read below some of the main subjects that this course deals with, and remember, you can freely browse the course for 30 days, because, if it is not what you searched for, you can ask a refund.

UNDERSTAND and APPLY inside Stored Procedures T-SQL concepts like:

3 Ways of Creating Dynamic Queries

Execute Dynamic Queries

The concept and utility of Cursors

SQL Server Pivot Operator

ROW_NUMBER() and create multiple Partitions

UPDATE with JOIN inside the same query

OUTPUT clause, OUTER and CROSS APPLY

Create with a Procedure Many-to-Many relational database

XML Parsing and master XML selection of Data

Who this course is for:

SQL Server students that have a basic knowledge and wish to rise above beginner level
Students that wish to become SQL Developers or good Web/App Developers

SQL SERVER Procedures&Concepts - Raise Above Beginner Level

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 4min

Procedure 1 - Dynamic Query warm up14 lectures • 32min

QUIZ No. 10

Procedure 2 - XML as input parameter8 lectures • 30min

QUIZ No. 20

Procedure 3 - XML , Dynamic and Cursor14 lectures • 1hr 14min

Quiz No. 30

Procedure 4 - OUTPUT , OUTER & CROSS APPLY and again Cursor7 lectures • 29min

Quiz No. 40

Procedure 5 - Output XML and UPDATE with JOIN clause5 lectures • 19min

Requirements

Description

Who this course is for: