2. INNER and OUTER Joins + [EXERCISES].mp4 (40.7 MB)
2. INNER and OUTER Joins + [EXERCISES].vtt (31.0 KB)
3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].mp4 (21.0 MB)
3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].vtt (18.5 KB)
4. Cartesian Product with the CROSS JOIN.mp4 (11.6 MB)
4. Cartesian Product with the CROSS JOIN.vtt (8.1 KB)
5. [EXERCISES] Joins and Subqueries Continued.mp4 (27.4 MB)
5. [EXERCISES] Joins and Subqueries Continued.vtt (20.3 KB)
6. Creating Views vs. Inline Views.mp4 (80.4 MB)
6. Creating Views vs. Inline Views.vtt (11.7 KB)
7. ADVANCED Problems using Joins, Grouping and Subqueries.html (0.1 KB)
[Tutorialsplanet.NET].url (0.1 KB)
Description
Udemy - Master SQL For Data Science [TP]
This course will turn you into a SQL query wizard. You’ll learn the skills you need to extract critical insight from data sitting in a database. There are over 100 puzzles scattered throughout the course with in-depth solutions providing plenty of opportunity for you to practice. After completing the course and all of it’s assignments, I promise you, you’ll never be afraid to look at a large SQL query again.
Just like my other courses, I follow the no-student-left behind principle; which means that I start from the very basics. You do not need any prerequisites to take this course. We move step by step into more advanced topics as we delve into the world of advanced querying techniques using subqueries, aggregations, joins, rollups and cubes, window functions, transposing & ranking data and using conditional expressions in very interesting ways.
As always I offer a 30 day money back guarantee but I doubt you’ll need it.