oraclecoursebooks.com

Free Oracle Course Books

Oracle 9i Administration

Description
Provides the foundation skills to create, maintain and manage an Oracle9i database, including day-to-day DBA tasks such as security, creating users, creating objects (tables, tablespaces) and backup and recovery, and an in-depth discussion of database architecture.

Relevance
Preparation for Oracle Certified Professional exam "Oracle9i Database: Fundamentals I Exam #1Z0-031" and some material for the next test, "Oracle9i Database: Fundamentals II Exam #1Z0-032".

Oracle 10g: Backup and Recovery with RMAN

Description
A comprehensive and practical introduction to RMAN including architecture, setup, backup, restore and recovery, recovery catalog maintenance, debugging, tuning and reporting. Every chapter contains many working examples and at least one hands-on workshop.

Relevance
This hands-on class is intended for experienced Oracle technologists** who need to use or evaluate Recovery Manager, Oracle's utility for backup and recovery. However, anyone new to backup and recovery, or currently using user-managed backup techniques, can also benefit from this book.

Oracle 10g: Introduction to PL/SQL Programming

Description
Covers PL/SQL fundamentals for Oracle 10g, and how to create database-intensive PL/SQL applications by writing efficient, scalable programs. Introduces PL/SQL including structure, concepts and language fundamentals; using PL/SQL and SQL including Cursors and Bulk Processing; Stored Procedures; Functions; Error handling; Packages; DML Triggers; Profile and Tuning; file input/output using UTL_FILE and sending email with UTL_MAIL, and new features in PL/SQL for Oracle 10g.

Relevance
Designed especially for developers and analysts with strong programming skills. However, administrators with a programming background can also benefit from this book.