This training course is part of the trajectory to achieve the oracle database 11g administrator certified associate oca certification. Oracle database 11g administration workshop i youtube. Youll begin by gaining a deep understanding of the most important. This course is designed to give students a firm foundation in basic administration of oracle database 11g. Administration i exam study guide is designed to provide students with the information that can help them learn more to pass the oracle database 11g administration i 1z0052 exam. Oracle database administrators guide, 11 g release 2 11. Experienced trainers pretest and posttest practices and solutions public price. Oracle database 12c sql worshop 2 student guide vol 2.
Sep 11, 2014 sql developer, which is the visual tool for database development, simplifies the following tasks. Also as an oracle database administrator, you need to be able to recover when problems occur in the database. Youll begin by gaining a deep understanding of the most important responsibilities a dba has. Oracle database 11g administration workshop i vol ii. These technologies are addressed by the following courses. Oracle 11g database administration training database. Performing usermanaged backup and recovery objectives recover from a lost temp file recover from a lost redo log group recover from the loss of password file perform usermanaged complete database recovery perform usermanaged incomplete database recovery. Administration workshop i dba release 2 course overview. Database architecture and asm, configuring for recoverability, using the rman recovery catalog, configuring backup specifications, using rman to create backups, performing usermanaged backup and recovery, using rman to perform recovery, using rman to duplicate a database, performing table. Oracle 11g new features workshop ora500 4 days request a class date this four day workshop will get students handson with all of the important new oracle 11g features they will need. Oracle database sql expert, oracle database 11g administrator certified associate, oracle database 11g administrator certified professional 1z0051.
Administration i exam study guide the oracle database 11g. Back and recover a database and its parts with rman commandline and enterprise manager use flashback technology to view past states of data and to revert either objects or the entire database back to a past state. Administration workshop i free download as powerpoint presentation. Administration workshop i release 2 oracle database 11g. Learn about architecture and how the database components work and interact.
Browsing and managing database objects executing sql statements and scripts editing and debugging plsql statements creating reports you can connect to any target oracle database schema by using standard oracle database authentication. This course takes the database administrator beyond the basic tasks covered in the first workshop. Administration workshop i release 2 course explores the fundamentals of basic database administration. This is a unique, onevolume guide to the administration and management of the oracle database.
Oracle 11g database administration oracle 11g database administration brian peasland published by itcourseware, llc. This is accomplished using backups, which are used to protect against problems such as media failure, user errors. In this class, youll learn how to install and maintain an oracle database. Oracle database 12c administration workshop course information days. Administration i exam code 1z0052 oracle database 11g. This course is designed to give participants a firm foundation in basic administration of oracle database 11g. Administration ii exam code 1z0053 3certifications. Oracle database 11g administration workshop i course information days. Administration workshop ii release 2 what you will learn this course takes the database administrator beyond the basic tasks covered in the first workshop. Administration workshop ii release 2 this course takes the database administrator beyond the basic tasks covered in the first workshop.
This oracle database administration training covers the fundamental skills necessary to be an oracle dba. Oracle database online documentation 11g release 2 11. You may copy and print this document solely for your own use in an oracle training course. 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. Administration workshop i release 2 elearning bundle consists of multiple online courses from one or more elearning vendors. The many instructors, including rob roselius and jeremy russell, whose ideas and. This course is your first step towards success as an oracle professional, designed to give you a firm foundation in basic database administration. Undo information is retained for all transactions, at least until the transaction is ended by. This includes how to define and test your own backup and recovery scenarios. Sql developer, which is the visual tool for database development, simplifies the following tasks. In this class, students learn how to install and maintain oracle database 11g. Oce exam preparation workshop is designed for those preparing to take the. Oracle database 10g administration i 84 questions objectives 120 minutes passing at 68% 1z0043 oracle database 10g administration ii 92 questions objectives 90 minutes passing at 70% follow on training. Oracle 10g database administration workshop i 655820 aug 23, 2008 4.
If yes, then our oracle database 11g upgrade assessment workshop is for you. Oracle database administrators manage the industrys most advanced information systems and command some of the highest salaries. Oracle database 11g administration workshop i vol i. Students gain a conceptual understanding of the oracle database architecture and how its components work and interact with one another. Course oracle database 11g administration workshop i. Administration workshop i release 2, this database 11g administration training gives you a firm foundation in basic database administration, including how to install and maintain an oracle database. Administration workshop i 10 5 undo data continued in case of a failed transaction, the safest behavior is chosen, and the oracle database reverses all changes made by a user, thereby restoring the original data. Administration workshop ii release 2, this database 11g administration training teaches you to perform backup and recovery, and diagnose and repair data failures.
The student begins by gaining a much deeper understanding of possibly the most important job of a dba. This document contains proprietary information and is protected by and other intellectual property laws. Students will learn to design and create a server using the optimal flexible architecture ofa, configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Oracle dba justin how to recover an oracle database to a specific scn, not using rman. Oracle 10g database administration workshop i oracle community. Oracle database administrators guide, 11g release 2 11. During this workshop an oracle expert, leveraging oracle best practices, will work with you to assess your current oracle database installation and prepare recommendations for a rapid, effective, and riskfree database upgrade and enhancement. Oracle 10g database administration workshop i oracle.
Nov 14, 2014 this course is designed to give participants a firm foundation in basic administration of oracle database 11g. Students will start with upgrades and downgrades and move on to real application testing, diagnosability and failure repair. The exam audience is represented by oracle database 11g administrators, that have a strong foundation. Administration workshop i release 2 this course is your first step towards success as an oracle professional, designed to give you a firm foundation in basic database administration. An important aspect of oracle database administration is to understand how a database and its major components function. In this course you will gain a conceptual understanding of oracle database architecture and learn how to manage an oracle database in an effective and efficient manner. Supporting documentation includes indepth concept, task, and reference material. Administration workshop is designed to provide you with a firm foundation in administration of an oracle database. Oracle database 11g ocm exam preparation workshop pdf this oracle database 11g. Objective dbas will learn the main skills required in their jobs, including monitoring, tuning and securing oracle instances, advanced backup and recovery, high availability ha, simple real application clustering rac environment set up. In this class, participants learn how to install and maintain oracle database 11g. The student begins by gaining a much deeper understanding of possibly the most important job of a dba backup and recovery. Administration workshop ii release 2 training takes the database administrator beyond the basic tasks covered in the first workshop.
1249 772 454 1507 1185 1458 1373 633 1663 1050 728 882 792 613 684 45 1050 708 94 151 1185 963 1037 1206 270 704 506 1470