Oracle Database 12c R2: SQL Workshop II Ed 2 Training

Live Online & Classroom Enterprise Certification Training

The Oracle Database: SQL Workshop II Ed 2 course will help students enhance their skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries. Students also learn to write more efficient queries using the functions supporting the timezone and regular expressions.

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is 12c R2: SQL Workshop II Ed 2 Certification Training about?

This course is designed for application developers with basic SQL language skills. Students learn how to use the advanced features of SQL in order to query and manipulate data within the database. Students will also learn how to control privileges at the object and system level. Advanced querying and reporting techniques are explained. Students will learn to use the regular expression support in SQL.

Students benefit by using Oracle SQL Developer as the main environment tool for writing SQL. SQL*Plus is introduced as an optional tool. Demonstrations and hands-on practice reinforce the concepts.

What are the objectives of 12c R2: SQL Workshop II Ed 2 Certification Training ?

Add new users with different levels of access privileges
Manage schema objects
Run data definition language (DDL) statements to create and manage schema objects
Manage objects with data dictionary views
Manipulate large data sets in the Oracle database by using subqueries
Manage data in different time zones
Control database access to specific objects
Write multiple-column subqueries
Use scalar and correlated subqueries
Use the regular expression support in SQL

Who is 12c R2: SQL Workshop II Ed 2 Certification Training for?

Functional Implementer
PL/SQL Developer
Application Developers
Database Administrators
System Analysts
Forms Developer

What are the prerequisites for 12c R2: SQL Workshop II Ed 2 Certification Training?

Suggested Prerequisite

Basic Knowledge of SQL
Familiarity with SQL Developer, SQL*Plus

Required Prerequisite

Oracle Database: SQL Workshop I Ed 2

Available Training Modes

Live Online Training

16 Hours

Classroom Training

2 Days

Course Outline Expand All

Expand All

Introduction

Course Objectives, Course Agenda and Appendixes Used in this Course

Review of the SQL Concepts

Provide an insight of the development environments

Tables used in the Course

Introduction to Data Dictionary Views

Introduction to Data Dictionary

Querying the Data Dictionary Views

Using the Data Dictionary views

Describe the Data Dictionary Structure

Creating Sequences, Synonyms, Indexes

Overview of sequences

Overview of indexes

Overview of synonyms

Creating Views

Overview of views

Managing Schema Objects

Creating and using temporary tables

Creating and using external tables

Managing constraints

Retrieving Data by Using Subqueries

Working with the WITH clause

Retrieving Data by Using a Subquery as Source

Using Scalar subqueries in SQL

Working with Multiple-Column subqueries

Correlated Subqueries

Manipulating Data by Using Subqueries

Inserting by Using a Subquery as a Target

Using Subqueries to Manipulate Data

Using Correlated Subqueries to Update and Delete rows

Using the WITH CHECK OPTION Keyword on DML Statements

Controlling User Access

Object privileges

Creating a role

Revoking object privileges

System privileges

Manipulating Data Using Advanced Queries

Using multitable INSERTs

Overview of the Explicit Default Feature

Tracking Changes in Data

Performing flashback operations

Using the MERGE statement

Managing Data in Different Time Zones

Using Datetime functions in queries

Working with INTERVAL data types

Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

12c R2: SQL Workshop II Ed 2 Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree