Oracle9i Database Fundamentals 1Z0-031 - Online Course

This series is designed to help users who have experience with relational databases, SQL, and networking prepare for the Oracle 9i 1Z0-031 exam. Users will be introduced to the major components of an Oracle server and the database structure, and will learn how to create and manage such components as databases, instances, tablespaces, tables, datafiles, storage units, undo data, tables, indexes, data integrity, users, profiles, privileges, and roles.

This series is for anyone preparing for the Oracle 1Z0-031: Oracle9i DBA Fundamentals I exam, or anyone who wants an introduction to Oracle database fundamentals. This online course contains 10 lessons and should take approximately 29 hours to complete.

Lesson 1: Oracle Architecture and Tools (3.0) hours

Oracle Architecture and Tools teaches you how to explain the Oracle server architecture, identify how users connect to the Oracle server, list tools used by DBAs to administer Oracle, describe the benefits of Optimal Flexible Architecture, and install Oracle using Oracle Universal Installer. This course introduces users to the major components of an Oracle server. Topics include Oracle Server Architecture, The Server Process, Connecting to Oracle Servers, Processing Queries, Processing DML Statements, Processing Commit Statements, Common Database Administration Tools, Oracle Universal Installer, Installing Oracle9i Database, Optimal Flexible Architecture, Oracle Authentication, Using Operating System Authentication, Using Password File Authentication, and Oracle Enterprise Manager Components.

Lesson 2: Managing Instances and Creating Databases (3.0) hours

Managing Instances and Creating Databases teaches you how to create and manage an initialization parameter file, configure Oracle-managed files, use the startup command, list the different options available for starting Oracle, shut down an Oracle instance, describe the two types of diagnostic files used in Oracle, list the prerequisites necessary for database creation, list values that must be set in the parameter file, use the Database Configuration Assistant, create a database with the create database command, define a character set for your database, configure language-dependent behavior for the your database, and retrieve NLS information from the your database. This course introduces users to managing an Oracle instance, creating a database, and using globalization parameters. Topics include Creating an Initialization Parameter File, Configuring Oracle-Managed Files, Starting an Instance using SQL*Plus, Startup Methods and Options, Shutting Down an Instance, Using Diagnostic Files, Planning for Database Creation, Preparing the Parameter File, Using the Database Configuration Assistant, Creating a Database Manually, Choosing a Character Set, Specifying Language-Dependent Behavior, and Viewing Globalization Support Information.

Lesson 3: Managing the Database Structure (3.0) hours

Managing the Database Structure teaches you how to use data dictionary views, query the data dictionary, use control files, and work with redo logs. This course introduces users to data dictionaries, control files, and redo log files. Topics include Constructing Data Dictionary Views, Tables and Views, Data Dictionary Contents, Querying the Data Dictionary, Using Control Files, Control File Contents, Using Oracle-Managed Files, Viewing Control File Information, Multiplexing Control Files, Redo Log Files, Controlling Log Switches and Checkpoints, Maintaining Redo Log Files, and Using OMF to Manage Redo Log Files.

Lesson 4: Managing Tablespaces and Datafiles (2.0) hours

Managing Tablespaces and Datafiles teaches you how to describe the logical structure of Oracle databases, create tablespaces, manage temporary segments, take tablespaces online and offline, change tablespace storage settings, and use Oracle-Managed Files (OMF) with tablespaces. This course introduces users to creating and managing tablespaces. Topics include Oracle's Logical Structure, Understanding Tablespaces, Creating Tablespaces, Changing Tablespace Size, Using Temporary Segments, Managing Uniform Extent Sizing, Changing Tablespace Status, Changing Tablespace Storage Settings, and Using OMF with Tablespaces.

Lesson 5: Managing Storage Structures and Undo Data (4.0) hours

Managing Storage Structures and Undo Data teaches you how to identify storage needs for different segment types, control the size allocation of extents and segments, acquire extents in dictionary-managed tablespaces, use multiple extents when using parallel processors, list the keywords that control block space usage, obtain information about storage from the data dictionary, describe the purpose of undo data, implement automatic undo management, create and configure undo segments, size OLTP and batch undo segments, and maintain undo segments manually. This course introduces users to the underlying storage structure of a database and to using undo segments. Topics include Types of segments, Acquiring and managing segments and extents, Controlling block space usage, Obtaining information about storage structures, Using undo data, Implementing automatic undo Management, and Creating, configuring, and maintaining undo Segments manually.

Lesson 6: Managing Tables (3.0) hours

Managing Tables teaches you how to explain how tables can store data, create permanent and temporary tables, manage storage structures, relocate tables, and drop unused columns. This course introduces users to creating and managing table structures. Topics include Storing Data, Distinguishing Oracle Datatypes, Extended and Restricted ROWIDs, Row Structure, Creating Permanent and Temporary Tables, Managing Storage Structures, Managing Tables, and Dropping Columns.

Lesson 7: Managing Indexes and Data Integrity (3.0) hours

Managing Indexes and Data Integrity teaches you how to describe the different types of indexes and their uses, create various types of indexes, reorganize and drop indexes, monitor index usage, implement data integrity constraints, maintain integrity constraints, and obtain index and constraint information from the data dictionary. This course introduces users to indexes and data integrity constraints. Topics include Index Types, Function-Based and Descending Indexes, Creating B-Tree and Bitmap Indexes, Reorganizing Indexes, Dropping Indexes and Getting Index Information, Monitoring Use of Indexes, Implementing Data Integrity Constraints, Using Deferred Constraints, Maintaining Integrity Constraints, and Obtaining Constraint Information.

Lesson 8: Managing Users and Profiles (2.0) hours

Managing Users and Profiles teaches you how to create new database users, manage existing users, monitor information about existing users, control resource use with profiles, administer profiles, manage passwords using profiles, and obtain profile information from the data dictionary. This course introduces users to creating and managing users and to control resources using profiles. Topics include Creating New Users, User Account Guidelines, Altering and Droping Existing Users, Monitoring User Information, Controlling Resource Use with Profiles, Administering Profiles, Administering Passwords Using Profiles, and Obtaining Profile Information.

Lesson 9: Managing Privileges and Roles (3.0) hours

Managing Privileges and Roles teaches you how to identify system and object privileges, grant and revoke privileges, identify auditing capabilities, create and modify roles, control availability of roles, remove roles, use predefined roles, and display role information from the data dictionary. This course introduces users to system and object privileges and user roles. Topics include System Privileges, Special and Object Privileges, Granting and Revoking Privileges, Granting Administrative Abilities, Identifying Audit Capablitities, Using the Audit Command, Managing Auditing, Creating and Modifying Roles, Controlling Availability of Roles, Using Predefined Roles, and Displaying Role Information.

Lesson 10: Exam Preparation (3.0) hours

Exam Preparation teaches you how to after completing this course, the user should be familiar with all the exam objectives for the Oracle 1Z1-031: Oracle9i DBA Fundamentals I exam. This course allows users to practice answering questions in order to prepare for taking the exam. Topics include This course covers all of the objectives for the certification exam.