Course: Oracle Database 11g: Administration Workshop I Release 2 (exam 1Z0-052)

$398.09 incl. vat

duration: 20 hours |

Language: English (US) |

access duration: 180 days |

In Onbeperkt Leren

In this Oracle 11g training course, as you will learn to install, configure and manage an Oracle 11g release 2 database. This training course is part of the trajectory to achieve the Oracle Database 11g Administrator Certified Associate (OCA) certification.

Among the topics covered are the architecture of an Oracle 11g database, Oracle Grid, instance management, ASM, network connectivity, security, managing locks, performance, backup and far more.


You can install, configure and manage an Oracle 11g database release 2. You are also prepared to achieve exam 1Z0-052.


You have general knowledge of SQL. General database knowledge is an advantage.

Target audience

Database Administrators

Oracle Database 11g: Administration Workshop I Release 2 (exam 1Z0-052)

20 hours

Oracle Database 11g Release 2: Database Creation and Instance Management

  • plan a database
  • choose the character set for the database
  • configure a database using the DBCA
  • access a database instance using various Oracle tools
  • recognize the scope and capabilities of database initialization parameters
  • modify database initialization parameters
  • configure database startup and shutdown options
  • assess database performance and metadata information
  • use Oracle Restart to manage components
  • create a new database
  • stop and start the database

Oracle Database 11g Release 2: The ASM Instance and Network Connectivity

  • recognize the primary processes of the ASM instance
  • manage the ASM instance
  • identify the features of ASM disks
  • manage ASM disk groups
  • configure and manage Oracle Net Services and the Oracle Net Listener using Enterprise Manager
  • configure database connections
  • manage the ASM instance and network connectivity

Oracle Database 11g Release 2: Storage Structures and User Security

  • recognize how table data is stored
  • create a new tablespace
  • manage the storage of information in a database
  • create and authenticate database user accounts
  • grant and manage privileges
  • create and manage roles
  • implement user profiles and user security
  • create a new tablespace
  • create and configure profiles
  • create a role

Oracle Database 11g Release 2: Managing Concurrency, Undo, and Auditing

  • manage locks and data concurrency
  • manage undo data operations to allow users to roll back transactions
  • recognize how auditing is used to secure a database
  • enable and review audit information and maintain the audit trail
  • resolve lock conflicts
  • undo data in a database
  • configure database auditing

Oracle Database 11g Release 2: Managing Database Maintenance and Performance

  • manage Oracle optimizer statistics
  • manage Automatic Workload Repository statistics
  • use the Automatic Database Diagnostic Monitor and advisors
  • view and configure automated maintenance tasks
  • manage alerts
  • monitor and analyze the performance of the database
  • maintain the database by viewing information and implementing a given recommendation
  • manage database performance

Oracle Database 11g Release 2: Backup and Recovery

  • identify the types of failure that can occur in a database
  • configure a database for instance recovery
  • prevent media failure
  • configure ARCHIVELOG mode
  • identify strategies for backing up a database
  • use RMAN to configure, schedule, manage, and view backup operations
  • perform data recovery
  • prepare a database for recovery
  • perform a database backup
  • perform recovery on a database

Oracle Database 11g Release 2: Moving Data and Oracle Support

  • identify the features of Oracle Data Pump
  • move data between Oracle Databases using Oracle Data Pump
  • use SQL*Loader to move data from external files into an Oracle Database
  • use external tables to access data in external sources
  • use Enterprise Manager Support Workbench to investigate, report, and resolve issues
  • work with My Oracle Support
  • manage patches
  • move data using the Data Pump
  • load data using SQL*Loader
  • use Support Workbench

TestPrep 1Z0-052 Oracle Database 11g: Administration I

TestPrep 1Z0-052 Oracle Database 11g: Administration I

We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.

Optional practice exam (trial exam)

To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam. 

Optional practice lab

To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediatelyThe lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience. 


Via ons opleidingsconcept bespaar je tot 80% op trainingen

Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo

Spar met medecursisten en profileer je als autoriteit in je vakgebied.

Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van

Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers

Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten


Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.

frequently asked quesions

What is included?

Certificate of participation Yes
Monitor Progress Yes
Award Winning E-learning Yes
Examination possibleYes
Mobile ready No
Sharing knowledge Unlimited access to our IT professionals community
Study advice Our consultants are here for you to advice about your study career and options
Study materials Certified teachers with in depth knowledge about the subject.
Service World's best service


Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.

Life Long Learning

Follow multiple courses? Read more about our Life Long Learning concept

read more

Contact us

Need training advise? Contact us!