Oracle Admin Short Training Course JBI | Remote | Virtual

Highlights

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

Course Details

•   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

Who should attend

The course is suitable for technical personnel who need to learn how to administer and maintain Oracle 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

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

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.

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 Admin Essentials training course

A Short Course Covering The Essentials of Oracle Database Administration

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