We use cookies to offer you a better experience and to analyse how visitors use our site, you may consent to our cookies by continuing to use our site, or you may view more information and choose to reject cookies by clicking here. Thank you

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields

PDF
Course Oracle SQL Advanced
  • Public Scheduled Price£895 +VAT
  • Course Duration2 Days
  • Course Options
    Private
    Private
    Flexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Public Scheduled
    Public Scheduled
    Fixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Virtual

Overview
The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features.
Prerequisites
    • Delegates should have attended the Oracle SQL course or have a similar level of experience.
Objectives
    • To provide the skills needed to use the more advanced features of Oracle SQL.
Target Audience
    • Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database.
Skills Gained
    • The delegate will learn and acquire skills as follows:

      Retrieving Data Using Correlated Subqueries, In-Line Views and Multi-Column Subqueries
      Using the WITH Clause
      Inserting and Updating Rows Using Complex Subqueries
      Creating Hierarchical Queries
      Creating Analytic Queries
      Using ROLLUP, CUBE and GROUPING SETS Group By Enhancements
      Implementing the GROUPING and GROUPING_ID Functions
      Managing Large Data Sets
      Inserting Data Conditionally and Unconditionally
      Merging Rows in a Table
      Creating TIMESTAMP and INTERVAL Datatypes
      Using TIMESTAMP, TIMEZONE and INTERVAL Functions and Literals
      Using Regular Expressions and Implementing Related Functions
      Managing Objects with the Data Dictionary
      Managing Schema Objects
      Performing Flashback Operations
      Creating and Using External Tables
      Controlling User Access to Database Objects
Course Content
    • DAY 1
      Session 1: ACCESS CONTROL
      System Privileges and Roles
      Create Users
      Alter User Details
      Grant and Revoke Object Privileges


      Session 2: RETRIEVE DATA USING SUBQUERIES
      ANY, ALL or SOME Operators
      Correlated Subqueries
      In-Line Views
      The Exists Operator
      The WITH Clause
      Multi-Column Subqueries
      Insert and Update Using a Query
      Correlated Update and Delete


      Session 3: HIERARCHICAL QUERIES
      Hierarchical data
      The START WITH and CONNECT BY clauses
      The LEVEL pseudo-column
      Sequencing the output
      Eliminating nodes and branches


      Session 4: ENHANCED GROUPING FEATURES
      Review of basic grouping concepts
      The ROLLUP and CUBE extensions
      The GROUPING SETS extension
      Using the GROUPING and GROUPING_ID functions


      Session 5: ANALYTIC QUERIES
      Ranking functions
      The NTILE and WIDTH_BUCKET functions
      Analytic Aggregate functions
      The FIRST and LAST Value functions
      The LEAG and LAG Functions
      The LISTAGG Function


      Session 6: MANAGE LARGE DATA SETS
      Multi-table Inserts
      Conditional and Unconditional Inserts
      Merging Data into a Table
      Table and View Based Merge
      A Sub Query Based Merge
    • DAY 2
      Session 7: FLASHBACK TECHNOLOGY
      Flashback Query
      The AS Clause
      Flashback Table
      Flashback Drop


      Session 8: REGULAR EXPRESSION SUPPORT
      Regular Expression Notation
      Character matching
      Repetition operators
      Sub expression grouping
      Regular expression functions


      Session 9:MANAGE OBJECTS WITH THE DATA DICTIONARY
      The Data Dictionary
      Useful Data Dictionary Tables
      Using the Data Dictionary


      Session 10: ADVANCED SCHEMA MANAGEMENT
      Virtual columns
      Invisible columns
      Default values for table columns
      Function Based Indexes
      Creating and Using External Tables


      Session 11: DATE, TIME AND TIMEZONE SUPPORT
      Date, Timestamp and Interval datatypes
      Handling dates and times
      Handling intervals
      Date, timestamp and interval functions and literals
      Related NLS parameters
What's included
    • For courses held on our premises, complimentary tea, coffee and biscuits are available. Lunch is not provided, however, there is a wide variety of eateries within a short walk of the centre.
    • Comprehensive course materials and exercises

 

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk

Printed: 21 Nov 19

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields