Introduction to Oracle 12c SQL Programming

This course has been superseded

We suggest the following instead:
Oracle Database - SQL I Introduction

Course Description

In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 12c Structured Query Language (SQL). participants will be introduced to Oracle 12c advanced capabilities database which promote better performance, increased scalability and easier data management.
2 days
Contact us for pricing
 

Prerequisites

Familiarity with relational database concepts is recommended.

Course Introduction

Course Objectives
Course Overview
Using the Workbook
Suggested References

Relational Database and SQL Overview

Review of Relational Database Terminology
Relational Database Management Systems
SQL Datatypes
Introduction to SQL

Oracle Database

Oracle Versioning and History
Logical and Physical Storage Structures
Datatypes
Overview of Oracle Architecture
Connecting to Oracle
SQL*Plus
Graphical Clients
The Oracle Data Dictionary
Sample Database

SQL Queries – The SELECT Statement

The SELECT Statement
Choosing Rows with the WHERE Clause
NULL Values
Compound Expressions
IN and BETWEEN
Pattern Matching: LIKE and REGEXP_LIKE
The CASE WHEN Expression
Creating Some Order

Scalar Functions

SQL Functions
Using SQL Functions
String Functions
Regular Expression Functions
Numeric Functions
Date Functions
Date Formats
Conversion Functions
Literal Values
Intervals
Oracle Pseudocolumns

SQL Queries - Joins

Selecting from Multiple Tables
Joining Tables
Self Joins
Outer Joins
Equijoins, Non-equijoins, and Antijoins

Aggregate Functions and Advanced Techniques

Subqueries
Correlated Subqueries
The EXISTS Operator
The Aggregate Functions
Nulls and DISTINCT
Grouping Rows
Combining SELECT Statements

Data Manipulation and Transactions

The INSERT Statement
The UPDATE Statement
The DELETE Statement
Transaction Management
Concurrency
Explicit Locking
Data Inconsistencies
Loading Tables From External Sources

Data Definition and Control Statements

Datatypes
Defining Tables
Constraints
Foreign Keys
Modifying Table Definitions
Deleting a Table Definition
Controlling Access to Your Tables

Other Database Objects

Views
Creating Views
Updatable Views
Sequences
Indexes
Oracle 12cOracle ProgrammingOracle Database 12cOracle SQLOracle SQL Programming