0845 450 6120

Oracle SQL

This 3 day Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced.


Who will the Course Benefit?

Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle relational database.

 
Reset

Learning Objectives

The delegates will practise:

  • Creating SQL statements to query database tables
  • Using standard aggregate functions and related SELECT statement clauses
  • Implementing extended SQL functions
  • Joining Tables
  • Using subqueries
  • Creating and altering tables and views
  • Inserting, updating and deleting rows in database tables

Pre-Requisites

There are no formal pre-requisites for the Oracle SQL course, although an understanding of databases and exposure to information technology in general would be useful.

Course Content

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

Exams & Certification

The course covers the major topics required for the Oracle examination 1Z0-051: Oracle Database 11g: SQL Fundamentals I. Together with the Oracle SQL Advanced course, the Oracle SQL course also covers the major topics required for the following Oracle examination: 1Z0-047: Oracle Database SQL Expert.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course.

One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Virtual Classroom

Virtual classrooms provide all the benefits of attending a classroom course without the need to arrange travel and accomodation. Please note that virtual courses are attended in real-time, commencing on a specified date.

Virtual Course Dates

Our Customers Include