We move! Starting September 1st, our QUEBEC CITY training center will be located at 5400, des Galeries Blvd, Suite 500, 5th Floor, Québec (Quebec) G2K 2B4

MS SQL: Creating Queries for non-IT people


overall satisfaction for this course

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


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.

Training Details


  • Introduction to relational databases: the basic concepts of tables, views, keys and relationships
  • Overview of database modeling 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

Customer Testimonials

The content is accessible which makes the understanding easier.

Kim R. / Analyste financière sénior, Farinart inc.

Select the training date*

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

    September 23 to September 24 2019 - CONFIRMED

  • Montreal

    October 28 to October 29 2019 - CONFIRMED

  • Montreal

    January 6 to January 7 2020

  • Quebec City

    February 20 to February 21 2020

  • Montreal

    March 16 to March 17 2020

  • Quebec City

    April 1 to April 2 2020

Trainer(s) assigned(s)

Other course(s) in this category