How to retrieve information from a Database Management System (DBMS) in SQL language when you are not a computer scientist? This course shows you how to extract data from a table, query data from multiple tables, present and sort data, and use subqueries.
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.
Is it for you ?
Anyone needing to perform simple queries or updates on a database using SQL.
Prerequisite
Basic knowledge of computer science.
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
See more + / -
- Using a query builder tool
- Designing simple and complex queries
- Using subqueries
- Set operations: UNION, INTERSECT and EXCEPT
- Validating and verifying queries.
💡 Useful information
Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .
Trainers
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote