This training will teach you how to retrieve data using SQL. Among other things, it will cover SQL joins and aggregations, which participants must use to answer questions about a sample database containing DVD rental data during the practice session.
The training includes theory, demos, and practical exercises. After this training you will have gained knowledge about:
- SQL SELECT statements with filters, sorting, etc.
- SQL joins, left, right, inner, outer (why do all of these exist?)
- SQL aggregations
- Indexes used to speed up query execution
- SQL Views
- Database connectivity (JDBC and ODBC)