Oracle 10g/11g Database Administration I Part 1

View Your Course Transcript

Videos

There are several great features that come with this course. The Course Transcript tracks your progress and allows you to pick up where you left off. You can view or email your transcript. The course comes with documentation found in Downloads Tab. You have access to the course and all videos for 1 year. Full screen viewing option available (see icon on bottom right corner of video).

Video Title	Minutes
00: Course Introduction	13
01: Architectural Components, Part One	30
02: Architectural Components, Part Two	34
03: Administration and Installation Tools for Oracle Server, Part One	10
04: Administration and Installation Tools for Oracle Server, Part Two	11
05: Database Architecture and Creation	62
06:Database Interfaces	17
07: Database Control	45
08: Storage Structures	21
09: User Management	48
10: Schema Object Management	46
11: Data Management using SQL*Loader	43
12: Data Management Using the Data Pump	38
13: PL/SQL Overview	23
14: PL/SQL Exceptions	24
15: Database Security Management, Part One	19
16: Database Security Management, Part Two	35
17: Database Security Management Part Three	22
18: Oracle Net Services, Part One	20
19: Oracle Net Services, Part Two	10
20: Summary and Review	12
Total:	9 hours 43 minutes

Course Materials

Want to be able to access these helpful materials? Contact Us!

• Student Guide
• Exercise Guide
• Oracle Installation Guide
• Module 09 Lab Exercise File
• Module 11 Lab Exercise File

Related Links

• Course Survey
• Oracle Certification Requirements
• Exam Pricing and Locations

For more information, contact us or call 1-877-546-4446

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.

Objectives

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.

Related Training

• Course: Oracle 10g/11g Database Administration I - Part 2
• Course: Oracle 10g/11g Database Administration II - Part 1
• Course: Oracle 10g/11g Database Administration II - Part 2
• Podcast: New Speed And Security Features For Oracle 10g
• Podcast: Using Virtual Indices In Oracle 10g And 11g
• Podcast: Incrementally Updating Backups In Oracle 10g And 11g
• Podcast: Flashback Technology In Oracle 10g Part 1
• Podcast: Flashback Technology In Oracle Part 2

For more information, contact us or call 1-877-546-4446

Oracle 10g/11g Database Administration I Part 1 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

For more information, contact us or call 1-877-546-4446

Prerequisites

You need to have equivalent Oracle 9i database experience or have taken the following GogoTraining courses:

• Oracle 10g/11g: Introduction to SQL
• Oracle 10g/11g: Advanced SQL
• Oracle 11g PL/SQL Programming Part 1
• Oracle 11g PL/SQL Programming Part 2

For more information, contact us or call 1-877-546-4446

System Requirements

Hardware:

• Java Runtime Environment (JRE)
• Memory requires 32 MB
• 200 MB disk space

Software:

• Oracle Universal Installer 11g Release 2 (11.2)-Detailed set up will be provided with the course.

For more information, contact us or call 1-877-546-4446

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.

For more information, contact us or call 1-877-546-4446

When you purchase a course from GogoTraining, you can submit comments or questions to our expert instructors.