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

Structured Query Language (SQL) using SAS
SAS via Coursera Data Query with Transact-SQL with Python
Cloudswyft via FutureLearn Microsoft Future Ready: Data Query with Transact-SQL (T-SQL)
Cloudswyft via FutureLearn Write advanced Transact-SQL queries
Microsoft via Microsoft Learn Learn Advanced SQL For Oracle Databases
Udemy