Oracle Extended Data Retrieval with SQL
Short course
In Bath
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
Start date
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.
Reviews
Course programme
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