Oracle Database 21c: New Features for Administrators

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

STUDENTS WILL LEARN TO

After completing this course, you will be able to:

  • Analytic View Enhancements to SQL and PL/SQL
  • Analytical SQL and Statistical Functions
  • New Analytical and Statistical Aggregate Functions
  • Oracle Blockchain Table
  • Authentication and Authorization
  • Auditing Enhancements
  • Oracle Advanced Security
  • Oracle Database Vault
  • Manageability
  • Diagnosability
  • ACFS Cluster File System
  • Oracle Automatic Storage Manager (ASM)
  • Clusterware Enhancements
  • Automatic Operations
  • Oracle Database In-Memory Enhancements
  • Flashback Enhancements
  • Oracle Multitenant
  • Oracle Sharding
  • SQL and PL/SQL Enhancements
  • Oracle Database Utilities
  • Upgrades and Migration
  • Globalization

 

Phone
Phone
Product
Oracle
Code
D110148GC10
Duration
5 Days
Price (baht)
70,500

About the course

COURSE TOPICS

Module 1 : New Features for Big Data and Data Warehousing

  • Analytic View Enhancements to SQL and PL/SQL
  • Practice 1-1: Analytic View Enhancements
  • Analytical SQL and Statistical Functions
  • Practice 2-1: Bitwise Functions
  • Practice 2-2: Enhanced Analytic Functions
  • New Analytical and Statistical Aggregate Functions
  • Practice 3-1: CHECKSUM Function
  • Practice 3-2: SKEWNESS Functions
  • Practice 3-3: KURTOSIS Functions
  • Machine Learning for SQL
  • Machine Learning for Python
  • Spatial and Graph

Module 2 : New Features for Security

  • Oracle Blockchain Tables
  • Practice 1-1: Managing Blockchain Tables and Rows
  • Authentication and Authorization
  • Practice 2-1: Gradual Database Password Rollover for Applications
  • Practice 2-2: Enforcing a Minimum Password Length for All PDBs
  • Auditing
  • Practice 3-1: Auditing Actions on Connected Sessions
  • Practice 3-2: Enforcing Unified Audit Policies on the Current User
  • Practice 3-3: SYSLOG Destination for Common Unified Audit Policies
  • Advanced Security
  • Practice 4-1: Setting Up Transparent Data Encryption
  • Practice 4-2: Defining the Default Encryption Algorithm for Tablespace Creation
  • Database Vault
  • Practice 5-1: Installing Oracle Database Vault
  • Practice 5-2: Preventing Local Users from Blocking Common Operations
  • Practice 5-3: Uninstalling Oracle Database Vault
  • Practice 5-4: Cleaning Up the Environment

 Module 3 : New Features for Management Solutions

  • Manageability
  • Demo: Connecting to Training Environment
  • Practice 1-1: Configure a DBFS file system
  • Diagnosability
  • Practice 2-1: Attention Log File

Module 4 : New Features for Performance

  • Automatic Operations
  • Practice 4-1: Shrinking Secure Files LOBs
  • Oracle Database In-Memory
  • Practice 5-1: Configuring and Observing Automatic In-Memory
  • Practice 5-2: Using In-Memory Hybrid Scans in Queries

 Module 5 : New Features in Multitenancy

  • Performing PDB Application Synchronization
  • Demo: How to Connect to Training Environment
  • Practice 1-1: Synchronizing Multiple Applications in Application PDBs
  • MAX IDLE BLOCKER TIME Parameter
  • Practice 2-1: Using the MAX_IDLE_BLOCKER_TIME Parameter.
  • DBCA Time Zone Support for PDB
  • Improving PDB Tenancy Management
  • Namespace Integration with Database

 Module 6 : New Features in Sharding

  • Introduction
  • Sharding New Features
  • Oracle Sharding
  • Oracle Sharded Database Architecture
  • Oracle Sharded Database Architecture Contd..
  • What’s New in Oracle Sharding 21C
  • What’s New in Oracle Sharding 21C Contd.

Module 7 : New Features for Application Development

  • Enhancements for SQL Set Operators
  • Expression in Initialization Parameters
  • SQL Macros
  • Practice 1-1: Using Expressions in Initialization Parameters
  • Practice 1-2: Exploring SQL Set Operator Enhancement
  • Practice 1-3: Using SQL Macro Scalar and Table Expressions
  • PL/SQL Enhancements
  • PL/SQL Extended Iterators
  • PL/SOL Qualfied Expressions
  • Practice 2-1: Using Pragma SUPPRESSES_ WARNING_6009
  • Practice 2-2: Exploring Enhancements to PL/SQL Iterator Constructs
  • Practice 2-3: Using Collection Iteration Controls
  • JSON Document Store
  • Practice 3-1: JSON Document Store

 Module 8 : New Features in Flashback

  • Flashback Database
  • Practice 1-1: Flashing Back PDBs to Any Time in the Recent Past
  • Practice 1-1: Flashing Back PDBs to Any Time in the Recent Past Continued

Module 9 : New Features for Upgrade and Utilities

  • Database Utilities
  • Practice 1-1: Including and Excluding Objects from Oracle Data Pump Export and Import
  • Practice 1-2: Index Compression on Oracle Data Pump Import
  • Practice 1-3: Validity Check for Oracle Data Pump Files
  • Practice 1-4: Parallelizing Transportable Tablespace Metadata Operations
  • Upgrade and Migrations

Module 10 : New Features for Globalization

  • Globalization

 

Register for Training

Schedule

Start DateEnd DateDuration (days)PriceRegisterCourseCodeProduct

เราใช้คุกกี้เพื่อพัฒนาประสิทธิภาพ และประสบการณ์ที่ดีในการใช้เว็บไซต์ของคุณ คุณสามารถศึกษารายละเอียดได้ที่ นโยบายความเป็นส่วนตัว และสามารถจัดการความเป็นส่วนตัวเองได้ของคุณได้เองโดยคลิกที่ ตั้งค่า

Privacy Preferences

คุณสามารถเลือกการตั้งค่าคุกกี้โดยเปิด/ปิด คุกกี้ในแต่ละประเภทได้ตามความต้องการ ยกเว้น คุกกี้ที่จำเป็น

Allow All
Manage Consent Preferences
  • Always Active

Save