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ébecEligibility:
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.