Advanced SQL: Logical Query Processing, Part 2

Go to class

Write Review

Free Online Course: Advanced SQL: Logical Query Processing, Part 2 provided by LinkedIn Learning is a comprehensive online course, which lasts for 2-3 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Advanced SQL: Logical Query Processing, Part 2 is taught by Ami Levin.

via LinkedIn Learning

2-3 hours worth of material

Self Paced

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

0, based on 0 Course votes at GetYourEducation

4.9, based on 174 Course reviews at LinkedIn Learning

Start your review of Advanced SQL: Logical Query Processing, Part 2

Add review ->

Language

English
Certificate
Certificate Available
Date of Start
21st September, 2020
Price
Free Trial Available
Provider
LinkedIn Learning
Taught By

Ami Levin
Share this course

Advanced SQL: Logical Query Processing, Part 2

ANIMATIONs

Adobe Lightroom Classic Fundamentals

Build, Train, and Deploy ML Pipelines using BERT

English for Research Publication Purposes

English for Research Publication Purposes

Introduction to Bohemian Watercolor Techniques