- Cursusduur23 uur
- CertificeringOracle
- Examen/CertificaatExamen 1Z0-050
- TaalEngels
- Online toegang3 maanden
- Waardering
- OrganisatieOracle
In deze Oracle training / cursus leert u de nieuwe features kennen van de Oracle database 11g. Deze training brengt u volledig op de hoogte van de belangrijkste nieuwe features van de Oracle database 11g. Ook leert u hoe u naar deze versie kunt upgraden. Tevens wordt u voorbereid op het Oracle 11g upgrade examen 1Z0-050.
De verbeteringen in deze 11g versie hebben onder andere betrekking op de installatie en upgrademogelijkheden, de opslag, de beveiliging, automatische SQL tuning, performance verbeteringen en verbeteringen aan RMAN.
Uw resultaat
U kent de nieuwe features van Oracle database 11g en bent in staat deze succesvol toe te passen.
Doelgroep
DBA's, administrators, database designers, support engineers die hun kennis van de Oracle database willen upgraden naar versie 11g en/of het Oracle examen 1Z0-050 willen halen. Dit examen is bedoeld voor diegene die hun OCP certificering op 10g willen upgraden naar een OCP certificering op 11g.
Inhoud Oracle 11g training / cursus
De Oracle 11g New Features training / cursus is opgebouwd uit verschillende lessen:
- Recognize the benefits of Oracle's Infrastructure grid and self-tuning capabilities
- Identify the changes to the Oracle database installation process and recognize the steps for installing Oracle Database 11g
- Recognize Oracle Database 11g's upgrade enhancements and identify the steps for performing an upgrade
- Recognize the steps for running the Oracle Database Upgrade Assistant as part of an upgrade
- Recognize the common post-upgrade steps and adjustments to initialization parameters, and identify the steps for creating a database
- Identify the steps for enabling Direct Network File System and installing a hot patch
- Identify the best practices and recommendations for testing and analyzing an Oracle Database 11g installation
- Create a new Oracle Database 11g database
- Recognize the ways to enhance efficiency and performance of Oracle Database 11g by using Automatic Storage Management (ASM) Fast Mirror Resync and ASM Preferred Mirror Read
- Identify ways to use ASM to enhance scalability and performance and control disk group attributes and compatibility
- Identify the steps for adding an offlined disk without ASM and also with ASM, following a nondata issue
- Recognize the syntax for performing disk group checks, mounting disk groups for fast rebalance, and forcing a disk group drop
- Identify the correct method for backing up ASM metadata using ASMCMD extensions
- Back up ASM metadata using ASMCMD extensions
- Recognize the steps for managing change when upgrading or reconfiguring Oracle Database, including the setting up a snapshot standby database as a test environment
- Recognize the general uses and benefits of SQL Performance Analyzer for ascertaining performance gains following a database change
- Identify the steps for capturing the SQL workload using SQL tuning sets
- Identify the different tasks that can be performed when managing components using the SQL Performance Analyzer
- Recognize the ways in which the different phases of the SQL Performance Analyzer help to assess the SQL performance impact of change
- Identify the elements of SQL plan management and recognize the steps for seeding SQL plan baselines
- Recognize ways to load and evolve SQL plan baselines, select SQL plans, and set up various SQL plan management scenarios
- Recognize the steps for executing all phases of SQL plan management
- Seed SQL Plan Baselines for your most regressing statements
- Recognize the benefits of using Database Replay and the concepts and reasons behind recreating a production database workload in a test environment.
- Identify the scope of Database Replay's capabilities by recognizing the supported database changes and workloads, as well as some of the considerations and available options during capture, replay and replay analysis.
- Identify the steps for running Database Replay using the Capture Wizard in Enterprise Manager.
- Recognize the steps for replaying workload using the Replay Workload Wizard and also using PL/SQL to do the same, as well as calibrating replay clients.
- Identify the steps for capturing the workload for a small application using Database Replay and replaying it to get the same results as during the original execution.
- Run Database Replay in Enterprise Manager.
- Recognize how SQL tuning can benefit developers in improving the performance of SQL statements, and identify the methods and DBA controls that you can use in Oracle Database 11g to run the Automatic SQL Tuning feature.
- Identify the general steps and concepts behind configuring Automatic SQL Tuning, reviewing results, and performing a fine tune using PL/SQL.
- Recognize the steps for executing Automatic SQL Tuning and viewing its results.
- Recognize the scope of Oracle Database 11g's AWR Baselines feature, which includes baseline template creation options and baseline views
- Recognize the steps for creating an AWR Baseline and using it to define alert thresholds
- Recognize the benefits of the Automatic Maintenance Tasks feature for statistics collection, segment advisor, and Automatic SQL Tuning, and identify how to control such tasks
- Recognize the steps for calibrating I/O resources in Oracle Database 11g
- Recognize how to manage resources and streamline schedules using the Resource Manager and lightweight jobs
- Identify the steps for creating and running lightweight scheduler jobs
- Calibrate I/O Resources in Oracle Database 11g
- Recognize the different ways to use Automatic Database Diagnostic Monitor to analyze Oracle Real Application Clusters (RACs) and report on issues affecting the entire database as well as individual instances
- Identify the benefits of Oracle Database 11g's Automatic Memory Management system
- Identify the concepts and methods employed in Oracle database 11g for gathering and publishing various kinds of statistics
- Identify the steps for observing memory distribution patterns using Automatic Memory Management and also for testing various statistic gatherings on a particular table
- Use Automatic Memory Management to observe memory distribution patterns
- Identify the steps for employing Oracle Database's new partitioning scheme to perform interval partitioning
- Recognize the steps for performing system and virtual column-based partitioning, using Oracle Database 11g's new partitioning scheme
- Identify the steps for performing reference partitioning, using Oracle Database 11g's new partitioning scheme
- Recognize the steps for performing extended composite partitioning, using Oracle Database 11g's new partitioning scheme, and for compressing tables
- Recognize the steps for using SQL Access Advisor to help you to decide which partitions, indexes, materialized views, and materialized view logs you need to optimize your database's workload
- Use the SQL Access Advisor to get partitioning recommendations
- Recognize the ways in which enhancements to RMAN in Oracle Database 11g can help you perform faster and optimized backups
- Identify the steps for duplicating an active Oracle Database 11g database
- Identify the steps for creating and managing archival backups and RMAN catalogs in Oracle Database 11g
- Duplicate an active Oracle Database 11g database
- Recognize the benefits of Flashback Data Archives in Oracle Database 11g for retaining historical data
- Identify the steps for using Flashback Data Archives
- Identify the steps for using the Flashback Transaction Backout and LogMiner features to locate and roll back transactions and user errors in Oracle Database 11g
- Recognize the scope and capabilities of the Automatic Diagnostic Repository (ADR) feature in Oracle Database 11g
- Identify the tasks that can be performed, using the Support Workbench wizard, to handle critical errors in Oracle Database 11g
- Identify the steps for configuring incident packages and for creating, manipulating, and modifying custom packages
- Identify the steps for dealing with critical errors in Oracle Database 11g, using the Health Monitor and SQL Repair Advisor tools
- Recognize your options for assessing data failures in Oracle Database 11g, using the Data Recovery Advisor
- Identify the steps for getting advice on repairing data failures, executing these repairs using RMAN data repair commands, and setting parameters to detect further corruption
- Repair a down database via Enterprise Manager
- Recognize ways to configure a password file to use case-sensitive passwords and also how to configure security settings in Oracle Database 11g
- Recognize the different types of encryption in Oracle Database 11g, and identify the steps for managing fine-grained access to external network services
- Recognize ways for setting up administrator authentication and managing transparent data encryption and other security settings
- Identify the steps for increasing the security of passwords and implementing tablespace encryption in Oracle Database 11g
- Identify the best approach to take to encrypt a tablespace in Oracle Database 11g
- Identify the ways in which SecureFiles enhance the performance of large object (LOB) data types
- Recognize the steps for migrating to SecureFiles and for creating, altering, accessing, and monitoring them
- Identify the steps for using SecureFiles for compression, data encryption, and performance
- Identify the benefits of SQL Query Result Cache and PL/SQL Function Cache, as well as using other Oracle Database 11g enhancements to online redefinition, locking mechanisms, and invisible indexes
- Recognize the benefits of PL/SQL native compilation enhancements, Adaptive Cursor sharing, and temporary tablespace shrink
- Identify the steps using the SQL Query Result Cache in Oracle Database 11g
- Identify ways of employing the SQL Query Result Cache in a given scenario
Optionele examentraining (proefexamens)
In aanvulling op deze training kunt u een speciale examentraining aanschaffen. De examentraining bevat verschillende proefexamens die het echte examen dicht benaderen. Zowel qua vorm als qua inhoud. Dit is de ultieme manier om te testen of u klaar bent voor het examen. U kunt deze examentraining optioneel meebestellen door bovenin de optie "Examentraining" op "Ja" te zetten. Lees hier meer over deze examentraining:
Benodigde voorkennis
U heeft praktijkervaring als DBA / administrator met een eerdere versie van de Oracle database. Bij voorkeur met versie 10g. Wilt u examen 1Z0-050 doen? Dan moet u in het bezit zijn van een OCP certificering op Oracle database 10g.
Naslagwerk
Heeft u behoefte aan een naslagwerk? Bestel Oracle Database 11g New Features bij onze partner Computerboek.nl.
Vragen stellen aan een mentor
In deze training is het mogelijk om, via de mail, vragen te stellen aan een gecertificeerde trainer. U stelt de vragen in het Engels.
Trainingsvorm online training / e-learning
Bij icttrainingen.nl leert u via ons innovatie leerconcept: Social Learning. Hoogwaardige online e-learning trainingen gecombineerd met een online kenniscommunity voor een optimale leerervaring. U kunt na uw bestelling direct online starten. Alle trainingen zijn 24 uur per dag en 7 dagen per week toegankelijk.
> Meer informatie
E-learning
E-learning is een interactieve digitale trainingsvorm. Deze trainingsvorm stelt u in staat om in uw eigen tempo en wanneer het u uitkomt de training te volgen. Het enige dat u nodig heeft is een PC met internettoegang.
Onze E-learning trainingen zijn volledig zelfstandig. U heeft dus geen aanvullende zaken als boeken en dergelijke nodig. Alles wat nodig is voor het succesvol afronden van de training en het eventueel bijbehorende examen is opgenomen in de E-learning training.
Meer informatie over E-learning.
Online kennis community
Tijdens en na uw training heeft u onbeperkt toegang tot de online kennis community. Binnen deze community staat het delen van kennis centraal. U vindt er achtergrondinformatie, artikelen door experts, informatieve filmpjes en discussies voor en door ICT experts. We nodigen u van harte uit deel te nemen aan deze expert community. Meer informatie over de kennis community.
Certificaat van icttrainingen.nl
Na het succesvol afronden van uw training ontvangt u altijd een certificaat van icttrainingen.nl als bewijs dat u de training met succes heeft gevolgd. Dit certificaat kunt u eenmalig, na afronding van de training, zelf genereren en downloaden.
