SolutionsConsulting & TrainingLive cohortsSQL & Python
Live cohortSQL and Python for Data Analysis
Every dataset has a story. Learn how to reveal it.
A four-month live programme where you’ll build your own database, analyse real data with Python, and finish by creating a project you can proudly showcase.
- Starts 4 Nov 2026
- Live online
- No coding experience needed
- ₦200,000, or ₦50,000 a month
Walk in curious. Leave job-ready.
Four months, one clear road. This is what you'll be able to do when you reach the end.
- Answer business questions with SQLPull exactly the numbers a manager asks for.
- Turn messy data into insightClean, analyse and chart it in Python.
- Build a database from scratchDesign it, fill it with real data and host it online.
- Explore big dataRun a full exploratory analysis on a large, real-world dataset.
- Show employers the proofFour projects, a sharper CV and a portfolio on GitHub.
Two tools. One clear path.
SQL gets the data out. Python makes sense of it. You learn both, in that order, on real business problems.
Four months, one step at a time.
Twelve live classes a month. Every month ends with a project.
- 01Data and databases
- 02Set up MySQL and DataGrip
- 03Read a real data model
- 04Build tables with keys
- 05Load and edit data
- 06SELECT: pull the data
- 07WHERE: filter it
- 08Text functions
- 09Number functions
- 10Dates and times
- 11CASE logic and missing values
- 12Totals with GROUP BY
- 13Joins across tables
- 14Subqueries and CTEs
- 15Window functions
- 16Views, indexes and procedures
- 01Set up Python
- 02Python fundamentals
- 03NumPy
- 04pandas
- 05Files, Excel, APIs and the web
- 06Data cleaning
- 07Transform and summarise
- 08Dates and time series
- 09Data visualisation
- 10Exploratory analysis
- 11Statistics
- 12SQL from Python
- 13Machine learning basics
- 14Large datasets in pandas
- 15Reporting your findings
- 16Capstone workshop
Your own database, from day one.
Pick a business you know. You'll design its database, fill it with real data, put it online and analyse it in Python.
- Week 1PickA shop, school, clinic or farm you know.
- Week 1DesignTables, keys and a clear diagram.
- Week 2FillLoad real data and check it.
- Month 2HostMove it to a free cloud server.
- Month 4ConnectRead it straight from Python.
- Month 4AnalyseExplore it and share what you find.
Leave with proof, not just a certificate.
Employers want to see what you can do. You'll have it ready to show.
- A database you designed, hosted in the cloud
- Four projects for your portfolio
- A big-data analysis, published on GitHub
- A CV and LinkedIn profile that show it
- An Exalda certificate
- Sales peak every December
- Top 10% of customers bring 46% of revenue
- Weekend orders are 18% larger
The details
Everything to know before you join.
- Starts
- Wednesday, 4 November 2026
- Graduation
- Saturday, 6 March 2027
- Classes
- Wed, Thu & Sat, 7–10pm GMT+1
- Format
- Live online, 48 classes of 3 hours
- Break
- No classes 21 Dec – 3 Jan
- You need
- A laptop (Windows or Mac) and internet
- Certificate
- 75% attendance and a 50% overall score
- Fee
- ₦200,000or four payments of ₦50,000: one before classes begin, then one each month
- Accountants and finance staff
- Business owners and managers
- Graduates and career changers
- Excel users ready for more
No coding experience needed.
- MySQL
- DataGrip
- Python
- Jupyter
- VS Code
- Google Colab
- pandas
- NumPy
- Matplotlib
- Seaborn
- scikit-learn
- SQLAlchemy
- GitHub
We set them up together in class.
No. We start with what a database is and build up one step at a time. If you can use Excel, you're ready.
Three live classes of 3 hours each, plus a short assignment after every class.
Assignments count for 55% of your score and the four projects for 45%. A score of 70% or more earns a Distinction.
Attend at least 75% of classes and finish with an overall score of 50% or more.
Yes. There are no classes from 21 December to 3 January. Classes resume on Wednesday, 6 January.
₦200,000. Pay it all at once, or in four payments of ₦50,000: the first before classes begin, then one each month.
Start asking your data better questions.
Enroll in the cohort starting Wednesday, 4 November. Pay ₦200,000 at once, or ₦50,000 a month.