Query databases and turn data into actionable insights
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.
Is it for you ?
Anyone needing to perform simple queries or updates on a database using SQL.
Prerequisites
Basic knowledge of computer science.
Training 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.
See more
📌 Practical information
Our training sessions are offered in Montreal or Quebec City, in person or in a virtual classroom. Dates and locations are specified when you select your session below. If you have any questions, check out our FAQ.
