Oracle Database 12cR2 Essential Administration

Select your learning method

Overview Learning objectives What you’ll learn Key facts FAQs What our customers say Get in touch

Learn essential skills

Course overview

With a practical focus, this proactive two-day course guides you through the key administration skills needed for Oracle Database 12cR2. It’s perfect for those managing smaller databases or supporting IT teams as part of a wider role or if you’re looking to expand your technical skills for career development purposes.

Enhance your Oracle database administration capabilities

In just two immersive days, you’ll become familiar with Oracle Database 12cR2 through practical lab exercises. ILX’s expert trainers will show you how to install, configure, monitor and secure Oracle databases using key tools like SQL Developer, Enterprise Manager Express and SQL*Plus.

Learning objectives

Set up Oracle Database 12cR2 using Oracle Universal Installer
Build a tailored database environment using DBCA
Create and maintain user accounts, privileges, and key schema objects
Configure Oracle Net and listener settings for secure connectivity
Track system performance using built-in monitoring tools and advisors
Apply basic backup strategies and perform recovery procedures
Gain insight into the components and processes that make up Oracle’s architecture
Navigate and use SQL Developer, Enterprise Manager Express and SQL*Plus confidently

What you’ll learn

Discover the essential elements of Oracle Database and the core administration tasks every small-scale Oracle DBA should acquire. From setting up Oracle 12cR2 to managing users, storage and backups, this practical course gives you the capacity to make your day-to-day projects more manageable and efficient.

Installing Oracle Database

A reliable installation is the foundation of effective administration. In this course, you’ll learn how to plan for a successful Oracle Database 12cR2 setup by assessing system requirements, preparing the operating environment, and using the Oracle Universal Installer (OUI) step-by-step. You’ll explore Oracle’s flexible architecture, set environment variables, and understand the purpose of the Oracle Inventory. We’ll also cover safe removal procedures to ensure you can cleanly de-install software when needed.

Using administration tools

Different administration tasks call for different tools. You’ll work hands-on with SQL Developer, Enterprise Manager Express, and SQL*Plus to perform a variety of configuration, monitoring, and troubleshooting tasks. We’ll compare the strengths of each tool and show you practical workflows so you can choose the right approach for the task at hand, whether you’re checking performance metrics, modifying user accounts, or updating database settings.

Oracle networking

Without proper networking configuration, your database can’t be accessed effectively. This course introduces Oracle Net concepts and takes you through configuring and managing the Oracle Net Listener. You’ll practise setting up local naming with Net Manager, test connections with TNSPING, and manage listener services from Enterprise Manager. By the end of the course, you’ll be able to create a stable, secure connection environment for your databases.

What’s included

Two-days of live, virtual training
Delivered by ILX’s Oracle experts
Real-time access to Oracle lab environments
Digital course materials to support learning
Post-course help to apply new skills
Certificate of completion from ILX Group
Small class sizes for personalised support

Key facts

Ideal for

IT support teams, sysadmins or anyone who finds themselves managing Oracle databases in their workflow.

Prerequisites

You should be comfortable with relational database basics and have some hands-on experience with Oracle SQL. If you’ve used Linux or UNIX before, that can better support your learning.

Learning experience

Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.

FAQs

Over two immersive days, you’ll gain increased confidence in Oracle 12cR2 administration. In our live labs, you’ll explore tools like SQL Developer and Enterprise Manager Express, perfect if you’re managing a smaller database and want to build your expertise.

Is this course right for someone new to database administration?

Yes – if you understand relational database basics and can write basic Oracle SQL statements, you’ll be able to follow the content. The course is designed for those starting to handle administrative tasks for small-scale Oracle databases, such as support engineers, sysadmins, or junior DBAs.

Will I learn to create and configure a database from scratch?

Definitely. You’ll gain hands-on experience with the Database Configuration Assistant (DBCA), exploring storage options, CDB versus non-CDB configurations, workload-based database types, and character set selection so you can design and deploy environments tailored to specific needs.

Does the training include performance monitoring techniques?

Yes. You’ll learn to use Oracle’s built-in monitoring architecture, including Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM), alongside additional advisor tools. This ensures you can track performance trends, identify bottlenecks, and apply informed improvements.

How much will I need to know about Linux or UNIX?

Only a basic familiarity is recommended. The course is delivered on a Linux platform, and all relevant commands will be demonstrated in context, so you’ll pick up practical operating system skills as you progress through the exercises.

Will the skills apply to newer Oracle versions?

Yes. Although the focus is on Oracle Database 12cR2, the administration techniques also apply to 18c and 19c, as the core tools and processes remain consistent.

What our customers say

‘This is now my second course with John at ILX and once again the delivery was simply excellent. Best fun I've had at work for a while now and would very highly recommend the course to anyone. Hoping to come back for more in the future!’

Ashley, AppOps Engineer (Jr DBA) - Government

‘Always good courses from ILX. Tutor explained the course very well.’

Paul, Development Analyst, Application Support - Transport

Why study with ILX

500,000+ learners

Join the half a million learners developing their skills with our training

5,000+ businesses

A trusted partner to thousands of organisations worldwide

96% customer satisfaction

Our passionate team goes above and beyond to support customer needs

Similar courses

SQL (Oracle)

Course

Oracle SQL

Oracle

Course

Oracle Database 19c Administration

SQL (Oracle)

Course

Oracle PL-SQL

SQL (Oracle)

Course

Oracle SQL Advanced