Questions? Feedback? powered by Olark live chat software

Oracle Database: SQL Workshop II Training Courses

About the Oracle Database: SQL Workshop II

Duration: 3 days (24 hours)

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.

Objectives
Grant and revoke privileges and roles.
How to Manage schema objects and data dictionary views.
Write efficient and complex subqueries.
Learn to Use the in-built functions supporting the usage of regular expressions and time zone.

Next Class Dates

Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

Back to Top

This training consists of the following courses:

Oracle Database: SQL Workshop II   More on this course

3 days | 24 hours

arrow Course Objectives

  • » Grant and revoke privileges and roles.
  • » How to Manage schema objects and data dictionary views.
  • » Write efficient and complex subqueries.
  • » Learn to Use the in-built functions supporting the usage of regular expressions and time zone.

Back to Top

arrow Course Outline

  • Introduction
    1. Course Objectives, Course Agenda and Appendixes Used in this Course
    2. Provide an insight of the development environments
    3. Tables used in the Course
    4. Review of the SQL Concepts
  • Introduction to Data Dictionary Views
    1. Introduction to Data Dictionary
    2. Describe the Data Dictionary Structure
    3. Using the Data Dictionary views
    4. Querying the Data Dictionary Views
  • Creating Sequences, Synonyms, Indexes
    1. Overview of sequences
    2. Overview of synonyms
    3. Overview of indexes
  • Creating Views
    1. Overview of views
  • Managing Schema Objects
    1. Managing constraints
    2. Creating and using temporary tables
    3. Creating and using external tables
  • Retrieving Data by Using Subqueries
    1. Retrieving Data by Using a Subquery as Source
    2. Working with Multiple-Column subqueries
    3. Using Scalar subqueries in SQL
    4. Correlated Subqueries
    5. Working with the WITH clause
  • Manipulating Data by Using Subqueries
    1. Using Subqueries to Manipulate Data
    2. Inserting by Using a Subquery as a Target
    3. Using the WITH CHECK OPTION Keyword on DML Statements
    4. Using Correlated Subqueries to Update and Delete rows
  • Controlling User Access
    1. System privileges
    2. Creating a role
    3. Object privileges
    4. Revoking object privileges
  • Manipulating Data Using Advanced Queries
    1. Overview of the Explicit Default Feature
    2. Using multitable INSERTs
    3. Using the MERGE statement
    4. Performing flashback operations
    5. Tracking Changes in Data
  • Managing Data in Different Time Zones
    1. Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
    2. Working with INTERVAL data types
    3. Using Datetime functions in queries

Back to Top

Recent Client Testimonials & Reviews

Very satisfied with the subject explanation by the Instructure. He was very good at explaining the topics and helping out with the questions.The excellent collaborative environment was maintained during the lecture and lab sessions.

-Neha T
Course(s) Taken

» Oracle Database: SQL Workshop II

The instructor was very good at explaining the topics and helping out with the questions.Very satisfied with the subject explanation by Deep.The excellent collaborative environment was maintained during the lecture and lab sessions.

-Neha T
Course(s) Taken

» Oracle Database: SQL Workshop II

The instructor is a good presenter and educator.

- Thomas N.

Course(s) Taken

» Oracle Database: SQL Workshop I

  More testimonials »  

Back to Top