| 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.) |
$571.20 |
| Schedule | Saturday 9 a.m. – 4:30 p.m. (30 minute lunch) |
| Dates | September 7, 21; October 5, 19. No class on September 14, 28 October 12. Last class on October 19: 9 a.m. – 12 p.m. |
| Prerequisites | Basic knowledge of the Windows operating system |
| Target Audience | Individuals who are new to writing SQL queries |
| Instructor | Khattar Daou |
| Location | 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
