Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Oracle 12c Advanced SQL

GK# 7376 Vendor# OR107

Course Overview

TOP

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.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • 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

Outline

TOP
Viewing outline for:

Virtual Classroom Live Outline

  • 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

Labs

TOP
Viewing labs for:

Virtual Classroom Live Labs

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

Who Should Attend

TOP
  • Application designers
  • Developers
  • Database administrators
Course Delivery

This course is available in the following formats:

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 2 day

Request this course in a different delivery format.
Enroll