Oracle Database 12c: SQL Workshop II
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.
Description
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.
What You'll Learn
- Grant and revoke privileges and roles.
- Manage schema objects and data dictionary views.
- Write efficient and complex subqueries.
- Use the in-built functions supporting the usage of regular expressions and time zone.
Prerequisites
- Familiarity with SQL Developer, SQL*Plus
- Basic Knowledge of SQL
- Oracle Database 12c : SQL Workshop I
Audience
Outline
10 modules
•
2 Days total
- 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
- Describe the Data Dictionary Structure
- Using the Data Dictionary Views
- Querying the Data Dictionary Views
- Overview of sequences
- Overview of synonyms
- Overview of indexes
- Overview of views
- Managing constraints
- Creating and using temporary tables
- Creating and using external tables
- 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
- 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
- System privileges
- Creating a role
- Object privileges
- Revoking object privileges
- Overview of the Explicit Default Feature
- Using multitable INSERTs
- Using the MERGE statement
- Performing flashback operations
- Tracking Changes in Data
- Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
- Working with INTERVAL data types
- Using Datetime functions in queries