Oracle 11g Administration (Part 2) Training Course JBI | Remote | Virtual

Highlights

Manage Memory

Plan a Backup and Recovery Strategy
Oracle Recovery Structures
Create and Manage a RMAN Recovery Catalog
Configure Backup Settings
Use RMAN to Perform Backups
Use RMAN to Restore and Recover
Monitor and Tune RMAN
Perform Tablespace Point-in-Time Recovery
Create a Duplicate Database with RMAN
Additional Recovery Issues
Use Flashback Technology to Recover a Database
Use Flashback to Recover from User Errors
Diagnostic Sources
Use ASM
Manage Database Performance
Monitor and Manage Storage with the Segment Advisor
Control Database Resources using Resource Manager
Automate Management Tasks with the Scheduler
Administer the Scheduler
Use Globalization

Course Details

Manage Memory
Plan a Backup and Recovery Strategy
Oracle Recovery Structures
Create and Manage a RMAN Recovery Catalog
Configure Backup Settings
Use RMAN to Perform Backups
Use RMAN to Restore and Recover
Monitor and Tune RMAN
Perform Tablespace Point-in-Time Recovery
Create a Duplicate Database with RMAN
Additional Recovery Issues
Use Flashback Technology to Recover a Database
Use Flashback to Recover from User Errors
Diagnostic Sources
Use ASM
Manage Database Performance
Monitor and Manage Storage with the Segment Advisor
Control Database Resources using Resource Manager
Automate Management Tasks with the Scheduler
Administer the Scheduler
Use Globalization

Who should attend

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.

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

Certification

Every delegate will be entitled to a certificate of achievement on completion of the course.

If you are missing your certificate - please use the link below to apply - you can also use this link to sign up for the JBI Training newsletter to receive technology tips directly from our instructors - Analytics, AI, ML, DevOps, Web, Backend and Security.

More about this course

FAQs

JBI Training offers twelve Oracle database courses. These include Oracle SQL Foundation (three days), Oracle SQL Advanced (four days), Oracle PL/SQL Foundation (three days), Oracle PL/SQL and Packages (five days), Oracle DBA Part 1 (five days), Oracle DBA Part 2 (three days), Oracle Admin Essentials (three days), Oracle Performance Tuning (three days), Oracle AWR Usage (three days), Oracle Backup and Recovery Essentials (two days), Oracle GoldenGate Essentials (three days), and Oracle 12c New Features (five days). All are available in London, online, or as customised onsite programmes.

Oracle SQL Foundation is a three-day course for professionals new to Oracle SQL, covering core querying, filtering, sorting, joins, aggregations, subqueries, and DML statements for inserting, updating, and deleting data. Oracle SQL Advanced is a four-day course for those with existing Oracle SQL experience who want to go deeper — covering advanced query techniques, analytical functions, hierarchical queries, XML and JSON handling in Oracle, performance considerations for SQL queries, and advanced features of the Oracle SQL dialect. Delegates should have solid SQL Foundation-level experience before attending the Advanced course.

PL/SQL (Procedural Language/SQL) is Oracle's proprietary procedural extension to SQL, used to write stored procedures, functions, triggers, and packages that run directly within the Oracle database. JBI offers two PL/SQL courses. Oracle PL/SQL Foundation (three days) covers the PL/SQL block structure, variables and data types, control flow, cursors, exception handling, and creating stored procedures and functions. Oracle PL/SQL and Packages (five days) extends this to cover packages, triggers, dynamic SQL, collections, bulk processing, advanced exception handling, and performance optimisation of PL/SQL code. Both courses are suited to Oracle developers and database programmers.

Oracle GoldenGate is a high-performance data replication and integration platform used to capture, transform, and deliver data changes between databases in real time — supporting use cases including zero-downtime migrations, high availability, disaster recovery, and real-time data integration between Oracle and heterogeneous database environments. JBI's three-day Oracle GoldenGate Essentials course covers the GoldenGate architecture, configuring Extract and Replicat processes, managing trails and checkpoints, monitoring and troubleshooting replication, and applying GoldenGate to common enterprise scenarios. It is suited to Oracle DBAs, data engineers, and integration architects working in environments where real-time data replication is required.

The three-day Oracle Performance Tuning course covers the techniques and tools used to identify and resolve performance problems in Oracle database environments. Topics include understanding the Oracle architecture from a performance perspective, using Explain Plan and SQL trace to analyse query execution, tuning SQL queries for optimal execution plans, using Oracle's Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance analysis, index design and management, memory configuration tuning, and I/O optimisation. It is suited to Oracle DBAs, senior developers, and database architects who are responsible for the performance and scalability of Oracle database systems in production environments.

Oracle DBA Part 1 is a five-day comprehensive foundation for Oracle database administration, covering Oracle architecture, installation and configuration, managing tablespaces and datafiles, user management and security, backup and recovery using RMAN, network configuration, and routine DBA operational tasks. Oracle DBA Part 2 is a three-day advanced programme for DBAs who have completed Part 1 or have equivalent experience, covering more complex administration topics including advanced backup and recovery strategies, Flashback technology, resource management, performance monitoring, and managing Oracle in more complex multi-tier environments. Together the two programmes provide a thorough, practical grounding in professional Oracle database administration.

Yes. All Oracle courses at JBI can be delivered as customised onsite or online programmes for corporate Oracle database teams. Content can be tailored to the team's Oracle version, existing environment, specific performance challenges, or DBA responsibilities. For example, a team managing Oracle in a high-availability environment can receive training focused on GoldenGate, backup and recovery, and performance tuning, while a development team building Oracle-backed applications can receive an integrated SQL and PL/SQL programme. JBI has delivered Oracle database training for teams at organisations including the BBC, NHS, RBS, Sky, EDF, and Cisco.

Oracle DBA - Part 2 training course

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

Public Courses

Customised Courses

Highlights

Course Details

Who should attend

Feedback

4.8 out of 5 average

Certification

More about this course

FAQs

Highlights

Course Details

Who should attend

Feedback

4.8 out of 5 average

Certification

More about this course

FAQs

What Oracle training courses does JBI Training offer?

What is the difference between Oracle SQL Foundation and Oracle SQL Advanced?

What is PL/SQL and what do the PL/SQL courses cover?

What is Oracle GoldenGate and what does the GoldenGate Essentials course cover?

What does Oracle Performance Tuning cover and who should attend?

What is covered across the Oracle DBA Part 1 and Part 2 courses?

Can Oracle training be customised for a corporate database team?

Email this page to yourself