Oracle Database 12c: Administration Workshop

PT0943
Training Summary
The overall objective of this course is threefold. First, this course instructs one in many of the day-to-day administration tasks required of an Oracle database administrator. Second, it is one of the course modules that assist in preparation for certification as an Oracle Certified Associated (OCA) database administrator. Finally, it introduces one to many of the administration sub-specialties that one might next pursue. It is increasingly rare for a single database administrator to fulfill all the required responsibilities necessary for management of an enterprise-scale Oracle database installation. Therefore, one may eventually specialize into backup and recovery strategies, database performance tuning, security administration and the like. So this course introduces the many powerful capabilities of the Oracle database and references the applicable courses within the Sideris Oracle database administration series that one might next consult.Whenever appropriate this course demonstrates how an Oracle database installation integrates with its host environment, most commonly a Linux, Unix or MS Windows operating system platform. Extensive examples, workshop exercises and solutions are provided using the SQL command-line, the Enterprise Manager Database Express and the Enterprise Manager Cloud Control interfaces.
Prerequisites
These are mandatory prerequisites for this textbook:Oracle Database 12c: SQL Fundamentals (Levels I & II)Oracle Database 12c: Install & Upgrade WorkshopOracle Database 12c: Architecture & Internals
Duration
5 Days/Lecture & Lab
Audience
The target audience for this textbook is all Oracle professionals. Among the specific groups for whom this textbook will be helpful are:Database administratorsApplication designers and developersWeb server administratorsSystem administratorsImplementation specialistsData center support engineersChief Information Officers (CIO) and other information technology (IT) management professionals
Course Topics
  • Introduction Managing The Database Instance
  • Introduction Database Architecture Review
  • Introduction Starting & Stopping Database Services
  • Introduction Oracle Network Environment
  • Storage Tablespace Management
  • Storage Advanced Tablespace Management
  • Storage Data Files & Temp Files Management
  • Storage Undo Data & Undo Tablespaces
  • Security & Schemas Security Overview & Database Privileges
  • Security & Schemas User Security
  • Security & Schemas Database Auditing
  • Security & Schemas Export & Import
  • Performance & Availability Managing Performance & SQL Tuning
  • Performance & Availability Data Concurrency
  • Performance & Availability Backup & Recovery Concepts

Related Scheduled Courses