MS SQL SERVER (T-SQL) Concepts - Raise above beginner level - Udemy
Doelgroep:
Alle niveaus
Duur: 74 colleges - 5,5 uur
Richtprijs: € 19,99
Taal: Engels
Aanbieder: Udemy
Duur: 74 colleges - 5,5 uur
Richtprijs: € 19,99
Taal: Engels
Aanbieder: Udemy
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