25,000+ Courses Nationwide
0345 4506120

Oracle 12c SQL

The Oracle 12c SQL training course gives a complete introduction to Oracle 12c's version of SQL, covering the SQL*Plus toolkit and Oracle 12c RDBMS contextual operating environment.

Target Audience:

  • Oracle Analyst Programmers
  • Oracle Technicians
  • Oracle DBA's
  • Oracle Developers
  • Oracle Support Teams
  • Oracle Testers
  • ANSI SQL Users

Select specific date to see price, venue and full details.

Learning Objectives

This Oracle 12c course gives a complete introduction to Oracle 12c's version of SQL, covering the SQL*Plus toolkit and Oracle 12c RDBMS contextual operating environment. It is an essential building block for all users of Oracle 's full technology range, including database technology, development tools, and web technologies. The course comprehensively introduces the ANSI standard features of the Oracle 12c SQL implementation.


PC Fundamentals

Course Content

Oracle Overview

Introducing Oracle

The Elements of the Oracle System

Relational Concepts


SQL*Plus and SQL


Logging on to SQL*Plus and Leaving SQL*Plus

Choosing and Describing Tables

Elements of the SQL Query

The SQL Buffer and Query Layout

Editing SQL Statements

The System Dummy Table

Selecting Columns

Duplicate Information (DISTINCT)

Sorting Information


SQL Functions

The Concatenation Operator

Elements of the SQL Query: Arithmetic

Column Aliases

String Functions

Arithmetic Functions

Date Functions

Mixed Functions


Advanced SQL Functions

Nesting Different Functions


Filtering Data Using Where

Where Operators

Where with Keywords

Where and Logical Operators

Where and Soundex


Retrieving Multiple Table Data

Joining Tables (Equi-Joins)

Aliases for Table Names

Thinking behind creating Joins

Joining Tables (Non-Equi-Joins)

Joining Tables (Outer Joins)

Joining Tables (Inner Joins)


Group By / Group By Functions

Group Function Examples

Group Function with Having

Object Support



Basic Subqueries

Multiple Column Subqueries

Subqueries with Having

Correlated Subqueries

Subquery Rules and Suggestions


Introduction to Data Definition Language (DDL)

Create, Drop Alter Keywords




Integrity Constraints

Types of Constraint

Referential Integrity

Defining Constraints

Integrity Constraints and Data Dictionary

Alter table



Create Index

Unique Option

When and What to Index

Drop Index

Validate Index

Index Type Overview


Data Manipulation Lang (DML)

Insert /Update/Delete

OPS Commands (Commit, Rollback and Savepoints)


Data Control Language (DCL)

Data Security

Grant and Revoke


SQL*Plus Reporting

Introducing SQL*Plus for Reporting

Using SQL*Plus

Using the System Editor for SQL*Plus

SQL*Plus Command Variables

Building SQL*Plus Reports

Titles and Headings



ANSI Standardisation

Oracle (since 9ir2) Joins improvements

Case Expressions


Scalar Subqueries

Date Datatype


INTERVAL Datatypes


Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.


We work with the best