MS SQL: Creating Queries for the Business User


overall satisfaction for this course

?Average calculated from scores obtained from 126 participants who took this course.
  • Duration 2 days
  • Regular fee 895
  • Preferential fee 750?
  • Locations
    • Montreal
    • Quebec City
  • Laboratory

Formation path :

Databases Training Paths

View path


To provide the knowledge and skills required to become familiar with modern databases, to prepare queries and reports using data extraction tools, and to use the database query language.

Targeted audience

Anyone needing to perform simple queries or updates on a database using SQL.


Basic familiarity with information technologies.

Customer Testimonials

This course suited perfectly my need.

Sylvie R. / Analyste qualité, Manuvie


  • Introduction to relational databases: the basic concepts of tables, views, keys and relationships
  • Overview of database modelling diagrams, and the relationships between tables
  • Data versus information: structured and non-structured data
  • Extracting data from a table with the SELECT command
  • Using joins to query data from several tables
  • Sorting and grouping
  • Using Microsoft Query (Excel) to query data
  • Using a query builder tool
  • Designing simple and complex queries
  • Using subqueries
  • Set operations: UNION, INTERSECT and EXCEPT
  • Validating and verifying queries


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

    January 25 to January 26 2017

  • Montreal

    April 6 to April 7 2017

  • Quebec City

    April 10 to April 11 2017

Trainer(s) assigned(s)

Other course(s) in this category