Oracle Database Administration

Please note, the topics mentioned here are only the major subtopics within the course

• Overview of Oracle Database Fundamentals
  • Summary of the Database Fundamentals Course
  • Overview on Application Architectures (Client/Server)
  • About Oracle Transaction processing steps
• Building afresh an Oracle Database Instance
  • Creation of Oracle Database through Install, DBCA or SQL
  • Setting Initialisation and Control file parameters
  • Setting up of Logical Memory and Storage structures
• Understanding Oracle Start/Stop and Processes
  • Start and Stop of Oracle Databases with multiple options
  • Connecting to Oracle Database with specific schemas
  • Altering Database availability through various options
  • About Oracle Control files and consistency of Oracle
• Oracle Data Dictionary and Parameter files
  • Introduction to Oracle Data Dictionary
  • Oracle Logical and Dynamic Performance Views
  • Static and Dynamic parameters of an Oracle Instance
  • Oracle Database-level and Session-level parameters
• Oracle Database Schemas and User Security
  • Organisation of an Oracle Schema with options
  • Create/Modify/Delete operations on Oracle Schemas/User
  • Introduction to Oracle Privileges and Roles for Users
  • About pre-defined and custom-made Roles and Privileges
• Oracle Physical and Logical Space Management
  • Overview of Oracle Datafiles and Tablespaces
  • Various operations on Oracle Datafiles and Tablespaces
  • Understanding Oracle Data Segments and Blocks
• More about Oracle Physical structures (Redo etc.)
  • About Online and offline Redo Logs of Oracle
  • Various operations on Redo Logfiles including Archiving
  • DBA operations involving Oracle Undo Segments
  • Data Dictionary views and tables on various physical structures
• Backup and restore of Oracle Database objects
  • Introduction to Physical and Logical Database Backup
  • Introduction to Oracle Recovery methodologies
  • Overview of Oracle Backup including native utilities
  • Role of Oracle offline Archive logs in the Recovery process
  • Overview of Advanced Oracle Recovery options (RMAN)

 

ENROL                             Request Info                             IT Courses Page