Oracle Extended Data Retrieval with SQL

Short course

In Bath

Price on request

Description

  • Type

    Short course

  • Location

    Bath

  • Duration

    1 Day

This Course is similar to SQL Part Two for Experienced Users, with slightly different topics. On completion of the course delegates will be able to: Use advanced techniques to retrieve data using ROLLUP, CUBE, Set operators, correlated subqueries, and hierarchical queries Write SQL scripts which use SQL to generate SQL Use SQL*Plus to format reports. Suitable for: The course has been designed for Database Administrators, System Analysts, Application Developers and IT/Technical Staff.

Facilities

Location

Start date

Bath (Somerset)
See map
11 Kingsmead Square, BA1 2AB

Start date

On request

About this course

Knowledge of Oracle SQL and SQL*Plus, or equivalent taining. Our Oracle SQL part 1 and 2 course should provide an ideal pre-requisite.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

AUDIENCE: The course has been designed for Database Administrators, System Analysts, Application Developers and IT/Technical Staff.
PREREQUISITES: Knowledge of Oracle SQL and SQL*Plus, or equivalent taining. Our Oracle SQL part 1 and 2 course should provide an ideal pre-requisite.
DURATION: 1 day. Hands on.
OBJECTIVES: This Course is similar to SQL Part Two for Experienced Users, with slightly different topics. On completion of the course delegates will be able to:
Use advanced techniques to retrieve data using ROLLUP, CUBE, Set operators, correlated subqueries, and hierarchical queries
Write SQL scripts which use SQL to generate SQL
Use SQL*Plus to format reports

COURSE CONTENT:
Using Group Functions with CUBE or ROLLUP
Operations Using ROLLUP as an extension to the group by clause to produce subtotal values
Using CUBE as an extension the group by clause to produce subtotal values
Using the GROUPING Function to Identify the Row Values Created by ROLLUP or CUBE Operators

Hierarchical Retrieval
Discussing the benefits of the hierarchical query
Ordering the rows retrieved by a query in a hierarchical manner
Formatting hierarchical data so that it is easy to read
Excluding branches from the tree structure

Writing Correlated Subqueries
Describing the types of problems that can be solved with a correlated subquery
Describing a correlated subquery Writing correlated subqueries
Using the EXISTS and NOT EXISTS Operators
Updating and deleting rows
Using correlated subqueries

Using Set Operators
Describing the set operators
Obeying the set operators rules and guidelines
Using a Set Operator to Combine Multiple Queries into a Single Subquery
Controlling the Order of Rows Returned

Writing Scripts to Generate Scripts
Describing the types of problems that are solved by writing SQL scripts that generate other SQL scripts
Writing and executing a script that generates a script of drop table commands
Writing and executing a script that generates a script of insert into commands

Oracle Extended Data Retrieval with SQL

Price on request