Oracle Database 11g: New Features for Administrators Accelerated Release 2 Schulung

Oracle Database new features Schulung Oracle Schulung

Oracle Database new features Schulung:
change management features and other key enhancements

This 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.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.Describe the key new capabilities in Oracle Database 11g (11.2.0.2).Identify how these new features can be applied in your own environments.Identify technical advantages and business benefits associated with these technologies.Proceed towards the adoption and implementation of Oracle Database 11g Patch Set 1 with greater confidence.Explore New Features of Oracle Database 11gThis course also gives you the opportunity to learn about the general new features of the Oracle Database 11g (11.2.0.2). Expert Oracle University instructors will help you examine the uses and benefits of the new features in managing storage and space, strengthening resource management and database manageability. In addition, hands-on practice sessions help reinforce your understanding of the new capabilities.Live Virtual Class FormatA Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Diese Oracle Database new features Schulung bieten wir Ihnen auch als individuelles Oracle Database new features Training vor Ort als Firmen-Seminar an.

Seminarinhalt  

  • 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 Performance Enhancements
    • SQL Monitoring in Oracle Database 11g Release 2
    • Viewing Session Details
    • Viewing the SQL Monitoring Report
    • 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
  • 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 Data Recovery Advisor
    • Oracle Total Recall
    • Flashback Transaction Backout
    • Enterprise Manager LogMiner Interface
    • Data Pump Legacy Mode
    • Assessing Data Failures
    • Data Recovery Advisor RMAN Command-Line Interface
    • Data Recovery Advisor Views
    • Setting Parameters to Detect Corruption
  • Introduction to Oracle Database 11.2.0.2
    • Course Objectives Lesson Roadmap
    • Installing and Upgrading with Patch Sets
    • Upgrading Out-of-Place Upgrading In-Place
    • New Software Updates Option
    • New Software Updates Option
    • Oracle ASM Configuration After Installation
    • Grid Infrastructure Configuration after Installation Upgrading Grid Infrastructure
    • Oracle ASM Configuration Assistant Enhancements
  • Oracle ASM and ACFS Enhancements
    • What You Already Know: ASM, ADVM and ACFS
    • Securing Oracle ACFS
    • Protecting Oracle ACFS with Encryption
    • Using Oracle ACFS Replication
  • Enhanced Segment Management
    • Allocating Space
    • Creating a Range-Partitioned Table
    • Viewing Partitions With and Without Segments
    • Controlling Deferred Segment Creation
    • Segments on Demand: Scope
    • Managing Space for Schema Objects
    • Additional Automatic Functionality
    • Viewing Segment Information in Enterprise Manager
  • Performance Enhancements
    • Creating and Enabling Resource Plans
    • Limiting Resource Usage Monitoring Resource Usage
    • Managing Query Workloads
    • Parallel Statement Queuing
    • Managing Parallel Execution of Workloads
    • Using the PARALLEL_TARGET_PERCENTAGE Attribute
    • Prioritizing Parallel Statement Queuing
    • Configuring Automatic SQL Tuning
  • Enhanced Real Application Testing
    • Realistic Testing with Real Application Testing
    • When to Use What?
    • Data Dictionary Changes for Integration
    • Using Enterprise Manager to Access SQL Performance Analyzer
    • Preprocessing a Database Workload
    • Using the Workload Analyzer
    • Controlling DB Replay with Timeout
    • Using Remote SPA with Active Data Guard

Seminar-Ziele:

  • Install Oracle Grid Infrastructure
  • Install Oracle Database 11g Release 2
  • Use Oracle Restart to manage components
  • Use the Oracle ASM and ACFS enhancements
  • Implement table compression and hybrid columnar compression
  • Implement data warehousing and partitioning enhancements
  • Use the SQL Performance Analyzer
  • Use Database Replay to record and replay workloads
  • 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
  • Describe the key new capabilities in Oracle Database 11g (11.2.0.2)
  • Manage space with the enhanced segment management
  • Use the capabilities of the enhanced database manageability

Weitere Informationen  

Zielgruppe

  • Data Warehouse Administrator
  • Database Administrators
  • Sales Consultants
  • Support Engineer
  • Technical Consultant

Voraussetzungen

  • Working knowledge of Oracle Database 10g

Ihr Vorteil

Die Oracle-Klassenraumtrainings werden in deutscher Sprache gehalten. Die Unterlagen können in deutsch oder englisch vorliegen.

Haben Sie Fragen oder Wünsche?

Rufen Sie uns kostenlos an unter
0800 4772466


Senden Sie uns gerne eine E-Mail an beratung@incas-training.de

Schulungsinformation

Termine und Preise  

Oracle Database 11g: New Features for Administrators Accelerated Release 2 Schulung

Preis:
€ 3.930,00 zzgl. MwSt.
€ 4.676,70 inkl. MwSt.

Dauer:
5 Tage

PDF Download
Wunschtermin auf Anfrage
Sie möchten dieses Training gerne an einem anderen Termin oder Ort besuchen?

Bitte klicken Sie Ihre Wunschtermine an

 

*  Diese Felder müssen ausgefüllt sein

Organisatorisches zum Seminar   

Kategorie: Oracle Database new features
Classroom Training (CT)

Sonstiges:
Getränke, Mittagessen, Oracle Database-Teilnahmezertifikat und Oracle Database new features-Schulungsunterlagen sind im Preis inbegriffen

Stichworte zu dieser Oracle Database new features Schulung:
D72074GC10, D72076GC10

Informationen zum Durchführungsort:
Krefeld Düsseldorf Essen Köln

Oracle Database new features Firmenschulung  

Die Vorteile einer Oracle Database new features Firmenschulung in Ihrem Hause (InHouse Schulung) oder bei der INCAS liegen auf der Hand:

  • Teilnehmerunabhängiger Tagessatz
  • Zeitersparnis durch eine kurze und intensive Oracle Database new features Schulung
  • Freie Terminwahl, auf Wunsch auch Abends oder an Wochenenden
  • Zielorientierter als eine offene Oracle Database new features Schulung, da exakt auf Ihre Bedürfnisse zugeschnitten
  • Vertraulicher, da Internes auch intern bleibt
  • Wir leihen Ihnen auf Wunsch gerne Schulungsrechner

PDF Download Firmenschulung Senden Sie mir ein unverbindliches Angebot:

Ansprechpartner

Gewünschter Oracle Database new features Seminarort

  •  
  •  
  •  

* Unkomplizierte Organisation * Sehr gute Rahmenbedingungen * Professioneller Coach * Wird weiterempfohlen

Stephan Knabe, DB Systel GmbH Siebel Integration Workshop

Ich habe in den fünf Tagen mehr gelernt, als ich erwartet hatte, mit den wichtigsten Funktionen bin ich nun vertraut und freue mich auf den Einsatz auf der Arbeit.

Ralph Gräser, - Oracle Database 11g: Administration Workshop

Frische Präsentation mit praxisorientierten Ausführungen.

Volker Kox, Volksbank Immobilien GmbH / Volksbank Schwalmtal eG OpenOffice Writer und Calc

Die Schulungen sind sehr informativ, saubere und ordentliche Schulungsräume, sowie freundliche Mitarbeiter. Sehr gut!

Oliver Domeischel, T-Systems International GmbH Oracle Commerce

Tolles Trainingszentrum, engagierte INCAS-Mitarbeiter sowie Trainer. Es war sehr kurzweilig!

Mario Stricker, DB Systel GmbH Siebel Integration Workshop

Endlich einmal ein verständlicher und praxisbezogener Kurs zu SQL. Super Trainer, Rahmenbedingungen auch TOP!

Axel Böhmer, Geologischer Dienst NRW Oracle Database: Professioneller Einstieg in SQL Release 2

Sehr gelungenes Seminar mit einem sehr erfahrenen Trainer. Der Lernerfolg war und ist deutlich spürbar.

Toni Richter, Volkswagen Aktiengesellschaft Oracle Database : Professioneller Einstieg in SQL Release 2

Der erste Kurs bei dem ich vieles mit nach Hause nehmen und ausbauen kann gepaart mit einer guten Trainingsatmosphäre und gemeinsamen leckeren Essen -- für die kurzen Zeit optimal... hab Feuer gefangen!

Hartmut Lehmann, TKN Java Programming Language, Java SE 6

ORACLE Certified Master

Alternative Oracle Trainings 

Kontakt  

INCAS Training und Projekte GmbH & Co. KG
Europark Fichtenhain A 15
D-47807 Krefeld
Fon: 02151 366250
Freecall: 0800 4772466
Fax: 02151 3662529
E-Mail: info@incas-training.de