Oracle Database 21c: New Features for Administrators

Course code

D110148GC10

Duration

5 Days, 40 Acad. Hours

Download pdf

Course Overview

Objectives

Prerequisites

Course Outline

Course Overview

This course covers the new and enhanced features of Oracle Database 21c for areas, such as: Big Data and Data Warehousing Security Management Performance and High Availability Flashback Oracle Multitenant Oracle Sharding Application Development Database Upgrade and Utilities Globalization

Objectives

Understand and utilize the enhanced Analytic View capabilities in SQL and PL/SQL for improved data analysis.
Implement and manage new security features, including Blockchain Tables, authentication enhancements, and advanced auditing techniques.
Explore and apply new Manageability tools for efficient database operations, including DBFS configuration and diagnosability improvements.
Optimize database performance using Automatic Operations, In-Memory advancements, and automatic In-Memory management.
Enhance multitenancy with PDB application synchronization, MAX_IDLE_BLOCKER_TIME parameter, and improved tenancy management.
Learn about Oracle Sharding enhancements to support distributed databases and understand the updated architecture for Oracle Sharded Database.
Leverage application development features like SQL Set Operators, SQL Macros, and PL/SQL enhancements for more streamlined and powerful coding practices.
Employ Flashback Database capabilities to recover PDBs to any point in the past with precision and ease.
Master the new utilities for database upgrades, including advanced Data Pump options for exporting/importing and the ability to check the validity of Data Pump files.
Address globalization requirements in Oracle Database 21c by implementing and managing new globalization features.

Target Audience

Database Administrators (DBAs)
Oracle Database Engineers
IT Professionals with previous Oracle DB experience
Data Warehouse Administrators
Data Analysts with a focus on Oracle technologies
Database Architects
Security Administrators
System Administrators managing Oracle environments
Database Developers
Application Developers using Oracle databases
IT Managers overseeing database or data warehousing teams
Technical Consultants specializing in Oracle technologies
Performance Engineers
Cloud Database Administrators
Multitenant Database Administrators
IT Professionals involved in database migration and upgrades
Professionals working with big data solutions on Oracle databases
Data Scientists interested in Oracle’s machine learning capabilities

Prerequisites

To ensure that our learners can successfully undertake training in the Oracle Database 21c: New Features for Administrators course, the following minimum prerequisites are recommended:

Basic knowledge of database concepts, including relational databases and SQL (Structured Query Language).
Familiarity with the fundamentals of Oracle Database administration, such as managing an Oracle Database instance, creating and managing users, and understanding Oracle Database architecture.
Prior experience with Oracle Database 12c or later would be beneficial, as it will aid in understanding the advancements and changes in Oracle Database 21c.
Understanding of PL/SQL programming concepts to comprehend the enhancements in SQL and PL/SQL mentioned in the course.
Awareness of data security principles, including authentication, authorization, and auditing, which are essential for the security module of the course.
An understanding of database performance concepts and tools, as performance tuning and management are discussed in the course.
Basic knowledge of Python programming can be helpful for the Machine Learning for Python lesson.
Comfort with command-line interfaces and scripting, as some practices may require executing commands or scripts in a terminal or command prompt environment.

Course Outline

1 New Features for Big Data and Data Warehousing

2 New Features for Security

3 New Features for Management Solutions

4 New Features for Performance

5 New Features for Multitenancy

6 New Features in Sharding

7 New Features for Application Development

8 New Features in Flashback

9 New Features for Upgrade and Utilities

10 New Features in Globalization

Back to trainings (Oracle)

Request the training

Oracle Database 21c: New Features for Administrators

Course code:

D110148GC10

Duration:

5 Days, 40 Acad. Hours

Apply

Download pdf