Duration: 1 days
Course Learning Skills: SQL
This course is for either system developers or people from other areas who need to use Oracle SQL to extract and analyse data.
Ideally each delegate should be familiar with the basic principles of data structures and database usage.
Delegates will gain an understanding of the basic principles of Structured Query Language covering each of the following:
- constructing an SQL statement
- filtering of table data
- dos and don’ts of joining tables
- primary and foreign keys
- number, date and text manipulations
- grouping and summarising
- maintaining tables and their structure
- maintaining table data