Understand tables, columns, rows, keys, and relationships.
School of Data & AIData AnalyticsBeginner to Intermediate
SQL for Data Analytics
Query databases, join tables, summarize records, and uncover business insights with SQL.
Learn how to retrieve, filter, join, group, and analyze data from relational databases so you can answer real business questions and prepare data for reports, dashboards, and deeper analysis.
Duration
7 weeks - 6-8 hours/week
Project
Understand tables, columns, rows, keys, and relationships.
Support
Mentorship and review options available
Overview
A practical Short Course built around a visible project.
Learn the SQL skills data analysts use to extract, filter, join, group, and analyze data from relational databases.
Write SQL queries to retrieve business data.
Filter, sort, and structure query results.
Join data across multiple tables correctly.
Use aggregation to summarize performance.
Apply CASE statements for business logic.
Use subqueries and common table expressions.
Analyze customer, revenue, product, transaction, and operations data.
Prepare SQL outputs for Excel, Python, and Power BI.
Build portfolio-ready SQL analytics projects.
Course roadmap
What you will work through.
The sequence below is specific to this course. It shows the phases, modules, lessons, and page outlines that move you toward Understand tables, columns, rows, keys, and relationships..
1Phase 1 - Relational Database FoundationsBuild database thinking before writing SQL: files vs databases, tables, records, relationships, primary keys, foreign keys, and basic data modeling.1 modules5 lessons1–2 weeks
Module 1: Understanding Data and DatabasesUnderstand why databases exist and how relational database structures support business analytics.5 lessons
Lesson 1: Why Databases ExistUnderstand why databases exist, how they differ from files, and why SQL matters for business analytics.75 minarticle5 pages
Welcome and Learning Objectives
Start the course and understand why databases matter.
8 min
Files vs Databases
Explain the difference between files and databases.
16 min
Business Data and Structured Data
Introduce business data and structured records.
17 min
Relational Databases in Plain English
Introduce relational databases and why they matter.
18 min
Exercise - Application Database Discovery
Students identify databases behind common applications.
16 min
Lesson 2: Database FundamentalsUnderstand tables, rows, columns, and records — the foundation of relational database thinking.75 minarticle5 pages
Welcome and Learning Objectives
Introduce the basic building blocks of databases.
8 min
Tables, Rows, Columns and Records
Explain core database structure.
18 min
From Business Entity to Table
Show how real business objects become database tables.
18 min
Design a Simple Customer Database
Guide students through customer table design.
18 min
Exercise - Customer Database Blueprint
Students submit a simple customer database design.
13 min
Lesson 3: RelationshipsUnderstand one-to-one, one-to-many, and many-to-many relationships and how they shape analytical queries.80 minarticle4 pages
Welcome and Learning Objectives
Introduce relationships between tables.
8 min
Types of Relationships
Explain common relationship patterns.
22 min
E-Commerce Relationship Model
Show a realistic relationship model.
25 min
Exercise - E-Commerce Relationship Model
Students model an e-commerce database.
25 min
Lesson 4: Primary Keys and Foreign KeysUnderstand primary keys, foreign keys, constraints, and how they protect data integrity.80 minarticle5 pages
Welcome and Learning Objectives
Introduce keys and integrity.
8 min
Primary Keys
Explain primary keys.
20 min
Foreign Keys and Constraints
Explain foreign keys and constraints.
22 min
Keys in Analytical Queries
Connect keys to SQL analysis.
18 min
Exercise - Key Integrity Diagram
Students create a key-based relationship diagram.
12 min
Lesson 5: Mini Project 1 - Database Blueprint ChallengeDesign a beginner-friendly relational database blueprint for a CRM, LMS, or e-commerce business.90 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
2Phase 2 - Querying DataLearn the SQL fundamentals required to retrieve, filter, sort, and calculate business data.1 modules5 lessons1–2 weeks
Module 1: SQL FundamentalsBuild core SQL query confidence using SELECT, WHERE, sorting, limiting, expressions, and CASE logic.5 lessons
Lesson 1: SELECT StatementsLearn how to select columns, create aliases, and build expressions.55 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
27 min
Practice Activity
Apply the lesson through a guided SQL exercise.
20 min
Lesson 2: Filtering DataUse WHERE, AND, OR, IN, BETWEEN, and LIKE to retrieve relevant business records.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided SQL exercise.
22 min
Lesson 3: Sorting and LimitingUse ORDER BY and LIMIT/TOP concepts to rank and inspect records.50 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
25 min
Practice Activity
Apply the lesson through a guided SQL exercise.
17 min
Lesson 4: Calculated FieldsCreate derived columns using arithmetic and CASE statements.55 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
27 min
Practice Activity
Apply the lesson through a guided SQL exercise.
20 min
Lesson 5: Mini Project 2 - Sales Insight Query PackWrite a practical set of SQL queries for sales, revenue, customer, and product analysis.80 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
3Phase 3 - Aggregation and ReportingUse SQL aggregation to build business KPI reporting datasets.1 modules5 lessons1–2 weeks
Module 1: Business Reporting with SQLUse COUNT, SUM, AVG, MIN, MAX, GROUP BY, HAVING, and KPI logic for reporting.5 lessons
Lesson 1: Aggregate FunctionsUse COUNT, SUM, AVG, MIN, and MAX to summarize business data.55 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
27 min
Practice Activity
Apply the lesson through a guided SQL exercise.
20 min
Lesson 2: GROUP BYGroup records by category, region, time, or customer segment.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided SQL exercise.
22 min
Lesson 3: HAVINGFilter aggregated results using HAVING.50 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
25 min
Practice Activity
Apply the lesson through a guided SQL exercise.
17 min
Lesson 4: Business KPI ReportingBuild SQL reports for revenue, customer growth, and retention metrics.65 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
32 min
Practice Activity
Apply the lesson through a guided SQL exercise.
25 min
Lesson 5: Milestone Project 1 - Executive KPI Reporting DatasetProduce dashboard-ready SQL datasets for executive KPI reporting.100 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
4Phase 4 - SQL Joins MasteryMaster the SQL joins needed to combine data across business tables accurately.1 modules6 lessons1–2 weeks
Module 1: Combining DataUse joins to connect customers, orders, products, payments, and other business tables.6 lessons
Lesson 1: INNER JOINUse INNER JOIN to return matching records across tables.55 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
27 min
Practice Activity
Apply the lesson through a guided SQL exercise.
20 min
Lesson 2: LEFT JOINUse LEFT JOIN to preserve records from the left table and analyze missing activity.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided SQL exercise.
22 min
Lesson 3: RIGHT JOIN and FULL JOINUnderstand completeness analysis using RIGHT JOIN and FULL JOIN concepts.50 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
25 min
Practice Activity
Apply the lesson through a guided SQL exercise.
17 min
Lesson 4: Multi-Table JoinsJoin several tables to build full business intelligence datasets.70 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
35 min
Practice Activity
Apply the lesson through a guided SQL exercise.
27 min
Lesson 5: Join Optimization ConceptsUnderstand efficient joins, common mistakes, and how poor joins create slow or wrong results.55 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
27 min
Practice Activity
Apply the lesson through a guided SQL exercise.
20 min
Lesson 6: Project - Customer Revenue AnalyticsBuild customer value, order, and revenue analysis using joins.90 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
5Phase 5 - Advanced SQL for AnalyticsUse subqueries, CTEs, window functions, trends, and retention analysis for advanced reporting.1 modules6 lessons2 weeks
Module 1: Analytical SQLDevelop advanced analytical SQL patterns for complex business questions.6 lessons
Lesson 1: SubqueriesUse nested and correlated queries for advanced reporting.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided SQL exercise.
22 min
Lesson 2: Common Table ExpressionsUse WITH statements to organize complex SQL logic.65 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
32 min
Practice Activity
Apply the lesson through a guided SQL exercise.
25 min
Lesson 3: Window FunctionsUse ROW_NUMBER, RANK, DENSE_RANK, LEAD, and LAG for analytical reporting.70 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
35 min
Practice Activity
Apply the lesson through a guided SQL exercise.
27 min
Lesson 4: Running Totals and TrendsUse SQL to calculate running totals, growth, and time-series reporting.65 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
32 min
Practice Activity
Apply the lesson through a guided SQL exercise.
25 min
Lesson 5: Cohort and Retention AnalysisBuild beginner-friendly cohort and retention analysis for subscription or repeat-use businesses.75 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
37 min
Practice Activity
Apply the lesson through a guided SQL exercise.
30 min
Lesson 6: Milestone Project 2 - Subscription Growth and Retention AnalyticsAnalyze subscription growth, retention, and cohorts with advanced SQL.110 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
6Phase 6 - Real-World Data AnalysisUse SQL to solve customer, product, marketing, and operations problems.1 modules4 lessons1–2 weeks
Module 1: Solving Business ProblemsApply SQL to practical business domains and reporting needs.4 lessons
Lesson 1: Customer AnalyticsUse SQL for customer segmentation, value analysis, and lifetime value concepts.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided SQL exercise.
22 min
Lesson 2: Product AnalyticsAnalyze product performance, product adoption, and revenue contribution.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided SQL exercise.
22 min
Lesson 3: Marketing AnalyticsAnalyze campaign performance and conversion metrics using SQL.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided SQL exercise.
22 min
Lesson 4: Operational AnalyticsBuild operational datasets for process, efficiency, and performance analysis.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided SQL exercise.
22 min
7Phase 7 - Professional SQLDevelop production-quality SQL habits for performance, maintainability, documentation, and BI collaboration.1 modules3 lessons1 week
Module 1: Production SQL SkillsWrite SQL that is readable, maintainable, dashboard-ready, and safer for production-scale work.3 lessons
Lesson 1: Query OptimizationLearn how to read queries, recognize performance basics, and understand index concepts.65 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
32 min
Practice Activity
Apply the lesson through a guided SQL exercise.
25 min
Lesson 2: Documentation and MaintainabilityWrite SQL that other analysts and engineers can understand and reuse.55 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
27 min
Practice Activity
Apply the lesson through a guided SQL exercise.
20 min
Lesson 3: Working with BI ToolsPrepare SQL datasets for Power BI, dashboards, and analytics platforms.60 minarticle3 pages
Overview and Learning Objectives
Introduce the lesson and clarify expected outcomes.
8 min
Concepts and Business Examples
Explain the concept with practical business examples.
30 min
Practice Activity
Apply the lesson through a guided SQL exercise.
22 min
8Phase 8 - Capstone, Graduation and PortfolioComplete an end-to-end SQL analytics capstone and package portfolio-ready SQL work.1 modules2 lessons1 week
Module 1: End-to-End Business Analytics CapstoneStudents complete an industry-based SQL analytics capstone and prepare their portfolio outcome.2 lessons
Lesson 1: Final Capstone - End-to-End Business Analytics ProjectBuild a professional SQL analytics project for one selected industry.150 minarticle2 pages
Project Brief
Explain the project scenario and expected output.
20 min
Review Checklist
Checklist for project quality.
20 min
Lesson 2: Graduation Requirements and Portfolio OutcomeClarify completion requirements and expected portfolio outputs.45 minarticle1 pages
Requirements and Portfolio Checklist
Summarize graduation requirements and portfolio assets.
45 min
Tools and skills
Build skill with the tools used in the work.
Understand tables, columns, rows, keys, and relationships.Write SQL queries to retrieve business data.Filter, sort, and structure query results.Join data across multiple tables correctly.Use aggregation to summarize performance.Apply CASE statements for business logic.Use subqueries and common table expressions.Analyze customer, revenue, product, transaction, and operations data.Prepare SQL outputs for Excel, Python, and Power BI.Build portfolio-ready SQL analytics projects.
Projects and exercises
- Understand tables, columns, rows, keys, and relationships.
- Structured exercises
- Portfolio practice
Resources included
- Course resources
- Project guidance
- Learners building practical tech skills
- A willingness to practice consistently
Career relevance
SQL for Data Analytics supports practical career readiness.
Support options
Choose the level of feedback that matches your pace.
Compare the project, price, and feedback level before choosing the support option that fits your pace.
Self-Paced Only
₦65,000
Upfront Payment
₦65,000due today
- ₦65,000 at enrollment
Pay once or split into fixed installments.
Access starts after your first confirmed payment.
Related Professional Diploma
View Professional DiplomaData Engineering
Learn how to build the pipelines, data models, warehouses, orchestration workflows, and cloud data systems that power analytics, reporting, machine learning, and AI products.
FAQ
Questions about this Short Course.
Short Course answers about scope, projects, support, and next steps.
SQL helps analysts retrieve data directly from databases. Many companies store business data in databases, so SQL is one of the most important analytics skills.
Related Short Courses
View all Short CoursesContinue building connected skills.
School of Data & AIData & AIBeginner to Intermediate
Excel for Data Analytics
Turn raw spreadsheets into clean analysis, useful reports, and business-ready insights.
Master the Excel skills used by data analysts to clean, organize, calculate, summarize, visualize, and report business data with confidence.
From₦50,000
6 weeks - 5–8 hours /week
Clean and organize messy spreadsheet data.
Project included
Mentor review available
School of Data & AIData AnalyticsIntermediate
Power BI for Business Intelligence
Build interactive dashboards and business reports that make performance clear.
Learn to connect, clean, model, measure, visualize, and present business data using Power BI.
From₦85,000
8 weeks - 6-8 hours/week
Connect Power BI to different data sources.
Project included
Mentor review available
School of Data & AIData AnalyticsBeginner to Intermediate
Python for Data Analytics
Clean, explore, analyze, automate, and visualize data with Python.
Learn Python for real analytics work: data cleaning, exploration, transformation, automation, and visual insight generation.
From₦85,000
8 weeks - 6-8 hours/week
Write Python code for data analysis tasks.
Project included
Mentor review available
Short Course enrolment
Start with SQL for Data Analytics.
Build the confidence to query real databases, combine tables, summarize records, and extract the data needed for dashboards, reports, and business decisions.