Oracle Database 12c: SQL Workshop II
CLASS DATE(s):
Request a Class

COURSE LENGTH: 2 Days

COURSE COST: $1295

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print

COURSE OVERVIEW

This Oracle Database: SQL Workshop II helps you enhance your skills as an Application developer by learning how to manage the database objects, data dictionary views and multicolumn subqueries. Expert Oracle instructors will teach you how to write more efficient queries using the functions that support timezone and regular expressions.

AUDIENCE AND PREREQUISITES

- Functional Implementer
- Forms Developer
- System Analysts
- Application Developers
- PL/SQL Developer

  

*Course Cost listed does not include the cost of courseware. Please refer to your Invoice for the additional cost. If you have any questions, please contact us (learn@vtec.org or 207-775-0244). Course subject to minimum enrollment. Courses maybe run as a LDL - Live Distance Learning if minimum enrolled is not met.

COURSE TOPICS:


Introduction
Course Objectives, Course Agenda and Appendixes Used in this Course
Provide an insight of the development environments
Tables used in the Course
Review of the SQL Concepts

Introduction to Data Dictionary Views
Introduction to Data Dictionary
Describe the Data Dictionary Structure
Using the Data Dictionary Views
Querying the Data Dictionary Views

Creating Sequences, Synonyms, Indexes
Overview of sequences
Overview of synonyms
Overview of indexes

Creating Views
Overview of views

Managing Schema Objects
Managing constraints
Creating and using temporary tables
Creating and using external tables

Retrieving Data by Using Subqueries
Retrieving Data by Using a Subquery as Source
Working with Multiple-Column subqueries
Using Scalar subqueries in SQL
Correlated Subqueries
Working with the WITH clause

Manipulating Data by Using Subqueries
Using Subqueries to Manipulate Data
Inserting by Using a Subquery as a Target
Using the WITH CHECK OPTION Keyword on DML Statements
Using Correlated Subqueries to Update and Delete rows

Controlling User Access
System privileges
Creating a role
Object privileges
Revoking object privileges

Manipulating Data
Overview of the Explicit Default Feature
Using multitable INSERTs
Using the MERGE statement
Performing flashback operations
Tracking Changes in Data

Managing Data in Different Time Zones
Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
Working with INTERVAL data types
Using Datetime functions in queries