Oracle Database 18c: New Features for Administrators Ed 1
Duration : 3 Days (24 Hours)
Oracle Database 18c: New Features for Administrators Ed 1 Course Overview:
The Oracle Database 18c New Features for Administrators Ed 1 course offers database administrators comprehensive training on managing and monitoring Oracle Database 18c. The course covers database architecture, performance tuning, backup and recovery, security, and other key features of Oracle 18c. Through practical exercises, discussions, and case studies, participants gain hands-on experience and learn to effectively plan and manage Oracle 18c databases in various environments, whether on-premises, in the cloud, or in a hybrid setup. By the end of the course, database administrators will be equipped to utilize the innovative features of Oracle Database 18c to enhance their organization’s application deployment and management capabilities.
Intended Audience:
- Experienced database administrators with familiarity in Oracle 18c database who want to enhance their technical knowledge and professional value.
- System administrators, database administrators, IT managers, development managers, and senior developers with at least one year of hands-on experience in the Oracle Database environment.
- Experienced DBAs responsible for designing, deploying, and maintaining the Oracle Database 18c.
- Professionals who will be administering Oracle Database 18c in production environments.
- Individuals seeking a better understanding of essential Oracle Database 18c functionality.
Learning Objectives of Oracle Database 18c: New Features for Administrators Ed 1:
1. Understand the architecture and components of Oracle Database 18c.
2. Identify Oracle Database 18c installation and migration requirements.
3. Configure Oracle Database 18c with Oracle Database Configuration Assistant (DBCA) and Database Upgrade Asssitant (DBUA).
4. Learn to use the new features such as Distributed Transactions, Sharding, Recycle Bin, Flashback Data Archive, In-Memory Column Store and Heat Map.
5. Monitor and manage the database with Oracle Performance Management, Database Performance Analyzer and Resource Manager.
6. Manage security with the Cloud Control feature.
7. Use the new Backup and Recovery features such as Automated RMAN.
8. Integrate Oracle Database 18c with Oracle Cloud Infrastructure.
9. Troubleshoot any Oracle Database 18c related issues.
10. Tune Oracle Database 18c using the Automated Database Diagnostic Monitor (ADDM).
Module 1: Leveraging Multitenant Enhancements
- Manage application PDBs fleet
- Manage PDB snapshots carousel
- Benefit from dynamic container map
- Understand lockdown profile inheritance and create and use static and dynamic lockdown profiles
- Use refreshable copy PDB switchover
Module 2: Managing Security
- Create and use a schema only account
- Isolate PDB keystores
- Export and import database links
- Configure encryption of sensitive data in Database Replay files
- Explain direct Active Directory Services integration
Module 3: Using RMAN Enhancements
- Reuse preplugin backups before and after a non-CDB conversion as a PDB or a PDB migration to another CDB
- Clone active PDB into another CDB using DUPLICATE and duplicate an on-premises CDB to Cloud as encrypted
Module 4: Applying General Database Enhancements
- Manage private temporary tables
- Use the new Data Pump Import option of the DATA_OPTIONS parameter
- Online modification of partitioning and subpartitioning strategy
- Merging of partitions and subpartitions online
- Generate batched DDL by using DBMS_METADATA_DIFF package
Module 5: Improving Performance
- Configure Automatic In-Memory
- Use IMEs window capture
- Describe the new SQL Tuning Set package
- Describe the concurrency of SQL execution of SQL Performance Analyzer tasks and Result Set Validation
Module 6: Handling Enhancements in Big Data and Data Warehousing
- Query inlined external tables and manage in-memory external tables
- Use analytic view new query capabilities
- Create and use polymorphic table functions
Module 7: Describing Sharding Enhancements
- Describe the user-defined sharding method
- Understand support for PDBs as shards
- Describe Oracle GoldenGate enhancements for Oracle Sharding support
- Query system objects across shards
- Describe improved multi-shard query enhancements
Oracle Database 18c: New Features for Administrators Ed 1 Course Prerequisites:
This training is designed for database administrators and other IT professionals with at least 5 years of experience who are interested in learning new features and enhancements of the Oracle Database 18c. Familiarity with the concepts and components of the Oracle Database is expected. Students should be familiar with database management tasks such as architecting, installing, upgrading, configuring, patching, tuning, and monitoring a database. Programming skills with Structured Query Language (SQL) or other procedural and object-oriented languages are beneficial.
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!