Oracle 10g - Introduction

Computer Training Center - South Bend
South Bend, Indiana, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course is intended for Oracle Database 10g Administrators, Sales Consultants, Support Engineers, Oracle Software Developers, and Technical Consultants. Students should have some knowledge of Oracle database utilities, architecture, and terminology. Students will also have knowledge of SQL *Plus, iSQL *Plus, and PL/SQL.

Overview: Students will perform key administrative tasks in Oracle Database 10g, such as creating and controlling databases, administering users, implementing security features, monitoring performance, and performing backup and recovery.

Topics covered include:

Lesson 1: Installing Oracle Database 10g

Topic 1A: Install Oracle Database 10g

Lesson 2: Exploring the Oracle Database 10g Architecture

Topic 2A: Understand Database Architecture

Topic 2B: Identify Database Object Types

Topic 2C: Recognize the Oracle Instance

Topic 2D: Understand the User Connection Process

Topic 2E: Identify Resources for the DBA

Lesson 3: Creating a Database

Topic 3A: Create, Configure, and Delete a Database Using the DBCA

Topic 3B: Use Client and Administration Tools

Lesson 4: Configuring Oracle Net Services

Topic 4A: Examine Oracle Net Services

Topic 4B: Perform Basic Oracle Net Server-Side Configuration

Topic 4C: Perform Basic Oracle Net Client-Side Configuration

Topic 4D: Configure Oracle Shared Server

Topic 4E: Configure Connect-Time Failover

Lesson 5: Using SQL and PL/SQL

Topic 5A: Write Simple SQL SELECT Statements

Topic 5B: Filter and Sort Data

Topic 5C: Work with SQL Functions

Topic 5D: Work with Multiple Tables

Topic 5E: Modify Data

Topic 5F: Control Database Transactions

Topic 5G: Explore PL/SQL

Lesson 6: Managing the Database Instance

Topic 6A: Obtain Instance Information

Topic 6B: Manage the Database Instance

Topic 6C: Organize Database Objects

Topic 6D: Describe Database Objects and Their Storage

Lesson 7: Managing Tablespaces and Datafiles

Topic 7A: Manage Tablespaces

Topic 7B: Find Tablespace and Datafile Information

Topic 7C: Resize and Drop Tablespaces

Topic 7D: Configure Oracle Managed Files

Lesson 8: Managing Tables and Indexes

Topic 8A: Create Tables

Topic 8B: Gather and Analyze Table Information

Topic 8C: Create Indexes

Topic 8D: Implement Integrity Constraints

Topic 8E: Maintain Integrity Constraints

Lesson 9: Creating Views and Sequences

Topic 9A: Create Views

Topic 9B: Create Sequences

Lesson 10: Managing Users and Security

Topic 10A: Manage Users

Topic 10B: Manage Privileges and Roles

Topic 10C: Manage Passwords and Resource Limits

Topic 10D: Audit Database Usage

Lesson 11: Monitoring Performance

Topic 11A: Manage Locks

Topic 11B: Gather and Use Tuning and Troubleshooting Information

Lesson 12: Loading and Unloading Data

Topic 12A: Manage Data Using the Data Pump

Topic 12B: Move Tablespaces

Topic 12C: Load Data Using SQL*Loader

Topic 12D: Create and Access External Tables

Lesson 13: Managing Undo Data

Topic 13A: Configure Undo Segments and Tablespaces

Topic 13B: Understand Automatic Undo Retention

Lesson 14: Administering and Performing Backups

Topic 14A: Create Redo Log Groups and Members

Topic 14B: Plan and Configure the Online Redo Log Group

Topic 14C: Manage and Maintain Control Files

Topic 14D: Back Up the Database

Topic 14E: Examine Recovery Manager Concepts

Lesson 15: Administering and Performing Recovery Operations

Topic 15A: Manage Recovery

Topic 15B: Employ User-Managed and RMAN Recovery

Topic 15C: Tune Database Recovery

Prerequisites: To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Introduction to Programming, SQL: Fundamentals of Querying, Object-Oriented Programming Java 2 - Object-Oriented Analysis and Design Using UML
...''

Phone:574.287.1053

School Address:

St. Joseph: 2364 S. Cleveland Ave | St Joseph, MI 49085 | 269.983.3903

South Bend: 2750 Foundation Drive| South Bend, IN 46628 | 574.287.1053


Jobs & Resumes: South Bend
Houses & Roommates: South Bend

GroupWise 6.0
Acrobat 7.0
InDesign CS - Level I
InDesign CS - Level II
PageMaker 7.0
Microsoft Publisher 2003
QuarkXPress 6
Lotus Approach ME 9.5
Lotus Notes 6.0 - Database Features
Access 2007
Relational Database
SQL Fundamentals
Oracle 9i
Oracle 8i - SQL, PL/SQL, and SQL*Plus
Illustrator CS
PageMill 3.0
Photoshop CS
CorelDRAW
ColdFusion MX

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.