Dozent gesucht für Auftrag - Oracle - Database

Kurs auf Englisch
Introduction:
Unlock the full potential of Oracle database with our comprehensive course and become a skilled DBA in
no time, Information presented in this course provides the Oracle DBAs the knowledge and experience to
perform Oracle databases performance tuning activities and Backup/Recovery concepts and strategies.
What you'll learn:
 Implement backup and recovery plans
 Oracle database performance tuning
Prerequisites:
- Basic knowledge of Oracle Database architecture and components.
- Familiarity with Oracle Database management and maintenance tasks.
- Understanding of SQL and experience with writing and tuning SQL queries.
Course content
Course 1 : Oracle Database: Backup and Recovery
1.1 : Backup and Recovery: Overview
1.2 : Backup and Recovery Configuration
1.3 : Using Recovery Manager (RMAN)
1.4 : Backup Strategies
1.5 : Creating Database Backups
1.6 : Using Optional Backup Features
1.7 : Tuning RMAN Backup Performance
1.8 : Recovery Catalog: Overview
1.9 : Creating a Recovery Catalog
1.10 : Managing Target Database Records
1.11 : Using Stored Scripts
1.12 : Creating and Using Virtual Private Catalogs
1.13 : Restore and Recovery Concepts
1.14 : Diagnosing Failure
1.15 : Performing Complete Recovery
1.16 : Performing Point-in-Time Recovery
1.17 : Performing Block Media Recovery
1.18 : Performing Additional Recovery Operations
1.19 : Oracle Flashback Technology: Overview
1.20 : Using Logical Flashback Features
1.21 : Using Flashback Database
1.22 : Using PDB Snapshot
1.23 : Database Duplication Overview
1.24 : Creating a Backup-Based Duplicate Database
Course 2 : Oracle Database: Performance Management and Tuning
2.1 : Overview
2.2 : Defining the Scope of Performance Issues
2.3 : Using the Time Model to Diagnose Performance Issues
2.4 : Using Statistics and Wait Events to Diagnose Performance Issues
2.5 : Using Log and Trace Files to Monitor Performance
2.6 : Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance
2.7 : Using Statspack to View Performance Data
2.8 : Using Automatic Workload Repository
2.9 : Using Metrics and Alerts
2.10 : Using Baselines
2.11 : Managing Automated Maintenance Tasks
2.12 : Using ADDM to Analyze Performance
2.13 : Using Active Session History Data for First Fault System Analysis
2.14 : Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues
2.15 : Overview of SQL Statement Processing
2.16 : Maintaining Indexes
2.17 : Maintaining Tables
2.18 : Introduction to Query Optimizer
2.19 : Understanding Execution Plans
2.20 : Viewing Execution Plans by Using SQL Trace and TKPROF
2.21 : Managing Optimizer Statistics
2.22 : Using Automatic SQL Tuning
2.23 : Using the SQL Plan Management Feature
2.24 : Overview of the SQL Advisors
2.25 : Using the SQL Tuning Advisor
2.26 : Using the SQL Access Advisor
2.28 : Using SQL Performance Analyzer to Determine the Impact of Changes
2.29 : Using Database Replay to Test System Performance
2.30 : Implementing Real-Time Database Operation Monitoring
2.31 : Using Services to Monitor Applications
2.32 : Overview of Memory Structures
2.33 : Managing Shared Pool Performance
2.34 : Managing Buffer Cache Performance
2.35 : Managing PGA and Temporary Space Performance
2.36 : Configuring the Large Pool
2.37 : Using Automatic Shared Memory Management
2.38 : Introduction to In-Memory Column Store