Expert oracle university instructors will reinforce topics with structured handson practices that will prepare you for the corresponding oracle certified associate exam. Oracle database 11g managing oracle on linux for dbas. Oracle database 12c administration workshop course information days. 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. Oracle database 11g administration workshop i release 2. Oracle database 11g storage architecture recognize how information is stored and structured within the oracle database 11g storage architecture. This includes how to define and test your own backup and recovery scenarios. Course outline of oracle 11g administration workshop 2. Oracle 11g database administration oracle 11g database administration brian peasland published by itcourseware, llc. In this class, youll learn how to install and maintain an oracle database.
Undo information is retained for all transactions, at least until the transaction is ended by. Administration workshop i is an instructorled course featuring lectures and handson exercises. Oracle dba training thousands of oracle dbas trained since 1996. 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. Who should attend the primary audiences for this course are. 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. Experienced trainers pretest and posttest practices and solutions public price. Oracle database 11g database administration oracle database 11g. Oracle dba workshop provides you with a strong foundation in basic database administration.
Administration workshop i volume 1 student guide d50102gc10 edition 1. Administration workshop i release 2 course explores the fundamentals of basic database administration. Course oracle database 11g administration workshop i. This online oca oracle database administration quiz is aim to test your knowledge on 11g administration and help you prepare for oca certification. Expert oracle database 11g administration experts voice. Database administrators web server administrators system administrators implementation specialists data center support engineers senior application.
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. Administration workshop ii release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. The student begins by gaining a much deeper understanding of possibly the most important job of a dba. Oracle database 11g administration workshop i release 2 1. This oracle 11g training course will allow the student to gain the skills necessary for daytoday administration of an oracle database. In this class, students learn how to install and maintain oracle database 11g. Oracle database 11g administration workshop ii volume i student. This course takes the database administrator beyond the basic tasks covered in the first workshop. Sam alapatis expert oracle database 11g administration is a comprehensive handbook for oracle database administrators dbas using the 11g release of the oracle database. In this class, youll learn how to install and maintain an. Information on the objectives and topics of the 1z0052 oracle database 11g. Administration workshop i release 2, this database 11g administration training gives you a firm foundation in basic database. 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. 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 lesson 1 intro to the oracle data dictionary. Administration workshop i volume i student guide d50102gc20 edition 2. Expert and experienced instructors, including oracle certified master dba john watson, proprietary courseware, recordings for future study, 20% alumni discounts and more. Oracle database 11g administration workshop ii release 2. Administration workshop i release 2 oracle database 11g. Oca oracle database administration test quiz proprofs. This course is your first step towards success as an oracle professional, designed to give you a firm foundation in basic database administration. 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 training course is part of the trajectory to achieve the oracle database 11g administrator certified associate oca certification. Oracle database 11g administration workshop i vol 1pdfppt. You will be given the soft copies of those materials with your email id signed in.
These technologies are addressed by the following courses. Oracle database administratio n certificate program on c. This document contains proprietary information and is protected by and other intellectual property laws. This class we will guide you to install and maintain an oracle database.
The overall objective of this course is to allow the student to gain the skills necessary for daytoday administration of an oracle database. Oracle database administrators manage the industrys most advanced information systems and command some of the highest salaries. 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. Youll begin by gaining a deep understanding of the most important responsibilities a dba has. 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.
Topic overview audience documentation accessibility related documents conventions. Oracle database 11g administration workshop i vol ii. 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. This course is designed to give students a firm foundation in basic administration of oracle database 11g. Oracle database 11g administration workshop i vol i. View notes oracle database 11g administration workshop i vol ii from itrw 321 at northwestern university. Oracle database 11g administration workshop i course information days. The student begins by gaining a much deeper understanding of possibly the most important job of a dba backup and recovery. Our team will give you a brief conceptual and architectural understanding of an oracle database and how their components interface with one another. Oracle database 11g administration workshop ii volume i student guide. 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. Administration workshop i release 2 course with code sku127 from it academy. You may copy and print this document solely for your own use in an oracle training course. In case of a failed transaction, the safest behavior is chosen, and the oracle.
Administration workshop i dba release 2 course overview. The many instructors, including rob roselius and jeremy russell, whose ideas and. Students gain a conceptual understanding of the oracle database architecture and how its components work and interact with one another. 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.
538 1282 1547 503 613 509 132 960 365 1024 931 386 861 673 1010 1133 1177 118 1405 1304 1527 1284 1416 892 1290 557 555 581 1000 1129 422 563 367 275 979 1491