IT

Data Management and Analytics

Learn relational databases, SQL querying, and foundational data analytics techniques.

SQL joins ER model Analytics

Database Fundamentals

What Is a Database? Understand what databases are, how relational databases work, and core concepts like tables, primary keys, and relationships. Entity-Relationship (ER) Diagrams Learn how Entity-Relationship (ER) diagrams model real-world data, and how to design multi-table databases with correct relationships.

SQL Essentials

What Is SQL? Write SQL SELECT queries to retrieve, filter, and sort data from database tables using WHERE, AND, OR, LIKE, and ORDER BY. Why Joins? Combine data from multiple tables using JOIN, and summarise data using GROUP BY, HAVING, and aggregate functions.