Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
- Introduction to Oracle Cloud
- Overview of Oracle Database 21c
Oracle Database Architecture
- Overview of the Oracle Database architecture
- Configuring and connecting to the Oracle Database Instance
- Understanding the Oracle Database memory structures
- Process architecture and structures
- Process startup sequence
- Storage architecture
Database Instance
- Overview of the Oracle Database management tools
- Enterprise manager management framework
Setting Up the Oracle Network Environment
- Overview of the Oracle Net Services and Oracle Net Listener
- Oracle Network Connections
- Configuring the Oracle Network tools
- Listener Control Utility
- Oracle Net configuration assistant
- Oracle Net Manager
- Enterprise Manager Cloud Control
Database Storage Structures
- Overview of Database Block Content
- Storage structure
- Creating and managing Tablespaces
- Navigating and viewing Tablespace information
- Using Oracle managed files
User Security
- Managing database user accounts
- Predefined administrative accounts
- Creating a user account
- Authentication and password reset
- Understanding the concept of privileges, roles, and profiles
Data Concurrency
- Understanding the locking mechanism
- Understanding data concurrency
- DML locks
- Enqueue mechanism
- Lock conflicts
Undo Data
- Overview of Undo data
- Managing transactions and storing Undo information
- Undo data vs. Redo data
- Configuring and guaranteeing Undo retention
- Changing the size of an Undo Tablespace
Oracle Database Auditing
- Overview of database auditing
- Database security and compliance monitoring
- Standard database auditing
- Audit administration
- Configuring audit train
- Audit options
Database Maintenance
- Overview of database maintenance
- Alert history
- Automatic Database Diagnostic Monitoring (ADDM)
- Understanding the advisory framework
- Enterprise manager and advisor
Managing Performance and Resources
- Monitoring performance
- Tuning activities and performance planning
- Instance tuning
- Performance tuning methodology and data
- Managing memory
- Overview of Database Resource Manager
- Using the Database Resource Manager
- Maintenance Resource Manager plan
- Resource Manager workflow
- Resource allocation methods
Space Management
- Block space management
- Chaining and migration
- Understanding the types of segments
- Allocating extents and space
- Creating tables without segments
Backup and Recovery
- Overview of Instance Recovery
- Understanding and configuring Instance Recovery
- Instance Recovery Phases
- Using MTTR Advisor
- Understanding Media Failure
Summary and Next Steps
Requirements
- Basic Linux and SQL knowledge
Audience
- Database administrators and developers
- Cloud database architects
- Application developers
28 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from £7600 online delivery, based on a group of 2 delegates, £2400 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (5)
I liked very much the format of the training, hands on, directly in sql developer.
Andreea - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
The exercises were explained very good.
Monica - DB Global Technology
Course - PL/SQL in Oracle 19c
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
It was quite hands-on, not too much theory.
