Получить консультацию
Training Center MUKКурсыOracleDatabaseOracle Database 21c: New Features for Administrators

Oracle Database 21c: New Features for Administrators

Код курса
D110148GC10
Продолжительность
5 Дней, 40 Ак. Часов
Описание курса
Цели
Требования
Программа курса
Описание курса

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
Требования

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.
Программа курса

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

Регистрация на ближайший курс
Oracle Database 21c: New Features for Administrators
Код курса:
D110148GC10
Продолжительность:
5 Дней, 40 Ак. Часов
Зарегистрироваться
Получить консультацию
Свяжитесь со мной
Получить консультацию
Отправить заявку
Регистрация на вебинар
Отправить заявку
Ваша заявка получена!
Мы свяжемся с вами в ближайшее время.