Oracle Database 11g Administration I Online Training Course
Course Topics: 13
Estimated Time Needed: 22 hour(s)
Audience: This training course is for anyone who is preparing for the Oracle Database 11g Administration I (1Z0-052) exam.
Course Description: 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 online course 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.
Click here to watch a preview from one Oracle Database 11g Administration I lesson
Course Tutorials Include:
Oracle Database 11g Administration I (1Z0-052): 1 Database Components and Architecture
Description
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)
Oracle Database 11g Administration I (1Z0-052): 2 Creating a Database
Description
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
Oracle Database 11g Administration I (1Z0-052): 3 Database Storage and Schema Objects
Description
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
Oracle Database 11g Administration I (1Z0-052): 4 Determining the Correct Network Architecture
Description
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
Oracle Database 11g Administration I (1Z0-052): 5 Implementing Security and Auditing
Description
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
Oracle Database 11g Administration I (1Z0-052): 6 Managing Data and Undo
Description
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
Oracle Database 11g Administration I (1Z0-052): 7 Managing Performance and Maintaining the Database
Description
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
Oracle Database 11g Administration I (1Z0-052): 8 Implementing Database Backups
Description
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
Oracle Database 11g Administration I (1Z0-052): 9 Recovering the Database
Description
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)
Oracle Database 11g Administration I (1Z0-052):10 Moving Data and Using EM Tools
Description
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
Oracle Database 11g Administration I (1Z0-052):11 Practice Exam 1
Description
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
Oracle Database 11g Administration I (1Z0-052):12 Practice Exam 2
Description
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
Oracle Database 11g Administration I (1Z0-052):13 Practice Exam 3
Description
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
Features
- Audio accompanies each lesson page throughout the course.
- MindNotes provide printable quick-reference sheets and other files to be used as learners apply their skills on the job.
- Instructional audio with graphics highlighting key points.
- Activities allow learners to apply course concepts in an interactive questioning environment.
- Exercises allow learners to practice in the actual application being studied.
- A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
- Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
- Search text enables learners to rapidly search all text within a course to easily retrieve information required.
- Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
- A skill assessment generates a customized learning path based on the results of a pre-test.
- A glossary provides a reference for definitions of unfamiliar terms.
- Bookmarking tracks the learner's progress in a course.