Watch Advanced SQL: Logical Query Processing, Part 2 Free Online - Full Video Classroom | MJ Accedemy

LinkedIn – Advanced SQL: Logical Query Processing, Part 2 2024-12

Download Course (Free)

Lecture 15/18

00:00/00:00

Lecture 15 of 18

Solution

Download Course (Free)

Course Content

0 / 18 completed

Section 1: Introduction3 videos

Course introduction

Agenda

Setting expectations

Section 2: Subqueries and Set Operators4 videos

Subqueries

14m

Set operators

13m

Challenge

Solution

11m

Section 3: Advanced Joins4 videos

Self and inequality joins

13m

Lateral joins

Challenge

Solution

Section 4: More on Grouping4 videos

Ordered set functions

20m

Grouping sets

17m

Challenge

Solution

15mNow Playing

Section 5: Recursions and Cursors2 videos

Recursions

12m

The cursors curse

19m

Section 6: Conclusion1 videos

Conclusion

12m

About this Lecture

Section: More on Grouping • Size: 33.93 MB • Duration: 15m

Course Summary

Advanced SQL: Logical Query Processing, Part 2. This course helps you understand the fundamental concepts of SQL and avoid common pitfalls in the development process. This course is the second in a series of tutorials that will help you understand the fundamental concepts of SQL and avoid common pitfalls in the development process. Course instructor, Ami Levin, teaches you how to fully understand SQL logical query processing. In this course, you will learn how expression, table, and row subqueries are processed, implement self joins and lateral joins, and use recursive WITH clauses.