|
Provided by: Serebra Learning Corporation Oracle SQL for End Users Part 2Oracle PL/SQL |
 |
Training
Provided by Serebra Learning Corporation
This course is the second in a two-part SQL for End Users series that is based on Introduction to Oracle: SQL and PL/SQL. In this course the learner displays data from multiple tables by using equijoins non-equijoins and self joins. In addition this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database. This course also covers how to embed subqueries in SQL statements. Finally the learner creates interactive reports by using substitution variables and executes a formatted report by using SQL*Plus commands.
|
|
||||||||||
Oracle SQL for End Users Part 2
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
Audience
End users are the targeted audience for this course.
Objective
- Access data from more than one table by using equijoins and nonequijoins and join a table to itself by using a self join.
- Group data by using group functions.
- Embed singlerow and multiplerow subqueries in a SQL statement.
- Create format and execute interactive reports.
Topics Include
Unit 1: Topics
- Match the join types used to display data from more than one table with their appropriate descriptions.
- 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.
- Retrieve rows from two tables by using a non-equijoin.
- Retrieve rows within the same table by using a self join.
- Retrieve rows from more than two tables by using an equijoin.
Unit 2: Group Functions
- Identify the features of a group function.
- Return the minimum and maximum values from a group of values by using the MIN and MAX group functions in a query.
- Perform calculations on a group of numeric values by using the AVG and SUM group functions in a query.
- Return the number of rows in a specified group by using the COUNT group function in a query.
- Manage null values when using group functions in a SQL statement.
- Group rows retrieved by using the GROUP BY clause.
- Identify illegal queries involving group functions.
Unit 3: Subqueries
- Identify the proper syntax when using a subquery in a SQL statement.
- Identify the characteristics of the 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 function in a single-row subquery.
- Identify two common errors that occur when using single-row subqueries.
- Identify the guidelines for using multiple-row subqueries.
- Retrieve data that is dependent upon the value of a group function in a multiple-row subquery.
Unit 4: Reporting with SQL*Plus
- Identify the characteristics of substitution variables.
- Prompt the user for a number value using a variable prefixed with a single ampersand.
- Prompt the user for character and date values by using a variable prefixed with a single ampersand and surrounded by single quotation marks.
- Specify column names and expressions at run time using substitution variables.
- Prompt the user for a value by using a variable prefixed with a double ampersand.
- Accept user input at run time by using the ACCEPT command.
- Maintain a variable at run time by using the DEFINE and UNDEFINE commands.
- Match the SET command variables with their functions.
- Identify the guidelines for using the SQL*Plus format commands.
- Control the display of a column by using the COLUMN command options.
- Group related rows by using the BREAK command.
- Run a formatted report by using a SQL*Plus script file.
Duration
8
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
