Beatsy Solutions Beatsy Solutions
Commercial Digital Literacy Professional Curriculum Verified

SQL, Databases and Practical Data Analysis

A comprehensive, hands-on relational database and analytical SQL program designed to build professional data analysis competence using PostgreSQL and MySQL. Master relational database design, schema n...

0.0
(0 ratings)
Category: LMS Training
Created by James Mwangi Last updated 10/2026 English / Swahili

What you'll learn

["Design normalized relational database schemas with primary keys, foreign keys, and integrity constraints","Author fluent SQL queries utilizing filtering, grouping, aggregation, and null-coalescing logic","Execute complex multi-table relational joins (INNER, LEFT, RIGHT, FULL) and self-joins without Cartesian products","Construct modular analytical queries using Subqueries and Common Table Expressions (CTEs)","Perform advanced time-series and cohort analytics using SQL Window Functions (ROW_NUMBER, RANK, LEAD, LAG)","Inspect query execution plans with EXPLAIN ANALYZE and optimize database performance using composite B-Tree indexes."]

Learning Tracks & Pricing Options

Designed for self-paced independent study, with optional 1-on-1 instructor support when needed.

2 Flexible Pathways
Curriculum & Support Feature Option A: Self-Study Ksh 8,000.00 Option B: Assisted Learning Ksh 17,600.00
All 10 Structured Modules
Downloadable PDF Manuals & Starter Code
Hands-on Practical Exercises & Capstone Labs
Verified Certificate of Completion
Dedicated 1-on-1 Instructor Mentorship Add on demand Included
Live Debugging & Screen-Share Support Add on demand Included
Milestone Portfolio Code Reviews Add on demand Included
Enroll Self-Study • Ksh 8,000.00 Enroll Assisted • Ksh 17,600.00
Self-Study Flexibility: If you choose Self-Study, you can request instructor assistance for any specific module whenever you need help without altering your self-study access.

Course Content

10 sections • 1770 lessons • 45h total length
Expand all sections

  • The Relational Model: Entities, Attributes, Tables, and Tuples
    30min
  • Keys and Identifiers: Candidate, Primary, Alternate, and Foreign Keys
    30min
  • Cardinality and Relationships: One-to-One, One-to-Many, and Many-to-Many
    30min
  • Entity-Relationship Diagrams (ERDs) & Data Modeling
    30min
  • Database Normalization: First Normal Form (1NF)
    30min
  • Database Normalization: Second Normal Form (2NF)
    30min
  • Database Normalization: Third Normal Form (3NF) & Boyce-Codd (BCNF)
    30min
  • Module 1 Practical Lab: Enterprise Relational Schema Design Challenge
    30min

  • SQL Standards and Database Engines: PostgreSQL vs MySQL
    30min
  • SQL Data Types: Numeric, Characters, Dates, and Booleans
    30min
  • Creating Tables: The `CREATE TABLE` Statement & Primary Keys
    30min
  • Enforcing Integrity Constraints: `NOT NULL`, `UNIQUE`, `CHECK`, and `DEFAULT`
    30min
  • Referential Integrity: Foreign Keys and Cascade Actions
    30min
  • Modifying Schemas: The `ALTER TABLE` Statement
    30min
  • Removing Objects: `DROP TABLE`, `TRUNCATE TABLE`, and `IF EXISTS`
    30min
  • Module 2 Practical Lab: Multi-Table E-Commerce DDL Buildout
    30min

  • Inserting Data: `INSERT INTO`, Multi-Row Inserts, and Default Values
    30min
  • Modifying Existing Records: The `UPDATE` Statement & Safe Filtering
    30min
  • Deleting Records: `DELETE FROM` vs Soft Deletes (`deleted_at`)
    30min
  • Upserting Data: `ON CONFLICT` (PostgreSQL) vs `ON DUPLICATE KEY UPDATE` (MySQL)
    30min
  • Transaction Fundamentals: `BEGIN`, `COMMIT`, `ROLLBACK`, and Savepoints
    30min
  • ACID Properties of Relational Transactions
    30min
  • Transaction Isolation Levels & Concurrency Phenomena
    30min
  • Module 3 Practical Lab: Transactional Order Processing Pipeline
    30min

  • The `SELECT` Statement: Column Projection, Expressions, and Aliases
    30min
  • Filtering Data with the `WHERE` Clause: Comparison & Logical Operators
    30min
  • Range and Set Filtering: `BETWEEN`, `IN`, and `NOT IN`
    30min
  • Pattern Matching: `LIKE`, `ILIKE`, Wildcards, and Regular Expressions
    30min
  • Three-Valued Logic & The Nature of `NULL`: `IS NULL` vs `= NULL`
    30min
  • Null Coalescing and Replacement: `COALESCE()` and `NULLIF()`
    30min
  • Sorting Results: `ORDER BY`, Multi-Column Sorting, and Null Ordering
    30min
  • Pagination: `LIMIT` / `OFFSET` and Keyset (Cursor) Pagination
    30min

  • Aggregate Functions: `COUNT()`, `SUM()`, `AVG()`, `MIN()`, and `MAX()`
    30min
  • Grouping Records: The `GROUP BY` Clause Mechanics
    30min
  • Filtering Aggregated Groups: The `HAVING` Clause vs `WHERE` Clause
    30min
  • Counting Unique Occurrences: `COUNT(DISTINCT column)`
    30min
  • Conditional Aggregation: Combining Aggregates with `CASE WHEN`
    30min
  • The Logical Query Processing Order in SQL
    30min
  • Advanced Grouping Extensions: `ROLLUP`, `CUBE`, and `GROUPING SETS`
    30min
  • Module 5 Practical Lab: Executive KPI & Revenue Aggregation Dashboard
    30min

  • The Relational Join Concept: Combining Data via Foreign Keys
    30min
  • Matching Records: The `INNER JOIN` Statement
    30min
  • Preserving Left-Side Records: The `LEFT OUTER JOIN` Statement
    30min
  • Finding Orphaned & Missing Records: Anti-Join Patterns
    30min
  • Right Joins & Full Outer Joins (`RIGHT JOIN` and `FULL OUTER JOIN`)
    30min
  • Hierarchical Relationships & The Self-Join Pattern
    30min
  • Cartesian Products: `CROSS JOIN` and Generating Permutations
    30min
  • Module 6 Practical Lab: Comprehensive Multi-Table Commercial Intelligence Query
    30min

  • Scalar and Multi-Row Subqueries: Subqueries in `WHERE` and `SELECT`
    30min
  • Correlated Subqueries: Row-by-Row Evaluation Mechanics
    30min
  • The `EXISTS` and `NOT EXISTS` Operators
    30min
  • Derived Tables: Subqueries in the `FROM` Clause
    30min
  • Common Table Expressions (CTEs): The `WITH` Clause Syntax
    30min
  • Chaining Multiple CTEs for Multi-Stage Data Pipelines
    30min
  • Recursive Common Table Expressions: Traversing Hierarchical Data
    30min
  • Module 7 Practical Lab: Multi-Stage Customer Segmentation & Lifetime Value Analysis
    30min

  • Introduction to SQL Window Functions: The `OVER()` Clause Architecture
    30min
  • Partitioning Data Windows: The `PARTITION BY` Sub-Clause
    30min
  • Ranking Functions: `ROW_NUMBER()`, `RANK()`, and `DENSE_RANK()`
    30min
  • Filtering by Window Calculations: Top-N Queries via CTEs
    30min
  • Time-Series Analysis with Navigation Functions: `LEAD()` and `LAG()`
    30min
  • Cumulative Aggregates: Running Totals and Year-to-Date (YTD) Revenue
    30min
  • Window Framing: `ROWS BETWEEN` vs `RANGE BETWEEN` (Moving Averages)
    30min
  • Module 8 Practical Lab: Advanced Cohort Retention & Churn Analysis
    30min

  • The Query Optimizer & Execution Plans: `EXPLAIN` and `EXPLAIN ANALYZE`
    30min
  • Understanding Scan Types: Sequential (Table) Scans vs Index Scans
    30min
  • B-Tree Indexes: Architecture, Primary Key Indexing, and Search Speed
    30min
  • Composite Indexes & The Leftmost Prefix Rule
    30min
  • Covering Indexes & Index-Only Scans
    30min
  • The Cost of Indexing: Write Overhead and Index Bloat
    30min
  • Query Anti-Patterns That Defeat Indexes (SARGability)
    30min
  • Module 9 Practical Lab: Slow Query Diagnostic & Performance Optimization Drill
    30min

  • Capstone Architecture & Business Intelligence Requirements
    30min
  • Capstone Phase 1: Relational Schema Buildout & Constraint Enforcement
    30min
  • Capstone Phase 2: Data Ingestion, Cleaning & Transformation Pipeline
    30min
  • Capstone Phase 3: Commercial Sales & Revenue Performance Analytics
    30min
  • Capstone Phase 4: Customer Segmentation & RFM Analysis Modeling
    30min
  • Capstone Phase 5: Customer Retention & Cohort Churn Modeling
    30min
  • Capstone Phase 6: Query Performance Tuning & Production Indexing
    30min
  • Capstone Presentation: Executive BI Insights & SQL Portfolio Defense
    30min

Description

A comprehensive, hands-on relational database and analytical SQL program designed to build professional data analysis competence using PostgreSQL and MySQL. Master relational database design, schema normalization (1NF–3NF), data definition and manipulation (DDL/DML), multi-table relational joins, advanced subqueries, Common Table Expressions (CTEs), analytical window functions, query performance indexing, data cleaning pipelines, and business intelligence reporting. Features real-world commercial datasets evaluating customer lifetime value, cohort retention, and revenue metrics.
Recommended Learning Pathway
Prerequisites / Prior Knowledge:

Basic computer literacy and basic familiarity with spreadsheet tables. No prior database, SQL, or programming experience required.

Student Reviews & Feedback

Verified ratings from students enrolled in this course.

No reviews yet for this course. Be the first enrolled student to share feedback!

Chat with us on WhatsApp