Oracle DBA - Part 1 training course

Learn To Administer Your Corporate Oracle Database - Improve Performance & Reduce Costs

"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

07/10/24 - 5 days

£1995 +VAT

Enrol

18/11/24 - 5 days

£1995 +VAT

Enrol

06/01/25 - 5 days

£1995 +VAT

Enrol

Customised Courses

* Train a team
* Tailor content
* Flex dates

From £1200 / day

Highlights Details Audience Feedback Prices/Dates

Public Courses

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

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

Oracle Goldengate Essentials

Oracle SQL Foundation

Oracle SQL Advanced

Oracle PL/SQL Foundation

Oracle PL/SQL and Packages

Oracle Performance Tuning

Top 20 "Pain Points" for Data Analysts

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

More about this course

This course is designed for database administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle Database 11g. This course is also suitable for delegates who need to be able to monitor and improve the database performance. They will be able to ensure the integrity and availability of a company's data within the Oracle environment.