Introduction to SQL

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