Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus training seminars presented by Netcom Learning register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus  

 Email information about this seminar Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus by Netcom Learning to yourself your manager or associates Email this event... View and register for other training seminars like Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus by Netcom Learning on FindaSeminar.com Find similar training.. Find and register for other training seminars by Netcom Learning on FindaSeminar.com Other seminars from Netcom Learning

By:

Netcom Learning   

For:

This course is intended for Designer/Developers, System Analyst, Database Administrators, Application Developers, and anyone who is interested in working in the database administration field.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

This course will introduce 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. (see full course description)

 

 Seminar / Training class dates & locations

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

oracle+sql+pl%2Fsql+database training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!


 

 

 

share this page 

print the agenda print agenda for the Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus seminar

 

 

Training Course Syllabus:


Description
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. Students will learn and practice how to create and maintain database objects. The students will also learn to store, retrieve, and manipulate data. Finally, the students will learn how to create PL/SQL blocks of application code that can be used in OracleŽ forms, reports, and other Oracle applications. This course will help the student to prepare for Oracle's exam, Introduction to Oracle9i SQL (1ZO-007).

Audience
·  Designer/Developers.
·  System Analyst
·  Database Administrators.
·  Application Developers.
·  Anyone who is interested in working in the database administration field

Objectives
·  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.

Benefits
·  Provide a realistic career path.
·  Increase earnings potential.
·  Get certified and be recognized
·  Stay ahead of the competition in this desirable industry.

Recommended Prerequisites
 ·  Microsoft Access 2002: Level 1
 ·  Microsoft Access 2002: Level 2
 ·  Microsoft Access 2002: Level 3

Exams
 ·  1Z0-007 : Introduction to Oracle9i: SQL

Next Steps
 ·  Oracle9i Database: Fundamentals I

Outline
    1. Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus
      1. Introduction to SQL*Plus and iSQL*Plus
      2. Introduction to SQL
      3. Introduction to PL/SQL
    2. SQL*Plus Commands
      1. Using SQL*Plus for Editing
      2. Using SQL*Plus to Work with Files
      3. Using SQL*Plus for Formatting Output
      4. Using SQL*Plus Variables
    3. Filtering and Sorting Data
      1. WHERE Clause
      2. ORDER BY Clause
    4. SQL Functions
      1. Expressions in a SELECT Statement
      2. Single Row Functions
      3. Group Functions
    5. Working with Multiple Tables
      1. Joins
      2. Subqueries
      3. Set Operators
    6. Tables and Constraints
      1. Creating and Modifying Tables
      2. Integrity Constraints
      3. Managing Data in Tables
      4. Transaction Control Language Statements
    7. Other Database Schema Objects
      1. Sequences, Synonyms, and Indexes
      2. Views
      3. Database Object Security
    8. Building PL/SQL Blocks
      1. Creating PL/SQL Blocks
      2. Manipulating Data in PL/SQL
    9. PL/SQL Control Structures
      1. Conditional Control Structures
      2. Iterative Control Structures
    10. Cursors
      1. Introduction to Cursors
      2. Implicit Cursors
      3. Explicit Cursors
      4. Cursor Loops
    11. Exception Handling
      1. Introduction to Exception Handling
      2. Types of Exceptions
    12. Procedures and Functions
      1. Developing Procedures and Functions
      2. Passing Parameters
    13. Oracle Packages
      1. Developing Packages
      2. Oracle-supplied Packages
    14. Oracle Triggers
      1. Building a Trigger
      2. Trigger Restrictions
    15. PL/SQL Collections
      1. Defining and Using Collections
      2. Collection Methods

    Seminar Summary:

    This course will introduce 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. (see full course description)

    print this agenda print agenda for the Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus training seminar

     view dates and locations for this seminar

     

     

     

    Custom Search