BD102

SQL Programming

89%

overall satisfaction for this course

?Average calculated from scores obtained from 1410 participants who took this course.
  • Duration 2 days
  • Regular fee 895
  • Preferential fee 750?
  • 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

Analysts, designers, programmers and relational database administrators.

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

    January 23 to January 24 2017

  • Quebec City

    March 15 to March 16 2017

  • Montreal

    March 20 to March 21 2017

  • Montreal

    May 8 to May 9 2017

  • Quebec City

    July 3 to July 4 2017

Trainer(s) assigned(s)

Other course(s) in this category