SQL – Beginner

Return to schedule

register-button24

Course Title SQL – Beginner
Course Number 900-002-EQ/2
Platform Windows
Duration 24 hours
Emploi-Québec fee (taxes incl.)
$48
General Public fee (taxes incl.)
$526.49
Schedule Tuesday

18:00 – 22:00

Dates TBD
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-213

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
TOP