D202

D202: Oracle for Database Administrator - 3 Days

Who Should Attend:

Software engineers, systems analysts, applications programmers, computer science students, and anyone who is interested in acquiring the technical skills required to administer a database environment.

Prerequisites:

D101 SQL programming module or familiarity with SQL syntax.

Objectives:
This advanced module provides hands-on practice and experience in Oracle database administration, and exposes participants to fundamental concepts and techniques involved in the administration of Oracle databases. Topics include database file and process architecture, database creation and modification, security management, database backup and recovery policies and techniques, and application and database level tuning. The module adopts a problem-solving approach to the management of the typical medium to large Oracle database.

Participants must have experience in relational database systems, application development or system administration.

Contents:

Database Architecture: ORACLE Architecture; Overview of Databases and Instances; Internal Database Structures; Internal Memory Structures; Background Processes. External Structures; Logical Modeling Conventions.

Hardware Configuration and Considerations: Architecture; Standalone Hosts; Networked Hosts.

Database Layouts: Logical Database Layouts; End Product; Optimal Flexible Architecture (OFA).

Physical Database Layouts: Database File Layout; File Location; Database Space Usage; Resizing Data Files; Moving Database Files; De-allocating Space.

Database Management: Managing the Development Process. Monitoring Multiple Databases: Common Problem Areas; Target Selection; The End Product; Creating Command CenterDatabase; Monitoring Memory Objects. Managing Large Databases: Setting Up Environment; Managing Transactions; Managing Backups.

Managing Rollback Segments: Space Usage Within Rollback Segments; Monitoring Rollback Segment Usage; Choosing Number and Size.

Database Tuning: Tuning Application Design; Tuning SQL; Tuning Memory Usage; Tuning Data Storage; Tuning Data Manipulation; Tuning Physical Storage; Tuning Logical Storage; Reducing Network Traffic.

Database Security and Auditing: Security Capabilities; Implementing Security; Limiting Available

Commands: Product User Profiles; Password Security During Logins; Password Encryption and

Trickery; Auditing; Protecting the Audit Trail; Security in a Distributed Environment.

Optimal Backup and Recovery Procedures: Capabilities, Logical Backups; Physical Backups; Integration of Backup Procedures; Recovery; Media (Disk) Failure; Recovering Accidentally Dropped or Altered Objects; Parallel Recovery; Recovery Manager.

Networked ORACLE: SQL*Net; Using the Net8 Assistant; Usage Examples: Client-Server Applications Usage Examples: Database Links; Usage Examples: The copy Command; Tuning SQL*Net and Net8.

--------

Contact Us Today for enquiries on courses