Nie masz czasu na szukanie?

508 913 532 Centrala Obsługi Klienta

biuro@prolearning.pl

Pobierz PDF Pobierz DOC Formularz na szkolenie

Formularz na egzamin

6 +
= 10

Oracle Database 11g: New Features for Administrators Accelerated

Program

  1. 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
  2. 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
  3. Oracle Restart
    • Controlling Oracle Restart
    • Using the srvctl Utility
    • Manually Adding Components to the Oracle Restart Configuration
  4. 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
  5. Storage Enhancements
    • Using 4 KB-Sector Disks
    • Using Table Compression
    • Hybrid Columnar Compression
    • SQL Access Advisor
    • Segment Creation on Demand
  6. 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
  7. Oracle SecureFiles
    • Enabling SecureFiles Storage
    • Creating SecureFiles
    • Using SecureFile Compression
    • Accessing SecureFiles Metadata
    • Migrating to SecureFiles
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. SQL Monitoring amp; 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 amp; Using New Statistic Preferences Features
    • Locking Enhancements amp; Adaptive Cursor Sharing
    • Using Table Annotation to Control Result Caching
  16. 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
  17. Flashback Technology, LogMiner, and Data Pump amp; 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
  18. Introduction to Oracle Database 11.2.0.2
    • Course Objectives amp; Lesson Roadmap
    • Installing and Upgrading with Patch Sets
    • Upgrading Out-of-Place amp; Upgrading In-Place
    • New Software Updates Option
    • New Software Updates Option
    • Oracle ASM Configuration After Installation
    • Grid Infrastructure Configuration after Installation amp; Upgrading Grid Infrastructure
    • Oracle ASM Configuration Assistant Enhancements
  19. 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
  20. 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
  21. Performance Enhancements
    • Creating and Enabling Resource Plans
    • Limiting Resource Usage amp; 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
  22. 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

W ramach uczestnictwa zapewniamy Państwu

  • organizacje szkolenia oraz zapewnienie trenera
  • testy sprawdzające poziom wiedzy i umiejętności poziomu umiejętności – pozwalające na uczestnictwo na szkoleniu osób o zbliżonym poziomie umiejętności (na życzenie Klienta)
  • materiały dydaktyczne w tym skrypt odpowiedni do określonego poziomu
  • samodzielne stanowisko komputerowe
  • catering podczas przerw (kawa, herbata, ciastka)
  • lunch
  • zestaw ćwiczeń po ukończeniu szkolenia dostępnych na płycie CD
  • certyfikat ukończenia szkolenia
  • bezpłatne konsultacje z Wykładowcą 2 tygodnie od ukończenia szkolenia
  • testy sprawdzające poziom wiedzy i umiejętności poziomu umiejętności po ukończeniu szkolenia (na życzenie klienta)

Cel

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. In addition, hands-on practice sessions help reinforce understanding of the new capabilities.

This course also gives students the opportunity to learn about the general new features of the Oracle Database 11g (11.2.0.2). Students examine the benefits and use of the new features in managing storage and space, strengthening resource management and database manageability.

 

Metody pracy

Wykład multimedialny, ćwiczenia, laboratoria

Wymagania

Working knowledge of Oracle Database 10g

Trener

Certified Trainer

Referencje

"Firma Logintrans Sp. z o.o. pragnie podziękować Centrum Innowacji ProLearning za współpracę w zakresie organizacji szkolenia „Arkusz kalkulacyjny Google Docs” oraz wyrazić swoje uznanie dla profesjonalnego przygotowania oraz…"

Logintrans

więcej

"Szkolenie MS-10972 Administering the Web Server (IIS) Role of Windows Server,które odbyło się w dniach: 11-15.01.2016 „Jako uczestnik szkolenia, mogę szczerze polecić je każdemu zainteresowanemu. Świetna organizacja od strony logistycznej.…"

Ceneo

więcej
więcej referencji

Ostatnio przeglądane

Słowa kluczowe

Oracle, Oracle Database, baza danych, relacyjne bazy danych, tworzenie baz danych, ASM, ASM System, Oracle Grid, SQL language, język zapytań, SQL
  • Nasze certyfikacje

  • Microsoft
  • Oracle
  • Certiport
  • Pearson Vue

Kurs:

Czas trwania:
Liczba godzin dziennie:
Liczba dni:
Lokalizacja:
Termin
Cena netto :

Twoje dane

- Zobacz regulamin
×

Prosimy o uzupełnienie poniższego formularza w celu zapisu na wybrane egzaminy.

Kod * Nazwa * Data * Godzina Opcja
+

Twoje dane

- Zobacz regulamin
×