Understand the essentials of Oracle Database 19c administration. This two-day practical course builds your confidence using key tools such as Enterprise Manager Express, SQL Developer and SQL*Plus, and teaches you how to install, configure and maintain Oracle systems.
Oracle Database 19c Essential Administration
Learn to install, configure and maintain Oracle Database 19c
Build your ability to manage Oracle Database 19c environments. The course strengthens your understanding of core admin tasks such as user and storage management, database security, backup and recovery, and performance monitoring.
Learning objectives
- Install Oracle 19c software
- Create and configure databases
- Use Enterprise Manager Express
- Manage users and schema objects
- Handle backup and recovery
- Monitor database performance
- Use SQL Developer and SQL*Plus
- Set up Oracle network connections
What you’ll learn
Explore the core functions involved in supporting and maintaining Oracle Database 19c systems. You’ll develop a knowledge of how Oracle databases operate, from setup and configuration to user management, performance tuning and recovery.
Installing Oracle 19c
You’ll learn what’s required to set up Oracle 19c databases. From understanding system prerequisites to using the Oracle Universal Installer, you’ll understand how to properly install the software in a Linux environment. Gain an overview of installation management, explore environment variables, Oracle architecture, and discover what’s involved in de-installation.
Creating and configuring databases
Discover how to use the Database Configuration Assistant (DBCA) to build a database that fits your needs. Work through storage choices, select the right character sets, and understand the benefits of container and non-container databases. By the end of the course, you’ll be able to create a solid, functional Oracle database ready for use.
Using management tools
Become familiar with Oracle’s key admin tools: SQL Developer, SQL*Plus, and Enterprise Manager Express. You'll learn how each tool supports different aspects of administration, from command-line tasks in SQL*Plus to graphical interfaces in Enterprise Manager Express. You’ll practise using these tools to perform common duties such as starting up and shutting down the database, reviewing alert logs, monitoring system health, and running basic queries.
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
Ideal for
Support staff or part-time DBAs managing smaller Oracle database environments.
Prerequisites
You’ll need an understanding of relational databases and Oracle SQL. This can be gained through our Oracle SQL course.
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 days, this practical course covers the key administrative tasks involved in managing Oracle Database 19c, making it suitable for DBAs and other professionals responsible for smaller databases.
How is Oracle network configuration explored in the course?
The course introduces Oracle’s networking environment, including how to configure and manage Oracle Net Listener and set up local naming for client connections. You’ll use tools such as Net Manager and TNSPING, plus learn how to test and troubleshoot connectivity. Practical exercises walk you through configuring the listener and establishing secure connections to the database.
Will I learn how to set up and manage Oracle user accounts?
You’ll learn how to create and manage user accounts, assign roles and privileges, and enforce account security. This includes locking and unlocking accounts, resetting passwords, and managing access rights to ensure users have appropriate levels of control over the database.
How is this course delivered?
The Oracle Database 19c Essential Administration course is delivered as live virtual classroom training. Sessions are led by expert trainers and include practical, hands-on exercises using our live labs. For businesses with multiple learners, we also offer the option to run this course onsite or virtually as a closed event tailored to your organisation’s needs.
What our customers say
"Very knowledgeable instructor, well-paced, not rushed. Everything was explained clearly."
Kimberley, Community Risk Reduction IT Systems – Fire
"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
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