Digitika Academy/SQL & Databases
Data Analytics

SQL & Database Analytics

SQL is the universal language of data. This course takes you from basic SELECT queries to advanced window functions, CTEs, and query optimisation — with a PostgreSQL practice environment throughout.

Difficulty:
Beginner
6 weeks
Online
Write complex SQL queries with JOINs and subqueries Design normalised database schemas Use window functions and CTEs Optimise slow queries with indexes
SQL & Database Analytics

You'll earn a certificate

Recognised across East African employers and institutions

Duration

6 weeks

Level

Beginner

Format

Online

Outcomes

4 skills

What you'll achieve

Write complex SQL queries with JOINs and subqueries
Design normalised database schemas
Use window functions and CTEs
Optimise slow queries with indexes

Everything included

6 weeks instruction
PostgreSQL practice environment
Query library
Certificate

How this course works

Instructor-led sessions

6 weeks of live, interactive classes with experienced instructors — online.

Hands-on practicals

Every concept is applied immediately through guided lab work, real-world exercises, and project builds.

Targeted assessments

Regular quizzes and milestone assessments keep you on track and prepare you for the final certification exam.

Certificate & portfolio

Graduate with a Codevertex certificate and proof-of-work to show employers and clients.

Tech Stack

PostgreSQLpgAdminDBeaver

Prerequisites

Basic computer skills

Career Pathways

Data AnalystDatabase AdministratorBackend Developer

Still have questions?

Our team is available Monday–Saturday, 8am–6pm EAT. We reply within the hour.

Choose a payment plan

TotalKES 12,000

Questions? WhatsApp us or call +254 743 793 901

Share this course

WhatsApp
All courses