Introduction to SQL
Course Code: Y1B3
ECTS Credits: 2.0
Course Description
This course introduces students to the core principals of relational databases and Structured Query Language (SQL). Students will learn how to model, design, implement, and query modern databases. The course begins with the relational data model and the structure of SQL, exploring its five sublanguages. Building on SQL proficiency, the course then addresses principles of database design, normalization and, star and snowflake schemas. Finally, students are introduced to the differences between OLAP (Online Analytical Processing) and OLTP (Online Transactional Processing) workloads.
Course Content
- Relational Databases
- Structured Query Language (SQL)
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Query Language (DQL)
- Data Control Language (DCL)
- Transaction Control Language (TCL)
- Normalization
- Schema Designs
- OLAP vs OLTP
Prerequisites
- Introduction to Programming with Python (Y1A1)