Exceptional training courses for oracle professionals

Oracle Admin Essentials Training Course

A Short Course Covering The Essentials of Oracle Database Administration

28 Jan London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

Oracle Admin Essentials training course (code: ORACADMSHO)


This short Oracle Database Administration training course explores the fundamentals of basic database administration.  The course is suitable for versions of Oracle database up to and including 12. The course is based around using the command line, but will provide Enterprise Manager Express to complement and enhance the learning experience.


The course is suitable for technical personnel who need to learn how to administer and maintain Oracle Databases.


•    Oracle Concepts Overview                                                                    
            Oracle Components
            The Oracle Instance
            The Oracle Database
            Oracle Processes
            The Listener
            Grid Infrastructure Overview
                        Oracle Restart
                        Automatic Storage Management
•    Oracle Database Software Installation                                               
            Pre-installation Tasks
            Installation Process
•    Oracle Database Creation                                                                      
            Using the Database Configuration Assistant
•    Managing an Oracle Database Instance                                            
            Connecting as a privileged user
            Startup and Shutdown
            Initialisation Parameters
            Understanding Oracle Processes
            Understanding System Global Area Components
            Managing the System Global Area size
            Understanding Program Global Area Components
            Managing the Program Global Area size
            The Automatic Diagnostic Repository
            The Data Dictionary
•    Control Files and Tablespaces                                                 
            Understanding the role of Control Files
            Understanding Tablespaces
            Understanding Data Files
            Oracle Managed Files
•    Redo Logging                                                                                           
            Understanding the role of Redo Logging
            Redo Log Groups
            Redo Log File Multiplexing
•    Undo Management                    


Install and create an Oracle Database
Discover the Oracle database architecture
Create and manage users
Create and manage storage structures
Administer the Oracle Database
Understand Oracle Flashback technology
Manage space requirements

Receive the latest version of this course into your inbox


28th Jan 2019 - 3 days £1595

see all dates


Show Discount for this course


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400
or request quote

  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote

Get in touch
0800 028 6400

Excellent feedback, consistently !

►"great tips help reduce build times"
► "we got access to exclusive content"
► "Short course meant less time off"

►"what an inspiring trainer !"
► "colleagues at 2 sites joined via web"
► "I passed my exam the next day"

Newsletter ! Get exclusive news about upcoming programs, technical insights & special offers