Oracle Database Administration -- The Complete Video Course

by Caffrey, Melanie; Scherer, Douglas

• ISBN13: 9780130321237
• ISBN10: 0130321230
• Edition: 1st
• Format: Paperback
• Copyright: 2000-12-01
• Publisher: Prentice Hall PTR

Summary

THE CONTENTS OF THIS PACKAGE INCLUDES:

Fully Integrated Book/QuickTime Video Package-Expert Training at an Incredible Value!!

CD-ROM contains 3 1/2 hours of QuickTime video instruction PLUS the Oracle DBA Interactive Workbook e-Book!

Master the basics of Oracle database administration—now! Managing the database and its physical layout, ensuring security and data integrity, providing for backups, PLUS the History of Oracle Networking.

Includes 3 1/2 hours of expert QuickTime video instruction by Columbia University instructors Melanie Caffrey & Douglas Scherer.

YOUR COMPLETE INTRODUCTION TO BECOMING AN ORACLE DBA

See it, hear it, do it! Don't just read about database administration. Watch and listen as your instructors use 31/2 hours of QuickTime video instruction to cover the key topics, and then add step-by-step digital videos, real-world labs, exercises, projects, and insight from the trenches to explore what it means to be an Oracle DBA.

LEARN THE FUNDAMENTALS OF GREAT DATABASE ADMINISTRATION FROM THE PROS!

First, watch QuickTime video lectures as your instructors walk through every key concept

Then, watch 14 "over the shoulder" digital videos that show you how it's done step by step

Next, read related sections in the book for more detailed coverage

Work through hundreds of hands-on labs and exercises

Finally, do your "homework"—real-world "Test Your Thinking" projects

Key Topics

• Covers all key aspects of day-to-day Oracle database administration, including:
• Creating new databases
• Managing physical database layouts
• Administering users, privileges, and resource groups
• Tuning Oracle and SQL code for maximum performance
• Security, auditing, and data integrity
• Backup, recovery, and much more!

SPECIALLY DESIGNED FOR

Oracle developers

Web/e-Business professionals

DBAs migrating from other platforms

PREREQUISITES

Basic understanding of relational database concepts, Entity Relationship Diagrams, SQL, and command line environment. No DBA experience necessary!

TOTAL RUNNING TIME: 3 HOURS 43 MINUTES

Includes the Oracle DBA Interactive Workbook

Experience the skills you need! You'll learn hands-on, through practical exercises, self-review questions, and real-world answers. Exclusive "Test Your Thinking" exercises lead you to a practiced understanding of the essential Oracle DBA skills.

SYSTEM REQUIREMENTS

For Windows

300 MHz processor or higher

Windows 95/98/NT 4.0x

For Macintosh

PowerPC 300 MHz processor or higher

System 8.0 or above

HARDWARE REQUIREMENTS

32 MB disk space/64 MB RAM

12x CD-ROM drive and sound card support

Netscape 4.08 (included)

QuickTime 4.1 (included)

Adobe Acrobat Reader 4.0 (included)

Table of Contents

Video Lectures.
Lecture 1 The Database Administrator's Job.
Lecture 2 Creating Your Database.
Lecture 3 Oracle Networking: Configuring Basic Net8/SQL*Net Components.
Lecture 4 Tablespaces.
Lecture 5 Segments and Extents.
Lecture 6 Data Blocks.
Lecture 7 Redo Logs.
Lecture 8 Datafiles.
Lecture 9 User Creation.
Lecture 10 Privilege and Resource Groups.
Lecture 11 Auditing.
Lecture 12 Rollback Segments.
Lecture 13 Locking.
Lecture 14 Logical Backup and Recovery.
Lecture 15 Physical Backup and Recovery.
Lecture 16 Application & SQL Optimization.
Lecture 17 Database Tuning & Optimization.