Sun Microsystems, Inc.
spacer spacer
spacer   Sun Educational Services  
spacer
black dot
  black fade
spacer
  Course Catalog
logo

Database Creation and Architecture

( WT-1250-180 )


     Course DescriptionBack To Top

Course Offered in Partnership With DigitalThink

This course is designed to give students a firm foundation in basic Oracle8 database administrative tasks. Students will gain the necessary knowledge and skills to set up, maintain, and troubleshoot an Oracle8 database.

In conjunction with the other four courses in the Oracle8 Database Administration Certification Series, this course helps students prepare for Oracle Certified Professional Exam number 1Z0-013, Oracle8: Database Administration, part of the Oracle8 DBA certification track.

This course requires a computer running either Windows, Macintosh, or UNIX.

eMentoring Services are included with this course.

  • Course length: 8 hours

    • Course details
        id:      WT-1250-180
        subscription duration:  180 days
        list price:  $  325.00


     
         Languages Offered Back To Top

    This course is currently available in English only.

     
         Prerequisites Back To Top

    To succeed fully in this course, students should be able to:

  • Demonstrate familiarity with SQL

    •  
         Skills Gained Back To Top

    Upon completion of this course, you should be able to:

  • Start up and shut down an Oracle instance and database
  • Create an operational database
  • Find the files in a database, and identify their purpose
  • Identify the processes that operate on a database
  • Understand the significant memory structures of a database instance

    •  
         Related Courses Back To Top

  • After: Managing Users and Connectivity
  • After: Managing Database Objects
  • After: Administrative Tasks
  • After: Extended Database Features

    •  
         Course Content Back To Top



    Module 1: Course Introduction Back To Top

  • Course Introduction
  • Prerequisites
  • What you need
  • What to expect
  • Meet your tutors
  • The course database
  • Meet your instructor


    • Module 2: Oracle Server Manager Back To Top

  • Oracle Server Manager
  • Server Manager
  • Locating Oracle Home
  • Locating the Server Manager executable file
  • Starting Server Manager
  • Some common Server Manager Commands
  • The EXIT Command
  • When you make a mistake
  • The HELP Command
  • The DESCRIBE Command
  • The SPOOL Command
  • Using Server Manager to execute SQL statements
  • Module Wrap-up


    • Module 3: Understanding Oracle Database Architecture Back To Top

  • Understanding Oracle Database Architecture
  • Database file overview
  • The initialization file
  • The Control File
  • Datafiles
  • Tablespaces
  • Looking at Tablespaces
  • Redo Logs
  • Preserve your redo logs
  • Oracle cycles through redo logs
  • Looking at redo log information
  • Archived Redo Logs
  • Module wrap-up


    • Module 4: Understanding Oracle8 Instance Architecture Back To Top

  • Understanding Oracle8 Instance Architecture
  • The difference between an instance and a database
  • Instance Overview
  • Process Coordination
  • The System Global Area (SGA)
  • The System Monitor (SMON)
  • The Process Monitor (PMON)
  • The Database Writer (DBW0)
  • When does the database writer write?
  • Writing out dirty buffers to make room for new data
  • Advancing the checkpoint
  • Limiting the number of dirty buffers
  • The Log Writer (LGWR)
  • The log-writing process
  • The Archiver (ARC0)
  • The ARCHIVE LOG LIST command
  • The Checkpoint process (CKPT)
  • Other processes
  • Module wrap-up


    • Module 5: Understanding Oracle8's Memory Architecture Back To Top

  • Understanding Oracle8's Memory Architecture
  • The System Global Area (SGA)
  • The database buffer cache
  • Multiple buffer pools
  • The redo log buffer
  • The shared pool
  • Matching SQL statements
  • The large pool
  • Program Global Areas
  • Contents of the Program Global Areas
  • Sort Areas
  • Module wrap-up


    • Module 6: Preparing to create a database Back To Top

  • Preparing to create a database
  • Preparation for this module
  • The Optimal Flexible Architecture
  • The database initialization file
  • Deciding on file locations
  • Setting the block size
  • Deciding on file sizes
  • Sizing the SGA
  • Other parameter settings
  • Module wrap-up


    • Module 7: Creating a database Back To Top

  • Creating a database
  • Writing the CREATE DATABASE command
  • Creating a new Oracle service (Windows NT only)
  • Starting an instance
  • Executing the CREATE DATABASE command
  • Changing the System Passwords
  • Running the CATALOG Script
  • Running the PUPBLD Script
  • The product user profile
  • Creating initial tablespaces
  • Creating additional rollback segments
  • Module wrap-up


    • Module 8: Starting and stopping an instance Back To Top

  • Starting and stopping an instance
  • The SHUTDOWN command
  • The STARTUP command
  • Restricted session mode
  • Starting and stopping the NT service
  • Using ORADIM to start and stop the service
  • Setting the database for autostart
  • Module wrap-up


    • Module 9: Course wrap-up Back To Top

  • Course wrap-up
  • Where you go from here
  • We'd love your feedback
  • Help us help you learn!


    • Terms of Use.  Privacy Policy.  Feedback.  Copyright 1994-2002 Sun Microsystems, Inc.