◊ ORACLE DATABASE 11G ADMINISTRATION I (1Z0-052) ONLINE TRAINING SERIES
Online Oracle Database 11g Administration I (1Z0-052) Training
Database » Oracle
Check out these great money-saving course packages:
Only $99.95
Oracle Database 11g Administration I (1Z0-052) Series (22 hours)
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
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
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)
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
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
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
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.
