Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus Seminar training classes conferences & workshops presented by Netcom Learning register for training on FindaSeminar.com

Home

Add your seminars

Training Calendar Creator Seminar Venues Training Provider Directory
 

New Seminar Search:  

 

Helpful links

find similar training...
Search by state...
Customer Support


Do you need help finding the right class, date, or location or other assistance?

Request information about upcoming training seminars workshops and conferences in   and other cities listed on FindaSeminar.com Submit a support request and receive a prompt reply.

We guarantee this Netcom Learning training seminar

We are an authorized partner of Netcom Learning

 

Price protection. The price to attend Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus is set by the training providerThere is no added charge for our services.

We honor most training provider coupons
*.   Call  a representative to see if your discount coupon applies.


Privacy. Your personal information won't be shared with anyone but the training provider Netcom Learning.


Security. When you register for this seminar on FindaSeminar.com your personal data and payment information is safely collected and processed using secure SSL encryption technology.

Flexibility. FindaSeminar.com offers you three ways to register for Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus seminar by Netcom Learning.
Register online, by phone (800) 349-1935,or fax (800) 712-5569
Who should attend Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus
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.
Reviews
Write and read Netcom Learning reviews and reviews about the training seminar Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus on the Seminar News Network and the Training News Network.
 

Frequently asked questions and registration options for the training seminar Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus

 
Find Training Near You
Use our clickable map to find training near you
Use Our Clickmap
 
hotel seminars meeting space directory
hotel meeting space training facilities restaurant and lodging

 
 
 

request on site training details for the Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus seminarRequest on site training

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 associatesEmail 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 See 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.

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search


 

 
 

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

     

     
     
     Netcom Learning training and seminar course catalog

    Click any title to view upcoming Netcom Learning training event dates and locations, class syllabus and other seminar details

     

         
     

     
         

     

      Also try the advanced seminar search tool

       FindaSeminar HomeComputer Training

    unix training
    training classes

     © 2002-2018 FindaSeminar.com™ All Rights Reserved.  Terms of Use |  Privacy Policy |  Training News Network