Oracle Database 11g Administration I (1Z0-052) - Online Course

The Oracle Database 11g: Administration I study guide will prepare you to become certified as an Oracle Database 11g Administrator Certified Associate as well as laying the foundation for the Oracle Database 11g Administrator Certified Professional certification. This series will cover some of the more in-depth database administration topics, such as configuration, security, backups, and recovery. These topics, along with a strong emphasis on database management, will prepare you for the exam.

This series is for anyone who is preparing for the Oracle Database 11g Administration I (1Z0-052) exam. This online course contains 10 lessons and 3 practice exams and should take approximately 22 hours to complete.

Lesson 1: Database Components and Architecture (2.0) hours

Database Components and Architecture teaches you how to explain the Memory Structures, describe the Process Structures, outline Storage Structures, identify the tools for Administering an Oracle database, plan an Oracle Database installation, and install the Oracle software by using Oracle Universal Installer (OUI). This course provides an overview of Oracle 11g components and architecture. It also covers how to install Oracle 11g and how to create a database. Topics include Database Components and Architecture.

Lesson 2: Creating a Database (2.0) hours

Creating a Database teaches you how to create a database by using the Database Configuration Assistant (DBCA), set database initialization parameters, describe the stages of database startup and shutdown, use alert log and trace files, and use data dictionary and dynamic performance views. This course provides a overview on creating an Oracle 11g database using the Database Configuration Assistant. Topics include Creating a Database, and Working with Oracle 11g.

Lesson 3: Database Storage and Schema Objects (3.0) hours

Database Storage and Schema Objects teaches you how to manage Database Storage Structures, describe tablespaces and data files, create and manage tablespaces, describe space management in tablespaces, manage Schema Objects, create and modify tables, manage constraints, create indexes, and create and use temporary tables. This course provides an overview of storing data in Oracle databases. Topics include Database Storage and Schema Objects, and Working with Schema Objects.

Lesson 4: Determining the Correct Network Architecture (2.0) hours

Determining the Correct Network Architecture teaches you how to configure the Oracle Network Environment, configure and manage the Oracle Network, and use the Oracle Shared Server architecture. This course provides an overview of Oracle network architecture and types of network configurations. Topics include Determining the Correct Network Architecture.

Lesson 5: Implementing Security and Auditing (2.0) hours

Implementing Security and Auditing teaches you how to administer User Security, create and manage database user accounts, grant and revoke privileges, create and manage roles, create and manage profiles, implement Oracle Database Security, describe database security and the principle of least privilege, and work with standard database auditing. This course provides an overview of user security and how to implement security for an Oracle database. Topics include Implementing Security and Auditing.

Lesson 6: Managing Data and Undo (1.0) hour

Managing Data and Undo teaches you how to manage data and concurrency, manage data using DML, identify and administer PL/SQL objects, monitor and resolve locking conflicts, manage undo data, provide an overview of undo, explain transactions and undo data, and manage undo. This course provides an introduction to managing data in Oracle. Topics include Managing Data and Undo.

Lesson 7: Managing Performance and Maintaining the Database (2.0) hours

Managing Performance and Maintaining the Database teaches you how to use and manage Optimizer Statistics, use and manage Automatic Workload Repository (AWR), use Advisory Framework, manage Alerts and Thresholds, use Automatic Memory Management, use Memory Advisors, and troubleshoot invalid and unusable objects. This course provides information on general database maintenance and how to effectively manage database performance. Topics include Maintaining the Database, and Managing Performance.

Lesson 8: Implementing Database Backups (2.0) hours

Implementing Database Backups teaches you how to explain backup and recovery concepts, identify the importance of checkpoints, redo log files, and archived log files, describe the flash recovery area, configure ARCHIVELOG mode, perform database backups, create consistent database backups, back up your database without shutting it down, create incremental backups, automate database backups, and manage backups, view backup reports and monitor the flash recovery area. This course provides information on backing up and recovering your Oracle database. Topics include Implementing Database Backups.

Lesson 9: Recovering the Database (1.0) hour

Recovering the Database teaches you how to identify the types of failure that can occur in an Oracle database, describe ways to tune instance recovery, provide an overview of Data Recovery Advisor, and use Data Recovery Advisor to perform recovery (control file, redo log file, and data file). This course provides an overview of the types of failure that can occur in an Oracle database. It also covers how to recover data. Topics include Recovering the Database.

Lesson 10: Moving Data and Using EM Tools (2.0) hours

Moving Data and Using EM Tools teaches you how to describe and use methods to move data, including directory objects, SQL*Loader, and external tables, explain the general architecture of Oracle Data Pump, use Data Pump Export and Import to move data between Oracle databases, use the Enterprise Manager Support Workbench, and manage Patches. This course provides an overview of methods used to move data in an Oracle database. Topics include Moving Data and Using EM Tools.

3 Practice Exams

This course presents questions that will help you prepare for the Oracle Database 11g Administration I (1Z0-052) exam.