Oracle 12c Advanced SQL

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.

    No classes are currenty scheduled for this course.

    Call (919) 283-1653 to get a class scheduled online or in your area!

  • 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
  • PIVOT / UNPIVOT
  • 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

  • TRUNCATE, COMMENT, RENAME Command
  • 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

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
  • Create and drop tables, views and indexes
  • Understand Structured Query Language
  • Format reports using SQL*Plus commands
  • Extract and organize information from the database
  • Insert, update, and delete information in database tables

Lab 1: Creating Tables And Constraints

Lab 2: Creating Views

Lab 3: Data Manipulation

Lab 4: Single Row Functions

Lab 5: Advanced Joins

Lab 6: Subqueries

Lab 7: Group Functions

Lab 8: Analytic Functions

Lab 9: SQL*Plus Reporting

Lab 10: Advanced DDL

Lab 11: Advanced DML

  • Application designers
  • Developers
  • Database administrators

Ready to Jumpstart Your IT Career?

CONTACT US NOW!