Highlights
- Oracle Database Architecture
- Installing and Configuring Oracle
- Creating and Managing an Oracle Instance and Database
- Administering an Oracle Instance and Database
- Configuring the Oracle Network Environment
- Creating and Managing Database Storage Structures
- Managing Redo Log Files and Control Files
- Managing Schema Objects
- Managing Users, Profiles, Privileges and Roles
- Managing Undo Data and Temporary Segments
- Managing Data and Concurrency
- Maintaining Database Security
- Database Maintenance
- Managing Performance
- Moving Data with SQL*Loader and Data Pump
- Backing up and Recovering the Database
- Support Workbench, Metalink, Service Requests and Patches
Course Details
- Oracle Database Architecture
- Installing and Configuring Oracle
- Creating and Managing an Oracle Instance and Database
- Administering an Oracle Instance and Database
- Configuring the Oracle Network Environment
- Creating and Managing Database Storage Structures
- Managing Redo Log Files and Control Files
- Managing Schema Objects
- Managing Users, Profiles, Privileges and Roles
- Managing Undo Data and Temporary Segments
- Managing Data and Concurrency
- Maintaining Database Security
- Database Maintenance
- Managing Performance
- Moving Data with SQL*Loader and Data Pump
- Backing up and Recovering the Database
- Support Workbench, Metalink, Service Requests and Patches
Who should attend
The course is suitable for technical personnel who need to learn how to administrate and maintain Oracle 11g Databases.
Feedback
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
