| |
|
| |
Oracle9i SQL - Introduction Training Class
Course ID: 5878
|
|
| |
|
|
| |
|
|
| |
Oracle9i SQL - Introduction Training Seminar
Overview:
This course introduces students to data server technology and explores the concepts of relational databases, the SQL*Plus interface tool, and the powerful SQL and PL/SQL programming languages.
At Course Completion:
This course will help the student to prepare for Oracle's exam, Introduction to Oracle9i SQL (1ZO-007). - Use SQL, PL/SQL, and SQL*Plus. - Use SQL*Plus commands. - Filter and sort data. - Use built-in SQL functions. - Work with multiple tables. - Create and modify tables and constraints. - Create and use other database objects. - Build a PL/SQL block. - Use PL/SQL control structures. - Process cursors in PL/SQL. - Handle runtime exceptions. - Develop procedures and functions. - Develop Oracle packages. - Create Oracle triggers. - Work with collections of data.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus
Introduction to SQL*Plus and iSQL*Plus
Introduction to SQL
Introduction to PL/SQL
|
|
Lesson 2: SQL*Plus Commands
Using SQL*Plus for Editing
Using SQL*Plus to Work with Files
Using SQL*Plus for Formatting Output
Using SQL*Plus Variables
|
Lesson 3: Filtering and Sorting Data
WHERE Clause
ORDER BY Clause
|
Lesson 4: SQL Functions
Expressions in a SELECT Statement
Single Row Functions
Group Functions
|
Lesson 5: Working with Multiple Tables
Joins
Subqueries
Set Operators
|
|
Lesson 6: Tables and Constraints
Creating and Modifying Tables
Integrity Constraints
Managing Data in Tables
Transaction Control Language Statements
|
Lesson 7: Other Database Schema Objects
Sequences, Synonyms, and Indexes
Views
Database Object Security
|
Lesson 8: Building PL/SQL Blocks
Creating PL/SQL Blocks
Manipulating Data in PL/SQL
|
Lesson 9: PL/SQL Control Structures
Conditional Control Structures
Iterative Control Structures
|
|
Lesson 10: Cursors
Introduction to Cursors
Implicit Cursors
Explicit Cursors
Cursor Loops
|
Lesson 11: Exception Handling
Introduction to Exception Handling
Types of Exceptions
|
Lesson 12: Procedures and Functions
Developing Procedures and Functions
Passing Parameters
|
Lesson 13: Oracle Packages
Developing Packages
Oracle-supplied Packages
|
|
Lesson 14: Oracle Triggers
Building a Trigger
Trigger Restrictions
|
Lesson 15: PL/SQL Collections
Defining and Using Collections
Collection Methods
|
|
|
|
|
|
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Oracle9i - Introduction
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Oracle9i SQL - Introduction Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5878
| Course Duration: 5 Days
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
 Gift card when you register today!
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|