Szkolenia Oracle

Cel szkolenia

This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam.

Learn To:

  • Install Oracle Grid Infrastructure.
  • Create and manage users.
  • Install and configure an Oracle Database.
  • Create and manage storage structures.
  • Administer the Oracle Database.
  • Understand the Oracle database architecture and how its components work and interact with one another.
  • Perform backup and recovery.

Plan szkolenia Rozwiń listę

  1. Exploring the Oracle Database Architecture
    • Oracle Database Architecture Overview
    • Oracle ASM Architecture Overview
    • Process Architecture
    • Memory structrues
    • Logical and physical storage structures
    • ASM storage components
  2. Installing your Oracle Software
    • Tasks of an Oracle Database Administrator
    • Tools Used to Administer an Oracle Database
    • Installation: System Requirements
    • Oracle Universal Installer (OUI)
    • Installing Oracle Grid Infrastructure
    • Installing Oracle Database Software
    • Silent Install
  3. Creating an Oracle Database
    • Planning the Database
    • Using the DBCA to Create a Database
    • Password Management
    • Creating a Database Design Template
    • Using the DBCA to Delete a Database
  4. Managing the Oracle Database Instance
    • Start and stop the Oracle database and components
    • Use Oracle Enterprise Manager
    • Access a database with SQLPlus
    • Modify database installation parameters
    • Describe the stages of database startup
    • Describe database shutdown options
    • View the alert log
    • Access dynamic performance views
  5. Manage the ASM Instance
    • Set up initialization parameter files for ASM instance
    • Start up and shut down ASM instances
    • Administer ASM disk groups
  6. Configuring the Oracle Network Environment
    • Use Enterprise Manager to create and configure the Listener
    • Enable Oracle Restart to monitor the listener
    • Use tnsping to test Oracle Net connectivity
    • Identify when to use shared servers and when to use dedicated servers
  7. Managing Database Storage Structures
    • Storage Structures
    • How Table Data Is Stored
    • Anatomy of a Database Block
    • Space Management in Tablespaces
    • Tablespaces in the Preconfigured Database
    • Actions with Tablespaces
    • Oracle Managed Files (OMF)
  8. Administering User Security
    • Database User Accounts
    • Predefined Administrative Accounts
    • Benefits of Roles
    • Predefined Roles
    • Implementing Profiles
  9. Managing Data Concurrency
    • Data Concurrency
    • Enqueue Mechanism
    • Resolving Lock Conflicts
    • Deadlocks
  10. Managing Undo Data
    • Data Manipulation
    • Transactions and Undo Data
    • Undo Data Versus Redo Data
    • Configuring Undo Retention
  11. Implementing Oracle Database Auditing
    • Describe DBA responsibilities for security
    • Enable standard database auditing
    • Specify audit options
    • Review audit information
    • Maintain the audit trail
  12. Database Maintenance
    • Manage optimizer statistics
    • Manage the Automatic Workload Repository (AWR)
    • Use the Automatic Database Diagnostic Monitor (ADDM)
    • Describe and use the advisory framework
    • Set alert thresholds
    • Use server-generated alerts
    • Use automated tasks
  13. Performance Management
    • Performance Monitoring
    • Managing Memory Components
    • Enabling Automatic Memory Management (AMM)
    • Automatic Shared Memory Advisor
    • Using Memory Advisors
    • Dynamic Performance Statistics
    • Troubleshooting and Tuning Views
    • Invalid and Unusable Objects
  14. Backup and Recovery Concepts
    • Part of Your Job
    • Statement Failure
    • User Error
    • Understanding Instance Recovery
    • Phases of Instance Recovery
    • Using the MTTR Advisor
    • Media Failure
    • Archive Log Files
  15. Performing Database Backups
    • Backup Solutions: Overview
    • Oracle Secure Backup
    • User-Managed Backup
    • Terminology
    • Recovery Manager (RMAN)
    • Configuring Backup Settings
    • Backing Up the Control File to a Trace File
    • Monitoring the Flash Recovery Area
  16. Performing Database Recovery
    • Opening a Database
    • Data Recovery Advisor
    • Loss of a Control File
    • Loss of a Redo Log File
    • Data Recovery Advisor
    • Data Failures
    • Listing Data Failures
    • Data Recovery Advisor Views
  17. Moving Data
    • Describe ways to move data
    • Create and use directory objects
    • Use SQL*Loader to move data
    • Use external tables to move data
    • General architecture of Oracle Data Pump
    • Use Data Pump export and import to move data
  18. Working with Support
    • Use the Enterprise Manager Support Workbench
    • Work with Oracle Support
    • Log service requests (SR)
    • Manage patches
Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje


Recommended Related Training Courses:

  • Oracle Database 11g: Administration Workshop II Release 2
  • Oracle Database 11g: SQL Tuning Workshop Release 2
  • Oracle Database 11g: Performance Tuning DBA Release 2
  • Oracle Database 11g: Backup and Recovery Workshop
Poziom trudności
Czas trwania 5 dni
Zobacz więcej szkoleń Oracle

Prosimy o wypełnienie poniższego formularza, jeśli chcą Państwo uzyskać więcej informacji o powyższym szkoleniu.

Cena szkolenia

  • Forma szkolenia: stacjonarne


Czytaj więcej o ctab

Czas trwania

5 dni

Dostępne terminy