1
Module 1: Relational DB Concepts
Understanding tables, primary keys, and foreign keys.
Programme Details
Databases and SQL for Data Science with Python
Learn how to access, manipulate, and analyze relational databases using SQL and Python. Apply for Data Analyst or Junior Data Scientist positions confidently.
About this Course
What you will learn
- Relational database concepts
- Writing SQL queries (CRUD, joins)
- Connecting Python to databases
- Analyzing data via SQL
Skills you will gain
Database ArchitectureSQL QueryingData ExtractionData Cleaning
Tools you will learn
PostgreSQLSQLitePythonPandas
Specialisations / Modules
2
Module 2: Advanced SQL Querying
Grouping, sorting, aggregations, and complex subqueries.
3
Module 3: Python Integration
Connecting your Python scripts directly to a live database.
4
Module 4: Data Science Project
Extracting messy data, cleaning it, and providing a final report.
Career Path
After graduation you can work as...
Enrolling in and finishing this course opens doors to several high-demand roles.
Database Admin (Junior)
Potential:Ksh 50k - 100k / mo
Data Analyst
Potential:Ksh 50k - 110k / mo
SQL Developer
Potential:Ksh 60k - 120k / mo