Data Analytics

📊 SQL for Data Analytics Certification

A hands-on certification in SQL for data analysts — covering querying, aggregation, window functions, CTEs, and building reporting-ready datasets from real-world data.

9 Weeks Virtual Certificate

KES 7500 Program fee can be done in installments

or deposit 40% (KES 3000) to secure your spot

Beginner

2 Weeks

Intermediate

4 Weeks

Advanced

4 Weeks

Learning Journey

Your path to mastery

3 structured levels — from foundations to expert mastery.

Level 1

SQL Foundations for Analysts

2 Weeks 7 courses

Builds SQL from the ground up for complete beginners. By the end, participants can query any relational database, filter and aggregate data, and produce simple …

What You'll Learn

1 SQL fundamentals: SELECT, WHERE, ORDER BY, LIMIT

2 Filtering with LIKE, IN, BETWEEN, IS NULL

3 Aggregations: COUNT, SUM, AVG, GROUP BY, HAVING

4 INNER JOIN and LEFT JOIN

5 CASE WHEN for conditional columns

6 Basic date functions

7 Introduction to PostgreSQL and MySQL environments

KES 3000 / level

Certificate included

Level 2

Analytical SQL Patterns

4 Weeks 8 courses

Takes analysts beyond basic queries into the patterns used daily in professional analytics — window functions, CTEs, cohort analysis, and time-series work.

What You'll Learn

1 Subqueries and correlated subqueries

2 CTEs and multi-step query structuring

3 Window functions: ROW_NUMBER, RANK, LAG, LEAD

4 Running totals and moving averages

5 Advanced JOINs: FULL OUTER, SELF JOIN

6 Time-series analysis with date functions

7 String functions and data cleaning

8 Cohort analysis and retention queries

KES 3000 / level

Certificate included

Level 3

Reporting, Optimization & Cloud SQL

4 Weeks 8 courses

Covers advanced analytical techniques, query performance tuning, and cloud SQL platforms. Participants complete a capstone project delivering a full reporting dataset for a BI tool.

What You'll Learn

1 Customer segmentation and RFM analysis

2 Funnel analysis and conversion tracking

3 Pivot tables and crosstabs in SQL

4 Query optimization: EXPLAIN, indexes, execution plans

5 Working with AWS Athena and partitioned datasets

6 Introduction to dbt for analytical workflows

7 Building datasets for Power BI and Tableau

8 Capstone: end-to-end analytical reporting project

KES 3000 / level

Certificate included

Complete Path

Master the Full Journey

All 3 levels — structured from foundations to expert mastery. Earn a verifiable certificate at each milestone.

🟢 SQL Foundations for Analysts KES 3000 per level

🟡 Analytical SQL Patterns KES 3000 per level

🔴 Reporting, Optimization & Cloud SQL KES 3000 per level

Total Investment

KES 9000

KES 7500

vs buying levels individually Save 17%

🟢

🟡

🔴

3 certificates included

Program Overview

This program teaches analysts how to extract, transform, and summarize data using SQL with confidence. Participants will go from writing basic SELECT statements to crafting complex multi-step analytical queries using window functions, CTEs, subqueries, and aggregation pipelines. All concepts are grounded in real business scenarios — sales reporting, customer segmentation, cohort analysis, and KPI dashboards. Supported databases include PostgreSQL, MySQL, and cloud platforms such as AWS Athena and BigQuery. Graduates leave with a certification and a portfolio of analytical SQL queries they built themselves.

Who Is This For?

Business analysts, data analysts, reporting specialists, and anyone who works with structured data and wants to move beyond spreadsheets into professional SQL-based analysis.

Prerequisites

Basic familiarity with spreadsheets (Excel or Google Sheets) Understanding of rows, columns, and tabular data No prior SQL experience required for the Beginner level

Delivery Options

Virtual

Need a Custom Solution?

Group pricing, custom dates, or a tailored version for your team.

Talk to Us

UPON COMPLETION