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

4ever-clojure
Independent Mastering Programming with MATLAB
Vanderbilt University via Coursera Advanced Relational Database and SQL
Coursera Project Network via Coursera 算法设计与分析 Design and Analysis of Algorithms
Peking University via Coursera 算法基础 | Fundamental Algorithms
Peking University via edX