| |
|
| |
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
|
|
| |
|
|
|
| |
| |
|
|
|
|