Administration workshop ii release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. This training course is part of the trajectory to achieve the oracle database 11g administrator certified associate oca certification. Oracle database administratio n certificate program on c. Oracle application express sql workshop guide describes how to use oracle application express sql workshop and utilities to load and unload data from an oracle database, generate ddl, view object reports, and restore dropped database objects. The many instructors, including rob roselius and jeremy russell, whose ideas and. This document contains proprietary information and is protected by and other intellectual property laws. In this class, students learn how to install and maintain oracle database 11g. Administration workshop i volume 1 student guide d50102gc10 edition 1. Course outline of oracle 11g administration workshop 2. The overall objective of this course is to allow the student to gain the skills necessary for daytoday administration of an oracle database.
Administration workshop i volume i student guide d50102gc20 edition 2. Administration workshop i release 2 suggested prerequisites working knowledge of sql and how to use plsql packages course objectives configure the oracle database for optimal recovery configure the database instance such that resources are appropriately allocated among sessions. Administration workshop i is an instructorled course featuring lectures and handson exercises. Oracle dba workshop provides you with a strong foundation in basic database administration. Oracle database sql expert 70 questions objectives 120 minutes passing at 66% sce oca 1z0042 ocp 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 database administrators manage the industrys most advanced information systems and command some of the highest salaries. Youll begin by gaining a deep understanding of the most important responsibilities a dba has. Oracle database 11g managing oracle on linux for dbas. Oracle 11g database administration oracle 11g database administration brian peasland published by itcourseware, llc. You will be given the soft copies of those materials with your email id signed in. 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. 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. Undo information is retained for all transactions, at least until the transaction is ended by. This course takes the database administrator beyond the basic tasks covered in the first workshop. Oracle database 11g administration workshop i vol i. Administration workshop i release 2 oracle database 11g. This course is your first step towards success as an oracle professional, designed to give you a firm foundation in basic database administration. Oracle dba training thousands of oracle dbas trained since 1996.
Administration workshop i dba release 2 course overview. This class we will guide you to install and maintain an oracle database. Administration workshop i release 2 course explores the fundamentals of basic database administration. This course is designed to give students a firm foundation in basic administration of oracle database 11g. You may copy and print this document solely for your own use in an oracle training course. Oracle database 12c administration workshop course information days. Oca oracle database administration test quiz proprofs. Expert oracle university instructors will reinforce topics with structured handson practices that will prepare you for the corresponding oracle certified associate exam. He was the president of the northern california oracle users group nocoug, the longest running and most active oracle users group in the world. This oracle 11g training course will allow the student to gain the skills necessary for daytoday administration of an oracle database. Expert oracle database 11g administration experts voice. Students gain a conceptual understanding of the oracle database architecture and how its components work and interact with one another.
Oracle database 11g administration workshop i vol ii. This online oca oracle database administration quiz is aim to test your knowledge on 11g administration and help you prepare for oca certification. In case of a failed transaction, the safest behavior is chosen, and the oracle. Oracle database 11g administration workshop i release 2 1. Administration workshop i free download as powerpoint presentation.
Exploring the oracle database architecture lesson 3. Oracle database 11g administration workshop i is a 5day training course offering a firm foundation in basic administration of oracle database 11g 5 day course hands on training official curriculum course code oc11gdba1. Topic overview audience documentation accessibility related documents conventions. Course oracle database 11g administration workshop i. Our team will give you a brief conceptual and architectural understanding of an oracle database and how their components interface with one another. 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. Oracle database 11g storage architecture recognize how information is stored and structured within the oracle database 11g storage architecture. Oracle database 11g administration workshop lesson 1 intro to the oracle data dictionary. The student begins by gaining a much deeper understanding of possibly the most important job of a dba backup and recovery. Oracle database 11g administration workshop i release 2.
Oracle database 11g database administration oracle database 11g. 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. These technologies are addressed by the following courses. Expert and experienced instructors, including oracle certified master dba john watson, proprietary courseware, recordings for future study, 20% alumni discounts and more.
All key aspects of database administration are covered, including backup and recovery, daytoday administration and monitoring, performance tuning, and more. Oracle database 11g administration workshop ii volume i student. Information on the objectives and topics of the 1z0052 oracle database 11g. Experienced trainers pretest and posttest practices and solutions public price. Oracle database 11g administration workshop ii release 2. In this class, youll learn how to install and maintain an. View notes oracle database 11g administration workshop i vol ii from itrw 321 at northwestern university. Administration workshop i release 2 course with code sku127 from it academy.
Oracle database 11g administrator certified associate, oracle database 11g administrator certified professional 1z0051 oracle database sql expert 70 questions objectives 120 minutes passing at 66% sce oca 1z0052 ocp oracle database 11g administration i 84 questions objectives 120 minutes passing at 68% 1z0053 oracle database 11g. This includes how to define and test your own backup and recovery scenarios. Administration workshop i release 2, this database 11g administration training gives you a firm foundation in basic database. Oracle database 11g administration workshop i course information days. Sam alapatis expert oracle database 11g administration is a comprehensive handbook for oracle database administrators dbas using the 11g release of the oracle database. Oracle database 11g administration workshop i vol 1pdfppt. Database administrators web server administrators system administrators implementation specialists data center support engineers senior application.
1517 1275 1107 1475 463 12 760 661 1003 693 916 416 70 253 345 952 377 1368 860 1372 839 1187 1275 483 552 1362 101 628 1219 416 947 1369 1119 212 50 876 369 732 342 951 38 566