ISQLGlobal Global Logo
Contact UsCertificationPlacementsCoursesCorporateHome

Oracle Database 11g Administration Workshop 1 Training institute in Chennai ISQL Global

Oracle Database 11g: Administration Workshop I Release 2

This Database 11g Administration training gives you a firm foundation in basic database administration, including how to install and maintain an Oracle database. Learn about architecture and how the database components work and interact.
Learn To
This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle Universityinstructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam.

  • 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.
Benefits to You
  • Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.
  • Create an Operational Database
  • You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. This includes performance monitoring, database security, User management and backup/recovery techniques.
Training Requirements
This Oracle Database 11g: Administration Workshop I Release 2 course fulfills the training requirement for an Oracle Certification Path. Onlyinstructor-led online (LVC, LWC), in-class (ILT) or Training On Demand courses fulfill the requirement. Please note that Self-Study Courses and Knowledge Center courses do not fulfill the training requirement.
Prerequisites
Suggested Prerequisite
  • Taken Oracle Introduction to SQL course or equivalent experience
  • Taken Oracle PL/SQL course or equivalent experience
Audience
  • Database Administrators
  • Java Developers
  • Support Engineer
  • Technical Consultant
  • Technical Administrator
Course Objectives
  • Install Oracle Grid Infrastructure
  • Install and configure Oracle Database 11g
  • Configure Oracle Net services
  • Monitor and administer undo data
  • Manage the database storage structures
  • Create and administer User accounts
  • Perform basic backup and recovery of a database
  • Manage data concurrency
  • Monitor performance
  • Describe Oracle Database Architecture
Course Topics
Exploring the Oracle Database Architecture
  • ASM storage components
  • Logical and physical storage structures
  • Oracle Database Architecture Overview
  • Oracle ASM Architecture Overview
  • Process Architecture
  • Memory structrues
Installing your Oracle Software
  • Oracle Universal Installer (OUI)
  • Installation: System Requirements
  • Tools Used to Administer an Oracle Database
  • Installing Oracle Grid Infrastructure
  • Installing Oracle Database Software
  • Tasks of an Oracle Database Administrator Silent Install
Creating an Oracle Database
  • Planning the Database
  • Password Management
  • Using the DBCA to Create a Database
  • Creating a Database Design Template
  • Using the DBCA to Delete a Database
Managing the Oracle Database Instance
  • Modify database installation parameters
  • Describe database shutdown options
  • Use Oracle Enterprise Manager
  • Describe the stages of database startup
  • Start and stop the Oracle database and components
  • Access a database with SQLPlus
  • View the alert log
  • Access dynamic performance views
Manage the ASM Instance
  • Set up initialization parameter files for ASM instance
  • Administer ASM disk groups
  • Start up and shut down ASM instances
Configuring the Oracle Network Environment
  • Use Enterprise Manager to create and configure the Listener
  • Identify when to use shared servers and when to use dedicated servers
  • Enable Oracle Restart to monitor the listener
  • Use tnsping to test Oracle Net connectivity
Managing Database Storage Structures
  • Oracle Managed Files (OMF)
  • Storage Structures
  • Tablespaces in the Preconfigured Database
  • Space Management in Tablespaces
  • Actions with Tablespaces
  • How Table Data Is Stored
  • Anatomy of a Database Block
Administering User Security
  • Benefits of Roles
  • Predefined Administrative Accounts
  • Implementing Profiles
  • Predefined Roles
  • Database User Accounts
Managing Data Concurrency
  • Resolving Lock Conflicts
  • Data Concurrency
  • Deadlocks
  • Enqueue Mechanism
Managing Undo Data
  • Undo Data Versus Redo Data
  • Data Manipulation
  • Transactions and Undo Data
  • Configuring Undo Retention
Implementing Oracle Database Auditing
  • Enable standard database auditing
  • Describe DBA responsibilities for security
  • Review audit information
  • Maintain the audit trail
  • Specify audit options
Database Maintenance
  • Use server-generated alerts
  • Use automated tasks
  • Manage the Automatic Workload Repository (AWR)
  • Set alert thresholds
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Describe and use the advisory framework
  • Manage optimizer statistics
Performance Management
  • Performance Monitoring
  • Dynamic Performance Statistics
  • Enabling Automatic Memory Management (AMM)
  • Automatic Shared Memory Advisor
  • Using Memory Advisors
  • Troubleshooting and Tuning Views
  • Invalid and Unusable Objects
  • Managing Memory Components
Backup and Recovery Concepts
  • Understanding Instance Recovery
  • Statement Failure
  • Phases of Instance Recovery
  • Archive Log Files
  • Media Failure
  • Part of Your Job
  • User Error
  • Using the MTTR Advisor
Performing Database Backups
  • Backup Solutions: Overview
  • Monitoring the Flash Recovery Area
  • Recovery Manager (RMAN)
  • Terminology
  • Configuring Backup Settings
  • Backing Up the Control File to a Trace File
  • User-Managed Backup
  • Oracle Secure Backup
Performing Database Recovery
  • Opening a Database
  • Data Recovery Advisor Views
  • Data Recovery Advisor
  • Loss of a Control File
  • Data Failures
  • Loss of a Redo Log File
  • Listing Data Failures
Moving Data
  • Use SQL*Loader to move data
  • Use external tables to move data
  • Describe ways to move data
  • Create and use directory objects
  • Use Data Pump export and import to move data
  • General architecture of Oracle Data Pump
Working with Support
  • Use the Enterprise Manager Support Workbench
  • Manage patches
  • Work with Oracle Support
  • Log service requests (SR)

    All rights reserved. ©1999 - 2022, ISQL Global.

    Terms of Service | Privacy Policy