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 955
  • Preferential fee 860?
  • Locations
    • Montreal
    • Quebec City
  • Top pick
  • Laboratory
    course
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).

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 22 to October 23 2018 - CONFIRMED

  • Quebec City

    November 5 to November 6 2018

  • Montreal

    December 19 to December 20 2018

  • Quebec City

    January 30 to January 31 2019

  • Montreal

    February 11 to February 12 2019

  • Quebec City

    May 1 to May 2 2019

  • Montreal

    June 3 to June 4 2019

Trainer(s) assigned(s)

Other course(s) in this category