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.
Duration
2 days
Schedule
9h to 16h
Regular fee
$1,035
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$930
Objectives of the training
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 knowledge of computer science.Trainers
Course architecture
- 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
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
2 days
Schedule
9h to 16h
Regular fee
$1,035
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$930
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote