Our course teaches core Oracle 18c administration skills for those managing small-scale or departmental databases. You’ll learn how to install, configure, and maintain Oracle environments using SQL Developer, Enterprise Manager Express, and SQL*Plus, covering essential tasks from user management to performance monitoring and database security.
Oracle Database 18c Essential Administration
Achieve control and stability in small-scale Oracle 18c environments
Gain the skills to efficiently manage and support Oracle 18c in smaller or departmental environments. Learn to set up databases, configure key components, monitor performance, and handle everyday administration tasks with SQL Developer, Enterprise Manager Express, and SQL*Plus, ensuring stability and security in your Oracle systems.
Learning objectives
- Install and configure Oracle 18c software
- Create and manage Oracle databases
- Administer users, roles, and schema objects
- Configure and monitor database performance
- Manage storage structures and network settings
- Perform essential backup and recovery operations
What you’ll learn
Develop the skills to install, configure, and manage Oracle databases using built-in tools such as SQL Developer and Enterprise Manager Express during our Oracle Database 18c Essential Administration course. Enabling you to keep smaller Oracle environments secure, efficient, and running at peak performance to reduce downtime and support business continuity.
Installing Oracle software
Learn the complete process for installing Oracle Database 18c correctly and efficiently. You’ll review system requirements, Oracle’s flexible architecture, and environment variables before using the Oracle Universal Installer (OUI) to deploy components. The course also covers Oracle Inventory, de-installation, and post-installation checks, ensuring a stable, high-performing Oracle environment from the start.
Creating and configuring a database
Gain the skills to create Oracle databases with the Database Configuration Assistant (DBCA), including container (CDB) and non-container types. You’ll select storage methods, database types, and character sets, balancing scalability and performance. By the end of the course, you’ll have configured a fully functional database tailored to your organisation’s operational needs.
User and schema management
Develop the ability to create and manage database users, roles, and privileges, ensuring secure access control. You’ll also create and maintain schema objects such as tables, indexes, views, synonyms, sequences, and constraints. Practical exercises reinforce skills for maintaining data integrity and applying business rules effectively across Oracle Database 18c environments.
Network and instance configuration
Discover how to configure Oracle’s network environment by setting up the listener, applying Oracle Net naming methods, and testing connections with TNSPING. You’ll explore instance management, including memory structures, background processes, and parameter settings. You’ll also learn how to troubleshoot using alert logs and trace files, ensuring reliable connectivity and stable database operations in production 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
Our Oracle Database 18c Essential Administration course teaches you how to install, configure, and manage Oracle databases, monitor performance, and perform backups. Equipping you to support smaller environments confidently and keep systems stable, secure, and efficient.
What tools will I use to manage the database?
You’ll work with Oracle’s core administration tools: SQL*Plus, Oracle SQL Developer, and Enterprise Manager Express. These enable you to monitor performance, configure settings, manage schema objects, and troubleshoot issues. Live labs will also ensure you can confidently apply each tool in real-world Oracle Database 18c administration scenarios.
How is this course different from full DBA training?
This course focuses on essential Oracle 18c admin skills for smaller or departmental databases, not large-scale enterprise setups. You’ll learn installation, database creation, user and schema management, basic performance monitoring, and backup and recovery, without delving into advanced topics such as RAC, Data Guard, or complex multitenant environments.
Do I need Linux experience to attend?
No prior Linux experience is required. All commands and processes are explained step-by-step, ensuring you can complete labs confidently. While the course runs on Linux, it focuses on Oracle database administration skills, making it accessible to learners from both technical and non-technical backgrounds.
Will I get hands-on practice?
Yes. Every module includes lab exercises in a live Oracle environment, covering installation, database creation, listener configuration, user and schema management, and basic recovery. You’ll apply each concept immediately, reinforcing skills for managing Oracle Database 18c in real workplace scenarios.
What if I want to continue learning Oracle?
After this course, you can progress to our Oracle Database 19c Administration course to learn advanced DBA skills. You can also enhance your expertise with our Oracle PL/SQL and Oracle SQL Advanced courses, strengthening your query and scripting abilities for enhancing your career prospects in database management.
What our customers say
“The teacher explained concepts patiently and thoroughly, ensuring that every student could follow along regardless of their prior experience. Practical examples and hands-on exercises helped reinforce learning, boosting confidence.”
Naomi, IT&S engineer - Pharmaceuticals
“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