| 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). |
|
Click here for lessons on Managing Oracle Tables, Indexes, Constraints, Undo, Redo Logs, Control files, RMAN, Logical Backups (Import and Export Utilities), SQL Loader, Oracle Networking, User Managed Backups and Partitioning. |
|
| Introduction to Oracle Recovery Manager (RMAN) |
This video lesson is the first lesson from SkillBuilders Introduction to Oracle 10g 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 Overview by Example book. It is good preparation for Oracle Certification exam 1Z0-040. |
| Oracle 10g Flashback Enhancements |
This lesson, intended for Oracle DBAs, is an excerpt from our Oracle 10g New Features Overview 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 Oracle 9i Differences for DBAs book. |
| Oracle 10g RMAN Enhancements |
This lesson, intended for Oracle DBAs, is an excerpt from our Oracle 10g New Features Overview 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 book. |
| Using Server Parameter Files (SPFILE) with an Oracle Database |
This lesson, intended for Oracle DBAs, is an excerpt from our Oracle 9i Differences for DBAs book. |
| Oracle 9i SGA Management |
This lesson, intended for Oracle DBAs, is an excerpt from our Oracle 9i Differences for DBAs book. 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. |
|
| 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. |
|
| Using Oracle SQL*Plus |
This introductory Oracle SQL lesson is an excerpt from our Introduction to Oracle: SQL & SQL*Plus book. |
| 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 Overview book. |
| Introduction to Oracle PL/SQL |
This lesson, intended for Oracle Developers and Oracle DBAs, is an excerpt from our PL/SQL Programming book. |
| SQL DECODE and Oracle9i CASE Statement |
This lesson is an excerpt from our Advanced SQL Queries for Oracle9i Databases book. |
| Oracle10g SQL Enhancements |
This lesson, intended for Oracle DBAs and Oracle Developers, is an excerpt from our Oracle 10g New Features Overview book. |
| Introduction to Oracle Application Express |
This lesson, intended for experienced Oracle users, provides a summary of the features found in Oracle Application Express |
|
