OR107 – Oracle 12c: Advanced SQL

Live Online & Classroom Enterprise Training

Location: Bangalore, India | Dubai, UAE

Industry Experienced Instructor  |  Remote Labs  |  Lab Access Post Training

Need help finding the right training?

Course Details

In this course, you will receive a hands-on introduction to advanced SQL concepts, especially as they relate to Oracle’s implementation of the SQL Language. Topics necessary to the development and administration of an Oracle 12c database are covered. This course is specifically designed for those who know generic SQL but are not familiar with SQL*Plus and more importantly, Oracle’s implementation of SQL.

Course Prerequisites

An understanding of relational database design concepts and general knowledge of SQL

Course Agenda

  • Understanding the Difference Between SQL, SQL*Plus, and PL/SQL
  • Understanding the SQL Developer Environment and Commands

2. SQL MODEL Statements

  • Symbolic cell addressing
  • Symbolic array computation
  • Wildcard dimension specification
  • Iterative rule evaluation
  • Partition wise computation

3. Analytical Functions

  • Single Row Analytic Functions
  • Aggregating Analytic Functions
  • The MODEL clause

4. SQL*Plus Reporting

  • SQL*Plus Report Writing Commands
  • COLUMN Command / Titles, System Variables
  • Master-Detail Report with TITLE and COLUMN Commands
  • Control Breaks, Computing Aggregate Amounts
  • Using SET Variables in SQL*Plus, SQL to Generate SQL
  • Creating, Deferrable, Dropping, Disabling/Enabling Constraints / Displaying Constraint Information
  • Handling Exceptions
  • Views, Synonyms, Sequences, Indexes, Virtual Columns
  • Temporary Tables, External Tables

5. Data Manipulation Language (DML) Commands

  • MERGE Command
  • Use of Subqueries
  • Transaction Control Commands / Read Consistency / Locking
  • Flashback Queries

6. Data Definition Language (DDL) Commands

  • Views, Synonyms, Sequences, Indexes, Virtual Columns
  • Temporary Tables, External Tables

7. Security

  • Users
  • Privileges
  • Roles
  • Authentication Methods

8. Multiple Table Inserts

  • Unconditional Insert ALL
  • Conditional Insert All
  • Conditional Insert First
  • Pivoting Insert
  • With Statement