Oracle Database 18c Administration Workshop Level 1
Duration: 4 Days
If you are a student of an accredited academic institution call us for a 25% discount.
Oracle Certified Master
John wrote the EXAM Guide
This course provides you with the skills necessary to create, maintain and manage an Oracle 12c database.
You will also be prepared to pass exam Oracle Database 12c: Installation and Administration 1Z0-062 (administered by PearsonVue).
In this class you will concentrate on the skills and best practices required for day-to-day database administration tasks such as security, creating and managing users, space management, administering undo and redo, running utilities, configuring Oracle networking, and simple backup and recovery techniques. An in-depth discussion of Oracle 12c database architecture is also provided.
The course is run on the current release of database 18c, but the instructors (OCM John Watson unless otherwise noted) will aways “back-port” the course to 12c and earlier where behavior has significantly changed.
Students have access to electronic versions of all examples, sample scripts and lab solutions. Approximately 33% of class time is spent on hands-on exercises.
Compared to the Oracle University courses “Oracle Database 18c: Administration Workshop” and “Oracle Database 18c: Install and Upgrade Workshop” our class is
“The delivery of this course was probably the best out of several online courses I have attended. Everything worked well. This course was definitely not light on content (like several courses – not skillbuilders, of course – that I have attended). It is nice to get that much value out of a week-long training.”
“This course was definitely not light on content (like several courses – not skillbuilders, of course – that I have attended). It is nice to get that much value out of a week-long training.”
Oracle Database Software installation
Creating a Database
Oracle 18c Database and Instance Architecture
Learning the Data Dictionary
Understanding and Configuring Oracle Net
Managing Users and Security
Managing Undo and Redo
Understanding and Managing Oracle Locking and Concurrency
Auditing Activity on Your Databases
Introduction to Oracle Instance Tuning
Understanding and Using The Database Scheduler
Understanding and Using The Resource Manager
Utilities: Using Data Pump amd SQL*Loader
Some additional topics, depending on time and interest:
Introduction to Oracle SQL tuning
RMAN: Backup and Recovery
Understanding and Managing Multitenant Architecture (CDB)