Free Retired Oracle Database Tutorials

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

Tutorial TitleDescription
Oracle Database Administration class
Lesson 1. Introduction to the Oracle Data DictionaryThis 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: FilesAn introduction to Oracle Architecture with an in-depth look at the operating system files that make up the database.
Lesson 3. Oracle 9i Architecture: ProcessesAn overview of Oracle Background Processes.
Lesson 4. Oracle 9i Architecture: MemoryAn in-depth lesson on the memory areas used by the Oracle Database such as the SGA and PGA.
Lesson 5. Creating Oracle Administrative UsersA practical and hands-on lesson on creating and using Oracle administrative users.
Lesson 6. Starting and Stopping an Oracle InstanceAn 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 filesLearning 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 UsersAdministrative processes needed to create and manage all users of the Oracle database.
Lesson 9. Oracle Password ManagementA hands-on lesson on Oracle password aging, locking and complexity routines.
Lesson 10. Introduction to Oracle Database AuditingA hands-on tutorial on recording user activity in the Oracle Database.
Lesson 11. Managing Oracle SecurityA discussion of Security related tasks for the Oracle DBA.
Lesson 12. Managing Oracle TablespacesCreating and managing locally managed tablespaces, including a discussion of Automatic Segment Storage Management (ASSM) and Oracle Managed Files (OMF).
Lesson 13. Managing Oracle TablesThis 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 UndoUsing 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 & RecoveryAn 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 PartitioningA brief discussion of Oracle partitioning
Appendix C. Other Table TypesA description of other Oracle table types including: IOTs; temp tables; Indexed Clustered; Hash Clustered; Nested and Object tables.
Appendix D. Fine Grained AuditingAn 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 FeaturesThis 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 EnhancementsThis 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 DataGuardThis lesson, intended for experienced Oracle users, provides a summary of the features found in Oracle 10g Dataguard
Oracle 9i Performance and Tuning EnhancementsThis lesson, intended for Oracle DBAs and Oracle Developers, is an excerpt from our Differences for Developers course.
Oracle 10g RMAN EnhancementsThis 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 DatabaseThis 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 TuningThis lesson will provide you with a foundation in Oracle SQL Tuning.
Lesson 2. Oracle SQL Statement ProcessingThis lesson provides an introduction to what is involved in executing a SQL statement, including the related Oracle architecture.
Lesson 3. Creating & Reading Oracle Execution PlansThis 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 EventThis lesson provides a practical introduction to Oracle SQL Trace, TKPROF and the 10053 Event Trace.
Lesson 5. Getting to Know CBOThis is a discussion in effective use of the Oracle Cost-Based Optimizer (CBO).
Lesson 6. All About B-Tree Indexes in OracleThis 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 TransformationsThis 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 IndexesA 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*PlusThis introductory Oracle SQL lesson is an excerpt from our Introduction to Oracle SQL & SQL*Plus course.
Introduction to the Oracle SQL SELECT StatementThis introductory Oracle SQL lesson is an excerpt from our Introduction to Oracle: SQL & SQL*Plus book.
Oracle10g SQL*Plus EnhancementsThis lesson, intended for a general audience, is an excerpt from our Oracle10g New Features by Example book.
Introduction to Oracle PL/SQLThis lesson, intended for Oracle Developers and Oracle DBAs, is an excerpt from our PL/SQL Programming course.
SQL DECODE and Oracle9i CASE StatementThis lesson is an excerpt from our Advanced SQL Queries for Oracle Databases course.
Oracle10g SQL EnhancementsThis lesson, intended for Oracle DBAs and Oracle Developers, is an excerpt from our Oracle 10g New Features by Example book.
Introduction to Oracle Application ExpressThis 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 EnhancementsThis 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 FunctionsThis is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.
Oracle9i Advanced Data AccessThis is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.
Oracle9i Grouping DataThis is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.
Oracle9i DML and Transaction ControlThis is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.
SQL*Plus ReportingThis is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.
Oracle9i Tables and ConstraintsThis is excerpted from our Introduction to Oracle: SQL & SQL*Plus course.
Views & SynonymsThis 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 EnhancementsThis 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 DatabaseThis 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.
Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

 

×