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
Testimonials (8)
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
Course - ORACLE PL/SQL Fundamentals
Luka is an excellent, patient teacher with a sense of humor. His relaxed style made the stressful experience of "be called to the blackboard" more pleasant. Also one student explaining or guiding the other was a very good idea. I will use the motto "KISS methodology" he shared with us in both my SQL exercises , private and professional life since I like to overcomplicate things. Luka also kept the good pace considering how much material was there for him to show and for us to learn.
IWONA KLIMASZEWSKA - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
I liked the way the trainer explained the information about the topics and the fact that he paid attention to the details so that the lessons were very practical and logical.
Andreea
Course - Oracle SQL for beginners
Exercises are entertaining and the topics were nicely introduced.
Adrian-Madalin Chirita - DB Global Technology SRL
Course - Oracle SQL Advanced
I like fact, that after each section we had exercises. It helps to remember discussed topic.
Adam Bińczycki
Course - Oracle 11g - SQL language for developers - Workshop
Trainer expertise on SQL tuning