top header
top gradation HOME top vertical line top vertical line top vertical line top vertical line top vertical line top vertical line top vertical line menu gray
black line 2
menu gray tab More About ATI
menu blue ATI — Who We Are
white line
menu blue Contact ATI Courses
white line
menu blue List Of ATI Courses
white line
menu blue Attendees Testimonials
white line
menu blue The ATI FAQ Sheet
white line
menu blue Suggestions/Wait List
white line
menu blue New Courses
white line
menu blue Become an ATI Instructor
menu gray tab site resources
menu blue Acoustics & Sonar
white line
menu blue Rockets & Space
white line
menu blue GPS Technology
white line
menu blue ATI Blog
white line
menu blue ATI Space News
white line
menu blue ATI Site Map
white line
menu blue ATI Staff Tutorials
white line
menu blue ATI Sampler Page
white line
menu gray tab bar
menu gray tab courses
white line
menu blue Current Schedule
white line
menu blue Onsite Courses
white line
menu blue Register Online
white line
menu blue Request Brochure
white line
menu blue Free On-Site Price Quote
white line
menu blue Download Catalog
white line
menu blue Distance Learning
black line  

Information Technology

ATI's Oracle 9i DBA Fundamentals I course


Summary:

    Technical Training Short On Site Course Quote

      This course provides the new DBA with the background and tools needed to install and patch Oracle software and set up, operate, and manage Oracle databases. Course covers Oracle9i, Release 1 and 2.

    Prerequisites:

      SQL and PL/SQL for Oracle9i or comparable experience is required.

    Who Should Attend:

      Prospective DBAs, including database operators and application designers and developers, should attend this course.

    Benefits of Attendance:

      Upon completion, students will be able to:

      • start up and shut down an Oracle instance and database;
      • create an operational database;
      • manage physical and logical storage;
      • manage users, privileges, and resources;
      • manage undo and redo data;
      • manage database objects; and
      • manager database storage.

    Course Outline:

      Chapter 1: Oracle Architectural Components

      1. Using the Universal Installer
      2. Describing the Oracle Instance and The System Global Area
      3. Describing the Oracle Database Structure

      Chapter 2: Oracle Tools

      1. Using SQL*Plus
      2. Using Oracle Enterprise Manager Tools

      Chapter 3: Managing an Oracle Instance

      1. Creating and Modifying Initialization Parameter File
      2. Starting and Stopping Instance
      3. Opening and Closing a Database
      4. Monitoring ALERT Log and Trace Files

      Chapter 4: Creating a Database

      1. Creating and Dropping a Database
      2. Creating Tablespaces
      3. Creating Users

      Chapter 5: Data Dictionary Views and Standard Packages

      1. Creating the Data Dictionary
      2. Querying the Dictionary Views
      3. Creating the PL/SQL Environment

      Chapter 6: Maintaing Control Files and Redo Logs

      1. Recreating and Relocating Control Files
      2. Creating Redo Log Groups and Members
      3. Dropping, Moving, and Renaming Redo Logs
      4. Querying the Data Dictionary for Information about Control Files and Redo Logs

      Chapter 7: Managing Undo Data

      1. Understanding the Purpose of Undo Data
      2. Managing Undo Data

      Chapter 8: Managing Tablespaces and Datafiles

      1. Planning File Locations to Optimize Database Performance
      2. Creating, Altering, Coalescing, and Dropping Tablespaces
      3. Adding, Renaming, and Relocating Datafiles

      Chapter 9: Storage Structures and Relationships

      1. Describing the Logical Database Structure
      2. Understanding Block Space Use
      3. Understanding Row Chaining and Migration
      4. Querying the Data Dictionary for Information About Storage Structures and Relationships

      Chapter 10: Managing Rollback and Temporary Segments

      1. Creating, Sizing, and Shrinking Rollback Segments
      2. Creating Temporary Tablespace
      3. Assigning Temporary Tablespace to Users
      4. Using Temporary Tablespaces

      Chapter 11: Magaing Tables

      1. Creating, and Altering Tables
      2. Dropping and Truncating Tables
      3. Analyzing Tables
      4. Querying the Data Dictionary for Information about Tables

      Chapter 12: Managing Indexes

      1. Selecting Correctly From Among Index Types
      2. Creating, Altering and Dropping Indexes
      3. Querying the Data Dictionary for Information about Indexes

      Chapter 13: Maintaing Data Integrity

      1. Creating, Enabling, Disabling and Dropping Constraints
      2. Querying the Data Dictionary for Information about Data Integrity

      Chapter 14: Loading and Reorganizing Data

      1. Using Conventional Path and Direct Path Loading
      2. Using the EXPORT and IMPORT Utilities

      Chapter 15: Managing Users, Profiles, Roles, and Grants

      1. Creating, Altering, Dropping Users
      2. Creating and Using Profiles
      3. Using Password Verification
      4. Granting System and Object Privileges
      5. Creating and Using Roles

      Chapter 16: Using Globalization Support

      1. Choosing Character Set and National Character Set for a Database
      2. Specifying the Language-Dependent Behavior

    Tuition:

      Tuition is $2500 per person at one of our scheduled public courses. Onsite pricing is available. Government personnel qualify for reduced rates. Please call us at 410-956-8805 or send an email to ati@aticourses.com.

    Register Now Without Obligation

spacer