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.5 days
Schedule
See training dates for details
Regular fee
$1,350
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.
$1,215
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.
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
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.
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.
$1,215
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.
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 in-company 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.
By checking this box, I confirm that I have read and agree toTechnologia’s Privacy Policywhich provides information on how my personal information will be used following collection. In the event that you do not consent to the terms of the concerned Privacy Policy, Technologia will not have the information to assess your request, contact you to follow up on your request or provide you with the services.
I would like Technologia to send me commercial communications.
Learn more >
By checking this box, I agree that Technologia may use my personal information to send me commercial communications. I understand that I can withdraw my consent at any time by clicking on the unsubscribe link included in each communication. To learn more about how we manage your personal information, please consult our
Technologia’s Privacy Policy.