We move! Starting September 1st, our QUEBEC CITY training center will be located at 5400, des Galeries Blvd, Suite 500, 5th Floor, Québec (Quebec) G2K 2B4
BD202

Advanced SQL Programming

93%

overall satisfaction for this course

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

Objectives

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.

Prerequisite

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

Training Details

Content

  • 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

Customer Testimonials

A more in-depth look at SQL. The trainer is excellent, energetic, able to answer everyone's questions and provide examples.

Alnour G. / Analyste programmeur senior, Financière Banque Nationale

Select the training date*

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

    October 21 to October 22 2019 - CONFIRMED

  • Montreal

    December 2 to December 3 2019

  • Montreal

    February 3 to February 4 2020

  • Quebec City

    February 10 to February 11 2020

  • Quebec City

    April 22 to April 23 2020

  • Montreal

    June 8 to June 9 2020

Trainer(s) assigned(s)

Other course(s) in this category