What you'll learn:
Learn all the ways to write and rewrite a join
Discover the power of CTE (Common Table Expression) and partition functions (ROW_NUMBER, OVER PARTITION BY...)
Requirements
Installation of SQL server on his workstation + studio management (SSMS)
Description

✔ Are you familiar with HINT in joints?
✔ Have you heard about the power of ROWS /RANGE UNBOUNDED PRECEDING?
✔ Did you know that a join can be rewritten in several ways?
✏On will cover in this course in the order :
The OVER clause with PARTITION BY
RANKING functions with ROW_NUMBER and NTILE,DENSE_RANK etc...
Aggregation with RANKING functions
LAG and LEAD analytical functions
The little-known ROWS /RANGE UNBOUNDED PRECEDING
The analytical functions FIRST_VALUES and LAST_VALUES
INNER JOIN
LEFT JOIN / RIGHT JOIN
FULL OUTER JOIN
Hints in the joins
EXECPT/ INTERSECT and Update with joints
We will discover a one hour course on CTE (common table expression). So powerful and so little known (I still don't understand by the way) and the derived table.
✅ If you really want to become proficient in TSQL, frankly you won't find anywhere else a course as in-depth as this one...
✅ If you are a regular BI user, this course could be very useful for your SSIS and Powerbi developments.
✅ If you are a developer, this course could help you to develop your TSQL knowledge in depth.
✅ Almost everywhere in the world of SQL, come to this course to discover all the facets and pitfalls to avoid when writing your knuckles.
✅ So come and improve your Transact SQL, in this course you will be welcome.
✅ There will also be exercises to do and correct in this course :)
Who this course is for
Beginners who don't know anything about SQL Server, and who want to get started.
Future Database Administrators (DBAs)
Developers who want to learn about TSQL
BI consultants working on technologies other than SQL Server (Oracle etc...)
Homepage
https://www.udemy.com/course/joins-partition-functions-and-cte-in-transact-sql-2019

Related Downloads :

{related-news}