Week 7 - Data Loading in SQL
GROUP BY, HAVING, Subquery, JOIN, CREATE TABLE, INSERT INTO
INSY336
EX3 - Intermediate SQL Queries
sql queries
Week 6 - Data Manipulation in SQL
database, SQL, SELECT, FROM, WHERE, ORDER BY, LIMIT
Mock exam - Quiz1
python
Week 4 - Control (loop)
loop, for, while, list, dict, json
EX2 - Intermediate Python
control, list, dict, pandas
Week 3 - Control (conditional)
conditional, if, bool
EX1 - Introduction to Python
Python basics
Week 2 - Representation
Functions, variables, operators
Week 1 - Introduction to Data Analytics
Course logistics, programming fundamentals, pseudocode