1-800-THE-TREE (1-800-843-8733)
 

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

Quick Enroll    

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

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

Related Courses
Oracle is a registered trademark of Oracle Corporation.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save as much as $1,000 on a Voucher 5-Pack!

Oracle Database 10g: A Comprehensive Hands-On Introduction
Upcoming Dates

Oracle Database 10g: A Comprehensive Hands-On Introduction
Bring Learning Tree On-Site

About the Course Author
Lev Moltyaner
About the Author - Lev Moltyaner

"I wanted to create as comprehensive an introduction to Oracle 10g as possible. By the end of the course, attendees will have an in-depth understanding of critical Oracle database concepts..."
more »

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
 

 

Oracle Database 10g: A Comprehensive Hands-On Introduction
Oracle Database 10g: A Comprehensive Hands-On Introduction
Participants developing stored procedures in Oracle Database 10g.
The most recent 100 evaluations scored this course at:

  (3.74/4.00)


Oracle Today


Certification Core Course CPE 29 Credits 2 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733