Nos Formations Oracle Base de données
- Durée: 5 Jours
- Objectifs:
-
- Create and manage an Oracle Database Instance.
- Create and manage Storage Structures.
- Configure the Oracle Network Environment.
- Create and manage users.
- Monitor the database and manage performance.
- Learn basic information on backup and recovery techniques.
- Use the Oracle Support Workbench and My Oracle Support to update your Oracle Database software.
- Durée: 5 Jours
- Objectifs:
- Develop backup and recovery procedures to address your business needs.
- Implement backup and recovery settings and perform backup operations to disk and tape.
- Employ Oracle Database recovery procedures to recover from media and other failures.
- Diagnose and repair data failures.
- Use Flashback Technologies and data duplication to complement backup and recovery procedures.
- Secure the availability of your database by appropriate backup and recovery strategies.
- Gain an understanding of the Oracle Database Cloud Service.
- Durée: 2 Jours
- Objectifs:
-
- Reasons for upgrade
- Oracle releases and patches
- Upgrade using the new Autoupgrade tool + hands-on
- Upgrade and migrate to Container databases + hands-on
- Upgrade Pluggable Databases + hands-on
- Upgrade to Autonomous Databases + hands-on
- Diagnosing and ensuring performance
- New interesting features for DBAs
- Durée: 4 Jours
- Objectifs:
- Multitenant Architecture: Benefits
- Other Benefits of Multitenant Architecture
- Oracle Multitenant Container Database
- Configurations
- Database Objects in a Non-CDB
- User-Added Objects to a Non-CDB
- SYSTEM Objects in the USER Container
- Provisioning a Pluggable Database
- Multitenant Container Database Architecture
- Containers
- Tools
- Data Dictionary and Dynamic Views
- Durée: 5 Jours
- Objectifs:
- Understand the concept, benefits, configuration, and usage of the new features and enhancements in database overall area
- Understand the concept, benefits, configuration, and usage of the new features and enhancements in the security area
- Understand the concept, benefits, configuration, and usage of the new features and enhancements in the availability area
- Understand the concept, benefits, configuration, and usage of the new features and enhancements in the performance area
- Understand the concept, benefits, configuration, and usage of the new features and enhancements in big data and data warehousing area
- Understand the concept, benefits, configuration, and usage of the new features and enhancements in diagnosability area
- Understand the concept, benefits, configuration, and usage of the new features and enhancements in sharding area
- Durée: 5 Jours
- Objectifs:
- Describe Performance Management
- Use AWR Performance Statistics
- Use AWR Based Tools
- Improve SQL Statement Performance
- Influence the Optimizer
- Use Tuning Analyzers and Advisors
- Monitor Operations and applications
- Manage Memory
- Manage Database Memory
- Use In-Memory Column Store Feature
- Durée: 4 Jours
- Objectifs:
-
- Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups
- Create and manage physical and logical standby databases.
- Use Enterprise Manager Cloud Control and the Data Guard command-line interface (DGMGRL) to maintain a Data Guard configuration
- Use Data Guard to achieve a highly available Oracle database.
- Durée: 4 Jours
- Objectifs:
-
- Install Oracle RAC software.
- Create cluster databases.
- Administer both administrator and policy-managed Oracle RAC databases.
- Monitor and address performance issues.
- Learn about services in a RAC environment as well as highly available connection features including Application Continuity and Transaction Guard.
- Create and administer a RAC One Node Database.
- Create and manage multitennant RAC databases.
- Durée: 4 Jours
- Objectifs:
-
- Introduction to Clusterware
- Oracle Clusterware Architecture
- Cluster Configuration Options
- Grid Infrastructure: Preinstallation Tasks
- Grid Infrastructure Installation
- Managing Cluster Nodes
- Traditional Clusterware Management
- Policy-Based Cluster and Capacity Management
- Upgrading and Patching Grid Infrastructure
- Monitoring and Troubleshooting Oracle Clusterware
- Durée: 2 Jours
- Objectifs:
-
- Administer ASM Instances
- Perform Client Database Failover with Flex ASM
- Administer ASM Disk Groups
- Rename the ASM Disk Groups
- Manage ASM Disk Group Space
- Perform Miscellaneous Administration Activities
- Manage Flex Disk Groups
- Administer ASM Files, Directories, and Templates
- Manage ACFS
- Perform ACFS Automatic Resizing
- Perform ACFS Defragmentation
- Perform ACFS Compression