| Course Title | SQL – Introduction |
| Course Number | 900-002-EQ |
| Platform | Windows |
| Duration | 24 hours |
| Gouvernement du Québec fee (taxes incl.) |
$48 |
| General Public fee (taxes incl.) |
$558.78 |
| Schedule | Monday 6 p.m. – 10 p.m. |
| Dates | January 7, 14, 21, 28; February 4, 11. |
| Prerequisites | Basic knowledge of the Windows operating system |
| Target Audience | Individuals who are new to writing SQL queries |
| Instructor | Khattar Daou |
| Location | Brittain Hall – lab BH-407 |
NB. This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
Course Description
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
