Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Advanced SQL: Logical Query Processing, Part 1

via LinkedIn Learning

Write review
DataCamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More → Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Gain a deeper understanding of how the database processes SQL queries; improve your programming skills; and learn to effortlessly read, write, and troubleshoot SQL queries.

Syllabus

Introduction
  • Course introduction
  • Course agenda
  • Tooling
  • Introducing the demo database
  • Using the code files
1. Constructing Query Source Data Sets
  • Single data source queries
  • Dual source query processing
  • Joining multiple source data sets
  • Challenge: Hybrid multi-table join
  • Solution: Hybrid multi-table join
2. Row Filters
  • Filtering source rows
  • Missing information and ternary logic
  • Dealing with ternary logic in SQL
3. Grouping
  • Grouping
  • Dealing with NULLs and elimination duplicates
  • Group filters
  • Challenge: Filtering and grouped query
  • Solution: Grouped query with Distinct
4. Ordering and Paging
  • Presentation ordering in multitier architecture
  • Ordering result sets
  • Paging result sets
Conclusion
  • Course review and takeaway
  • Feedback and additional resources

Taught by

Ami Levin

Reviews

4.7 rating at LinkedIn Learning based on 1665 ratings

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.