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 :)