Free RedHat Linux Training Cambridge Intercontinental University | Solaris Administration Global Career Certification | CompTIA Linux+ and Security+

      Oracle Database Administration

      Welcome

      Welcome
      Prerequisites for this Course
      About this Course
      Technet Database Administration Manuals

      Database Administration

      Oracle Database Administration? pt. 1
      Oracle Database Administration? pt. 2
      The Basic Architecture of Oracle

      Oracle Database Administration Tools

      What are the Tools?
      SQL*Plus
      SQL*Plus Worksheet
      iSQL*Plus
      All the Other Oracle Tools
      Database Configuration Assistant pt. 1
      Database Configuration Assistant pt. 2
      Oracle Enterprise Manager Console pt. 1
      Oracle Enterprise Manager Console pt. 2
      The Management Server and the Agent
      Net Configuration Assistant and Net Manager
      Oracle Enterprise Manager Console pt. 3
      Oracle Enterprise Manager Console pt. 4

      The Architecture of Oracle

      Oracle Database Architecture
      Memory Structures
      Processes
      Datafiles/Tablespaces/Objects
      Control Files/Logging/Archiving/Recovery
      COMMIT vs ROLLBACK
      Rollback and Undo
      Temporary Sort Space
      How it all Fits Together
      Oracle Managed Files
      Partitioning

      Installing Oracle and Creating a Database

      The Oracle Installer pt. 1
      The Oracle Installer pt. 2
      The Oracle Installer pt. 3
      Configuration Parameter Files pt. 1
      Configuration Parameter Files pt. 2
      SQL*Net Configuration Files
      Oracle Optimal Flexible Architecture
      Windows Specifics pt. 1
      Windows Specifics pt. 2
      Creating a Database with a Script pt. 1
      Creating a Database with a Script pt. 2

      Starting Up and Shutting Down a Database

      Connecting to a Database
      STARTUP Command pt. 1
      STARTUP Command pt. 2
      SHUTDOWN Command pt. 1
      SHUTDOWN Command pt. 2
      Combining STARTUP and ALTER DATABASE
      The Oracle Enterprise Manager Console

      Configuration Parameters

      What is the Parameter File?
      Looking at Parameters
      The Parameters and What They Do pt. 1
      The Parameters and What They Do pt. 2
      The Parameters and What They Do pt. 3

      DDL and the Physical Database

      DDL and the Physical Database?
      The ALTER DATABASE Command
      Looking at the Database
      Changing Datafiles
      Sizing of Datafiles
      Datafiles and Tempfiles
      Control Files
      Logfiles and Archives pt. 1
      Logfiles and Archives pt. 2
      The ALTER SYSTEM Command pt. 1
      The ALTER SYSTEM Command pt. 2
      Automated Undo/Manual Rollback pt. 1
      Automated Undo/Manual Rollback pt. 2
      Metadata Views

      DDL and the Logical Database

      What is the Logical Database?
      Tablespace Management pt. 1
      Tablespace Management pt. 2
      Tablespace Management pt. 3
      Metadata Views

      Expanding Database Objects

      Tables pt. 1
      Tables pt. 2
      Tables pt. 3
      Indexes pt. 1
      Indexes pt. 2
      Clusters
      Index Organized Tables
      Sequences
      UNDROP, PURGE and the Recycle Bin
      Partitioning
      Metadata Views pt. 1
      Metadata Views pt. 2

      Expanding Security for Database Administration

      Types of Users
      Grants and Revokes
      Create and Alter User Syntax
      Administration Users
      Database Auditing

      Scheduling

      The DBMS_JOB Package
      Job Scheduling in Oracle
      Scheduling/Executing Jobs in Windows and Unix

      Utilities

      Export
      Import
      SQL*Loader
      ORAPWD and ORADIM

      Built-In Packages

      Supplied Packages

      Scripting for Automation

      Some Example Scripts