Copied to clipboard

SQL - Beginner

The following courses are offered by John Abbott College and with financial assistance provided by the Gouvernement du Québec - you pay $5 per hour.

About the program

This hands-on course examines the database and design concepts, introduces SQL Structure Query Language (SQL) and explores the concept of relational database management systems. It also covers 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

  • Relational database management systems (RDBMS)
  • Structure of Relational Databases
  • Introduction to SQL Languages: data-definition language (DDL), and data-manipulation language (DML), and Data-Control language (DCL)
  • Database design
  • Keys and Constraints
  • Entity Relationship Diagram
  • Normalization of Database Tables

Condition of admission

The admission conditions and the inscription procedures may differ from a CEGEP to another.

You should be ready to provide legal documents such as: a birth certificate, a proof of education (high school or cegep diploma, etc), some grade sheets, a comparative evaluation or a foreign degree, a resume, etc.

As for individuals born outside of Canada, you will have to provide a proof of citizenship or permanent residency.

To receive more details about the consulted program, please visit the website of the establishment offering the training, with the help of the information below.

John Abbott College (Continuing Education)

Course Attestation and Professional Development

Establishments offering this program

John Abbott College (Continuing Education)

English