The Oracle Database 12c R2: New Features for 12c R1 Administrators course is designed for existing 12c Release 1 DBAs. In addition to covering the New Features of R2, this course also introduces students to the Oracle Database Cloud Service.
- Create and manage application containers and applications in multitenant container databases.
- Manage resources in a multitenant container database and pluggable databases with Resource Manager performance profiles and new memory directives.
- Perform pluggable database flashback.
- Upgrade the multitenant container databases and pluggable databases.
- Manage security by using enhancements in unified auditing, system privileges, Privilege Analysis, Data Redaction, Transparent Sensitive Data Protection and Transparent Data Encryption.
- Manage data availability by using Recovery Manager, Oracle Data Pump features and SQL*Loader enhancements, and by performing enhanced online operations.
- Increase the SQL performance by using the In-Memory Column-Store enhancements at deployment and SQL performance.
- Tune the SQL performance by using the Optimizer Statistics Advisor and SQL join processing.
- Monitor your databases by using DB operations enhancements.
- Benefit from enhancements in partitioning methods.
- Benefit from ADR automatic space file management.
- Use the Trace File Analyzer collector to diagnose issues.
- Use the new SQL*Plus history commands and SQL enhancements such as long identifiers.
- Use the new SQLcl utility to benefit from commands and features missing from SQL*Plus itself.
- Describe the Oracle Public Cloud services related to databases management.
Benefits to you
In the lessons, you learn the new and enhanced features of Oracle Database 12c Release 2 (220.127.116.11) amongst different areas such as Multitenant, security, availability, performance, diagnosability, manageability, partitioning and SQL.
You also learn how to easily deploy databases with Oracle Database Cloud Services, check automated backups and monitor your Cloud deployment with new Cloud tools.
Hands-on Practices and Demonstrations
Hands-on practices and available demonstrations help you learn how to use these new or enhanced features of Oracle Database 12c. You'll explore using Oracle Enterprise Manager Cloud Control and other tools like Oracle Enterprise Manager Database Express SQL Developer to manage, monitor and administer your data center. You will also learn about performance new features of the first patchset of Oracle Database 12c: Full Database In-Memory Caching, the In-Memory Column Store which is one of the most important features of the 12.1 first patchset, and Automatic Big Table Caching.
Knowledge of Oracle Database 12c and particularly 18.104.22.168.
För att alltid hålla en hög kvalitet på våra teknikkurser använder vi både engelsk- och svensktalande experter som kursledare.
- Application Containers and Applications
- Security in PDBs
- PDBs Creation Using New Methods
- PDBs Recovery and Flashback
- Performance in PDBs
- Upgrade and Other Operations in PDBs
- Privileges and User Profiles
- Unified Auditing
- Data Redaction
- Data Encryption
- Transparent Sensitive Data Protection
- Availability Enhancements
- Oracle Data Pump, SQL*Loader and External Tables
- In-Memory Column Store
- SQL Tuning
- Resource Manager and Other Performance Enhancements
- Oracle Database Cloud Services
- SQL Enhancements