Banner Image

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