BD102

SQL Programming

90%

overall satisfaction for this course

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

Objectives

To provide the knowledge and skills required to formulate queries and to update a database using the SQL language.

Targeted audience

Developers (other than supervisors), Web specialists and those working in networking positions (other than security).

Prerequisite

Knowledge of conceptual data modeling (Course BD101).

Training Details

Content

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

Customer Testimonials

Wonderful use of the course material. Very efficient!

André B. / Chef de service, Mise en onde et conservation de fichiers, Bell Média inc.

Select the training date*

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

    November 18 to November 19 2019 - CONFIRMED

  • Quebec City

    January 20 to January 21 2020

  • Montreal

    January 22 to January 23 2020

  • Gatineau

    February 5 to February 6 2020

  • Montreal

    April 20 to April 21 2020

  • Quebec City

    June 1 to June 2 2020

  • Montreal

    July 13 to July 14 2020

Trainer(s) assigned(s)

Other course(s) in this category