Oracle 12c Advanced SQL

2 Day | Instructor Led

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.

Inquire About
Oracle 12c Advanced SQL

Ideal Candidates for Oracle 12c Advanced SQL Class

Application designers
Developers
Database administrators

Oracle 12c Advanced SQL Prerequisites

There Are No PreRequisites Defined for this Course

What You'll Get in Oracle 12c Advanced SQL

What You'll Learn in Oracle 12c Advanced SQL

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

No Certification Test Available For This Course

No Certification Test Available For This Course

Oracle 12c Advanced SQL 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

    Testimonials

    A. Erlich

    RITSC, N6C

    I just wanted to say your presentation on Social Media Technology and Security was the finest I have ever attended.

    Wilder Guerra

    US Navy Reserve

    This course is definitely an eye opener. With how much social media has taken over, it is important to be fully aware of the capabilities along with all the risks it brings. It is important to get this course because social media is the new norm.

    Rebekah Coughlin

    MicroTech

    The Social Media and Security Training course offered by UKI is a great and beneficial course combining technical training to fully understand TCP IP networking, DNS, and the harms of malware and cross-site scripting; as well as practical training that allowed attendees to play with open source social intelligence gathering solutions. This is the perfect class for those involved in IT security and interested in social media and identity theft.


    Top Related Courses

    In this course, you will learn about the Oracle Server architecture, expand the size of the database, implement security, and how to perform specific database administration tasks.



    In this course, you will learn a wide variety of advanced concepts to let you fully master administration of an Oracle database. This course includes a thorough discussion of new Oracle 12c automation features including flashback technologies, automated storage management, automated tuning tools, and automated management tools (such as the new scheduler).



    You will receive a hands-on introduction to SQL Basics and SQL*Plus and learn about relational databases and how to access them through SQL and SQL*Plus.



    © 2017 Ultimate Knowledge Insitute | All Rights Reserved | GSA# GS-35F-0469W