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

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
Gain a deep 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 621 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.

Someone learning on their laptop while sitting on the floor.