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 Ак. Часов
