Currently Empty: USD$0.00
🔥 Hot Selling
SQL Advance
Move from writing correct SQL to designing efficient, scalable analytical queries.
Advanced · 3 course parts · 3 capstone projects · Certificate included.
Original price was: USD$50.00.USD$15.99Current price is: USD$15.99. /month
Self-paced online course · SQL Intermediate or equivalent foundation recommended.
Self-paced access
Hands-on SQL practice
SQL Intermediate Course Learning Features
Design Faster SQL
Learn how execution plans, indexing, partitioning and refactoring affect query performance.
Advanced Set & Join Logic
Use FULL JOIN, CROSS JOIN, INTERSECT, EXCEPT and dynamic filtering for reconciliation and comparison.
Advanced Analytics Patterns
Build window functions, recursive CTEs, CASE logic and conditional aggregation for BI reporting.
3 Capstone Projects
Complete one applied project after each part: performance, data reconciliation and executive BI reporting.
Build Advanced SQL Skills for Analytics, BI and Data Engineering
SQL Advance is designed for learners who already understand intermediate SQL and want to move into performance, advanced set logic, scalable query design and analytical reporting.
Skills you'll gain
- Read execution plans and understand scans, seeks and query cost
- Use indexes, partitioning and materialized views to support performance
- Refactor long SQL with chained CTEs
- Apply FULL JOIN, CROSS JOIN, INTERSECT, EXCEPT and dynamic subquery filtering
- Use COUNT OVER, ROW_NUMBER and RANK
- Build recursive CTEs, CASE logic and conditional aggregation for BI reporting
Hands-on learning
- Write and run advanced queries in the built-in AI-assisted SQL editor
- Practise with familiar education-related tables
- Work through performance, reconciliation and reporting problems
- Use the built-in AI tutor for course-specific explanations and guidance
- Complete exactly three capstone projects — one after each course part
Who should take this course
- Learners who have completed SQL Intermediate or equivalent study
- People preparing for data analyst, BI, reporting and data engineering roles
- Learners ready to move from correct SQL to efficient, scalable SQL
Prerequisites
- Comfort with subqueries, CTEs, derived tables, joins and grouped aggregation
- SQL Intermediate is the recommended preceding course
- No prior AI tool experience is required
SQL Advance Curriculum: 3 Advanced Parts
Three parts cover performance and engineering, advanced joins and set logic, and analytics/BI/data-engineering patterns.
Learn how to understand what the database is doing, improve query efficiency and structure complex SQL more cleanly.
- Indexes — search shortcuts for faster lookups
- Execution plans — table scans vs. index seeks
- Query refactoring for readability
- Partitioning — range, list and hash
- Materialized views
- Multi-step queries with chained CTEs
- Capstone 1: Query Performance Audit
Compare datasets, identify gaps, find overlaps, generate combinations and apply pattern-based or dynamic filters.
- FULL JOIN with NULL logic
- CROSS JOIN — every combination
- INTERSECT — what overlaps
- EXCEPT — what is missing
- REGEXP — pattern-based text filtering
- Dynamic subquery filtering
- Capstone 2: Data Gap & Overlap Analysis
Apply advanced analytical patterns for ranking, row-level summaries, recursive logic and BI reporting.
- Window functions — COUNT, ROW_NUMBER and RANK OVER
- CTEs and recursive CTEs
- SQL's logical execution order
- CASE-based conditional logic
- Conditional aggregation for BI reports
- Capstone 3: Executive BI Dashboard Report
3 Hands-On SQL Advance Capstone Projects
Each course part ends with one applied project, giving learners exactly three advanced SQL capstones across the course.
1Part 1
Query Performance Audit
Take slow, poorly structured queries and improve them by reading execution plans, selecting appropriate indexes and refactoring the SQL.
- Execution plans
- Indexing strategy
- Query refactoring
2Part 2
Data Gap & Overlap Analysis
Compare related datasets to identify missing records, overlapping records and inconsistencies using advanced joins, set operators and dynamic filtering.
- FULL JOIN with NULL logic
- INTERSECT & EXCEPT
- Dynamic subquery filtering
3Part 3
Executive BI Dashboard Report
Build a multi-metric analytical report using window functions, CTE logic, CASE expressions and conditional aggregation for BI-ready output.
- Window functions
- Recursive CTEs
- Conditional aggregation
See Inside a Real SQL Advance Lesson
Here is a representative Part 2 example showing how advanced join logic identifies records that are missing from one side of a relationship.
Part 2 · FULL JOIN Logic and Missing Records
A FULL JOIN keeps matched and unmatched rows from both sides. NULL values reveal where a corresponding row is missing. MySQL does not provide a native FULL OUTER JOIN keyword, so a full-outer result is commonly emulated with combinations of LEFT/RIGHT JOIN and UNION when needed.
Analytical question
Question: Which records appear on one side of a comparison but not the other?
SELECT ...
FROM table_a a
LEFT JOIN table_b b ON a.id=b.id
UNION
SELECT ...
FROM table_a a
RIGHT JOIN table_b b ON a.id=b.id
WHERE a.id IS NULL;
The advanced skill is understanding which rows must be preserved, what counts as a match and how NULL values expose gaps.
SQL Advance Course Format, Practice and Certificate
Format100% self-paced, online
Curriculum3 advanced parts
Typical paceAbout 5–7 weeks
AccessOngoing with active subscription
PracticeEmbedded AI-assisted SQL editor
AI TutorIncluded — advanced concept guidance
Capstone Projects3 — one after each part
CertificateCertificate of completion from CiAI
PrerequisitesSQL Intermediate or equivalent foundation
Frequently Asked Questions
SQL Intermediate or equivalent comfort with subqueries, CTEs and derived tables is recommended because SQL Advance builds directly on those techniques.
The course covers indexes, execution plans, query refactoring, partitioning, materialized views, advanced joins and set logic, window functions, recursive CTEs, SQL logical execution order and conditional aggregation.
There are exactly three hands-on capstone projects, one after each course part: Query Performance Audit, Data Gap & Overlap Analysis, and Executive BI Dashboard Report.
Yes. The built-in AI tutor provides course-specific explanations and advanced SQL guidance.
Most learners can work through the three parts in about five to seven weeks. The course is self-paced.
Yes. Learners who complete the course receive a certificate of completion from the Canadian Institute of Artificial Intelligence (CiAI).
The course price shown on this page is US$15.99 per month.
Visit the DataSoSi FAQ page or Contact Us.
Visit the About CiAI page.
Continue Building Your SQL and AI Skills
Meet the Creator of the Course
Learn from an educator who works across data science, machine learning, AI, analytics, and applied business problems.
Dr. Mark Lokanan
Professor · Senior Machine Learning Engineer · Data Scientist · AI Specialist
Dr. Mark Lokanan is a professor at Royal Roads University and a Senior Machine Learning Engineer at Vedia. His work spans data science, machine learning, artificial intelligence, analytics, financial crime, and applied research. Drawing on both academic and industry experience, he designed the SQL Advance course to help learners move from correct SQL into performance-aware query design, advanced data reconciliation, analytical engineering, and BI-ready reporting for data analytics, business intelligence, and technology-focused roles.
SQL Advance Course Assistant
Ask me about SQL Advance: the 3 course parts, 3 capstone projects, indexes, execution plans, partitioning, advanced joins, set logic, window functions, recursive CTEs, CASE, conditional aggregation, prerequisites, certificate, price, enrollment, DataSoSi, or CiAI.