|
Provided by: 123-CBT Computer Based Training SQL and PL SQL Data Retrieval Techniques |
 |
Course Overview
This course is the second in a three-part Oracle series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition, how to use SQL*Plus commands to build on basic SQL statements and create customized queries that retrieve the information and display it in a format specified by the user will be covered.
Learn To:
- Retrieve rows from multiple tables by using an equijoin, a non-equijoin, an outer join, and a self join.
- Write SQL statements that contain common group functions.
- Restrict groups of rows retrieved by using the HAVING clause and to write SQL statements that contain common group functions.
- Group rows retrieved by using the GROUP BY clause.
- Write single-row, multiple row, multiple-column subqueries.
- Obtain values at run time by creating and maintaining substitution variables.
- Use SQL*Plus format commands to format report output.
- Run a formatted report using a SQL*Plus script file.
Content Emphasis
Skills-Based
Audience
Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be able to use a graphical user interface (GUI) and should be familiar with data processing concepts and techniques. Some prior knowledge of programming languages would be an advantage. In addition, participants should have taken the first part of this series, Oracle SQL: Basic SELECT Statements (61110). This course will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks: Oracle7.3 Certified Database Administrator, Oracle8 Certified Database Administrator, and Oracle Certified Application Developer, Release 2.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Displaying Data From MultipleTables
Duration: 1 - 2 Hour(s)- Identify the four join types used to display data from more than one table.
- Identify a Cartesian product.
- Retrieve rows from two tables by using an equijoin.
- Specify additional search conditions in an equijoin by using the AND operator in the WHERE clause.
- Simplify a query by using a table alias in an equijoin.
- Retrieve rows from more than two tables by using an equijoin.
- Retrieve rows from two tables by using a non-equijoin.
- Retrieve rows from two tables by using an outer join.
- Retrieve rows within the same table by using a self join.
Unit 2: Group Functions
Duration: 1 - 2 Hour(s)- Identify the features of a group function.
- Write SQL statements that contain common group functions.
- Manage null values when using group functions in a SQL statement.
- Group rows retrieved by using the GROUP BY clause.
- Retrieve a subgroup of rows from within a larger group retrieved by using the GROUP BY clause.
- Restrict groups of rows retrieved by using the HAVING clause.
- Identify illegal queries involving group functions.
- Write a SQL statement that contains nested group functions.
Unit 3: Subqueries
Duration: 2 Hour(s)- Identify the requirements for using subqueries.
- Identify the characteristics of three subquery types.
- Write a single-row subquery to return one row in the WHERE clause of a SELECT statement.
- Retrieve data that is dependent upon the value of a group functi
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
