COURSE HIGHLIGHTS :

  • Faculty : All faculty members are having rich IT industry experience, in a number of technical and managerial roles at senior positions.
  • Extensive discussions and experience sharing by trainers.
  • The Course material is been developed in accordance with Oracle University pattern.
  • Complete theoretical and practical knowledge will be delivered.
  • Students will get opportunities to work on live projects and get acquainted with real time industry scenario.
  • Complete course content strictly as per syllabus of paper 1.
  • Complete handís on training on sql.
  • Numerous case studies.
  • Concept of database management system, special benefits.
  • Placement Assistance for certified students.
  • Test series (over 2000 question,20 papers).
  • Training certificate directly from ORACLE university.
  • Authorized training kit & study material from ORACLE.
  • Experienced + certified faculties.


Oracle Database 11g Certification


Step 2 -
Exam Number: 1Z0-052
Duration:90 minutes
Number of Questions:70
Passing Score:66%


Oracle Database 11g: Administration

Course Content


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


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


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



COURSE CONTENT


Oracle Database 11g: SQL Fundamentals 1Z0-051 Oracle Database 11g: Administration 1Z0-052