Westhub Academy
Log in Get Started
← Back to Courses
Free 🎓 Verifiable Certificate

Database Management

35 modules · Beginner

A complete, practical, beginner-to-advanced course in database management. Start with relational database fundamentals and SQL (queries, joins, aggregation), then database design and normalization, then advanced SQL, indexing, and performance tuning, then database administration (backup and recovery, security, replication and high availability), then NoSQL databases, and finish with data warehousing and analytics fundamentals. Learning by doing throughout, with six hands-on projects culminating in a capstone: designing, building, securing, and optimizing a complete, realistic database system.

Course Content

1. What is a Database? Relational Concepts & the RDBMS

  • Lesson
    45 min
  • 1. What is a Database? Relational Concepts & the RDBMS Quiz
    10 min
  • What is a Database? — Homework & Mini Project
    45 min

2. Installing & Exploring: Tables, Rows & Data Types

  • Lesson
    45 min
  • 2. Installing & Exploring: Tables, Rows & Data Types Quiz
    10 min
  • Tables, Rows & Data Types — Homework & Mini Project
    45 min

3. Querying Data: SELECT, WHERE, ORDER BY, LIMIT

  • Lesson
    45 min
  • 3. Querying Data: SELECT, WHERE, ORDER BY, LIMIT Quiz
    10 min
  • Querying Data: SELECT, WHERE, ORDER BY, LIMIT — Homework & Mini Project
    45 min

4. Joins: Combining Data Across Tables

  • Lesson
    45 min
  • 4. Joins: Combining Data Across Tables Quiz
    10 min
  • Joins: Combining Data Across Tables — Homework & Mini Project
    45 min

5. Aggregation: GROUP BY, HAVING & Aggregate Functions

  • Lesson
    45 min
  • 5. Aggregation: GROUP BY, HAVING & Aggregate Functions Quiz
    10 min
  • Aggregation: GROUP BY, HAVING & Aggregate Functions — Homework & Mini Project
    45 min

6. Project: Query a Sample Database

  • Lesson
    45 min
  • Assignment
    90 min
  • Checkpoint Quiz: Querying Fundamentals
    15 min

7. Modeling Data: Entity-Relationship Diagrams

  • Lesson
    45 min
  • 7. Modeling Data: Entity-Relationship Diagrams Quiz
    10 min
  • Entity-Relationship Diagrams — Homework & Mini Project
    45 min

8. Primary Keys, Foreign Keys & Constraints

  • Lesson
    45 min
  • 8. Primary Keys, Foreign Keys & Constraints Quiz
    10 min
  • Primary Keys, Foreign Keys & Constraints — Homework & Mini Project
    45 min

9. Normalization: 1NF, 2NF, 3NF

  • Lesson
    45 min
  • 9. Normalization: 1NF, 2NF, 3NF Quiz
    10 min
  • Normalization: 1NF, 2NF, 3NF — Homework & Mini Project
    45 min

10. Denormalization & When to Break the Rules

  • Lesson
    45 min
  • 10. Denormalization & When to Break the Rules Quiz
    10 min
  • Denormalization & When to Break the Rules — Homework & Mini Project
    45 min

11. Data Types & Schema Design Best Practices

  • Lesson
    45 min
  • 11. Data Types & Schema Design Best Practices Quiz
    10 min
  • Data Types & Schema Design Best Practices — Homework & Mini Project
    45 min

12. DDL: Creating & Altering Tables

  • Lesson
    45 min
  • 12. DDL: Creating & Altering Tables Quiz
    10 min
  • DDL: Creating & Altering Tables — Homework & Mini Project
    45 min

13. Project: Design & Build a Normalized Database Schema

  • Lesson
    45 min
  • Assignment
    90 min
  • Checkpoint Quiz: Data Modeling & Schema Design
    15 min

14. Subqueries & Common Table Expressions (CTEs)

  • Lesson
    45 min
  • 14. Subqueries & Common Table Expressions (CTEs) Quiz
    10 min
  • Subqueries & Common Table Expressions — Homework & Mini Project
    45 min

15. Window Functions

  • Lesson
    45 min
  • 15. Window Functions Quiz
    10 min
  • Window Functions — Homework & Mini Project
    45 min

16. Views & Stored Procedures

  • Lesson
    45 min
  • 16. Views & Stored Procedures Quiz
    10 min
  • Views & Stored Procedures — Homework & Mini Project
    45 min

17. Transactions & ACID Properties

  • Lesson
    45 min
  • 17. Transactions & ACID Properties Quiz
    10 min
  • Transactions & ACID Properties — Homework & Mini Project
    45 min

18. Indexing Fundamentals

  • Lesson
    45 min
  • 18. Indexing Fundamentals Quiz
    10 min
  • Indexing Fundamentals — Homework & Mini Project
    45 min

19. Query Optimization & Execution Plans

  • Lesson
    45 min
  • 19. Query Optimization & Execution Plans Quiz
    10 min
  • Query Optimization & Execution Plans — Homework & Mini Project
    45 min

20. Project: Optimize a Slow Query Set

  • Lesson
    45 min
  • Assignment
    90 min
  • Checkpoint Quiz: Advanced SQL & Performance
    15 min

21. Backup & Recovery Strategies

  • Lesson
    45 min
  • 21. Backup & Recovery Strategies Quiz
    10 min
  • Backup & Recovery Strategies — Homework & Mini Project
    45 min

22. Database Security: Users, Roles & Permissions

  • Lesson
    45 min
  • 22. Database Security: Users, Roles & Permissions Quiz
    10 min
  • Database Security: Users, Roles & Permissions — Homework & Mini Project
    45 min

23. Replication & High Availability

  • Lesson
    45 min
  • 23. Replication & High Availability Quiz
    10 min
  • Replication & High Availability — Homework & Mini Project
    45 min

24. Database Monitoring & Maintenance

  • Lesson
    45 min
  • 24. Database Monitoring & Maintenance Quiz
    10 min
  • Database Monitoring & Maintenance — Homework & Mini Project
    45 min

25. Migrations & Schema Change Management

  • Lesson
    45 min
  • 25. Migrations & Schema Change Management Quiz
    10 min
  • Migrations & Schema Change Management — Homework & Mini Project
    45 min

26. Project: Implement Backup, Recovery & Security for a Database

  • Lesson
    45 min
  • Assignment
    90 min
  • Checkpoint Quiz: Backup, Security & Reliability
    15 min

27. Introduction to NoSQL: Types & Trade-offs

  • Lesson
    45 min
  • 27. Introduction to NoSQL: Types & Trade-offs Quiz
    10 min
  • Introduction to NoSQL: Types & Trade-offs — Homework & Mini Project
    45 min

28. Document Databases

  • Lesson
    45 min
  • 28. Document Databases Quiz
    10 min
  • Document Databases — Homework & Mini Project
    45 min

29. Key-Value & Wide-Column Stores

  • Lesson
    45 min
  • 29. Key-Value & Wide-Column Stores Quiz
    10 min
  • Key-Value & Wide-Column Stores — Homework & Mini Project
    45 min

30. Data Warehousing Fundamentals

  • Lesson
    45 min
  • 30. Data Warehousing Fundamentals Quiz
    10 min
  • Data Warehousing Fundamentals — Homework & Mini Project
    45 min

31. ETL/ELT & Data Pipelines

  • Lesson
    45 min
  • 31. ETL/ELT & Data Pipelines Quiz
    10 min
  • ETL/ELT & Data Pipelines — Homework & Mini Project
    45 min

32. Data Modeling for Analytics: Star Schema

  • Lesson
    45 min
  • 32. Data Modeling for Analytics: Star Schema Quiz
    10 min
  • Data Modeling for Analytics: Star Schema — Homework & Mini Project
    45 min

33. Project: Build a NoSQL Data Store & Simple Data Pipeline

  • Lesson
    45 min
  • Assignment
    90 min
  • Checkpoint Quiz: NoSQL & Data Warehousing
    15 min

34. Database Certifications & Career Paths

  • Lesson
    45 min
  • 34. Database Certifications & Career Paths Quiz
    10 min
  • Database Certifications & Career Paths — Homework & Mini Project
    45 min

35. Capstone Project: Design, Build, Secure & Optimize a Complete Database System

  • Lesson
    45 min
  • Assignment
    90 min
  • Capstone Review Quiz: Complete Database System Design
    15 min
Sign Up — It's Free

Free · Learn at your own pace

No open cohort right now

🧑‍🏫 Book VIP (1-on-1) Training

Programme Details

Self-Taught
Free
Certificate
NGN 20,000.00
Cohort
NGN 100,000.00
VIP (1-on-1)
NGN 300,000.00
Modules
35
Lessons
105
Programme Length
12 weeks

Certificate Preview

🏅

Certificate of Completion

John Doe

SAMPLE · PREVIEW

Complete the course to unlock your certificate for download.