Register for Waitlist
,
This class if full now. You can register on the wait list to be notified when a seat becomes available.
Oracle Database 18c: Administration Workshop Training
Live Online & Classroom Enterprise Certification Training
Powered By
The Oracle Database 18c: Administration Workshop Ed 1 course provides you with a firm foundation in administration of an Oracle database. In this course, you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner.
Powered By
Looking for a private batch ?
REQUEST A CALLBACKNeed help finding the right training?
-
Certified Trainer
-
Authorized Courseware
-
Completion Certificate from ATP
-
Enterprise Reporting
-
Lifetime Access
-
CloudLabs
-
24x7 Support
-
Real-time code analysis and feedback
What is 18c: Administration Workshop Certification Training about?
What are the objectives of 18c: Administration Workshop Certification Training ?
Who is 18c: Administration Workshop Certification Training for?
What are the prerequisites for 18c: Administration Workshop Certification Training?
Available Training Modes
Live Online Training
40 HoursClassroom Training
5 DaysCourse Outline Expand All
Expand All
- Sample HR Schema
- Oracle Cloud Overview
- Oracle Database Editions, Options, and Management Packs
- Automatic Storage Management (ASM) Overview
- Oracle Database Instance Configurations
- Oracle Database Memory and Process Structures
- Connecting to the Database Instance
- Logical and Physical Database Structures
- Multitenant Architecture
- Oracle Database Server Architecture
- Automated Database Provisioning
- Oracle Database Cloud Service Architecture
- Features and Tooling
- SSH Key Pairs
- Database File Storage
- Input to the Creation Wizard
- Oracle Database Cloud Service Tools
- Database Configuration Assistant (DBCA)
- Oracle Enterprise Manager Cloud Control
- Oracle enterprise Manager Database Express
- SQL Developer
- SQL*Plus
- Managing Network Access to DBCS
- Managing the Compute Node
- Scaling a Database Deployment
- Patching a Database Deployment
- Starting Up Oracle Database Instances
- Data Dictionary Views
- Shutting Down Oracle Database Instances
- Dynamic Performance Views
- Automatic Diagnostic Repository (ADR)
- Alert Log and Trace Files
- Initialization Parameter Files
- Oracle Net Services Administration Tools
- Configuring Communication Between Database Instances
- Oracle Net Listener Overview
- Connecting to an Oracle Database Instance
- Comparing Dedicated and Shared Server Configurations
- Naming Methods
- Assigning Quotas to Users
- Applying the Principal of Least Privilege
- Managing Oracle Cloud Users, Privileges, and Roles
- Creating and Assigning Profiles
- User Authentication
- Managing Oracle Database Users, Privileges, and Roles
- Dropping PDBs
- Cloning PDBs
- Methods and Tools to Create PDBs
- Creating PDBs from Seed
- Unplugging and Plugging in PDBs
- Overview of Transparent Data Encryption (TDE)
- Creating and Activating an Encryption Key
- CDB and PDB Master Encryption Keys
- Encryption in Oracle Database Cloud Service
- Viewing Tablespace Information
- Creating, Altering and Dropping Tablespaces
- Table Data Storage
- Tablespace Encryption by Default in DBCS
- Implementing Oracle Managed Files
- Moving and Renaming Online Data Files
- Resumable Space Allocation
- Shrinkable Segments
- Deferred Segment Creation
- Space-Saving Features
- Oracle Database Space Management Features
- Types of Segments
- Table and Row Compression
- Block Space Management
- Comparing Local Undo Mode and Shared Undo Mode
- Transactions and Undo Data
- Storing Undo Information
- Configuring Undo Rentention
- Comparing Undo Data and Redo Data
- Temporary Undo
- External Tables
- Oracle Data Pump
- Migrating to Oracle Database Cloud Service
- SQL*Loader
- Point-in-time Recovery
- Complete Recovery
- Categories of Failure
- Flashback Technology
- Instance Recovery
- Configuring ARCHIVELOG Mode
- Configuring and Monitoring the Fast Recovery Area
- Multiplexing Control Files
- Multiplexing Redo Log Files
- Archive Redo Log Files
- RMAN Backup Types
- On-Demand Backups on DBCS
- Using Recovery Manager (RMAN)
- Backup Terminology
- Automatic Backups on Database Cloud Service (DBCS)
- Database Recovery Advisor
- Recovering Data Files in ARCHIVELOG Mode
- Recovering Data Files in NOARCHELOG Mode
- Recovery Options in Database Cloud Service (DBCS)
- Managing Memory Components
- Automatic Workload Repository (AWR)
- Advisory Framework
- Monitoring Wait Events, Sessions, and Services
- Managing Metric Thresholds and Alerts
- Performance Tuning Methodology
- Performance Planning Considerations
- Automatic Database Diagnostic Monitor (ADDM)
- Oracle Optimizer
- SQL Tuning Advisor
- SQL Performance Analyzer
- Optimizer Statistics
- SQL Access Advisor
- SQL Tuning Process
Who is the instructor for this training?
The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.
18c: Administration Workshop Certification Training - Certification & Exam
- SpringPeople is the Authorized Training Partner of Oracle.
- The training fees is exclusive of exam cost.
- For any queries; feel free to reach us at oracle@springpeople.com
Reviews
Previous
Next
My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!
Shweta Priya
Sony
I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.
Swati Singh
GE
I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.
Nikhil Kohli
Stryker
I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!
Heena Rajan
Mindtree
