"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
• 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
"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
Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...
All 20 points are in our latest Newsletter - Delivered directly to your inbox
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
Corporate Policies Terms & Conditions
JB International Training Ltd - Company number 08458005
Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS
