O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle Database Administration Fundamentals I

Video Description

This is the second in a series of courses, aimed at preparing the user for Oracle Certification Exam # 1Z0-031. This course will teach Oracle database administration fundamentals; installing Oracle, creating databases, managing objects in the database and more. This course expands on the first course offered by VTC (Introduction to Oracle SQL and PL/SQL). Following courses will include: Oracle Database Administration Fundamentals II and Oracle Database Performance Tuning. To get started, click one of the movie topics below.

Table of Contents

  1. Part 1 - Welcome
    1. Lession 1.1 - Welcome 00:01:27
    2. Lession 1.2 - Prerequisites for this Course 00:02:20
    3. Lession 1.3 - About this Course 00:04:52
    4. Lession 1.4 - Technet Database Administration Manuals 00:05:54
  2. Part 2 - Database Administration
    1. Lession 2.1 - Oracle Database Administration? pt. 1 00:04:46
    2. Lession 2.2 - Oracle Database Administration? pt. 2 00:05:34
    3. Lession 2.3 - The Basic Architecture of Oracle 00:07:29
  3. Part 3 - Oracle Database Administration Tools
    1. Lession 3.1 - What are the Tools? 00:05:33
    2. Lession 3.2 - SQL*Plus 00:03:30
    3. Lession 3.3 - SQL*Plus Worksheet 00:02:01
    4. Lession 3.4 - iSQL*Plus 00:02:27
    5. Lession 3.5 - All the Other Oracle Tools 00:01:42
    6. Lession 3.6 - Database Configuration Assistant pt. 1 00:07:59
    7. Lession 3.7 - Database Configuration Assistant pt. 2 00:06:43
    8. Lession 3.8 - Oracle Enterprise Manager Console pt. 1 00:06:22
    9. Lession 3.9 - Oracle Enterprise Manager Console pt. 2 00:04:55
    10. Lession 3.10 - The Management Server and the Agent 00:03:03
    11. Lession 3.11 - Net Configuration Assistant and Net Manager 00:05:39
    12. Lession 3.12 - Oracle Enterprise Manager Console pt. 3 00:04:23
    13. Lession 3.13 - Oracle Enterprise Manager Console pt. 4 00:04:41
  4. Part 4 - The Architecture of Oracle
    1. Lession 4.1 - Oracle Database Architecture 00:03:20
    2. Lession 4.2 - Memory Structures 00:06:54
    3. Lession 4.3 - Processes 00:07:19
    4. Lession 4.4 - Datafiles/Tablespaces/Objects 00:07:59
    5. Lession 4.5 - Control Files/Logging/Archiving/Recovery 00:06:48
    6. Lession 4.6 - COMMIT vs ROLLBACK 00:06:22
    7. Lession 4.7 - Rollback and Undo 00:05:11
    8. Lession 4.8 - Temporary Sort Space 00:05:39
    9. Lession 4.9 - How it all Fits Together 00:07:03
    10. Lession 4.10 - Oracle Managed Files 00:05:45
    11. Lession 4.11 - Partitioning 00:05:45
  5. Part 5 - Installing Oracle and Creating a Database
    1. Lession 5.1 - The Oracle Installer pt. 1 00:04:58
    2. Lession 5.2 - The Oracle Installer pt. 2 00:01:52
    3. Lession 5.3 - The Oracle Installer pt. 3 00:03:27
    4. Lession 5.4 - Configuration Parameter Files pt. 1 00:03:51
    5. Lession 5.5 - Configuration Parameter Files pt. 2 00:07:02
    6. Lession 5.6 - SQL*Net Configuration Files 00:05:24
    7. Lession 5.7 - Oracle Optimal Flexible Architecture 00:05:45
    8. Lession 5.8 - Windows Specifics pt. 1 00:03:57
    9. Lession 5.9 - Windows Specifics pt. 2 00:06:27
    10. Lession 5.10 - Creating a Database with a Script pt. 1 00:04:54
    11. Lession 5.11 - Creating a Database with a Script pt. 2 00:04:33
  6. Part 6 - Starting Up and Shutting Down a Database
    1. Lession 6.1 - Connecting to a Database 00:04:54
    2. Lession 6.2 - STARTUP Command pt. 1 00:05:45
    3. Lession 6.3 - STARTUP Command pt. 2 00:05:40
    4. Lession 6.4 - SHUTDOWN Command pt. 1 00:06:51
    5. Lession 6.5 - SHUTDOWN Command pt. 2 00:05:27
    6. Lession 6.6 - Combining STARTUP and ALTER DATABASE 00:01:34
    7. Lession 6.7 - The Oracle Enterprise Manager Console 00:01:43
  7. Part 7 - Configuration Parameters
    1. Lession 7.1 - What is the Parameter File? 00:04:41
    2. Lession 7.2 - Looking at Parameters 00:02:17
    3. Lession 7.3 - The Parameters and What They Do pt. 1 00:05:26
    4. Lession 7.4 - The Parameters and What They Do pt. 2 00:06:53
    5. Lession 7.5 - The Parameters and What They Do pt. 3 00:04:30
  8. Part 8 - DDL and the Physical Database
    1. Lession 8.1 - DDL and the Physical Database? 00:03:55
    2. Lession 8.2 - The ALTER DATABASE Command 00:02:31
    3. Lession 8.3 - Looking at the Database 00:05:23
    4. Lession 8.4 - Changing Datafiles 00:05:19
    5. Lession 8.5 - Sizing of Datafiles 00:04:15
    6. Lession 8.6 - Datafiles and Tempfiles 00:04:22
    7. Lession 8.7 - Control Files 00:07:21
    8. Lession 8.8 - Logfiles and Archives pt. 1 00:04:03
    9. Lession 8.9 - Logfiles and Archives pt. 2 00:06:44
    10. Lession 8.10 - The ALTER SYSTEM Command pt. 1 00:06:14
    11. Lession 8.11 - The ALTER SYSTEM Command pt. 2 00:04:53
    12. Lession 8.12 - Automated Undo/Manual Rollback pt. 1 00:05:45
    13. Lession 8.13 - Automated Undo/Manual Rollback pt. 2 00:02:27
    14. Lession 8.14 - Metadata Views 00:03:49
  9. Part 9 - DDL and the Logical Database
    1. Lession 9.1 - What is the Logical Database? 00:03:08
    2. Lession 9.2 - Tablespace Management pt. 1 00:06:03
    3. Lession 9.3 - Tablespace Management pt. 2 00:07:32
    4. Lession 9.4 - Tablespace Management pt. 3 00:05:51
    5. Lession 9.5 - Metadata Views 00:01:27
  10. Part 10 - Expanding Database Objects
    1. Lession 10.1 - Tables pt. 1 00:03:57
    2. Lession 10.2 - Tables pt. 2 00:03:10
    3. Lession 10.3 - Tables pt. 3 00:04:48
    4. Lession 10.4 - Indexes pt. 1 00:05:38
    5. Lession 10.5 - Indexes pt. 2 00:06:21
    6. Lession 10.6 - Clusters 00:02:33
    7. Lession 10.7 - Index Organized Tables 00:01:54
    8. Lession 10.8 - Sequences 00:02:39
    9. Lession 10.9 - UNDROP, PURGE and the Recycle Bin 00:01:29
    10. Lession 10.10 - Partitioning 00:07:06
    11. Lession 10.11 - Metadata Views pt. 1 00:05:58
    12. Lession 10.12 - Metadata Views pt. 2 00:06:18
  11. Part 11 - Expanding Security for Database Administration
    1. Lession 11.1 - Types of Users 00:01:52
    2. Lession 11.2 - Grants and Revokes 00:01:15
    3. Lession 11.3 - Create and Alter User Syntax 00:03:28
    4. Lession 11.4 - Administration Users 00:07:48
    5. Lession 11.5 - Database Auditing 00:00:54
  12. Part 12 - Scheduling
    1. Lession 12.1 - The DBMS_JOB Package 00:01:51
    2. Lession 12.2 - Job Scheduling in Oracle 00:02:06
    3. Lession 12.3 - Scheduling/Executing Jobs in Windows and Unix 00:05:10
  13. Part 13 - Utilities
    1. Lession 13.1 - Export 00:02:42
    2. Lession 13.2 - Import 00:01:48
    3. Lession 13.3 - SQL*Loader 00:03:54
    4. Lession 13.4 - ORAPWD and ORADIM 00:01:30
  14. Part 14 - Built-In Packages
    1. Lession 14 - Supplied Packages 00:03:37
  15. Part 15 - Scripting for Automation
    1. Lession 15 - Some Example Scripts 00:07:47
  16. Part 16 - Credits
    1. Lession 16 - About the Author 00:02:00