Course Description
In this Oracle database administration course, Part 1 of a two part online training series, you will explore how an Oracle Database applies 'grid computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. In this Oracle training, students learn how to install, administer and maintain an Oracle 10g or 11g database in an effective and efficient manner. Topics such as the interaction among Oracle components, an understanding of Oracle's architecture and user management are covered. Students learn to install, administer and maintain an Oracle 10g or 11g database in an effective and efficient manner. Performance monitoring, database security and backup and recovery techniques are covered. This course will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.
Once you have completed Oracle 10g/11g Database Administration I Part 1 the next course is this series is Oracle 10g/11g Database Administration I Part 2. The Oracle 10g/11g Database Administration I Part 2 course will contiue to build your knowledge in shared server, database performance monitoring, database maintenace, how to use the undo management feature, how to deal with locking conflicts and finishing up with backups and database recovery. Click here to learn more about Oracle 10g/11g Database Administration I Part 2.
In This Course You Will Learn:
As a result of taking this Oracle training course, you will be able to:
- Explain Oracle's architectural components.
- Demonstrate how to use Oracle's universal installer and configuration assistants.
- Identify the different interfaces to an Oracle database.
- Describe the different database control and storage structures.
- Explain how to use schema and user management tools.
- Contrast the different techniques for importing data to an Oracle database and exporting data from an Oracle database.
- Describe PL/SQL declarations, code and exceptions.
- Discuss Oracle's password security and database auditing features.
- Configure Oracle's default user account features.
- Configure and tune Oracle's Listener and Net Services features.
- Learn how to establish, tune and monitor Oracle's Shared Server configuration.
- Explain how to manually and automatically monitor the performance of an Oracle database.
- Describe how to use Oracle's advisors to help tune and monitor database performance.
- Show how to tune and administer Oracle's database undo management.
- Discover how Oracle detects and resolves locking conflicts.
- Learn the roles of control files, data files and redo log files in database backup and recovery.
- Describe the implications of running your database in NOARCHIVELOG mode and ARCHIVELOG mode on database backup and recovery.
- Discuss the different types of database backups.
- Differentiate the differences between user-managed and server-managed backups.
- Contrast the differences between database restoration and database recovery.
- Illustrate the importance of database incarnations in database recovery.
Prerequisites
You need to have equivalent Oracle 9i database experience or have taken the following GogoTraining courses:
Outline
Module 00: Oracle 10g/11g Database Administration I Part 1 Online Training - Course Introduction
Module 01: Architectural Components, Part One:
• Physical Structure
• Memory Structure
• Process Structure
• Logical Structure
Module 02: Architectural Components, Part Two:
• Stages of a SQL Statement
• Defining the Database, Instance and Server
Module 03: Administration and Installation Tools for Oracle Server, Part One:
• Administration Tools
• The Oracle Universal Installer
Module 04: Administration and Installation Tools for Oracle Server, Part Two:
• SQL*Plus
• Configuration Assistants
Module 05: Database Architecture and Creation
• Database Architecture
• Database Creation
Module 06: Database Interfaces
• Database Interfaces
Module 07: Database Control
• The Console
• The Listener
• Agents
• Instance
• Controlling the Database
Module 08: Storage Structures
• Tablespace Creation
• Tablespace Management
• Tablespace Information
Module 09: User Management
• Managing Users
• Managing Roles
• Managing Privileges
Module 10: Schema Object Management
• Managing Tables
• Managing Constraints
• Managing Indexes
• Managing Views
Module 11: Data Management using SQL*Loader
• Using SQL*Loader to Import Information
Module 12: Data Management Using the Data Pump
• Data Pump Export
• Data Pump Import
Module 13: PL/SQL Overview
• PL/SQL Declarations
• PL/SQL Code
Module 14: PL/SQL Exceptions
• Creating Exceptions
• Handling Exceptions
• Built-In Exceptions
Module 15: Database Security Management, Part One
• Managing Default User Accounts
Module 16: Database Security Management, Part Two
• Password Security Features
Module 17: Database Security Management Part Three
• Database Auditing
Module 18: Oracle Net Services, Part One
• Oracle Net Services Overview and Concepts
• Oracle Listener Creation and Configuration
Module 19: Oracle Net Services, Part Two
• Oracle Net Manager
• Using TNSPING
Module 20: Oracle 10g/11g Database Administration I Part 1 Online Training - Course Summary and Review
• Oracle Architectural Components
• Installing and Configuring Oracle
• Database Architecture, Creation and Interfaces
• Database Control and Storage Structures
• Managing Users and Schemas
• Managing Data
• Overview of PL/SQL
• Database Security management
• Oracle Net Services
Certification
Oracle 10g/11g Database Administration I Part 1 online training is part of a two-course series that helps you to prepare for Oracle's exam 1Z0-052. This course maps to Oracle's course, Oracle Database 11g: Administration I. When you pass exam 1Z0-052, you have completed a portion of the requirements towards the Oracle Database 11g Administrator Certified Associate certification.
For more information about the certification requirements, pricing, and locations select the link in the related training section.