BD202

Advanced SQL Programming

Save 100$ off if you register for the session from December 6th to 7th in Montreal

94%

overall satisfaction for this course

?Average calculated from scores obtained from 751 participants who took this course.
  • Duration 2 days
  • Regular fee 945
  • Preferential fee 795?
  • Locations
    • Montreal
    • Quebec City
  • Top pick
  • Laboratory
    course
Parcours

Formation path :

Databases Training Paths

View path
SUMMARY
DETAILS

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

Customer Testimonials

I would recommend this course to anyone wanting to optimize their SQL knowledge.

Yves F. / Analyste, Comité de gestion, taxe scolaire de l'île de Mtl

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

DATES*

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

    December 6 to December 7 2017

  • Quebec City

    December 11 to December 12 2017

  • Montreal

    February 26 to February 27 2018

  • Quebec City

    April 19 to April 20 2018

  • Montreal

    May 28 to May 29 2018

Trainer(s) assigned(s)

Other course(s) in this category