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

Database » Oracle

Only $99.95

ONLINE Oracle TRAINING FEATURES

  • Learn Oracle online with these interactive online Oracle courses.
  • Affordable Pricing (Only $99.95 for the complete series)
  • A full year to complete the Oracle courses
  • Retake the Oracle courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test
  • Oracle Database 11g Administration I (1Z0-052) Series (22 hours)

1. Oracle Database 11g Administration I (1Z0-052):1 Database Components and Architecture

Time: 2 hours
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.

Objectives

  • Explain the Memory Structures
  • Describe the Process Structures
  • Outline Storage Structures
  • Identify the tools for Administering an Oracle database
  • Plan an Oracle Database installation
  • Install the Oracle software by using Oracle Universal Installer (OUI)

Topics

  • Database Components and Architecture


2. Oracle Database 11g Administration I (1Z0-052):2 Creating a Database

Time: 2 hours
This course provides a overview on creating an Oracle 11g database using the Database Configuration Assistant.

Objectives

  • 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
  • Use data dictionary and dynamic performance views

Topics

  • Creating a Database
  • Working with Oracle 11g


3. Oracle Database 11g Administration I (1Z0-052):3 Database Storage and Schema Objects

Time: 3 hours
This course provides an overview of storing data in Oracle databases.

Objectives

  • 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
  • Create and use temporary tables

Topics

  • Database Storage and Schema Objects
  • Working with Schema Objects


4. Oracle Database 11g Administration I (1Z0-052):4 Determining the Correct Network Architecture

Time: 2 hours
This course provides an overview of Oracle network architecture and types of network configurations.

Objectives

  • Configure the Oracle Network Environment
  • Configure and manage the Oracle Network
  • Use the Oracle Shared Server architecture

Topics

  • Determining the Correct Network Architecture


5. Oracle Database 11g Administration I (1Z0-052):5 Implementing Security and Auditing

Time: 2 hours
This course provides an overview of user security and how to implement security for an Oracle database.

Objectives

  • 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
  • Work with standard database auditing

Topics

  • Implementing Security and Auditing


6. Oracle Database 11g Administration I (1Z0-052):6 Managing Data and Undo

Time: 1 hours
This course provides an introduction to managing data in Oracle.

Objectives

  • 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
  • Manage undo

Topics

  • Managing Data and Undo


7. Oracle Database 11g Administration I (1Z0-052):7 Managing Performance and Maintaining the Database

Time: 2 hours
This course provides information on general database maintenance and how to effectively manage database performance.

Objectives

  • 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
  • Troubleshoot invalid and unusable objects

Topics

  • Maintaining the Database
  • Managing Performance


8. Oracle Database 11g Administration I (1Z0-052):8 Implementing Database Backups

Time: 2 hours
This course provides information on backing up and recovering your Oracle database.

Objectives

  • 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
  • Manage backups, view backup reports and monitor the flash recovery area

Topics

  • Implementing Database Backups


9. Oracle Database 11g Administration I (1Z0-052):9 Recovering the Database

Time: 1 hours
This course provides an overview of the types of failure that can occur in an Oracle database. It also covers how to recover data.

Objectives

  • 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
  • Use Data Recovery Advisor to perform recovery (control file, redo log file, and data file)

Topics

  • Recovering the Database


10. Oracle Database 11g Administration I (1Z0-052):10 Moving Data and Using EM Tools

Time: 2 hours
This course provides an overview of methods used to move data in an Oracle database.

Objectives

  • 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
  • Manage Patches

Topics

  • Moving Data and Using EM Tools


11. Oracle Database 11g Administration I (1Z0-052):11 Practice Exam 1

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

Objectives

  • Complete the practice exam questions

Topics

  • Practice Exam


12. Oracle Database 11g Administration I (1Z0-052):12 Practice Exam 2

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

Objectives

  • Complete the practice exam questions

Topics

  • Practice Exam


13. Oracle Database 11g Administration I (1Z0-052):13 Practice Exam 3

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

Objectives

  • Complete the practice exam questions

Topics

  • Practice Exam



Resources for Oracle Database 11g Administration I (1Z0-052)

  • Know of a good resource for Oracle Database 11g Administration I (1Z0-052) Online Training? Please Let Us Know.
Student Login



  1. Forgot My Password
  2. Support

Live eLearning

Like a class you would go to, but you don't have to go anywhere

More...

Try a Free Course

Click here to try a free course.

Partners & Resources
  1. View Partners & Resources
  2. Become a Partner
© Webucator, Inc. All rights reserved. | Toll Free: 877-932-8228 | UK: 0808-101-3484 | From outside the USA: 315-849-2724| Fax: 315-849-2723