Introduction to Oracle 12c SQL Programming Training

Answers to Popular Questions:

 
Yes, this class can be tailored to meet your specific training needs.
Yes, we provide Oracle, MySQL, Cassandra, Hadoop Database consulting services.
Yes, group discounts are provided.

Course Description

 
In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 11g Structured Query Language (SQL). Students will be introduced to Oracle 12c advanced capabilities database which promote better performance, increased scalability and easier data management.
Course Length: 2 Days
Course Tuition: $890 (US)

Prerequisites

Familiarity with relational database concepts is recommended.

Course Outline

 

1. Course Introduction
Course Objectives
Course Overview
Using the Workbook
Suggested References

2. Relational Database and SQL Overview
Review of Relational Database
Terminology
Relational Database Management
Systems
SQL Datatypes
Introduction to SQL

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

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

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

6. SQL Queries-Joins
Selecting from Multiple Tables
Joining Tables
Self Joins
Outer Joins
Equijoins, Non-equijoins, and Antijoins

7.  Aggregate Functions and Advanced Techniques
Subqueries
Correlated Subqueries
The EXISTS Operator
The Aggregate Functions
Nulls and DISTINCT
Grouping Rows
Combining SELECT Statements

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

9. Data Definition and Control Statements
Datatypes
Defining Tables
Constraints
Foreign Keys
Modifying Table Definitions
Deleting a Table Definition
Controlling Access to Your Tables

10. Other Database Objects
Views
Creating Views
Updatable Views
Sequences
Indexes

11. Appendix A–Using Oracle SQL*Plus
SQL*Plus
The SQL Buffer
Buffer Manipulation Commands
Running SQL*Plus Scripts
Tailoring Your SQL*Plus Environment
Viewing Table Characteristics
SQL*Plus Substitution Variables
Interactive SQL*Plus Scripts
SQL*Plus LOB Support

12. Appendix B-The Data Dictionary
Introducing the Data Dictionary
DBA, ALL, and USER Data Dictionary

Course Directory [training on all levels]

Upcoming Classes