Advanced SQL: Logical Query Processing, Part 2

Offered By: LinkedIn Learning

Course Description

Overview

Take your SQL skills to the next level. Continue learning about aspects of logical query processing: from subqueries to ordered set functions, and from lateral joins to cursors.

Syllabus

Introduction

Course introduction
Agenda
Setting expectations

1. Subqueries and Set Operators

Subqueries
Set operators
Challenge
Solution

2. Advanced Joins

Self and inequality joins
Lateral joins
Challenge
Solution

3. More on Grouping

Ordered set functions
Grouping sets
Challenge
Solution

4. Recursions and Cursors

Recursions
The cursors curse

Conclusion

Conclusion

Taught by

Ami Levin

Related Courses

程序设计实习 / Practice on Programming
Peking University via Coursera 程序设计基础
Peking University via edX 算法基础
Peking University via Coursera Principles of Computing (Part 2)
Rice University via Coursera 算法设计与分析 Design and Analysis of Algorithms
Peking University via Coursera