Back

Free Retired Oracle Database Tutorials

These self-paced tutorials, once used as course books, are a bit old, but free. Enjoy!

Tutorial Title Description
Oracle Database Administration class
Lesson 1. Introduction to the Oracle Data Dictionary This tutorial provides an Introduction to the Oracle Data Dictionary from the perspective of the DBA. Diagrams, examples and queries against the Oracle Data Dictionary views support the descriptive text.
Lesson 2. Oracle 9i Architecture: Files An introduction to Oracle Architecture with an in-depth look at the operating system files that make up the database.
Lesson 3. Oracle 9i Architecture: Processes An overview of Oracle Background Processes.
Lesson 4. Oracle 9i Architecture: Memory An in-depth lesson on the memory areas used by the Oracle Database such as the SGA and PGA.
Lesson 5. Creating Oracle Administrative Users A practical and hands-on lesson on creating and using Oracle administrative users.
Lesson 6. Starting and Stopping an Oracle Instance An in-depth, hands-on lesson on using the Oracle STARTUP and SHUTDOWN commands to start and stopn an Oracle database.
Lesson 7. Oracle Initialization Parameter files Learning how to start an Oracle database with non-default parameter files, change parameter values and work with 9i SPFILES.
Lesson 8. Creating and Managing Oracle Users Administrative processes needed to create and manage all users of the Oracle database.
Lesson 9. Oracle Password Management A hands-on lesson on Oracle password aging, locking and complexity routines.
Lesson 10. Introduction to Oracle Database Auditing A hands-on tutorial on recording user activity in the Oracle Database.
Lesson 11. Managing Oracle Security A discussion of Security related tasks for the Oracle DBA.
Lesson 12. Managing Oracle Tablespaces Creating and managing locally managed tablespaces, including a discussion of Automatic Segment Storage Management (ASSM) and Oracle Managed Files (OMF).
Lesson 13. Managing Oracle Tables This lesson begins with a brief overview of the eight different types of tables that the Oracle Database provides. The remainder of the lesson will concentrate on the most common type of table – heap tables. Not only will you learn how to create heap tables, you will also learn the practical management skills you will need for day to day table management tasks such as managing concurrency with INITRANS and MAXTRANS,
moving tables, using DBMS_STATS to collect statistics for the cost based optimizer, increasing performance by turning off redo logging, compressing tables and simple techniques for measuring DML performance.
Lesson 14. Oracle B-Tree Indexes This lesson covers Oracle B-tree indexes. We will learn what they are, what makes them work (organization) and many other things that will let you put them to good use, including turning off redo logging when creating indexes to increase performance, collecting statistics with DBMS_STATS, making intelligent decisions on what columns should be indexed, when and how to create multi-column (composite) indexes, using index compression and when and where to create indexes.
Lesson 15. Oracle Table Constraints This lesson will teach you about Oracle table constraints. After you learn what they are, we will discuss what I hope are the most common techniques and issues related to constraints, including creating contraints, violating constraints, using the NOVALIDATE option to add a constraint without validating existing data, disabling constraints and dropping and renaming constraints. As always, you will also learn about the Oracle data dictionary views related to this topic.
Lesson 16. Managing Undo Using Automatic Undo Mangement (AUM) to manage undo in the Oracle database.
Lesson 17. Managing Redo Logs Effective management of Oracle Redo Logs
Lesson 18. Managing Control Files How to protect, add, backup and recreate Oracle Control files
Lesson 19. Introduction to RMAN An introduction to Oracle RMAN. You will learn what it is and how to make use of basic, critical backup and recovery techniques.
Lesson 20. Logical Backups – Import and Export A lesson describing using the import and export utilities to perform logical backups of the Oracle database.
Lesson 21. Loading with SQL*Loader Loading data with the Oracle SQL*Loader utility.
Lesson 22. Introduction to Oracle Networking A practical introduction to get you started with Oracle Net.
Lesson 23. Creating a new Database A discussion on using the Database Configuration Assistant to create a new database.
Appendix A. User Managed Backup & Recovery An overview discussing database failure scenarios; strategies; archiving; hot and cold user-managed backups; complete user-managed recovery and point-in-time recovery.
Appendix B.Implementing Partitioning A brief discussion of Oracle partitioning
Appendix C. Other Table Types A description of other Oracle table types including: IOTs; temp tables; Indexed Clustered; Hash Clustered; Nested and Object tables.
Appendix D. Fine Grained Auditing An introduction to Fine Grained Auditing in the Oracle Database.
Oracle 9i and 10g New Features Tutorials for Database Administrators (back to top)
Introduction to Oracle Recovery Manager (RMAN) This video lesson is the first lesson from SkillBuilders Backup & Recovery with RMAN course. This training will teach you what RMAN is and explain the basic features of RMAN.
Oracle 10g Backup Recovery RMAN New Features This lesson, intended for Oracle DBAs, covers 10g features related to RMAN and backup and recovery. It is an excerpt from our Oracle 10g New Features by Example book. It is good preparation for Oracle Certification exam 1Z0-040.
These lessons require Free Registration.
Oracle 10g Flashback Enhancements This lesson, intended for Oracle DBAs, is an excerpt from our Oracle 10g New Features by Example book. This tutorial is also helpful preparation for Oracle Certification exam 1Z0-040.
Oracle10g: Intro to DataGuard This lesson, intended for experienced Oracle users, provides a summary of the features found in Oracle 10g Dataguard
Oracle 9i Performance and Tuning Enhancements This lesson, intended for Oracle DBAs and Oracle Developers, is an excerpt from our Differences for Developers course.
Oracle 10g RMAN Enhancements This lesson, intended for Oracle DBAs, is an excerpt from our Oracle 10g New Features by Example book. It will help you prepare for Oracle Certification exam 1Z0-040.
Introduction to Oracle Recovery Manager (RMAN) This lesson, intended for Oracle DBAs, is an excerpt from our Backup & Recovery with RMAN course.
Using Server Parameter Files (SPFILE) with an Oracle Database This lesson, intended for Oracle DBAs, is an excerpt from our Differences for Developers course.
Oracle 9i SGA Management This lesson, intended for Oracle DBAs, is an excerpt from our Differences for Developers course. This tutorial covers SGA-related parameters such as DB_CACHE_SIZE and SGA_MAX_SIZE, multiple database block size support (subcaches), how to dynamically change shared memory allocations (including examples of v$sga_dynamic_components) and the cache advisories.
Oracle SQL Tuning for Developers and DBAs (back to top)
Lesson 1. Introduction to Oracle SQL Tuning This lesson will provide you with a foundation in Oracle SQL Tuning.
Lesson 2. Oracle SQL Statement Processing This lesson provides an introduction to what is involved in executing a SQL statement, including the related Oracle architecture.
Lesson 3. Creating & Reading Oracle Execution Plans This is a hands-on, in-depth lesson on displaying and reading Oracle execution plans, including how to use EXPLAIN PLAN, V$SQL_PLAN and SQL*Plus Autotrace.
Lesson 4. Oracle SQL Trace & 10053 Event This lesson provides a practical introduction to Oracle SQL Trace, TKPROF and the 10053 Event Trace.
Lesson 5. Getting to Know CBO This is a discussion in effective use of the Oracle Cost-Based Optimizer (CBO).
Lesson 6. All About B-Tree Indexes in Oracle This lesson will provide an introduction to Oracle B-Tree indexes.
These lessons are more advanced and require Free Registration.
Lesson 7 Access Paths This guide to many of the techniques Oracle uses to retrieve data.
Lesson 8 CBO Transformations This lesson provides an introduction to some of the techiques CBO will use to transform a query, including bitmap conversions, OR to UNION and view merging.
Lesson 9 SQL Coding Tips This lesson provides suggestions, ideas and tips for improving the performance of SQL statements.
Lesson 10 Join Methods This provides a practical introduction to the join methods available to the Oracle9i cost-based optimizer.
Lesson 11 Bind Variables This lesson is a discussion emphasizing the importance of bind variables and “shared pool reuse”.
Lesson 12 Table Types This provides an introduction to the affect that the Oracle table types (and related options) have on SQL performance.
Lesson 13 More B-Tree Indexes A further study of B-Tree Indexes
Lesson 14 Other Indexes This lesson provides an introduction to bitmap, bitmap join and function-based indexes in Oracle9i.
Appendix A Hints A partial list of optimizer hints
Appendix B Oracle10g Tuning Features An excerpt from SkillBuilders’ Oracle10g New Features By Example book.
Appendix C Concurreny Control A discussion of Concurrency control concepts, row lock architecture, locking rules, types of locks and application locking issues.
Introduction to SQL, PL/SQL, Application Express and More (back to top)
Using Oracle SQL*Plus This introductory Oracle SQL lesson is an excerpt from our Introduction to Oracle SQL & SQL*Plus course.
Introduction to the Oracle SQL SELECT Statement This introductory Oracle SQL lesson is an excerpt from our Introduction to Oracle: SQL & SQL*Plus book.
Oracle10g SQL*Plus Enhancements This lesson, intended for a general audience, is an excerpt from our Oracle10g New Features by Example book.
Introduction to Oracle PL/SQL This lesson, intended for Oracle Developers and Oracle DBAs, is an excerpt from our PL/SQL Programming course.
SQL DECODE and Oracle9i CASE Statement This lesson is an excerpt from our Advanced SQL Queries for Oracle Databases course.
Oracle10g SQL Enhancements This lesson, intended for Oracle DBAs and Oracle Developers, is an excerpt from our Oracle 10g New Features by Example book.
Introduction to Oracle Application Express This lesson, intended for experienced Oracle users, provides a summary of the features found in Oracle Application Express
SQL, PL/SQL, 9i and 10g New Features (back to top)
These lessons are more advanced and require Free Registration.
Oracle10g PL/SQL Enhancements This is a succinct summary of the enhancements that Oracle10g brings to PL/SQL. Note that this is excerpted from our Oracle10g New Features by Example book.
Oracle9i Functions This is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.
Oracle9i Advanced Data Access This is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.
Oracle9i Grouping Data This is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.
Oracle9i DML and Transaction Control This is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.
SQL*Plus Reporting This is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.
Oracle9i Tables and Constraints This is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.
Views & Synonyms This is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.
Oracle10g Flashback Enhancements This lesson, intended for Oracle DBA’s, is an excerpt from our Oracle10g New Features by Example book.
It will help you prepare for Oracle Certification exam 1Z0-040.
Oracle10g: Intro to DataGuard This lesson, intended for experienced Oracle users, provides a summary of the features found in Oracle10g Dataguard
Oracle9i Performance and Tuning Enhancements This lesson, intended for Oracle DBA’s and Oracle Developers, is an excerpt from our Differences for Developers course.
Oracle 10g RMAN Enhancements This lesson, intended for Oracle DBA’s, is an excerpt from our Oracle10g New Features by Example book. It will help you prepare for Oracle Certification exam 1Z0-040.
Introduction to Oracle Recovery Manager (RMAN) This lesson, intended for Oracle DBA’s, is an excerpt from our Backup & Recovery with RMAN course.
Using Server Parameter Files (SPFILE) with an Oracle Database This lesson, intended for Oracle DBAs, is an excerpt from our Differences for Developers course.
Oracle9i SGA Management This lesson, intended for Oracle DBAs, is an excerpt from our Differences for Developers course. This tutorial covers SGA-related parameters such as DB_CACHE_SIZE and SGA_MAX_SIZE, multiple database block size support (subcaches), how to dynamically change shared memory allocations (including examples of v$sga_dynamic_components) and the cache advisories.