Designed for those overseeing small to medium-sized Oracle databases, this course focuses on the day-to-day tasks that keep systems running smoothly. You’ll learn how to install and configure Oracle Database 19c, manage users and storage, maintain security and carry out basic backup and recovery.
15% off eLearning, up to 20% off virtual courses - use code: NSWOCT25UK
View courses
52fdb085-9e65-4709-a483-f386fab9e9ef
Oracle Database 19c Essential Administration
Select your learning method
Learn essential skills
Course overview
Build essential knowledge for effective Oracle administration
Designed for part-time DBAs and support teams, this course focuses on the key tasks and tools needed to maintain small Oracle systems effectively. Across two days, you’ll learn how to install and configure the software, manage users and storage, secure the database, and carry out performance monitoring and recovery tasks.
Learning objectives
- Set up and install Oracle Database 19c software
- Create and configure databases tailored to your environment
- Navigate and utilise Enterprise Manager Express for key admin tasks
- Create and manage user accounts, roles and schema components
- Perform backup, recovery and restore operations confidently
- Monitor and assess database performance using built-in tools
- Work efficiently with SQL Developer and SQL*Plus interfaces
- Configure Oracle networking and test client connectivity
What you’ll learn
This course shows you how to carry out core Oracle 19c admin tasks confidently. From managing users to understanding performance diagnostics, you'll build practical skills in our live labs and benefit from the support of our expert trainers.
Managing users and roles
Learn how to create and manage user accounts in Oracle Database 19c. You’ll cover key tasks such as assigning roles and privileges, updating passwords, and locking or unlocking accounts. The course explains how these activities support database security and access control. By the end, you’ll be able to carry out routine user administration tasks and understand their role in maintaining a secure and well-managed system.
Schema objects and data integrity
This course explains how to use core database objects, including tables, indexes, views, and sequences. Learn how to apply data integrity rules using constraints such as primary keys, helping to ensure that your data remains accurate and correctly linked. Develop practical techniques that will help you maintain a well-structured and reliable database.
Performance monitoring
Discover how to monitor and improve database performance using Oracle’s built-in tools. You’ll learn how to identify early signs of potential issues, interpret key performance reports such as AWR, and use diagnostic advisors to support system stability. This course is designed to give you a clear understanding of performance monitoring, even if it isn’t your primary responsibility.
What’s included
- 2 days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
- Course completion certificate
Key facts
Who it’s for
Support staff, entry-level DBAs or IT professionals who manage Oracle systems as part of a broader technical role.
Prerequisites
You should have completed our Oracle SQL course or be familiar with relational databases and Oracle SQL.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
Designed for those who manage small databases or support Oracle systems as part of a broader role, this course provides experience with core database administration tasks.
How do I use the Database Configuration Assistant (DBCA) to create an Oracle database?
You’ll be guided through the process of creating a database using DBCA, Oracle’s graphical setup tool. The course covers key steps such as selecting storage methods, choosing between container and non-container databases, defining character sets, and specifying database type. Learn how to make the right configuration choices for your use case.
What’s the role of Oracle performance advisors and how are they used?
Oracle performance advisors help identify and resolve performance issues within the database. In this course, you’ll explore tools like the Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM). These tools support proactive monitoring and provide recommendations to improve database efficiency and stability.
Does the course include backup and recovery training?
Yes. The course introduces Oracle’s approach to backup, recovery, and restore operations. You’ll learn how to configure ARCHIVELOG mode, set up backup parameters, and perform recovery scenarios. This helps ensure you’re prepared to protect data and restore service in the event of failure.
What our customers say
"Thoroughly enjoyed the course, very informative and a good balance between instruction and practical work."
Megan, Transport
"I was a little bit worried coming in that I wouldn't have the requisite knowledge, however, I found that it was just about the perfect level between being able to understand the concepts and stretching the grey matter. Hoping to come back for more in the future!”
Ashley, AppOps Engineer (Jr DBA) - Government
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
Quote request
Please complete the form to ensure your quote is accurate and we will contact you soon.
For the best prices, get in touch!