Exceptional training courses for oracle professionals

Oracle Admin Essentials Training Course

A Short Course Covering The Essentials of Oracle Database Administration

NEXT COURSE
22 Apr London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

Oracle Admin Essentials training course (code: ORACADMSHO)

TRAINING COURSE OVERVIEW

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.

AUDIENCE

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

CONTENT

DETAILHIGHLIGHTS

•    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

UPDATES
Receive the latest version of this course into your inbox



LONDON COURSES
- INCLUDES LUNCH-

22nd Apr 2019 - 3 days £1595
Book

see all dates


X

Show Discount for this course


PRIVATE COURSES


  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


CONTACT
0800 028 6400



FEEDBACK

►"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