HOME
 

Oracle Database 11g Release 2 DBA - Part I

STL
Course summary
Length: 5 days
Language: English
Location: Nationwide
Provider: STL plus
Course type: Company-Specific / In-House

Oracle Database 11g Release 2 DBA - Part I



Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... This course will give database administrators key skills in being able to set up, configure and maintain an Oracle 11g database.

Suitability - Who should attend?



This five day course is suitable for IT professionals, network adminstrators and database administrators who need to set up, configure and maintain an Oracle 11g database.

Training Course Content



Course Introduction

Administration and course materials
Course structure and agenda
Delegate and trainer introductions

Session 1: INTRODUCTION TO ORACLE DATABASE 11g

Principles of a relational database
Common database administration tasks
Role and responsibilities of a DBA

Session 2: ORACLE DATABASE 11g ARCHITECTURE

Structure of an Oracle database
Oracle instances
Memory structures
Background processes
Server processes and client processes
Understanding the Oracle database
Overview of ASM databases

Session 3: INSTALLATION AND CONFIGURATION OF AN ORACLE DATABASE

System requirements
Designing and optimum structure
Overview of authentication methods
Using environment variables
Configuring the Oracle Universal Installer (OUI)
Planning a silent install
Overview of the database configuration assistant (DBCA)
Creating databases through DBCA
Managing database through DBCA
Deleting database through DBCA
Managing templates through DBCA

Session 4: ADMINISTER A DATABASE INSTANCE

Overview of administrative tools
Managing a database with SQL*Plus
Managing a database with Enterprise Manager (EM)
Working with the EM Database Console
Accessing EM
Navigating EM
User privileges and EM
Understanding Oracle Restart

Session 5: CONFIGURE THE ORACLE NETWORK ENVIRONMENT

Understanding network configurations
Setting up Oracle Net Listener
Managing Oracle Net Listener
Naming methods with Oracle Net
Setting up Oracle network
Managing Oracle network
Using Enterprise Manager and Listener together
Setting up client connections with Net Manager
Viewing listener configuration
Working with the Oracle listener
Enabling Oracle Restart to monitor the listener
Using TNSPING to diagnose connectivity issues
Creating a connection to the database
Setting up Net Services with Enterprise Manager
Understanding Dedicated Server architecture
Understanding Shared Server architecture
Choosing Shared Servers or Dedicated Servers

Session 6: MANAGE AN ORACLE INSTANCE

Creating a connection to an Oracle database
Overview of database authentication
Creating a password file
The Startup Process
The Shutdown Process
Initialization parameters
Terminating a database and instance using SQL and EM
Initiating a database and instance using SQL and EM
Using the alert log
Using trace files
Understanding initialization parameters with EM

Session 7: TABLESPACE AND DATAFILE MANAGEMENT

Understanding tablespaces
Understanding datafiles
Viewing storage structure with EM
Overview of tablespace commands
Local tablespaces
Dictionary tablespaces
Bigfile tablespaces
Temporary tablespaces
Multiple temporary tablespaces
Creating tablespaces
Managing tablespaces
Using standard block sizes and non-standard block sizes
Using OMF to create and manage tablespaces
Drop tablespace command

Session 8: MANAGE REDO LOGS

Overview of Redo logs
Designing redo logs
Redo log data dictionary tables
Working with log switches and checkpoints
Maintaining log files
Working with log file members and groups
Clearing log files
Working with online redo log files
Multiplex redo log files
Managing redo logs with EM
Managing online redo log files with OMF
Listing redo log information

Session 9: MANAGE CONTROL FILES

Understanding control files
Components of a control file
Working with control files
Diagnosing broken control files
Mirroring control files
Creating a standby control file
Using OMF to manage control files
List control file information

Session 10: MANAGE SCHEMA OBJECTS

Creating new tables
Viewing table properties
Overview of data integrity
Defining constraints
Modifying tables
Creating indexes
Viewing index attributes
Creating views
Working with sequences

Session 11: MANAGE USERS

Different account types
User accounts
Creating user accounts
Authenticating an operating system
Changing passwords
Managing user accounts
Dropping user accounts
Monitoring user information
Terminating user sessions
Product user profiles

Session 12: MANAGE PROFILES AND RESOURCES

Understanding user profiles
Parameters of profile resources
Creating a profile command
Using profiles to manage passwords
Using profiles to control resource usage
Maintaining profiles
Dropping profiles

Session 13: MANAGING PRIVILEGES

Accessing the database
Built-in roles
System-level privileges
Object-level privileges
The grant command
The revoke command
Creating new roles
Modifying roles
Dropping roles
Managing role availability
Using predefined roles
Synonyms
Listing valid grants

Session 14: DATABASE AUDITING

Understanding database auditing
Performing an audit on SYS statements
Performing an audit on end user sessions
Statement auditing
Privilege auditing
Performing an audit on database object modifications
Relocating an audit table
Using EM to audit

Session 15: UNDO MANAGEMENT

Overview of Undo data
Managing and implementing undo
Configuring the undo retention
Switching undo tablespaces
Specifying the retention period
Guaranteeing undo retention
Retention period for flashback queries
Viewing undo space details
Using the undo advisor
Sizing the undo tablespace
Using EM to manage undo

Session 16: MOVING DATA

Working with directory objects
Exporting and importing the data pump
Structure of a data pump
Data dictionary views of a data pump
Using a data pump in interactive mode
Utilising the data pump API
Exporting data with the data pump
Importing data with the data pump
Overview of SQL Loader
Command line parameters
Filtering records
Keyword of a control file
Datafiles
Typical SQL Loader data paths

Session 17: OVERVIEW OF MANAGING AN ASM INSTANCE

Understanding Automatic Storage Management (ASM)
Storage components of ASM
Creating initialization files for an instance of ASM
Initiating and cancelling ASM Instances
Managing ASM disk groups
Managing ASM Files

Session 18: DATA CONCURRENCY AND LOCK CONFLICTS

Oracle lock types
How to acquire locks
Overview of contention
Resolving deadlocks
Preventing locking issues
Detecting lock contention
Emergency conflict resolution

Session 19: PROACTIVE DATABASE MAINTENANCE

Creating a self-monitoring architecture
Using the automatic workload repository
Methods for automating database diagnostic monitoring
Configuring monitoring an Oracle database
Using Advisors
Creating notification rules

Session 20: PERFORMANCE MANAGEMENT

Overview of tuning
Identifying unusable objects
Using the optimizer statistics collection
Using the automated statistics collection
Understanding performance metrics
Using the advisors
Troubleshooting performance issues

Session 21: BACKUP AND RECOVERY CONSIDERATIONS

Overview of backup solutions
Using Oracle Secure Backup
Best practice for backing up an Oracle database
Backing up, restoring and recovering the database
Failure types
Tuning instance recovery
Working with checkpoints
Working with redo log files
Working with archive log files
Altering the ARCHIVELOG mode of a database
Configuring databases for optimum recoverability

Session 22: DATABASE BACKUPS

Overview of RMAN backup
Configuring backup sets and image copies
Using EM to carry out backups
Automating backups of the database
Overview of backup options
Catalog settings
Monitoring the flash recovery area
Managing backups

Session 23: DATABASE RECOVERY

Overview of restore and recovery operations
Retrieving an entire database from a backup
Restoring a system critical data file
Restoring a control file
Restoring a redo log file
Data Recovery Advisor

Session 24: ENHANCE THE CAPABILITIES OF THE DATABASE

Using the Workbench for Enterprise Manager Support
Overview of security updates
Communicating with Oracle support
Logging service requests
Managing patches
Applying patches

Expenses



Prices from £3000 (Guideline pricing). Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Oracle Database 11g Release 2 DBA - Part I.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.microsofttraining.net

Request information

Find out more about this Oracle Database 11g Release 2 DBA - Part I course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here