- الموقع: Bukit Merah - Central
- مدة الدورة التدريبية: 5 Days
تفاصيل الدورة
In the Oracle Database 12c: New Features for Administrators course, you’ll learn about the new and enhanced features of Oracle Database 12c. Expert instructors will teach you how these features increase security, manageability and performance.
Explore the Following New Features:
- Online Data-file Move
- Heat Map
- Automatic Data Optimization
- Temporal history
- Temporal validity
- Row-archival
- Unified Auditing
- Administrative privileges
- Privilege Analysis
- Data Redaction
- Adaptive Execution Plans
- SQL Plan Directives
- Real-Time ADDM
- Compare Period ADDM
- Data Pump
- Partitioning
- SQL
Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
Multitenant Architecture
After a brief review of the Oracle Enterprise Manager Cloud Control 12c and Enterprise Manager Database Express, you'll learn the new concept of multitenant architecture, its benefits and usage. This includes tasks like creating, managing, monitoring, backing up and recovering multitenant container database and pluggable databases.
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.
Audience
- Administrator
- Database Administrators
- System Administrator
Related Training
- Required Prerequisites
- Good knowledge of Oracle Database 11g
Suggested Prerequisites
- Good knowledge of Oracle Database 11g
- Oracle Enterprise Manager Cloud Control 12c: Install & Upgrade
- Using Oracle Enterprise Manager Cloud Control 12c NEW
Course Objectives
- Create, manage and monitor multitenant container database and pluggable databases
- Manage datafile online operations, data lifecycle management with heat map and automatic data optimization, archive data using Row-archival or Temporal Validity and Temporal Histor
- Set up the unified audit trail
- Understand and use the new privileges, such as SYSBACKUP, SYSDG, SYSKM and manage privilege analysis
- Create and manage Data Redaction masking policies
- Use the Recovery Manager enhancements
- Manage the database performance with monitoring DB operations, Real-Time ADDM and Compare Period ADDM Compare two databases using Schema Change Plans to propagate changes from one environment to another Use Data Comparisons to compare data across environments
- Tune the SQL performance using Adaptive Execution Plans, SQL Plan Directives and statistics enhancements
- Manage resources in a multitenant container database and pluggable databases with enhanced Resource Manager
- Explore new Oracle Data Pump features and SQL*Loader Express Mode
- Use online operations during partition movement and compression, and other DDL operations
- Use partial global partitioned indexes
- Explain new SQL enhancements such as extended data type column and SQL row limiting clause
Course Topics
- Enterprise Manager and Other Tools
- Basics of Multitenant Container Database (CDB)
- Configuring and Creating CDB and PDBs
- Managing CDB and PDBs
- Managing Tablespaces, Common and Local Users, Privileges and Roles
- Managing Backup / Recovery / Flashback and Migration
- Online Datafile Move and Automatic Data Optimization
- In-Database Archiving
- Auditing Enhancements
- Privileges Enhancements
- Oracle Data Redaction
- General RMAN New Features and FDA Enhancements
- Monitoring DB Operations
- Schema and Data Changes
- SQL Tuning
- Real-Time ADDM and Compare Period Advisor
- Resource Manager and Other Performance Enhancements
- Index and Table Enhancements
- ADR and Network Enhancements
- Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements
- Partitioning Enhancements
- SQL Enhancements
نبذة عن معهد New Horizons Singapore
Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business
عرض الجميع دورات New Horizons SingaporeOracle أسئلة ذات صلة
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoon1,449 درهممدة الدورة التدريبية: Upto 30 Hours
- Oracle 11g PL/SQL Beginner Skill-Up55 درهم
882 درهممدة الدورة التدريبية: Upto 10 Hours - Oracle 12c OCP 120-061: SQL Fundamentals Study 365188 درهممدة الدورة التدريبية: Upto 16 Hours