0845 450 6120

Oracle Database 12c Introduction for Experienced SQL Users

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.

We don't currently have any courses listed for Oracle Database 12c Introduction for Experienced SQL Users, would you like to view all courses for Oracle?

Learning Objectives

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.

Pre-Requisites

SQL Fundamentals

Course Content

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 

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

Our Customers Include