LIVE Instructor-Led Courses
Dismiss

Oracle Admin Essentials training course

A Short Course Covering The Essentials of Oracle Database Administration

JBI training course London UK

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

Public Courses

08/04/24 - 3 days
£1595 +VAT
20/05/24 - 3 days
£1595 +VAT
01/07/24 - 3 days
£1595 +VAT

Customised Courses

* Train a team
* Tailor content
* Flex dates
From £1200 / day
EDF logo Capita logo Sky logo NHS logo RBS logo BBC logo CISCO logo
JBI training course London UK

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

•    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                    

 

JBI training course London UK

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

5 star

4.8 out of 5 average

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022



“JBI  did a great job of customizing their syllabus to suit our business  needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and  the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

 

 

JBI training course London UK

Newsletter

 

Sign up for the JBI Training newsletter to stay updated with world-class technology training opportunities, including Analytics, AI, ML, DevOps, Web, Backend and Security. Our Power BI Training Course is especially popular.  Gain new skills, useful tips, and validate your expertise with an industry-leading organisation, all tailored to your schedule and learning preferences.



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.

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

 

Copyright © 2023 JBI Training. All Rights Reserved.
JB International Training Ltd  -  Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us

POPULAR

Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course