BD102

SQL Programming

89%

overall satisfaction for this course

?Average calculated from scores obtained from 1515 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 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).

Customer Testimonials

Excellent basic knowledge to understand SQL.

Jocelyne D. / Analyste, Caisse de dépôt et placement du Québec

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

DATES*

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

    October 2 to October 3 2017

  • Quebec City

    November 20 to November 21 2017

  • Montreal

    December 4 to December 5 2017

  • Montreal

    February 5 to February 6 2018

  • Quebec City

    March 26 to March 27 2018

  • Montreal

    April 30 to May 1 2018

  • Montreal

    July 9 to July 10 2018

  • Quebec City

    July 11 to July 12 2018

Trainer(s) assigned(s)

Other course(s) in this category