|Course Title||SQL – Beginner
|Emploi-Québec fee (taxes incl.)
|General Public fee (taxes incl.)
|Schedule||Saturday 9:00 a.m. – 5:30 p.m.
Lunch 30 mins.
|Dates||September 16, 23, 30|
|Prerequisites||Basic knowledge of the Windows operating system|
|Target Audience||Individuals who are new to writing SQL queries|
|Location||Brittain Hall – lab BH-214|
NB. This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
This course provides an introduction to SQL Structure Query Language (SQL) and explores the concept of relational database management systems. We will cover the topics of designing a database, creating tables, setting primary and foreign keys as well as normalizing the database tables.
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