The Oracle Database 19c Administration course equips learners with the practical skills needed to manage, monitor, and support Oracle databases effectively. It covers key areas such as database architecture, user and security management, performance tuning, and backup and recovery.
Oracle Database 19c Administration
Boost your confidence in Oracle Database administration
On this five-day course, you’ll pick up the skills to run, manage and troubleshoot Oracle 19c databases. You’ll learn the tools, techniques and advanced Oracle features such as Multitenant Architecture, RAC, ASM used by DBAs on a daily basis.
Learning objectives
- Run and manage Oracle databases
- Set up network access and listeners
- Tune performance and fix issues
- Handle storage and space
- Set up users, roles and access
- Schedule tasks automatically
- Add auditing and security
- Plan for backup and recovery
What you’ll learn
On the Oracle Database 19c Administration course, you’ll gain a strong foundation in managing and supporting Oracle databases. Guided by our experienced trainers, you’ll work through DBA tasks such as setting up databases, managing users, monitoring performance, and more.
Instance administration
Understanding how to manage an Oracle database instance is at the heart of database administration. In this course, you'll learn how to use tools like SQL*Plus, SQL Developer and Enterprise Manager to handle key admin tasks. From checking system settings to working with parameter files and startup processes, you’ll get to grips with the tasks that keep your databases running smoothly. We’ll also cover how to spot issues early, make changes safely and ensure your database is correctly set up for reliable performance.
Performance monitoring
Learn how to keep your databases running smoothly and reliably in high-pressure environments. Even well-built databases can run into performance issues; this course teaches you how to identify and fix these issues. You’ll use Oracle’s tools to track database performance and find the root cause of slowdowns or bottlenecks. Learn how to interpret key metrics, use the Automatic Workload Repository, and apply tuning strategies.
Backup and recovery setup
Explore Oracle’s backup and recovery tools, this course will show you how to plan, configure and test backups. You’ll learn how to protect your data against loss or corruption and understand how to get things back on track if something goes wrong. The course covers Oracle’s recommended strategies and gives you the tools to build an effective recovery plan that works in the real world.
What’s included
- 5 days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
Key facts
Ideal for
IT professionals or junior DBAs who want to improve their ability to run Oracle databases.
Prerequisites
You’ll need to understand the basics of databases and Oracle SQL. Some Linux or PL/SQL experience would be helpful, but is not essential.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
Learn the fundamentals of Oracle database administration. We’ll guide you through core concepts such as setup, tuning and troubleshooting, using real-world examples and practical exercises throughout.
Who is Oracle Database 19c Administration course designed for?
If you understand the basics of database administration and have some prior experience working with Oracle SQL, this course would be perfect for you. It’s designed to build practical Oracle database administration skills, starting with managing the instance and moving into tasks such as user management, backups and performance tuning.
If you’re looking for a course aimed at complete beginners, our Oracle SQL Fundamentals training will give you a familiarity with the core language of the database.
Will this course help me achieve Oracle certification?
This course is closely aligned to the Oracle Database Administration I (1Z0-082) certification exam. While you’ll need to complete additional study and practice to pass the exam, this training gives you a solid foundation. You’ll get practical, hands-on experience with Oracle 19c, and learn how to apply your knowledge in real-world scenarios, something that helps significantly when tackling certification questions. It’s one of the most effective ways to build confidence and prepare for formal Oracle DBA accreditation.
Do I need to have a knowledge of Linux to take this course?
While this course runs on a Linux environment — as Oracle databases often do — you don’t need to be a Linux expert to do this training. A familiarity with Linux or UNIX can help you feel more comfortable, especially if you’ll be managing Oracle on those platforms back at work. But if you’re new to Linux, don’t worry, our trainers will walk you through the platform.
What our customers say
"The course was particularly good and certainly took my PL/SQL to another level. The instructor was particularly good and very knowledgeable, anything he didn't know he would investigate and come with the explanation. That is not my first class with him and one of the reasons I actually book with this company."
Caroline, Government
"Very well laid out and John does an amazing job of explaining things in detail."
Ali, Operations Technical Service Analyst - Utilities
Why study with StayAhead
96% customer satisfaction
We combine experience and passion to deliver training that meets the highest standards
30+ years’ experience
Industry-leading specialists delivering high-impact IT training
Experiential instructor-led training
Courses are delivered by experienced instructors using hands-on, practical live labs