back to Course Categories | back | print
Oracle9i: Database Fundamentals for Developers          

Duration: 2 days

Description 
This course is designed to teach students key skills necessary to manage an Oracle database server application. This course will focus on the Oracle architecture, database objects, creating, modifying and deleting database objects, partitioning, managing indexes, data extraction, and working with indexes. At the end of this class students will be able to create a schema, build database objects, load and extract data, implement business rules with constraints and develop multilanguage applications.

Topics

  • The Oracle9i architecture
  • Different Oracle environments
  • Parallel query
  • Oracle9i instance memory management
  • Dynamic SGA
  • Oracle background processes
  • Managing the Oracle database: datafiles, control files and redo log files
  • Optimal Flexible Architecture
  • SQL*Plus and SQL Worksheet
  • Understanding Oracle storage
  • Tablespaces
  • Segment management
  • Undo tablespaces
  • Temporary tablespaces
  • Multiple block sizes
  • Managing tables and indexes
  • Block, extent, segment and tablespace configuration
  • Managing schema objects
  • Different types of tables
  • Different types of indexes
  • Managing tables
  • Managing indexes
  • Maintaining tables
  • Maintaining indexes
  • Managing Oracle storage
  • Setting physical storage characteristics
  • Troubleshooting an Oracle server
  • Working with data dictionary views
  • Working with schema objects
  • Sequences
  • Synonyms
  • Database links
  • Creating, altering and deleting tables
  • Renaming tables
  • Managing tables
  • Working with constraints
  • Primary and foreign keys
  • Unique keys
  • NOT NULL constraints
  • Check constraints
  • DEFAULT values
  • Creating and accessing external tables
  • Time zones
  • Working with dates and timestamps
  • Partitioning
  • Different types of partitioning
  • Partioned tables
  • Partitioned indexes.
  • Multi-table INSERT statement
  • Globalization
  • Exporting data
  • Importing data
  • SQL*Loader
  • Reorganizing data
  • Transportable tablespaces
  • Managing transactions

Prerequisites

  • Oracle9i SQL class or equivalent experience.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design