Introduction to Oracle 12c SQL Programming

Request more details:

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