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

Oracle Database 11g: A Comprehensive Hands-On Introduction

Developing Database Applications with Oracle Database Tools
 
Course: 926   Type: Hands-On Training   Duration: 4 Days
 
 

You Will Learn How To

  • Design, build and manage Oracle 11g database applications
  • Establish a data model and a storage framework
  • Retrieve and manipulate data efficiently using SQL Developer
  • Create and manage database tables, sequences and synonyms
  • Ensure data integrity, enforce security and enhance performance
  • Write structured PL/SQL code to develop stored procedures, triggers and packages

Course Benefits

The Oracle Database 11g server enables high-speed transactions, better business decisions and sophisticated applications. These capabilities provide users the functionality to build high-quality and efficient database applications. In this course, you gain a solid foundation to maximize Oracle 11g and develop robust databases for your organization.

Who Should Attend

Those who are new to Oracle databases as well as those planning to move to an Oracle database environment. Relational database experience and familiarity with basic programming concepts are helpful. Experience with Oracle databases is not required.

Hands-On Training

Throughout this course, exercises provide hands-on experience building Oracle 11g databases, including:
  • Designing a database with a data model
  • Navigating the dictionary with Enterprise Manager
  • Coding with SQL Developer and SQL*Plus
  • Retrieving and manipulating data with SQL constructs
  • Creating tables, sequences, views and synonyms
  • Managing security, integrity and performance
  • Programming with cursors, loops and control logic
  • Debugging PL/SQL programs
  • Building procedures, packages and triggers

Related Courses

 
Oracle is a registered trademark of Oracle Corporation. 		 

Upcoming Dates

Jan 13 - 16, 2009
 Washington, DC (Reston, VA)
Jan 20 - 23, 2009
 New York
Feb 3 - 6, 2009
 Washington, DC (Rockville, MD)
Mar 3 - 6, 2009
 Ottawa
Mar 10 - 13, 2009
 Toronto
Apr 7 - 10, 2009
 Los Angeles
Apr 21 - 24, 2009
 Washington, DC (Reston, VA)
May 12 - 15, 2009
 Washington, DC (Rockville, MD)
Jun 2 - 5, 2009
 Ottawa
Jun 9 - 12, 2009
 Toronto
Aug 4 - 7, 2009
 New York
Sep 1 - 4, 2009
 Ottawa
Sep 15 - 18, 2009
 Toronto

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

Oracle Database 11g: A Comprehensive Hands-On Introduction

Developing Database Applications with Oracle Database Tools
 
Course: 926   Type: Hands-On Training   Duration: 4 Days
 
 
Course 926 Content
 

Introduction to Oracle 11g Technology

  • The Oracle database product offering
  • Relational database concepts
  • Applying data modeling techniques
  • Oracle database tools: SQL Developer and SQL*Plus

Database Installation and Administration

Assessing the Oracle database architecture

  • Defining memory structures, processes and SGA
  • Establishing a storage framework

Managing Oracle databases

  • Installing and configuring Oracle Database 11g
  • Working with Oracle Enterprise Manager
  • Leveraging the Oracle Data Dictionary

Accessing and Manipulating Data

Retrieving data efficiently with SQL Developer

  • Selecting, restricting and ordering data
  • Avoiding pitfalls in null values
  • Exploiting built-in SQL functions

Applying powerful SQL techniques

  • Joins, outer joins and ANSI joins
  • Grouping data and applying aggregate functions
  • Combining result sets with set operators
  • Comparing simple and correlated subqueries

Modifying data with SQL statements

  • Inserting, updating, deleting and merging data
  • Controlling transactions with ROLLBACK and COMMIT
  • Locking data to preserve integrity

Creating and Managing Database Objects

Implementing the physical design

  • Mapping logical model to physical design
  • Creating users and schemas

Constructing and maintaining tables

  • Defining column datatypes
  • Altering and dropping columns
  • Restoring data with Flashback and the recycle bin

Building views, sequences and synonyms

  • Filtering data with views
  • Generating unique IDs with sequences
  • Streamlining access to objects with synonyms

Maintaining Integrity, Security and Performance

Enforcing integrity

  • Implementing referential integrity with primary, unique and foreign keys
  • Incorporating business rules with check constraints
  • Managing transactions and data with deferred and enforced constraints

Securing the data

  • Authenticating users with password aging
  • Controlling access with system and object privileges
  • Simplifying privilege management with roles

Improving performance

  • Guidelines for creating indexes
  • Indexing the data for optimal access
  • Managing unique, non-unique and composite indexes

Programming with PL/SQL

Writing basic programs

  • Declaring and initializing variables
  • Controlling logic with IF and CASE statements
  • Performing iterations with WHILE and FOR LOOPs
  • Defining and managing PL/SQL records
  • Trapping errors with exception handlers

Processing data with cursors

  • Declaring cursors to perform row-level operations
  • Passing parameters to cursors to increase flexibility
  • Simplifying cursors with FOR LOOPs
  • Improving insert and delete performance with CURRENT OF or ROWID
  • Terminating loops with cursor attributes

Implementing Server-Side Logic

Modularizing code

  • Constructing procedures and functions
  • Passing parameters to subprograms
  • Debugging programs with DBMS_OUTPUT

Creating packages and triggers

  • Advantages of deploying packages
  • Bundling subprograms in packages
  • Defining statement and row-level triggers
  • Governing triggers with conditional predicates
 
http://www.learntree.com/courses/926pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

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

Developing Database Applications with Oracle Database Tools
 
Course: 926   Type: Hands-On Training   Duration: 4 Days
 
 

Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,800 10-Day Pass
$ 1,670 Training Passport
$ 1,700 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 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,670 per course
  • Savings as much as 40%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,700 per course
  • Save as much as 45%
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,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 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 $305 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.learntree.com/courses/926pf.htm