Using SQL, correlated subqueries, CTEs, Pivots, UDFs and Sequences. SQL Server 2012 to 2017 (inc. 70-761).
(
ratings )
21
students
Created by
June 30, 2021
1 week, 3 days
What you'll learn
-
Learn all about subqueries, using them in the SELECT, FROM and WHERE clauses.
-
Learn about correlated subqueries, where the results of the subquery depends on the main query.
-
Learn about Common Table Expressions (CTE), using the WITH statement.
-
Use ROW_NUMBER, LAG and CTEs to group consecutive numbers.
-
Learn about PIVOT and UNPIVOT to spread data across columns.
-
Find out all about functions, including UDFs (user defined functions): scalar, inline table and multi-statement table functions
-
"Join" the functions into tables using the CROSS APPLY and OUTER APPLY.
-
Learn about synonyms, dynamic SQL and SQL injection.
-
Find out about uniqueidentifiers (NEWID and NEWSEQUENTIALID functions), and create and use Sequences.
Requirements
-
You need to know about data types and functions, SELECT queries, and ranking functions.
-
If you don't, then you should take my earlier Sessions first.
-
There is a 30-day money back guarantee of this Udemy course.
-
Why not have a look at the curriculum below and see what you can learn?
