People in charge of reporting or analysis, assistants, anyone who needs to carry out simple queries or updates on a database with SQL language.
No particular knowledge. Education common to all relational databases (Oracle, SQL Server, DB2, PostGreSQL, MySQL, Access, SQL Lite, etc.).
This "discovery" course will enable you to understand relational databases and how they operate. You'll work with the SQL language to query the data in a base. You'll also become familiar with more advanced queries to analyse information.
At the end of this training, the participant will be able to:
Introduction to databases
Exercise: Investigating the database by searching for tables, views, columns, and keys.
Extracting data from a table
Exercise: Querying multiple tables on different criteria.
Querying data from multiple tables
Exercise: Creating queries with joins and assembly operators.
Ranking and statistics
Exercise: Creating queries using simple and aggregate calculations. Subtotals and numbering.
Presenting and sorting data
Exercise: Using functions to improve the presentation of the query result.
Using subqueries
Exercise: Writing queries that include sub-queries of different forms. Creating views.
By the end of the training, the trainee will receive a certificate of participation issued by the House of Training.
Many sequential exercises for extracting data from an example database.