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. In this class you will concentrate on the skills and best practices required for daytoday database administration tasks such as security, creating and managing users, space management, administering undo and redo, running utilities, configuring oracle networking, and simple backup and. Administration workshop ed 2 oracle university appeleznous. Oracle database 12c administration oracle database 12c administration workshop d78846gc10. Expert oracle university instructors will demonstrate how this solution protects your oracle database against planned and unplanned downtimes. Focus areas 19 oracle database 12c 110 oracle fusion middleware 112 oracle enterprise manager cloud control 1 oracle cloud 114 oracle cloud.
Describes how to administer oracle automatic storage management oracle asm and oracle asm cluster file system oracle acfs for oracle database. This course covers all the tasks involved in managing, tuning, and protecting an oracle 12c database system. Contains a highlevel text description of the sql syntax used to manage information in oracle database. Describe the oracle database architecture components related to backup and recovery. Exadata database machine administration workshop ed 3 new. Contains a complete description of oracle sql, the language used to manage information in oracle database. Administration workshop ed 2 new suggested prerequisites using oracle enterprise manager cloud control 12c using oracle enterprise manager cloud control 12c ed 2 new course objectives describe oracle database backup methods and recovery operations that can be used to resolve database failure.
Administration workshop ed 3 course is designed to provide you with a firm foundation in administration of an oracle database. Oracle database 12c sql worshop 2 student guide vol 2. Sql workshop ii ed 2 course will help students enhance their skills as application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries. Oracle database 12c administration workshop student guide. Explains the concepts behind plsql and illustrates every facet of the language. 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 will teach you how to evaluate your own recovery requirements. Backup and recovery workshop ed 3 oracle database 12c. Oracle database 12c sql workshop 2 student guide volume.
Backup and recovery workshop, students learn how to perform backup and recovery based on the related oracle database architecture components. Prior knowledge of oracle database 11g r2 or 12c rac. Oracle database 12c administration ed 2 global knowledge. Oracle database administration workshop level 1 skillbuilders. Youll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. This 5day oracle database 12c administration workshop ed 2 course provides the skills to manage an oracle database instance. Students also learn to write more efficient queries using the functions supporting the timezone and regular expressions. Whether youre looking for an exadata database machine or rac administration class, or to learn more about the admin, install and upgrade process, the oracle courses listed below are the latest offerings. Administration workshop ii release 2 training takes the database administrator past the essential errands shrouded in the principal workshop. Program with plsql training starts with an introduction to plsql and then explores the benefits of this powerful programming language. New features for administrators ed2 course, youll learn about the new and enhanced features and options of oracle database 12c.
Administration workshop i overview this course is designed to give students a firm foundation in basic administration of oracle database 12c. Presents plsql, the oracle procedural extension of sql, an advanced fourthgeneration programming language. Youll learn about the oracle database architecture and how to effectively manage an oracle database. Backup and recovery workshop new unix and linux essentials course objectives configure io resource. A working knowledge of unixlinux along with an understand of general networking, storage and system administration concepts. Connectivity and space management in oracle database 12c. Prior knowledge and understanding of oracle database 11g release 2, including automatic storage management asm and real application clusters rac suggested prerequisites oracle database 12c. Oracle database 11g administration workshop ii pdf 12. Oracle database 12c sql workshop 2 student guide volume 1. Real application security is a new feature in oracle database 12c. Expert oracle university instructors will deep dive into global resources and cache fusion.
Oracle sql developer is a powerful easytouse gui with browse, create, edit, and draganddrop capabilities for managing database objects, and creating and viewing reports. Students gain a conceptual understanding of the oracle database architecture and how its components work and interact with. Backup and recovery workshop, learn to evaluate your own recovery requirements. Administration workshop ed 2 duration 5 days what you will learn the oracle database 12c. View test prep oracle database 12c sql workshop 2 student guide volume 1. In this course, you will be introduced to oracle database cloud service. Oracle database 11g administration workshop i vol ii. There are instructorled, virtual, and selfpaced classes available to suit your schedule.
It will not look hard to pass the oracle database 12c administrator certified professional exam and you will be sure to pass oracle database 12c administrator certified professional exam. Sep 11, 2014 iii contents 1 introduction lesson objectives 1 2 lesson agenda course objectives 14 course agenda 15 appendices and practices used in the course 17 lesson agenda 18 oracle database 12c. This course is designed to provide you with a firm foundation in administration of an oracle database. Administration workshop will help you build a firm foundation in administration of an oracle database. Oracle database 12c administration workshop ed 2 new training. Oracle database architecture objectives 22 oracle database server.
New features for 12c r1 administrators 12c r1 ocas and ocps. Share and manage data in clusters 90 5 oracle middleware 12c. Administration workshop ed 3 oracle database 12c r2. Administration workshop will teach you about the oracle database architecture. Oracle database 12c is the worlds first database designed for the cloud. This course provides you with the skills necessary to create and administer an oracle database.
In this class, students learn how to install and maintain oracle database 12c. Develop appropriate backup and recovery procedures to address your business needs. Rac administration training will teach you about oracle rac database architecture. Complete oracle database 12c administrator certified. Sep 11, 2014 oracle database 12c sql worshop 2 student guide vol 2 1. Sql workshop ii student guide volume ii d80194gc10 edition 1. Source code online books for professionals by professionals expert oracle rac 12c expert oracle rac 12c is a handson book helping you understand and implement oracle real application clusters rac, and to reduce the totalcostofownership tco of a rac database. Administration workshop must be completed within 5 years after the student oracle database 12c is the worlds first database designed for the cloud. Data guard administration ed 1 training teaches you how to use oracle data guard. Oracle database 12c administration workshop student guide12c sql worshop 1 student guide vol 1 otto paiz.
Oracle database 11g administration workshop ii vol 2pdfppt. In this course, you will be introduced to oracle database exadata cloud service. You will discover how to effectively manage an oracle database instance, configure the oracle network environment and perform database maintenance. The new oracle database administration learning subscription also helps you prepare for these exams with 247 access to continually updated training and handson labs and integrated certification. Oracle database 12c sql workshop 2 student guide volume 2. Your abilities and knowledge grow slowly as you read the stuff. Administration workshop ed 2 suggested prerequisites using oracle enterprise manager cloud control 12c ed 2 course objectives describe oracle database backup methods and recovery operations that can be used to resolve database failure.
Beginning oracle database 12c administration is your entry point into a successful and satisfying career as an oracle database administrator the chapters of this book are logically organized into four parts closely tracking the way your database administration career will naturally evolve. The oracle database administration workshop is designed to provide you with a firm. These ekit materials are for your use in this classroom only. Youll start by picking up a profound comprehension of the most vital obligations a dba. Develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. Administration workshop ed 2 training with exitcertifiedoracle database 12c.
The following topics are covered in the oracle database. Oracle database 12c sql worshop 1 student guide vol 1. Administration ed 2 course, students will learn the different ways in which oracle application express can be installed and will perform a full development environment installation on a. In this class you will concentrate on the skills and best practices required for daytoday database administration tasks such as security, creating and managing users, space management, administering undo and redo, running utilities, configuring oracle networking, and simple backup and recovery. Oracle database 12c sql worshop 2 student guide vol 2 1. Administration workshop 1 2 course objectives after completing this course, you should be able to.
Build rich client applications with adf ed 1 90 5 oracle soa suite 12c. Oracle database 12c training courses exitcertified. Beginning oracle database 12c administration springerlink. Undo information is retained for all transactions, at least until the transaction is ended by. Build composite applications 90 5 oracle service bus 12c.
1079 1089 909 1177 525 1006 991 1225 259 887 1615 1409 1296 907 1444 435 499 67 1623 1377 166 1467 192 585 1462 468 263 422 1146 1098 144 363 279 553 360 394 58