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.

⚡⚡ Would you like to benefit from this course for a price between 10 and 15 euros ? Then send me an email to [email protected] ⚡⚡

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

Course Content

  • Let’s Set Up our working environment installing Management Studio and SQL Server –> 5 lectures • 20min.
  • Learn to combine data with the power of JOINS –> 9 lectures • 56min.
  • Exercise on the joins –> 9 lectures • 4min.
  • Correction Exercise 1 to 8 on the joins –> 1 lecture • 8min.
  • Let’s discover the little known CTE (common table expression) and derived table –> 8 lectures • 28min.
  • Let’s discover the power of the Ranking functions –> 9 lectures • 55min.

Joins, partition functions, and CTE in Transact SQL 2019.

Requirements

  • Installation of SQL server on his workstation + studio management (SSMS).

⚡⚡ Would you like to benefit from this course for a price between 10 and 15 euros ? Then send me an email to [email protected] ⚡⚡

✔ 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 🙂