MS524

MS SQL: Creating Queries for the Business User

95%

overall satisfaction for this course

?Average calculated from scores obtained from 205 participants who took this course.
  • Duration 2 days
  • Regular fee 945
  • Preferential fee 795?
  • Locations
    • Quebec City
    • Montreal
  • Laboratory
    course
Parcours

Formation path :

Databases Training Paths

View path
SUMMARY
DETAILS

Objectives

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.

Prerequisite

Basic familiarity with information technologies.

Customer Testimonials

This course is really adapted to beginners with SQL queries.

Johanne L. / Chargée de projet, Assurance qualité, Service correctionnel du Canada

Content

  • 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

DATES*

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

    December 11 to December 12 2017

  • Quebec City

    January 22 to January 23 2018

  • Montreal

    February 7 to February 8 2018

  • Quebec City

    May 7 to May 8 2018

  • Montreal

    May 30 to May 31 2018

Trainer(s) assigned(s)

Other course(s) in this category