fr
en
Oracle Database 19c–21c: database administration
Your applications depend on well-administered databases. With Oracle, connect configuration, operation and maintenance to work more methodically. Strengthen your independence and your ability to monitor the environment against service requirements.
- Duration
- 5 days 35 hours
- Code
- ORA1921-AD Code
Presentation
Oracle Database is a relational database management system (RDBMS) developed by Oracle Corporation. A benchmark solution for organisations, it provides high performance, flexibility and enhanced security, both on-premises and in the cloud. The Long-Term Support (LTS) 19c version offers maximum stability, while version 21c brings more advanced features and capabilities.
This course guides you through the steps required to administer Oracle Database versions 19c and 21c. You will learn to install Oracle Database, create databases and instances, configure user access and set up security. Through theory and practical exercises, you will learn best practices for designing a modern relational database architecture.
Over 5 days, you will build the skills needed for everyday Oracle database administration, particularly backup and recovery. Whether you are an Oracle administrator or aspiring system administrator, develop your expertise and update your skills.
Objectives
By the end of this Oracle Database administration course, you will be able to:
- Explain Oracle database architecture in versions 19c and 21c.
- Download and correctly install Oracle Database.
- Create and configure an Oracle database using the DBCA configuration assistant.
- Identify the core features needed to administer Oracle Database.
- Configure security and manage Oracle database users.
- Connect client computers to an Oracle Database server.
- Perform a complete backup with RMAN and Data Pump, and recover a database following an incident.
- Deploy and administer a multi-database architecture with Oracle Multitenant (CDB and PDB).
Program
Module 1: exploring Oracle Database and its architecture
- The Oracle Database system.
- Major new features in versions 19c and 21c.
- Overview of Oracle Database 19c and 21c features.
- The difference between a database and an instance.
- Multi-instance, multitenant and Real Application Clusters (RAC) architecture principles.
- Cache memory management with Oracle In-Memory Database.
- Oracle instance components and file types.
Module 2: installing and creating an Oracle database
- Minimum installation requirements.
- Installation with Oracle Universal Installer and silent mode.
- Pre-installation and post-installation tasks.
- Creating a database with DBCA, silent mode or scripts.
Practical exercises
- Download and install Oracle Database 19c and 21c.
- Create a custom database using Oracle scripts.
Module 3: administering an instance and storage
- Managing system privileges: SYSDBA and SYSOPER.
- Oracle server parameter files: Pfile and Spfile.
- Starting and stopping an Oracle database.
- Managing Automatic Diagnostic Repository (ADR) data.
- Logical tablespace structure, data blocks and segment types.
- Redo log and control files.
Practical exercises
- Start and stop a database following a sequential procedure.
- Change Oracle database parameters.
- Multiplex a control file and create a tablespace.
Module 4: securing an Oracle database
- Core Oracle Database security features.
- Managing user accounts: privileges, roles and objects.
- Setting up Oracle database auditing.
- Managing concurrent sessions and terminating blocked sessions.
Practical exercises
- Configure user privileges and apply a new data schema.
- Identify and terminate a blocking session.
Module 5: managing tables, indexes and Oracle tools
- How tables and indexing work.
- Creating, dropping and rebuilding B-tree indexes.
- Oracle SQL Developer, Enterprise Manager Database Express and Cloud Control.
Practical exercises
- Create large tables with B-tree indexes.
- Test Oracle Database graphical tools.
Module 6: configuring network connectivity with Oracle Net Services
- Implementing and configuring the listener.
- Configuring the client tnsnames.ora file for database connections.
Practical exercises
- Configure an Oracle client and server using Oracle Net.
Module 7: backing up and recovering a database
- Best practices for backup and partial or complete recovery.
- Manual backup with Oracle RMAN.
- Using noarchivelog and archivelog modes for backups.
- Data Pump export and import.
Practical exercises
- Perform an online backup with RMAN and recover the database.
- Perform a logical backup using Data Pump export.
Module 8: consolidating databases with Oracle Multitenant
- Oracle Multitenant features.
- Creating a container database (CDB).
- Creating a pluggable database (PDB).
- Managing CDB resources and administering multiple CDBs.
Practical exercises
- Create a container database with Oracle Multitenant.
Audience
This course is designed for database administration professionals, including:
- New Oracle administrators seeking the fundamentals of Oracle Database installation and administration.
- Experienced database administrators wishing to consolidate their skills in versions 19c and 21c.
- System administrators moving into Oracle database administration.
Prerequisites
To attend this Oracle Database administration course, you should have:
- Database knowledge: an understanding of relational database management.
- Technical skills: solid experience administering Oracle infrastructure and the ability to use SQL.
- English proficiency: a good command of English and technical IT terminology.
Teaching and assessment methods
- Initial skills assessment
- Training materials provided to participants
- Continuous assessment throughout the course
- End-of-course feedback questionnaire
- Combination of theory and practical application
- Attendance records
- Post-course follow-up evaluation
- Quiz / multiple-choice questions
- Practical exercises
Course highlights
- Practical approach: theory and hands-on exercises based on real-world cases.
- Self-assessment: quizzes to assess your Oracle knowledge and skills throughout the course.
- Individual support: discussion opportunities and guidance adapted to your level.
- Comprehensive programme: installation, backup, security and multi-database consolidation with Oracle Multitenant.
Dates and sessions
Choose the date and delivery format that suit you.
No upcoming sessions are currently available.
Oracle is a registered trademark of Oracle Corporation® (in French) and/or its affiliates.