![Joins, partition functions, and CTE in Transact SQL 2019]()
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 41 lectures (2h 51m) | Size: 1.94 GB
Discover the power of CTE (Common Table Expression) and partition functions (ROW_NUMBER, OVER PARTITION BY.
3 hours of Transact SQL dedicated to joins and the power of the little known CTE, and function partition
Learn all the ways to write and rewrite a join
..)
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
⚡⚡
✔ 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 :)
Bners 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...)
DOWNLOADuploadgigrapidgatornitroflare