Registration: Please contact CTD at eqctd@dawsoncollege.qc.ca to request the form.

This course provides an introduction to Structure Query Language (SQL) and explores the concepts of designing and working with a relational database management system. We will cover the topics of designing a database, creating tables, setting primary and foreign keys as well as normalizing the database tables to 3rd normal form.

Prerequisite: Knowledge of computers and databases

Topics Covered in this Course:
• Overview of the relational database management systems (RDBMS)
• Introduction to SQL Language and Sublanguages (DDL, DML and DCL)
• Steps for Database design
• Primary Key
• Foreign Key
• Entity Relationship Diagram
• Normalization of Database Tables

Required Material: 2GB (or higher) Flash (USB) Drive