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 

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

 

Our Customers Include