← Back to courses
SQLIntermediate

SQL Applied

Real-World Business Querying

17 hours76 lessons Self-study
1 viewed this week5.0 (56)
EE
Emmanuel Edegbo

Lead Data Engineer & Architect

About this course

Apply SQL to real business scenarios with complex joins, subqueries, CTEs, and window functions across retail and compliance datasets.

SQL is the universal language of relational data — used in every enterprise data platform from compliance systems to BI tools. It remains foundational because before any insight is built or model trained, data must first be queried correctly.

Who this course is for

  • ✓Career switchers entering data roles — analyst, BI developer, junior data engineer
  • ✓Working professionals who need to query data confidently — PMs, ops, finance, marketing, audit
  • ✓Junior data analysts filling gaps in their SQL fundamentals
  • ✓BI developers who learned reporting tools first and want solid query skills underneath

Who this course is NOT for

  • ✗Experienced data engineers — SQL Core is foundational; start at SQL Applied or SQL Professional
  • ✗Database administrators — this course teaches querying, not server administration
  • ✗Anyone wanting JavaScript, Python, or web-development first — different tracks exist for that

How you'll learn

  • →Each chapter follows the same rhythm: concept → formal syntax → worked example → expected output → hands-on lab
  • →Every lab runs in your browser against the real SalesLT and ComplianceLT datasets — no local install needed
  • →Auto-graded labs give instant feedback; AI-graded Professional Challenges give rubric-based scores in seconds
  • →Module Readiness Checks at the end of every chapter confirm you're solid before moving on
  • →Course discussion lets you ask the instructor and other learners questions inline with each lesson

By the end of this course, you'll be able to

  • ✓Read and write professional SELECT queries against any relational database
  • ✓Filter, sort, group, and aggregate data with confidence
  • ✓Diagnose NULL behaviour, type coercion, and other beginner traps before they bite
  • ✓Combine result sets with UNION and translate business questions into SQL independently
  • ✓Document and defend your queries to non-technical stakeholders

Course at a glance

11
Chapters
76
Lessons
17h
Estimated time
Self-study
Format

Datasets used

SalesLTRetail dataset — products, orders, customers, pricing. Used for revenue analysis and customer-segmentation examples.
ComplianceLTBanking compliance dataset — accounts, transactions, risk ratings, alerts. Used for risk-monitoring and reconciliation examples.

Tools you'll need

  • •SQL Server Management Studio (Windows)
  • •DBeaver Community Edition (Windows / macOS / Linux)

What you get when you enrol

  • ✓Lifetime access to every lesson, exercise, and update — including future revisions to this course.
  • ✓12-month Azure SQL practice access against the same datasets used in the course (read-only). Renews on request for active learners.
  • ✓Auto-graded labs in your browser — write SQL, hit Run, get instant feedback against the expected result.
  • ✓AI-graded Professional Challenges — open-ended scenarios reviewed against a published rubric, not just a single right answer.
  • ✓Course discussion + community — talk to other learners and ask the instructor questions inside the course.
  • ✓Basic Certificate on demonstrated capability — awarded when you complete every Hands-On Lab and Module Readiness Check, plus the Professional Challenges. Confirms you can write, run, and defend course-level SQL against real datasets.
  • ✓Optional Advanced Certificate on completion of SQL Core multi-project— a separate credential awarded when you complete all three capstone projects, each independently assessed and approved by an instructor. Each project is end-to-end query engineering against a real brief with defined acceptance criteria — proves competence at a level an employer can actually evaluate. The Basic Certificate alone confirms course mastery; the Advanced Certificate confirms you can deliver.
  • ✓Optional live training upgrade — instructor-led cohort sessions with capped capacity, sold separately.

What you'll learn

  • ✓Write complex multi-table queries for business reporting
  • ✓Use window functions (ROW_NUMBER, RANK, LAG, LEAD, running totals)
  • ✓Build recursive CTEs for hierarchical data
  • ✓Apply PIVOT and UNPIVOT for data reshaping
  • ✓Use MERGE for upsert operations
  • ✓Complete a real-world capstone project against the unfamiliar HRPro schema — an HR Data Quality Audit using the full eleven-table model

Who this is for

Software testersBusiness analystsData analystsData engineersCyber security professionalsData scientists

Curriculum

76 lessons · 17h 25m
1. SQL Investigation Framework7 lessons
2. Data Models & Schema Diagrams7 lessons
3. JOIN Types10 lessons
4. Aggregate Functions8 lessons
5. NULL Handling9 lessons
6. Date Functions8 lessons
7. Type Conversion7 lessons
8. Views8 lessons
9. Investigation Query Patterns9 lessons
10. Capstone Project — HRPro HR Data Quality Audit2 lessons
11. SQL Applied Cheat Sheet1 lessons

Prerequisites

  • •SQL Core or equivalent foundation in SQL

What learners say

How ratings work
5.0
56 ratings (time-weighted)
  1. 5★
    56
  2. 4★
    0
  3. 3★
    0
  4. 2★
    0
  5. 1★
    0

Course discussion

Open to enrolled learners

Sign in to read and post in the course discussion.

Sign in