Faites confiance à votre formation en TI |

Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

Oracle Database 11g: New Features for Administrators DBA Release 2

Catégorie: Formation

Bases de données et grilles

Format: Formation en classe avec formateur

Autres formats:

This five-day classroom course gives you the opportunity to learn about and practice with the new change management features and other key enhancements in Oracle Database 11g Release 1 and Release 2. Topics covered include the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas of particular interest to database administrators. In addition, hands-on practice sessions help reinforce understanding of the new capabilities.

Learn To:

Implement manageability features to simplify database management
Use change management features to master database changes
Use database advisors to provide proactive database monitoring
Increase data availability by using ASM, RMAN, and Flashback feature enhancements

Compétences acquises

Install Oracle Grid Infrastructure
Install Oracle Database 11g Release 2
Use Oracle Restart to manage components
Use Automatic Storage Management (ASM) enhancements
Implement table compression and hybrid columnar compression
Implement data warehousing and partitioning enhancements
Use the SQL Performance Analyzer
Use SQL Plan Management and load SQL plan baselines

Use Database Replay to record and replay workloads
Set and manage Automatic SQL Tuning
Use Resource Manager enhancements
Use Enterprise Manager to monitor SQL commands
Use the new and enhanced RMAN features
Use Total Recall to create, protect, and use history data
Use Data Pump in legacy mode
Use Data Recovery Advisor

Qui peut en profiter

Data Warehouse Administrator
Database Administrators
Sales Consultants

Support Engineer
Technical Consultant

Préalables

Working knowledge of Oracle Database 10g

Ce cours est donnÃ© par des formateurs certifiÃ©s Oracle.

Oracle University a nommÃ© ExitCertified Partenaire de lâ€™annÃ©e 2011

Il y a une diffÃ©rence....dÃ©couvrez-la.

Code:	11gR2-DB-NF
Format:	Formation en classe avec formateur

Durée:	5
Certifié par:	Oracle

Frais d’inscription (CAD): 4,125$

Oracle University Awards ExitCertified the North American Partner of the Year Award for 2011

Toronto, ON		Sep.17 - Sep.21.2012

Toronto, ON		Oct.29 - Nov.2.2012

Quebec, QC		Nov.5 - Nov.9.2012

Toronto, ON		Dec.10 - Dec.14.2012

4 Dates Offered

Oracle Database 11g: New Features for Administrators DBA Release 2 Contenu détaillé

Oracle Grid Infrastructure

Installing Oracle Grid Infrastructure for a Standalone Server
Creating an ASM Disk Group
ASM Cluster File System
ASM Dynamic Volume Manager
ASM File System Snapshot

Installation and Upgrade Enhancements

Installing Oracle Database 11g Release 2
Oracle Database Upgrade Enhancements
Online Patching
Upgrading Your Time Zone File and Timestamp with Time Zone Data

Oracle Restart

Controlling Oracle Restart
Using the srvctl Utility
Manually Adding Components to the Oracle Restart Configuration

ASM Enhancements

Seting up ASM fast mirror resync
Using ASM Scalability and Performance Enhancements
ASM Disk Group Compatibility
Using ASMCMD Extensions
ASM File Access Control
ASM Optimal Disk Placement

Storage Enhancements

Using 4 KB-Sector Disks
Using Table Compression
Hybrid Columnar Compression
SQL Access Advisor
Segment Creation on Demand

Data Warehouse and Partitioning Enhancements

Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
Degree of Parallelism Enhancements
In-Memory Parallel Query
Partitioning Enhancements
System-Managed Indexes for List Partitioning

Oracle SecureFiles

Enabling SecureFiles Storage
Creating SecureFiles
Using SecureFile Compression
Accessing SecureFiles Metadata
Migrating to SecureFiles

Security and Networking Enhancements

Secure Password Support
Automatic Secure Configuration
Managing Default Audits
Setting Database Administrator Authentication
Transparent Data Encryption
Hardware Security Module
Tablespace Master Key Re-Key
Supporting IPv6 Address Notification

SQL Performance Analyzer

SQL Performance Analyzer: Overview
Using SQL Performance Analyzer
Using Enterprise Manager to Access SQL Performance Analyzer
SQL Performance Analyzer: PL/SQL Example
SQL Performance Analyzer: Data Dictionary Views

SQL Plan Management

SQL Plan Management: Overview
Loading SQL Plan Baselines
Using the MIGRATE_STORED_OUTLINE Functions
Viewing Important Baseline SQL Plan Attributes
Loading a SQL Plan Baseline Automatically
Purging SQL Management Base Policy

Database Replay

Using Database Replay
Database Replay System Architecture
Supported Workloads
Database Replay Workflow in Enterprise Manager
Database Replay PL/SQL Procedures
Database Replay Data Dictionary Views

Automatic SQL Tuning

Automatic SQL Tuning in Oracle Database 11g
Selecting Potential SQL Statements for Tuning
Controlling the Automatic SQL Tuning Task
Configuring Automatic SQL Tuning
Using the PL/SQL Interface to Generate Reports

Intelligent Infrastructure Enhancements

Using New Automatic Workload Repository Views
Creating AWR Baselines
Defining Alert Thresholds Using Static Baseline
Controlling Automatic Maintenance Tasks
Fixed Policy CPU Resource Management
Instance Caging
Scheduler Enhancements

Diagnosability Enhancements

Seting Up Automatic Diagnostic Repository
ADRCI: The ADR Command-Line Tool
Incident Packaging Service (IPS)
Using the Enterprise Manager Support Workbench
Invoking IPS Using ADRCI
Running Health Checks Manually
Using the SQL Repair Advisor

SQL Monitoring

SQL Monitoring in Oracle Database 11g Release 2
Viewing Session Details
Viewing the SQL Monitoring Report

Performance Enhancements

Using the DBMS_ADDM Package
New and Modified Views
Enabling Automatic Memory Management
Using New Statistic Preferences Features
Locking Enhancements
Adaptive Cursor Sharing
Using Table Annotation to Control Result Caching

Application Maintenance and Upgrade Enhancements

Online Redefinition Enhancements
Creating and Using Invisible Indexes

Backup and Recovery Enhancements

Using New SET NEWNAME Clauses
Optimized Backups
Using New Settings for Binary Compression
Enhancements to Database Duplication
Creating Archival Backups
TSPITR Enhancements and Modifications
Creating and Using Virtual Private Catalogs
Introduction to Oracle Secure Backup Cloud Module

Flashback Technology, LogMiner, and Data Pump

Oracle Total Recall
Flashback Transaction Backout
Enterprise Manager LogMiner Interface
Data Pump Legacy Mode

Data Recovery Advisor

Assessing Data Failures
Data Recovery Advisor RMAN Command-Line Interface
Data Recovery Advisor Views
Setting Parameters to Detect Corruption

Your Name:

Your Email:

Sign up for newsletter:

Send Email To:

Course Link:

http://exitcertified.ca/oracle-training/11gR2-DB-NF.html

Message:


	Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source. Il y a une différence. Apprenez directement de la source.



Canada	United States
Formation à Montréal :: 514.876.1666 Formation à Ville de Québec :: 514.876.1666 Formation à Ottawa :: 613.232.3948 Formation à Toronto :: 416.487.3948 Formation à Vancouver :: 604.633.3948 Formation à Victoria :: 1.866.328.3948 Formation à Calgary :: 403.291.2855 Formation à Edmonton :: 780.441.3948 Formation à Regina :: 1.866.328.3948	Formation à Sacramento :: 916.669.3970 Formation à San Francisco :: 415.975.3948 Formation à San Jose :: 408.288.3948 Formation à Las Vegas :: 1.800.803.3948 Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948	Des questions? Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.

ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :

Formation Sun	Formation Oracle	Formation Symantec	Formation IBM	Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris	Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle	Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec	DB2, OS/400, Formation zSeries, s/390, iSeries, AIX	SUSE, Formation RedHat

Formation MySQL	Formation Apple	Formation en gestion de projet
Base de données MySQL	Cours Apple, Formation Leopard	Formation du PMI

Oracle Database 11g: New Features for Administrators DBA Release 2

Compétences acquises

Install Oracle Grid Infrastructure

Install Oracle Database 11g Release 2

Use Oracle Restart to manage components

Use Automatic Storage Management (ASM) enhancements

Implement table compression and hybrid columnar compression

Implement data warehousing and partitioning enhancements

Use the SQL Performance Analyzer

Use SQL Plan Management and load SQL plan baselines

Use Database Replay to record and replay workloads

Set and manage Automatic SQL Tuning

Use Resource Manager enhancements

Use Enterprise Manager to monitor SQL commands

Use the new and enhanced RMAN features

Use Total Recall to create, protect, and use history data

Use Data Pump in legacy mode

Use Data Recovery Advisor

Qui peut en profiter

Data Warehouse Administrator

Database Administrators

Sales Consultants

Support Engineer

Technical Consultant

Préalables

Working knowledge of Oracle Database 10g

Formation de Oracle (3027 cours)

Formation de Bases de données et grilles (209 cours)

Formation de 11g (118 cours)

Oracle Database 11g: New Features for Administrators DBA Release 2 Contenu détaillé