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 2/18

00:00/00:00

Lecture 2 of 18

Agenda

Download Course (Free)

Course Content

0 / 18 completed

Section 1: Introduction3 videos

Course introduction

Agenda

3mNow Playing

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

15m

Section 5: Recursions and Cursors2 videos

Recursions

12m

The cursors curse

19m

Section 6: Conclusion1 videos

Conclusion

12m

About this Lecture

Section: Introduction • Size: 6.13 MB • Duration: 3m

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.