|
Provided by: 123-CBT Computer Based Training 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: o Identify the four Oracle join types used to display data from more than one table.
o Identify a Cartesian product.
o Retrieve rows from two tables by using an equijoin.
o Identify the features of a group function.
o Write SQL statements that contain common group functions.
o Manage null values when using group functions in a SQL statement.
o Identify the requirements for using subqueries.
o Identify the characteristics of each subquery type.
o Write a single-row subquery to return one row in the WHERE clause of a SELECT statement.
o Identify the characteristics of substitution variables.
o Prompt the user for a number value at run time by using a substitution variable.
o 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.
Deployment Options Internet / Intranet, Download, LAN, Workstation
Accreditation NASBA credits: 4 CPE Credits
Language Options American English, German, Brazilian Portuguese, Spanish
Total Learning Time 6 to 8 hours
61131 Objectives Unit 1: Displaying Data from Multiple Tables 1 - 2 hours
o Identify guidelines for using the SET operators.
o Create a compound query that uses the UNION operator to combine data from two results sets.
o Create a compound query that uses the INTERSECT operator to combine data from two results sets.
o Create a compound query that uses the MINUS operator to combine data from two results sets.
o Identify the four Oracle join types used to display data from more than one table.
o Identify a Cartesian product.
o Retrieve rows from two tables by using an equijoin.
o Specify additional search conditions in an equijoin by using the AND operator in the WHERE clause.
o Simplify a query by using a table alias in an equijoin.
o Retrieve rows from more than two tables by using an equijoin.
o Retrieve rows from two tables by using a nonequijoin.
o Retrieve rows from two tables by using an outer join.
o Retrieve rows from within the same table by using a self join.
o
Learn To: o Identify the four Oracle join types used to display data from more than one table.
o Identify a Cartesian product.
o Retrieve rows from two tables by using an equijoin.
o Identify the features of a group function.
o Write SQL statements that contain common group functions.
o Manage null values when using group functions in a SQL statement.
o Identify the requirements for using subqueries.
o Identify the characteristics of each subquery type.
o Write a single-row subquery to return one row in the WHERE clause of a SELECT statement.
o Identify the characteristics of substitution variables.
o Prompt the user for a number value at run time by using a substitution variable.
o 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.
Deployment Options Internet / Intranet, Download, LAN, Workstation
Accreditation NASBA credits: 4 CPE Credits
Language Options American English, German, Brazilian Portuguese, Spanish
Total Learning Time 6 to 8 hours
61131 Objectives Unit 1: Displaying Data from Multiple Tables 1 - 2 hours
o Identify guidelines for using the SET operators.
o Create a compound query that uses the UNION operator to combine data from two results sets.
o Create a compound query that uses the INTERSECT operator to combine data from two results sets.
o Create a compound query that uses the MINUS operator to combine data from two results sets.
o Identify the four Oracle join types used to display data from more than one table.
o Identify a Cartesian product.
o Retrieve rows from two tables by using an equijoin.
o Specify additional search conditions in an equijoin by using the AND operator in the WHERE clause.
o Simplify a query by using a table alias in an equijoin.
o Retrieve rows from more than two tables by using an equijoin.
o Retrieve rows from two tables by using a nonequijoin.
o Retrieve rows from two tables by using an outer join.
o Retrieve rows from within the same table by using a self join.
o
|
|
||||||||
Training
Provided by 123-CBT Computer Based Training
Oracle9i SQL Data Retrieval Techniques
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
