This two-day focused course enables you to explore the core administration skills you need to master Oracle Database 12cR2. It’s ideal for those supporting smaller databases or tackling administration tasks alongside other IT roles and for expanding your technical knowledge to enhance your career opportunities.
Oracle Database 12cR2 Essential Administration
Gain invaluable Oracle administration skills for strong career development
Over two focused days, you’ll gain hands-on experience with Oracle Database 12cR2 using live labs and real-world administration scenarios. Guided by expert trainers, you’ll learn to install, configure, monitor and secure databases with SQL Developer, Enterprise Manager Express and SQL*Plus. This training is ideal for small database environments and supports skills you can apply directly in your role.
Learning objectives
- Install Oracle Database software
- Create and configure a database
- Manage users and schema objects
- Configure Oracle networking
- Monitor database performance
- Perform basic backup and recovery
- Understand Oracle architecture
- Use administration tools including SQL Developer
What you’ll learn
Build deeper knowledge about the administration tasks every small database DBA needs to work effectively. From setting up Oracle 12cR2 to managing storage and keeping the system running smoothly, you’ll complete the course with a valuable new practical toolkit that will make your daily projects easier to manage.
Creating a database
Learn how to create and configure a database using Oracle’s Database Configuration Assistant (DBCA). You’ll learn how to differentiate between CDB and non-CDB architectures, choosing appropriate storage methods and understanding how character sets influence your setup. This is a must-have skill for anyone pursuing Oracle DBA 12C training, because it means you’re confident creating Oracle Database 12c environments that fit different workloads. Whether you’re supporting production systems or test environments, you’ll be equipped to make the right choices for any current or future work projects.
User and schema management
This course focuses on the day-to-day administration skills every Oracle Database 12C administrator needs. You’ll learn how to create and manage user accounts, apply roles and privileges, and keep control over who gains access. We’ll also guide you through managing schema objects like tables, views, sequences and indexes, essential tools for keeping databases clean, efficient and secure. These practical tasks are central to Oracle DBA 12C training and give you the confidence to manage user access and data structure independently.
Backup and recovery
A solid understanding of backup and recovery is so important for DBAs. In this course, you’ll learn how to set up ARCHIVELOG mode, configure your backup settings and perform basic recovery tasks when needed. We’ll explain the logic behind Oracle’s approach to recovery and give you the hands-on experience to reinforce your expertise. If you’re learning Oracle Database 12C Administration, these are must-have skills to keep your systems safe, and your data protected.
What’s included
- Two days of focused Oracle Database 12cR2 training
- Live virtual sessions with experienced Oracle instructors
- Access to live Oracle lab environments during the course
- Digital course manual to keep
- Post-course support to help apply what you've learned
- Certificate of completion from StayAhead Training
- Small group delivery for tailored support and interaction
Key facts
Ideal for
IT professionals who manage small Oracle databases or provide support with occasional administration responsibilities. Great for those stepping into DBA tasks without being full-time DBAs.
Prerequisites
You should understand relational database concepts and have working knowledge of Oracle SQL. Basic familiarity with Linux or UNIX is useful but 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
Over two engaging days, this expert-led course boosts your practical Oracle administration skills using 12cR2, SQL Developer, and Enterprise Manager Express. Ideal for small database environments and expanding your technical capabilities.
Is this the right course if I manage a small Oracle database?
Yes, if you look after a small Oracle database or support systems that use one, this course is an ideal choice. It's designed for people who don’t do DBA work full-time but need to handle administration tasks confidently. This course is also useful if you're in IT support or development and want to become more confident with Oracle Database 12C Administration.
Do I need to know SQL before attending?
Yes, a solid grasp of Oracle SQL is important before beginning this course. You’ll be using SQL for lots of the administration tasks we cover, so it helps to have some knowledge of the basics. If you’re not quite there yet, our Oracle SQL course is the perfect place to start before moving on to this course.
What version of Oracle does this course cover?
We focus on Oracle Database 12cR2, but what you learn also applies to 18c and 19c. The tools and techniques are the same across those versions, so you’ll be in a great position to handle real-world Oracle Database 12C Administration tasks, whatever your professional situation.
What’s the difference between this course and the full Oracle Database Administration course?
This course is designed for IT professionals who manage smaller databases or occasionally support administration tasks. If you're looking for a more in-depth programme aimed at full-time DBAs, our Oracle Database Administration course would potentially be a better choice.
What our customers say
‘The lecturer was amazing - so passionate and knowledgeable, which made the sessions really enjoyable and easy to follow. I learned a lot and felt supported throughout. I would definitely consider returning for future sessions and highly recommend StayAhead training to my colleagues.’
Kamila, Data Administrator - Retail / Hire
‘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