SQL Programming

Save 100$ off if you register for the session from 3rd to 4th in Quebec


overall satisfaction for this course

?Average calculated from scores obtained from 1410 participants who took this course.
  • Duration 2 days
  • Regular fee 895
  • Preferential fee 750?
  • Locations
    • Quebec City
    • Montreal
  • 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

Analysts, designers, programmers and relational database administrators.


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 the 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.
  • Quebec City

    July 3 to July 4 2017

  • Montreal

    October 2 to October 3 2017

  • Quebec City

    November 20 to November 21 2017

  • Montreal

    December 4 to December 5 2017

Trainer(s) assigned(s)

Other course(s) in this category