Weeks 1-4: Basics of SQL
- Topic 1: Databases, SQL, selection, creation, insertion, deletion, aggregate functions
- Topic 2: Primary/foreign key, Joins, Union, Cases, Date functions, Views, Cases, pivoting
- Topic 3: CTE, Subquery, Index, Window functions, stored procedures, triggers, transactions
Weeks 5-6: Python
- Topic 1: Data structures - lists, tuples and dictionaries
- Topic 2: Object-oriented programming
- Topic 3: Main libraries - numpy, scipy, sklearn, pandas
Week 7: Excel
- Topic 1: PivotTable, PivotChart, Solver
- Topic 2: Index Match, Vlookup, Hlookup, Sumifs, Countifs, Averageifs
Week 8: Probability and statistics
- Topic 1: Random variables, Distributions and central limit theorem
- Topic 2: Statistics - hypothesis testing, confidence intervals, p-values
Week 9-10: Machine Learning - basic algorithms
- Topic 1: Linear and Logistic Regression
- Topic 2: Classification and clustering
- Topic 3: Decision Trees
Week 11-12: Visualisation
- Topic 1: Basics of visualisation, types of charts
- Topic 2: Python libraries: Streamlit, plotly and matplotlib