Training in Oracle SQL – Intermediate Course

Key Information

Duration: 1 days

Course Learning Skills: SQL

Brief

Attendees

This workshop is for anyone who already understands the basic concepts of Oracle SQL (see our basic course) and wishes now to move to the next stage.

Prerequisites

Ideally each delegate should be familiar with the basic principles of using SQL queries to filter and join database tables.

Benefits

Delegates will gain a better understanding of Structured Query Language covering each of the following:

1. reviewing all types of joins
2. using outer joins
3. combining inner and outer joins
4. reviewing all types of sub-queries
5. comparing sub-queries and joins
6. case statements
7. reviewing summary and grouping functions
8. set operators
9. using indexes
10. using a data dictionary

Do a short survey to tell us what you think about training?

Click here to take the survey, it’ll only take a few minutes!