Oracle 21c DBA (Database Administration)

A warm welcome to the Oracle 21c DBA course by Uplatz.

Oracle Autonomous Database leverages new technologies, such as machine learning, to create a completely autonomous database, building on decades of database platform optimization and automation. The Oracle Autonomous Database is self-driving, secure, and repairable. These advancements reduce complexity, human error, and manual management, resulting in increased dependability, security, and operational efficiency at a lower cost. Oracle's autonomous capabilities enable IT employees to focus on higher-value activities rather than time-consuming database administration duties, allowing them to transition IT operations into a contemporary cloud platform paradigm. Oracle has continued to develop state-of-the-art, on-premises and cloud-based solutions and technologies to address data management requirements for enterprises of all sizes, from previous database platforms such as Oracle Database 12c to today's newest and industry-leading Oracle Database 19c.

The Oracle 12c DBA course uses a step-by-step approach to provide ideas and demonstrations to students so that they may learn quickly. This course is for you if you wish to become an Oracle Database Administrator (Oracle DBA). Database Administrators (DBAs) are found in almost every business to keep the database up to date. The understanding you have of Oracle Database's general architecture is required to become a proficient DBA. Learn all you need to know about Oracle Database 12c management, development, security, and enabling high availability and data warehousing, from the ground up. Use Uplatz's video courses to upskill, increase employment stability, and differentiate yourself at work.

Course Objectives

• Understanding the Database Architecture can help you execute your DBA job more effectively.

• Install the Oracle software and database that you'll need.

• Administrate database user accounts.

• Manage Tablespaces to ensure that enough space is available for data backup and recovery.

• Diagnose the issues and, if necessary, collaborate with Oracle Support.

• Configure the Listeners so that users may interact with one another.

Oracle 21c DBA - Course Syllabus

1. Installation Of Oracle Linux 8 on Oracle VM

2. Introduction to Oracle 21c DBA

3. Oracle 21c Architecture

4. Practice 1 - Creating a CDB

5. Practice 2 - Creating PDBs from the Seed

6. Practice 3 - Performing Basic CDB Administration Tasks

7. Practice 4 - Managing Common and Local Users

8. Practice 5 - Backup and Recovery in CDB and PDBs

9. Practice 6 - Flashback and Point-in-time Recovery

Who this course is for:

• Oracle DBAs (Database Administrators)
• Database Developers
• Beginners & newbies aspiring for a career in Oracle Database Administration
• Cloud Database Architects
• Oracle Cloud Infrastructure Engineers
• Oracle DBA - Oracle 10G, 11G, 12C, 19C
• Platform Architects
• Software Developers & Administrators
• Application Developers
• Oracle Cloud Specialists
• Senior Database Administrators (PostgreSQL, Oracle)