Feedback

Feedback to trainingforit.co.uk


Site comment Site ratings
Email (optional)

Content

Design

Ease of use

Overall

Oracle Database 10g DBA - Part I

Summary
Length:
5 days
Price:
1,795 GBP excl. VAT
Training Provider:
StayAhead Training plusStayAhead Training
Location:
Training Method:
Startdate:  
London: 20/02/2012, 21/05/2012, 13/08/2012, 29/10/2012

About Oracle Database 10g DBA - Part I

Oracle Database 10g DBA - Part I Course Overview
This course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle database.

The Oracle Database 10g DBA - Part I course is designed to give the Oracle database administrator practical experience in setting up, administering and troubleshooting an Oracle10g database.  Database administrators will gain an understanding of the architecture and processes of the Oracle database server.  They will be able to ensure the integrity and availability of a company's data within the Oracle environment.  They will be able to monitor the performance of the database and perform basic backup and recovery of the database.

Skills Gained
The delegate will practise:
  • Installing and Configuring Oracle
  • Creating and Managing an Oracle Database
  • Administering an Oracle Database
  • Configuring the Oracle Network Environment
  • Configuring Shared Servers
  • Creating and Managing Database Storage Structures
  • Managing Redo Log Files and Control Files
  • Managing Schema Objects
  • Managing Users, Profiles, Privileges and Roles
  • Managing Undo Data and Temporary Segments
  • Monitoring and Resolving Lock Conflicts
  • Maintaining Database Security
  • Monitoring the Performance of the Database
  • Loading and Unloading Data
  • Backing Up and Recovering the Database

Who will the Course Benefit?
Anyone who needs to administer, monitor and support an Oracle 10g database.

Course Objectives
The objectives of the Oracle Database 10g DBA - Part I course are that the Oracle database administrator will gain practical experience in setting up, administering and troubleshooting an Oracle10g database. Database administrators will gain an understanding of the architecture and processes of the Oracle server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment.

Examinations
This Oracle Database 10g DBA - Part I course covers the main examination topics of the Oracle exam #1Z1-042 Oracle Database 10g: Administration I.

Exams are not included as part of the course.

Before taking any exam, ensure you have the recommended experience.  The Oracle website lists all exam requirements and these are updated regularly.

Requirements
Delegates wishing to attend the Oracle Database 10g DBA - Part I course should have an understanding of relational database concepts and good operating system knowledge.  They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL.  Knowledge of PL/SQL would be beneficial.

Pre-Requisite Courses
  • Oracle SQL




Follow-On Courses
  • Oracle Database 10g DBA - Part II




NOTE: Course technical content is subject to change without notice.

Oracle Database 10g DBA - Part I Training Course
Course Contents - DAY 1
Course Introduction
  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: INTRODUCTION TO ORACLE DATABASE 10g
  • Relational database concepts
  • Database administration tasks
  • DBA responsibilities

Session 2: ORACLE DATABASE 10g ARCHITECTURE
  • Oracle architecture
  • The Oracle instance
  • Memory structures
  • Background processes
  • Server and client processes
  • The Oracle database

Session 3: INSTALLATION & CONFIGURATION OF AN ORACLE DATABASE
  • Installation Prerequisites
  • Understand system requirements
  • Use optimal flexible architecture
  • Authentication methods for a database
  • Oracle environment variables
  • Install Oracle software using the Oracle Universal Installer (OUI)
  • Use the Database Configuration Assistant (DBCA) to create a database
  • Use DBCA to manage templates
  • Upgrade a database using Database Upgrade Assistant (DBUA)

Session 4: ADMINISTER A DATABASE
  • Administrative tools available to a DBA
  • Using SQL*Plus in Oracle to manage a database
  • Administer the database using Enterprise Manager (EM)
  • Start and stop the agent
  • Start and stop the EM Database Console
  • Access EM
  • EM navigation
  • Grant EM administrative privileges to a user

Session 5: CONFIGURE THE ORACLE NETWORK ENVIRONMENT
  • Overview of network configuration
  • Oracle Net Listener configuration and management
  • Oracle Net Naming methods
  • Tools for configuring and managing the Oracle network
  • Configure client connections with Net Manager
  • View listener configuration
  • Start and stop the Oracle listener
  • Use TNSPING to test Oracle Net connectivity
  • Connect to the database

Oracle Database 10g DBA - Part I Training Course
Course Contents - DAY 2
Session 6: MANAGE AN ORACLE INSTANCE
  • Access an Oracle database
  • Database authentication methods
  • Initialization parameters
  • Password file
  • SHUTDOWN the database
  • STARTUP the database
  • View alert log and trace files

Session 7: TABLESPACE AND DATAFILE MANAGEMENT
  • Overview of tablespaces and datafiles
  • Use EM to view the storage structure of the database
  • Create tablespace commands
  • Locally managed tablespaces
  • Dictionary managed tablespaces
  • Bigfile tablespaces
  • Temporary tablespaces
  • Multiple temporary tablespaces
  • Create tablespaces
  • Manage tablespaces
  • Use standard and non-standard block sizes
  • Create and manage tablespaces using OMF
  • Manage tablespaces

Session 8: MANAGE REDO LOGS
  • Redo log file structure
  • Maintaining redo log files
  • Log switches and checkpoints
  • Multiplex redo log files
  • Manage online redo log files with OMF
  • List redo log information

Session 9: MANAGE CONTROL FILES
  • The usage of the control file
  • The contents of a control file
  • Manage control files
  • Standby control file
  • Manage control files with OMF
  • List control file information

Oracle Database 10g DBA - Part I Training Course
Course Contents - DAY 3
Session 10: MANAGE SCHEMA OBJECTS
  • Create a new table
  • View the attributes and contents of a table
  • Understand data integrity
  • Define constraints
  • Create indexes
  • View index attributes
  • Create views
  • Create and use sequences

Session 11: MANAGE USERS
  • Database administration accounts
  • User accounts
  • Create a user account
  • Change a user's password
  • Alter and drop a user account
  • Monitor user information
  • Terminate user sessions

Session 12: MANAGE PROFILES AND RESOURCES
  • Create profile command
  • Manage passwords with profiles
  • Control resource usage with profiles
  • Alter and drop profile command

Session 13: MANAGING PRIVILEGES
  • Database access
  • System level roles and privileges
  • Object level privileges
  • The grant and revoke commands
  • Create roles
  • Modify and drop roles
  • Control the availability of roles
  • Use predefined roles
  • Synonyms
  • Listing valid grants
  • Product user profiles

Session 14: DATABASE AUDITING
  • Auditing SYS statements
  • Auditing end user sessions
  • Auditing the use of privileges
  • Auditing modifications made to database objects
  • Audit table relocation
  • Fine grained auditing

Oracle Database 10g DBA - Part I Training Course
Course Contents - DAY 4
Session 15: UNDO MANAGEMENT
  • Undo data overview
  • Monitor and administer undo
  • Configure undo retention
  • Guarantee undo retention
  • Use the undo advisor
  • Size the undo tablespace

Session 16: MANAGE DATA
  • Use Data Pump to export data
  • Use Data Pump to import data
  • Use SQL Loader
  • Create directory objects

Session 17: ORACLE SHARED SERVER
  • When shared servers should be used
  • Configure shared servers
  • Monitor shared servers
  • Shared server architecture

Session 18: MONITORING AND RESOLVING LOCK CONFLICTS
  • Detect and resolve lock conflicts
  • Manage deadlocks

Oracle Database 10g DBA - Part I Training Course
Course Contents - DAY 5
Session 19: PROACTIVE DATABASE MAINTENANCE
  • Automatic Workload Repository
  • Automatic Database Diagnostic Monitoring
  • Monitor an Oracle database
  • Use the Advisors
  • Set up notification rules

Session 20: PERFORMANCE MONITORING
  • Troubleshoot invalid and unusable objects
  • Gather optimizer statistics
  • View performance metrics
  • React to performance issues

Session 21: BACKUP AND RECOVERY CONSIDERATIONS
  • Oracle Suggested Backup Strategy
  • Database backup, restore and recover
  • Types of failure
  • Tune instance recovery
  • Checkpoints, redo log files and archive log files
  • Configure ARCHIVELOG mode
  • Configure a database for recoverability

Session 22: DATABASE BACKUPS
  • Types of RMAN backup
  • Backup sets and image copies
  • Create consistent database backups
  • Perform online backups
  • Perform incremental backups
  • Automate database backups
  • Monitor the flash recovery area
  • Manage backups

Session 23: DATABASE RECOVERY
  • Recover from the loss of a system critical data file
  • Recover from the loss of a non system critical data file
  • Recover from the loss of a control file
  • Recover from the loss of a redo log file

Session 24: FLASHBACK
  • Flashback Query
  • Flashback Version Query
  • Flashback Transaction Query
  • Flashback Table
  • Flashback Drop

Continuing studies

Follow on course: Oracle Database 10g DBA - Part II

Expenses

£1,795.00

About StayAhead Training

technical it training

SQL, Oracle, UNIX and Linux experts

StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.

StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.

StayAhead IT Training works with some of the largest names in the IT training industry to provide courses on behalf of Parity Training, Global Knowledge, New Horizons and many more.

unix, linux, oracle, sql, javaSpecialist IT training

StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena and enjoy an enviable position in the UK by being amongst the top IT Technical training organisations.

The UNIX curriculum not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle curriculum also has depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.

StayAhead's training flexibility comes from developing their own courses that include high quality course material, written not only to support the learning process, but can also act as a helpful reference guide on the delegates return to work.

In-house IT training

In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.

StayAhead's focus on IT training

StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. Whether delegates attend a StayAhead Training scheduled course or an on-site course, each event is approached in a professional manner.

StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.

specialist it training


plus Show all courses with StayAhead Training

Request information - obligation free

Get more information from StayAhead Training by filling out the following form. This is a free service for you and the course provider to help you find the most suitable training.
To request information from StayAhead Training, please fill out the following details:
* =  Required field
Email Address*
First Name*
Last Name*
Company
Position
Town/City*
Telephone*
Start date
Number of participants
Message*
Rules

Contact information for StayAhead Training

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

Phone no: 020 7600 6116
www.stayahead.com

More Information
Request Information
To request information from Oracle Database 10g DBA - Part I, please fill out the following details:

What happens now?
Write a course review
Have you studied » Oracle Database 10g DBA - Part I at » StayAhead Training? Share your experience & help others to pick the right course. Set grades (1-5) where 1= very poor & 5 = excellent.
V. Poor | Poor | OK | Good | Excellent
Trainer / Provider
Venue / Facilities
Course Materials
Networking with other delegates

Do you recommend the provider:


Need help finding the right course?

  
By submitting your e-mail, you become a member of Trainingforit.co.uk