oraclecoursebooks.com

About this Site

Course books on this site are made available by SkillBuilders, a leading provider of Oracle and IT training, Oracle database consulting and Oracle software since 1985. These course books are produced by experienced Oracle and IT professionals, and are the same high-quality materials used in SkillBuilders' classes.

Feel free to use this online-only material for educational purposes, for self-study or as part of classroom or guided e-learning. You can purchase professionally-bound copies of any course book, complete with scripts and solutions, at SkillBuilders.com. Training vendors can also order printed copies bound in their own company-supplied covers.

Content on this site remains © Skillbuilders and may not be printed, reproduced, redistributed or resold.

Email me when you add new books!

We have several more books we're preparing to release here, and plan to keep
this unique site growing. Be the first to know when new books are online!

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.