Oracle Database 12c: Administration Workshop
Overview and Course Objectives
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 courses 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.
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.
Participants should have knowledge of relational concepts and knowledge of SQL is mandatory. Oracle Database 12c: SQL I - Introduction and Oracle Database 12c: SQL II - Intermediate are recommended prerequisites for this course.
Introduction: Managing The Database Instance
Introduction: Database Architecture Review
Introduction: Starting & Stopping Database Services
Introduction: Oracle Network Environment
Introduction: Diagnostics & Oracle Support
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: SQL Loader
Security & Schemas: Export & Import
Performance & Availability: Managing Performance & SQL Tuning
Performance & Availability: Data Concurrency
Performance & Availability: Backup & Recovery Concepts
This course considers is one of several in the Sideris series applicable to certification training as an Oracle Database 12c Administrator Certified Associate (OCA) for "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration".
If Oracle PL/SQL is still a mystery to you, you could follow Oracle Database 12c: PL/SQL I – Introduction.
Next training dates
1 to 5 April 2019
3.750 EUR (VAT excluded) per person
From 9 AM to 5 PM
De Villermontstraat 9
This training in-company?
Upon your request we can organize this training for you.