Databases
Conestoga College · Waterloo, Ontario
Relational database design, SQL, normalization, transactions, and introductory NoSQL concepts.
Overview
An introductory and applied course covering the fundamentals of relational databases and modern data storage concepts. Students learn to design, query, and maintain database systems used in real-world applications.
Topics Covered
- Relational Model — tables, keys, relationships, and referential integrity
- SQL — SELECT, JOINs, subqueries, aggregates, and window functions
- Normalization — 1NF through BCNF, eliminating redundancy and anomalies
- Transactions — ACID properties, isolation levels, concurrency control
- Stored Procedures & Triggers — server-side logic and automation
- NoSQL Concepts — document stores, key-value, column-family, and graph databases
Tools & Technologies
- PostgreSQL
- MySQL / MariaDB
- MongoDB (introductory)
- DBeaver / pgAdmin