Oracle 9i: Database Fundamentals for Developers

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.
Students should have Oracle 9i SQL class or equivalent experience.
2 Days/Lecture & Lab
  • The Oracle 9i architecture
  • Different Oracle environments
  • Parallel query
  • Oracle 9i 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

Related Scheduled Courses