Oracle9i SQL: Data Retrieval Techniques

This course covers joins, group functions, subqueries, and the iSQL*Plus report variables. Additionally, this course shows students how to access data from multiple table using joins, aggregate data using group functions, create subqueries, and use iSQL*Plus commands to create customized queries.

Learn To

• Identify the four Oracle join types used to display data from more than one table.
• Identify a Cartesian product.
• Retrieve rows from two tables by using an equijoin.
• 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.
• Identify the requirements for using subqueries.
• Identify the characteristics of each subquery type.
• Write a single-row subquery to return one row in the WHERE clause of a SELECT statement.
• Identify the characteristics of substitution variables.
• Prompt the user for a number value at run time by using a substitution variable.
• Prompt the user for a character value at run time by using a substitution variable.

Audience

The audience includes database administrators, designers, developers, technical support  professionals, and application developers. This course will help students prepare for the Oracle9i DBA certification, and is mapped to Exam 1Z0-007.