Gain the practical skills to manage and support Oracle databases in smaller or departmental settings. This course shows you how to install and configure Oracle 18c, manage users and schema objects, oversee storage structures, and monitor performance using SQL Developer, Enterprise Manager Express, and SQL*Plus.
15% off eLearning, up to 20% off virtual courses - use code: NSWOCT25SA
View courses
943a3aff-3509-47e2-92ab-e79affea11ad
Oracle Database 18c Essential Administration
Select your learning method
Learn essential skills
Course overview
Optimise and secure your Oracle 18c database operations
Develop the expertise to run Oracle 18c databases smoothly in smaller or departmental settings. Learn how to create and configure databases, manage users and schema objects, monitor performance, and apply security best practices using SQL Developer, Enterprise Manager Express, and SQL*Plus, keeping your systems efficient, stable, and protected.
Learning objectives
- Install and set up Oracle 18c software
- Create, configure, and maintain Oracle databases
- Manage schema objects, users, and access controls
- Tune and monitor database performance effectively
- Configure network connections and storage resources
- Perform essential backup, restore, and recovery procedures
What you’ll learn
Our Oracle Database 18c Essential Administration course teaches you the core capabilities for installing, configuring, and maintaining Oracle 18c in smaller or departmental environments. You’ll learn to use SQL Developer, Enterprise Manager Express, and SQL*Plus to perform everyday administration, monitor performance, and ensure secure, stable, and efficient database operations.
Storage structure management
Learn the skills to manage and optimise the physical and logical storage structures that power Oracle Database 18c. You’ll work with control files, redo and archive logs, tablespaces, and undo management. You’ll also gain a clear understanding of strategies that maximise performance, maintain high availability, and ensure storage configurations support efficient recovery and long-term stability.
Configuration for growth and scalability
Explore techniques for configuring Oracle 18c databases to handle increasing workloads. You’ll adjust settings for optimal resource usage, plan storage expansion, and prepare your environment for future growth. By the end, you’ll also be able to adapt configurations to meet evolving business and performance demands.
Security and access control
Gain the knowledge to protect Oracle 18c environments through effective security measures. You’ll configure user authentication, manage roles and privileges, and enforce least-privilege principles. Practical exercises show how to maintain compliance, safeguard sensitive data, and reduce the risk of unauthorised access in smaller Oracle database deployments.
Performance monitoring and backup
Develop essential skills to keep Oracle 18c databases secure and high performing. Learn how to use AWR, ADDM, and advisory tools for proactive diagnostics, configure ARCHIVELOG mode, and apply recovery strategies. You’ll also gain practical experience in optimising backup settings to protect data, prevent downtime, and maintain stability in smaller Oracle environments.
What’s included
- Two-days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
Key Facts
Ideal for
Support staff and new Oracle users who manage small databases or assist with administration.
Prerequisites
Basic knowledge of relational databases and Oracle SQL. Some Linux familiarity is helpful 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
The Oracle Database 18c Essential Administration course teaches you how to create databases, manage users and schema objects, configure networking, monitor performance, and perform essential backup and recovery using Oracle’s built-in administration tools.
What kind of databases will I work with during the training?
You’ll work with Oracle Database 18c in both container and non-container configurations. Training includes creating databases with DBCA, managing schema objects, and working with control files, redo logs, and tablespaces. These practical exercises help you understand how Oracle maintains performance, consistency, and availability in different environments.
How much Oracle knowledge do I need to attend?
You should be familiar with basic database concepts and Oracle SQL. Prior SQL course completion or work experience is ideal. The course builds on existing knowledge, making it suitable for application support staff, junior DBAs, and technical professionals looking to strengthen core Oracle 18c administration skills.
Does this course help with preparing for certification?
Yes. While not a formal certification course, the content aligns with topics found in entry-level Oracle exams, including database architecture, user management, and recovery processes. You’ll gain practical, real-world skills that improve retention and readiness, along with guidance on potential next steps toward official Oracle certification.
What other Oracle courses could I take next?
We recommend advancing to our Oracle Database 19c Administration course for more complex DBA skills. You can also develop query and programming expertise with Oracle SQL Advanced or Oracle PL/SQL. These follow-on courses support career growth, certification goals, and the ability to manage more advanced Oracle environments confidently.
What if my team needs customised training?
We offer tailored private training for teams, adaptable to your organisation’s systems and priorities. Whether onsite or virtual, we can focus on specific Oracle features, processes, or challenges. This ensures team-wide skill development, consistent best practices, and reduced reliance on external support for essential Oracle administration tasks.
What our customers say
“Thoroughly enjoyed the course, very informative and a good balance between instruction and practical work.”
Megan, ILX Learner - Transport
“Tarn is an excellent instructor. Everything was clearly communicated. One of the best courses I have attended in recent years.”
Simon, Senior 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!