1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Oracle Database 10g: A Comprehensive Hands-On Introduction

Developing Database Applications with SQL and PL/SQL
 
Course: 593   Type: Hands-On Training   Duration: 5 Days
 
 

You Will Learn How To

  • Build, query and manipulate Oracle 10g databases to create powerful applications
  • Retrieve and manipulate data efficiently using powerful SQL features
  • Create and manage database tables, views and sequences
  • Maintain data integrity and enforce security with privileges and roles
  • Compose reusable structured PL/SQL code with cursors and procedures
  • Enhance performance through indexes and PL/SQL optimization

Course Benefits

To efficiently handle today's business-critical information, organizations count on database systems that are reliable and scalable, and on experienced professionals to manage them. In this course, you gain the practical knowledge and skills required to leverage the Oracle Database 10g server. Hands-on exercises provide experience in applying relational database concepts, leveraging the SQL language and programming with PL/SQL.

Who Should Attend

Those interested in Oracle 10g. Relational database experience and familiarity with basic programming concepts are useful. Oracle experience is not required.

Hands-On Training

Exercises provide experience creating robust and powerful applications with Oracle 10g, including:
  • Creating tables, views and sequences
  • Producing queries using joins, set operators, groupings and subqueries
  • Merging large datasets & inserting across multiple tables
  • Imposing business rules with declarative constraints
  • Enforcing security with roles
  • Enhancing performance with indexes
  • Controlling logic and handling exceptions
  • Building PL/SQL procedures, triggers and packages

Related Courses

 
Oracle is a registered trademark of Oracle Corporation. 		 

Upcoming Dates

May 19 - 23, 2008
 New York
Jun 9 - 13, 2008
 Washington, DC (Reston, VA)
Jun 23 - 27, 2008
 Chicago (Downtown)
Jun 23 - 27, 2008
 New York
Jul 7 - 11, 2008
 Dallas
Jul 14 - 18, 2008
 Atlanta
Jul 21 - 25, 2008
 Toronto
Jul 28 - Aug 1, 2008
 Boston (Waltham)
Aug 11 - 15, 2008
 Washington, DC (Reston, VA)
Aug 18 - 22, 2008
 Los Angeles
Aug 25 - 29, 2008
 New York
Sep 8 - 12, 2008
 Ottawa
Sep 8 - 12, 2008
 Washington, DC (Rockville, MD)
Sep 15 - 19, 2008
 Washington, DC (Alexandria, VA)
Sep 22 - 26, 2008
 Annapolis, MD

For complete schedule, please visit www.learningtree.com
 
http://www.learningtree.com/courses/593pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Oracle Database 10g: A Comprehensive Hands-On Introduction

Developing Database Applications with SQL and PL/SQL
 
Course: 593   Type: Hands-On Training   Duration: 5 Days
 
 
Course 593 Content
 

Oracle 10g Technology Overview

  • Relational database concepts
  • Logical data modeling
  • Specifying attributes, entities, relationships and candidate keys
  • Installation, configuration and architecture
  • Defining SGA, processes and database files

Retrieving and Controlling Data

Working with SQL*Plus and iSQL*Plus

  • Configuring environment settings
  • Defining connections using login.sql
  • Implementing case-insensitive queries

Assessing SQL fundamentals

  • Selecting, filtering and ordering results
  • Avoiding pitfalls in null values
  • Pattern matching with regular expressions
  • Combining result sets with set operators

Exploiting SQL techniques

  • Oracle joins vs. ANSI joins
  • Outer joins and self joins
  • Grouping and aggregating data
  • Simple and correlated subqueries
  • Comparing CASE and DECODE functions

Manipulating data

  • Streamlining DML with MERGE
  • Locking data and managing transactions

Designing and Formulating the Database

Applying the physical design

  • Mapping logical model to physical design
  • Establishing a storage framework
  • Creating users and schemas
  • Defining LOB and TIMESTAMP data

Constructing and managing tables

  • Building tables with CREATE TABLE
  • Altering and dropping tables
  • Restoring data with Flashback
  • Accessing OS files with external tables
  • Leveraging the data dictionary

Developing views and sequences

  • Assembling views to filter data
  • Generating unique IDs using sequences

Maintaining integrity

  • Determining referential integrity
  • Imposing business rules with CHECK constraints
  • Handling data with deferred and enforced constraints

Optimizing Server Programming

Invoking PL/SQL fundamentals

  • Declaring variables and constants
  • Defining stored procedures and functions
  • Writing structured code with %TYPE and %ROWTYPE

Establishing program control

  • IF...THEN...ELSE vs. CASE statements
  • Creating WHILE LOOPs and FOR LOOPs
  • Error handling with predefined exceptions

Operating with cursor types

  • Controlling implicit and explicit cursors
  • Passing parameters to cursors
  • Simplifying cursors with FOR LOOPs
  • Improving performance with ROWID
  • Handling concurrency with FOR UPDATE

Implementing Development Techniques

Assembling triggers

  • Distinguishing statement and row triggers
  • Regulating triggers with predicates
  • Building triggers to validate, derive and audit data

Constructing procedures and packages

  • Choosing best parameter types
  • Creating and administering packages
  • Advantages of employing packages
  • Debugging programs with DBMS_OUTPUT

Advancing Security and Performance

Enforcing security

  • Verifying with password aging
  • Classifying system and object privileges
  • Controlling access with roles
  • Accessing schemas via synonyms

Enriching performance

  • Guidelines for defining optimal indexes
  • Creating unique, non-unique and composite indexes
  • Monitoring index usage
 
http://www.learningtree.com/courses/593pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Oracle Database 10g: A Comprehensive Hands-On Introduction Tuition

Developing Database Applications with SQL and PL/SQL
 
Course: 593   Type: Hands-On Training   Duration: 5 Days
 
 

Course Tuition
$ 2,950 Standard Tuition
Tuition with a Savings Plan
$ 2,075 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,655 Alumni Gold Discount
$ 2,620 Government Discount
 

 

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,665 per course
  • Savings as much as 40%
  • Only $4,990
Flex Pass
  • 3 courses in 24 months
  • As little as $1,830 per course
  • Save as much as 35%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,150
Training Vouchers
  • Save as much as $850 per course
  • Fully transferable
  • As low as $2,095 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $295 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learningtree.com/courses/593pf.htm