Prerequisite: Knowledge of computers and databases

Required Materia * : Computer with Windows 10 or MacOS X or higher, microphone & headset, high-speed internet connection.

* (If the course is online)

This course provides an introduction to Structured 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.

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

Courses subsidized by Emploi-Québec

Eligibility:

You are eligible to take these courses if you are:

• a seasonal worker who is not currently working, but retains ties with his/her employer;
• self-employed;
• overqualified for the position you currently hold and the course is relevant to your area of study.

You are not eligible to take these courses if you are:

• employed in the public or para-public sector;
• a full-time student;
• unemployed and/or receiving employment insurance or welfare;
• receiving CSST (worker's compensation) from the SAAQ.

Maximum of two (2) courses per person.
Maximum of three (3) registrations per establishment.