MS SQL SERVER (T-SQL) Concepts - Raise above beginner level
- 4.7
-
![]()
![]()
![]()
![]()
![]()
5.5 hours on-demand video
$
11.99
Brief Introduction
Learn XML, Pivot operator, Dynamic Queries, Cursors, CTE's and much more by building 8 Stored Procedures from scratchDescription
Join this course and learn the concepts below by building 8 Stored Procedures
UNDERSTAND and APPLY inside Stored Procedures T-SQL concepts like:
XML Parsing
3 Ways of Creating 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
Master XML selection of Data
Requirements
- Requirements
- Basic SQL knowledge
- SQL Server 2014
- MS SQL SERVER Management Studio
- Adventure Works Database
Stan Silviu Valentin
4.7 Raiting
MS SQL SERVER (T-SQL) Concepts - Raise above beginner level
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Learn XML, Pivot operator, Dynamic Queries, Cursors, CTE's and much more by building 8 Stored Procedures from scratch Join this course and learn the concepts below by building 8 Stored Procedures...
