BD202

Advanced SQL Programming for programmers

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
    • Montreal
    • Quebec City
  • 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

Programmers.

Prerequisite

Knowledge of SQL.

.

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.
  • Montreal

    February 3 to February 4 2020

  • Quebec City

    February 10 to February 11 2020 - CONFIRMED

  • 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