Joins, partition functions, and CTE in Transact SQL 2019

3 hours of Transact SQL dedicated to joins and the power of the little known CTE, and function partition

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
⚡⚡ Would you like to benefit from this course for a price between 10 and 15 euros ? Then send me an email to olivtone@yahoo.fr ⚡⚡

✔ 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…)