Oracle Database 11g Administration 1...

General Information

Posted on the 29/05/20

Ad details

Oracle Database 11g Administration 1
Certification

Program Summary
The Oracle Database 11g Administrator I (1Z0-052) exam is primarily intended for Oracle Database 11g administrators that have a strong foundation and expertise in the industry’s most advanced database management system.
Exploring the Oracle Database Architecture
• Explain the Memory Structures
• Describe the Process Structures
• Overview of Storage Structures
Preparing the Database Environment
• Identify the tools for Administering an Oracle Database
• Plan an Oracle Database installation
• Install the Oracle software by using Oracle Universal Installer (OUI)
Creating an Oracle Database
• Create a database by using the Database Configuration Assistant (DBCA)
Managing the Oracle Instance
• Setting database initialization parameters
• Describe the stages of database startup and shutdown
• Using alert log and trace files
• Using data dictionary and dynamic performance views
Configuring the Oracle Network Environment
• Configure and Manage the Oracle Network
• Using the Oracle Shared Server architecture
Managing Database Storage Structures
• Overview of tablespace and datafiles
• Create and manage tablespaces
• Space management in tablespaces
Administering User Security
• Create and manage database user accounts
• Grant and revoke privileges
• Create and manage roles
• Create and manage profiles
Performing 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
Performing Database Recovery
• Overview of Data Recovery Advisor
• Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
Moving Data
• Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
• Explain the general architecture of Oracle Data Pump
• Use Data Pump Export and Import to move data between Oracle databases
Managing Data and Concurrency
• Monitor and resolve locking conflicts
Managing Undo Data
• Overview of Undo
• Transactions and undo data
• Managing undo
Implementing Oracle Database Security
• Database Security and Principle of Least Privilege
• Work with Standard Database Auditing
Database Maintenance
• Use and manage optimizer statistics
• Use and manage Automatic Workload Repository (AWR)
• Use advisory framework
• Manage Alerts and Thresholds
Performance Management
• Use Automatic Memory Management
• Use Memory Advisors
• Troubleshoot invalid and unusable objects
Intelligent Infrastructure Enhancements
• Use the Enterprise Manager Support Workbench
• Managing Patches
Backup and Recovery Concepts
• Identify the types of failure that can occur in an Oracle database
• Describe ways to tune instance recovery
• Identify the importance of checkpoints, redo log files, and archived log files
• Overview of flash recovery area
• Configure ARCHIVELOG mode

Program Name : Oracle Database 11g Administration 1
Training Track : DBA
Duration : 2 Months

For Details Contact Us: A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, and Karachi, Pakistan Call: 3498-OMNI (6664) | M: 03377222191 | 0312216 9325 I03122169321 E: info@omni-academy.com| www.omni-academy.com IFb: www.facebook.com/Omniacademy

Report this ad