SQL Programming


overall satisfaction for this course

?Average calculated from scores obtained from 1515 participants who took this course.
  • Duration 2 DAYS
  • Regular fee 945
  • Preferential fee 795?
  • Locations
    • Montreal
    • Quebec City
  • Top pick
  • Laboratory

Formation path :

Databases Training Paths

View path


To provide the knowledge and skills required to formulate queries and to update a database using the SQL language.

Targeted audience

Developers (other than supervisors), Web specialists and those working in networking positions (other than security).


Knowledge of conceptual data modeling (Course BD101).

Customer Testimonials

Excellent basic knowledge to understand SQL.

Jocelyne D. / Analyste, Caisse de dépôt et placement du Québec


  • Databases and SQL
  • Data definition
  • Creating and modifying objects: CREATE, ALTER and DROP
  • Updating data: INSERT, UPDATE and DELETE
  • Transactions and procedural SQL
  • Querying data with the SELECT command
  • Inner joins and outer joins
  • Self joins: joining a table with itself
  • Nested queries
  • Sorting results: ORDER BY
  • Aggregation functions: COUNT, MIN, MAX and AVG
  • Grouping with GROUP BY and HAVING
  • Set operations: union, intersection and difference
  • Data manipulation functions
  • Transactions: COMMIT and ROLLBACK
  • Controlling access to data: GRANT, REVOKE and DENY


*Unless stated otherwise, all sessions are in French.
  • Montreal

    July 9 to July 10 2018

  • Quebec City

    July 11 to July 12 2018

  • Montreal

    October 22 to October 23 2018

  • Quebec City

    November 5 to November 6 2018

  • Montreal

    December 19 to December 20 2018

Trainer(s) assigned(s)

Other course(s) in this category