25,000+ Courses Nationwide
0345 4506120

Oracle Database 12c Introduction for Experienced SQL Users

This 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.

Who Should Attend?

Oracle Technicians

Oracle DBAs

Oracle Developers


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


SQL Fundamentals

Course Content

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


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