Advanced SQL Programming


overall satisfaction for this course

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

Formation path :

Databases Training Paths

View path


To provide the knowledge and skills required to optimize SQL requests in order to significantly improve application performance.

Targeted audience

Analysts, designers, programmers and relational database administrators.


Knowledge of conceptual data modeling (Course BD101) and SQL syntax (Course BD102).

Customer Testimonials

Exceeds my expectations. Really advanced course. I never thought that I would learned as much in two days. Excellent trainer.

Eric L. / Développeur logiciel, Cooper Industries (Electrical) Inc.


  • Review of relational database design and normalization
  • Problems related to collation
  • The importance of table and column sizing
  • Operations on tables: DELETE, INSERT, UPDATE
  • The SELECT query and joins
  • Sargable vs nonsargable queries
  • Optimizing predicates: LIKE, BETWEEN, IN, NOT IN, EXISTS and INTERSECT
  • Operations on groups (GROUP BY and correlated subqueries)
  • Aggregation functions
  • Auxiliary tables
  • Handling views and temporary tables
  • Optimizing subqueries and group operations
  • The judicious use of indexes (for sorting and querying)
  • Code optimization
  • Cursors: when to use them and how to avoid them
  • Triggers
  • Presentation of some advanced techniques


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

    November 21 to November 22 2016

  • Quebec City

    November 30 to December 1 2016

  • Montreal

    February 15 to February 16 2017

  • Montreal

    May 15 to May 16 2017

  • Quebec City

    June 19 to June 20 2017

Trainer(s) assigned(s)

Other course(s) in this category