Oracle SQL

This course is designed for anyone who needs to access and work with an Oracle Database.

Essential Oracle SQL skills

This course is a suitable introduction to SQL as used in Oracle Databases and associated tools. The course covers SQL statements that query and update data as well as defining the data structure.

Course Objectives
To provide delegates with the knowledge and skills needed to retrieve and update data held in an Oracle Relational Database.

Skills Gained
This course will enable delegates to:

Describe the basic structure of a relational database
Use the command line features of SQL*Plus
Create SQL statements to select data from an Oracle Database
Generate simple reports from selected data
Create and alter tables, indexes and views
Create, update and delete records
Grant and revoke access privileges
Access the Data Dictionary

Course Content

Relational Database Concepts

Using SQL*plus

SQL Select Statement

Selecting data from multiple tables

Inner Joins, Outer Joins and Self Joins

Grouping and sorting data

Sub-queries and In-line views

Character, Date and Numeric Functions

SQL*Plus run-time parameters and variables

SQL*Plus Control Parameters

Producing reports with SQL*Plus

Creating and changing tables and Views

Constraints and Indexes

Inserting, Updating and deleting data

Basic Transaction control

Controlling access to the database

Related Data Dictionaty tables and views