Oracle Database 12c Introduction for Experienced SQL Users

Course code: OD04

2 days £920.00

This iTrain Oracle 12c SQL for Users training course gives a basic introduction to Oracle's version of 12c SQL, introducing the concepts behind the SQL language and the basics of SQL*Plus.

Course content >

Who Should Attend?

Oracle Technicians

Oracle DBAs

Oracle Developers



SQL Fundamentals

Course Reviews

iTrain also offer all of these courses as closed courses on your site. Please call 020 7608 1835

27 Feb 2020 London Delegates:    £920.00 £840.00
16 Apr 2020 London Delegates:    £920.00
29 Jun 2020 London Delegates:    £920.00

Course Contents

The Oracle Database 12c Introduction for Experienced SQL Users training course is designed to introduce concepts and functionality in an accessible and friendly format, the course has been prepared to assist end-users understand how to retrieve and maintain information within a controlled Oracle 12c database environment.

Understanding the Oracle Database Environment

Identify Oracle Database components

Define an instance and how to connect to it

Describe parsing of a SQL statement

Describe the processing of a SQL statement

Declare, reference, and display bind variables

Describe read consistency


Using SQL Developer

List the key features of Oracle SQL Developer

Install Oracle SQL Developer

Identify the menu items of Oracle SQL Developer

Create a database connection

Manage database objects

Use SQL Worksheet

Save and Run SQL scripts

Create and save reports


Getting Started with Oracle SQL

Execute a SELECT statement

Implement pseudocolumns in SQL

Utilize the different types operators, conditions, expressions, and functions in SQL

Convert between data types using explicit data type conversion

Describe how SQL treats NULL values


Combining Tables using Advanced Queries

Write subqueries

Update and delete rows using correlated subqueries

Explain the concept of hierarchical query

Perform joins in SQL

Create a tree-structured report

Exclude branches from the tree structure


Creating and Managing Tables

Create and maintain tables by using the CREATE, ALTER, DROP, RENAME, and TRUNCATE statements

Use the data dictionary to view and maintain information about tables

Create and maintain integrity constraints

Discuss constraint states


Creating and Managing Other Oracle Database Objects

Create and maintain a view

Retrieve, insert, update, and delete data through a view

Create, maintain, and use sequences

Create and maintain indexes

Create private and public synonyms


Controlling User Access

Discuss the concepts of users, roles, and privileges

Create users

Create roles

Grant and revoke object privileges

Create and access database links


Oracle Database Extensions to DML and DDL Statements

Describe the features of multi table INSERT statements

Use multi table INSERT statements

Merge rows using the MERGE statement

Create and use external tables

Describe transaction processing



Contact us for more information