SQL Programming


overall satisfaction for this course

?Average calculated from scores obtained from 1658 participants who took this course.
  • Duration 2 days
  • Regular fee 955
  • Preferential fee 860?
  • Locations
    • Montreal
    • Quebec City
  • Top pick
  • Laboratory


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).


  • 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

    June 3 to June 4 2019 - CONFIRMED

  • Montreal

    August 26 to August 27 2019

  • Quebec City

    November 4 to November 5 2019

  • Montreal

    November 18 to November 19 2019

Trainer(s) assigned(s)

Other course(s) in this category