Name: Oracle 9i: SQL for End Users
Course Code: OR13409
Duration: 2
Scheduled Dates for OR13409
In this course, students learn about relational principles of an Oracle database. The class also covers how to query data and how to use iSQL*Plus to format query output.
Key Topics
- Relational Principals and Oracle Concepts
- Describing the Lifecycle Development Phases
- Discussing the Theoretical and Physical Aspects of a Relational Database
- Describing the Oracle Implementation of the RDBMS and ORDBMS
- Describing the Features of Oracle8i
- Describing New Features of Oracle9i
- Describing How SQL Is Used in the Oracle Product Set
- Writing Basic SQL Statements
- Listing the Capabilities of SQL SELECT Statements
- Executing a Basic SELECT Statement
- Differentiating Between SQL Statements and iSQL*Plus Statements
- Restricting and Sorting Data
- Limiting the Rows Retrieved by a Query
- Sorting the Rows Retrieved by a Query
- Single-Row Number and Character Functions
- Describing the Various Types of Functions Available in SQL
- Using Character and Number Functions in SELECT Statements
- Single-Row Date and Conversion Functions
- Using SYSDATE in Conjunction with SELECT Statements
- Arithmetic Operations with Dates
- Describing Conversion Functions Available in SQL
- Using Date Functions in SELECT Statements
- Displaying Data from Multiple Tables
- Writing SELECT Statements Using Equality and Nonequality Joins to Access Data from More Than One Table
- Describing the Cartesian Product
- Joining a Table to Itself
- Natural Join and Cross Join
- Aggregating Data Using Group Functions
- Identifying the Available Group Functions
- Describing the Use of Group Functions
- Using the GROUP BY Clause to Group Data
- Writing Subqueries
- Describing the Types of Problems that Subqueries Can Solve
- Defining Subqueries
- Listing the Types of Subqueries
- Writing Single-Row and Multiple-Row Subqueries
- iSQL*Plus
- Producing Queries that Require an Input Variable
- Customizing the iSQL*Plus Environment
- Producing More Readable Output
- Creating and Executing Script Files
Objectives
- Upon completion of this course, participants will be able to:
- Describe the relational aspects of Oracle database management systems
- Retrieve data in an Oracle database
- Use iSQL*Plus to execute SQL statements
Required Skills/Experience
- Familiarity with a graphical user interface (GUI)
- Familiarity with data processing concepts and techniques
Fee: $1,200.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
