Data & Databases with SQL and Python
Model, query and analyse data with SQL and Python. Go from reading a raw CSV file to designing a normalised relational schema, writing production-grade SQL with joins, aggregation and window functions, tuning queries with indexes and transactions, and shipping a full end-to-end analysis pipeline.
5
Sections
20
Lessons
57
Quiz questions
5h
Study time
What's inside
- Reading and reshaping real CSV and JSON data with Python and pandas
- Normalised schema design, and the anomalies it prevents
- Production SQL: joins, aggregation, window functions
- Indexes, transactions and query tuning
Who your students will be
Analysts, developers moving into data, operations staff
Outcomes you can promise
- Read, clean and reshape real-world data files (CSV, JSON) using core Python and pandas
- Design normalised relational schemas that avoid update, insert and delete anomalies
- Write SQL from basic SELECT statements through multi-table joins, aggregation and window functions
- Understand how indexes and query plans affect performance, and use transactions safely
- Combine Python and SQL into a repeatable, end-to-end data analysis pipeline
- Debug and optimise slow or incorrect queries using EXPLAIN and systematic reasoning
The full syllabus
Nothing is withheld — this is exactly what a student gets, so you can judge it before you licence it rather than after.
Section 1Handling Data in Python
Read, parse and clean real-world data files using core Python and pandas before it ever touches a database.
4 lessons
Handling Data in Python
Read, parse and clean real-world data files using core Python and pandas before it ever touches a database.
- 01Reading and Writing FilesKnowledge check14 min
- 02Working with CSV and JSONKnowledge check15 min
- 03pandas: DataFrames and SeriesKnowledge check16 min
- 04Cleaning and Reshaping DataKnowledge check16 min
Section 2Relational Modelling and Normalisation
Design schemas that represent your data accurately, avoid redundancy, and prevent the update, insert and delete anomalies that plague unstructured spreadsheets.
4 lessons
Relational Modelling and Normalisation
Design schemas that represent your data accurately, avoid redundancy, and prevent the update, insert and delete anomalies that plague unstructured spreadsheets.
- 01Tables, Rows, KeysKnowledge check14 min
- 02Anomalies and the Case for NormalisationKnowledge check14 min
- 03First, Second and Third Normal FormKnowledge check15 min
- 04Entity-Relationship Diagrams and Schema DesignKnowledge check15 min
Section 3SQL Querying: From SELECT to Window Functions
Write real SQL, from filtering and sorting a single table through multi-table joins, aggregation and advanced window functions.
4 lessons
SQL Querying: From SELECT to Window Functions
Write real SQL, from filtering and sorting a single table through multi-table joins, aggregation and advanced window functions.
- 01SELECT, WHERE and ORDER BYKnowledge check14 min
- 02Joining Multiple TablesKnowledge check16 min
- 03Aggregation and GROUP BYKnowledge check15 min
- 04Window FunctionsKnowledge check17 min
Section 4Indexes, transactions and performance
Understand how a database actually executes a query, use indexes to speed up lookups, and use transactions to keep data consistent under concurrent writes.
4 lessons
Indexes, transactions and performance
Understand how a database actually executes a query, use indexes to speed up lookups, and use transactions to keep data consistent under concurrent writes.
- 01How Indexes WorkKnowledge check16 min
- 02Transactions and ACIDKnowledge check15 min
- 03Reading Query Plans and Diagnosing Slow QueriesKnowledge check16 min
- 04Constraints and Data Integrity at ScaleKnowledge check14 min
Section 5End-to-end analysis pipeline project
Bring everything together: ingest a raw CSV with Python, load it into a normalised schema, query it with SQL, and produce a repeatable analysis report.
4 lessons
End-to-end analysis pipeline project
Bring everything together: ingest a raw CSV with Python, load it into a normalised schema, query it with SQL, and produce a repeatable analysis report.
- 01Planning the Pipeline12 min
- 02Extract and Transform with PythonKnowledge check18 min
- 03Loading into a Normalised SchemaKnowledge check17 min
- 04Producing the Analysis ReportKnowledge check16 min
20 lessons you don't have to write
At €129 a student, this licence pays for itself after 3. Everything after that is margin on work already done.