search
    

    Home Oracle Oracle Database: SQL Workshop II NEW

    QUICK

    INFORMATION

    course-duration

    2 Day(s) Course

    courseware

    Official Courseware

    exam-voucher

    Exam Voucher

    certified-trainer

    Certified Trainer

    one-o-one

    1:1 Training Available on Demand

    customize-batch

    Customize Your Batch

    ABOUT

    THE COURSE

    The Oracle Database: SQL Workshop II training imparts the essential skills to Application developers in managing the database objects, data dictionary views and multicolumn subqueries. During this training, participants will also learn to write various efficient queries deploying the functions supporting the time zone and regular expressions.

    Completion of this training course will enable candidates in:

    • Granting and revoking privileges and roles.
    • Managing schema objects and data dictionary views.
    • Writing efficient and complex subqueries.
    • Using the inbuilt functions supporting the usage of regular expressions and time zone.

    Course Benefits:


    Attaining certification of this course will help participants to deploy the advanced features of SQL in order to query and manipulate data within a database, learn how to control privileges at the object and at the system level. This course has been designed for application developers that will explain advanced querying and reporting techniques are explained.

    1. Introduction

    • Course Objectives & Agenda
    • Provide an insight of the development environments
    • Review of the SQL Concepts
    • Tables used in the Course


    2. Introduction to Data Dictionary Views

    • Introduction to Data Dictionary
    • Describe the Data Dictionary Structure
    • Use the Data Dictionary views
    • Query the Data Dictionary Views

    3. How to Create Sequence, Synonym, And Indexes

    • Overview of Sequences
    • Overview of Synonyms
    • Overview of Indexes

    4. Creating Views

    • Overview of views

    5. Managing Schema Objects

    • Manage constraints
    • Create and using temporary tables
    • Create and using external tables

    6. Retrieving Data by Using Subqueries

    • Retrieve Data by Using a Subquery as Source
    • Work with Multiple-Column subqueries
    • Use Scalar subqueries in SQL
    • Correlated Subqueries
    • Work with the WITH clause

    7. Manipulating Data by Using Subqueries

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

    8. Controlling User Access

    • System privileges
    • Create a role
    • Object privileges
    • Revoke object privileges

    9. Managing Data in Different Time Zones

    • Work with CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP
    • Work with INTERVAL data types
    • Use Date time functions in queries

    10. Manipulating Data Using Advanced Queries

    • Overview of the Explicit Default Feature
    • Use multi-table INSERTs
    • Use the MERGE statement
    • Perform flashback operations
    • Track Changes in Data

    This Oracle Database SQL Workshop II is ideal for:

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

    • Familiarity with SQL Developer, SQL*Plus
    • Basic Knowledge of SQL
    • Oracle Database: SQL Workshop I Ed 2

    Name Code Fee

    enquiry

    ENQUIRY FORM

    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.