> > > ORDB12C

Oracle Database 12c: Administration Workshop (ORDB12C)

Course Description Schedule Course Outline
 

Who should attend

The target audience for this training is all Oracle professionals. Among the specific groups for whom this course will be helpful are:

  • Database administrators
  • Application designers and developers
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
  • Chief Information Officers (CIO) and other information technology (IT) management professionals

Prerequisites

These are recommended prerequisites for this textbook:

  • !FL-OR-SQL

Course Objectives

The overall objective of this training 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 training 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 training introduces the many powerful capabilities of the Oracle database and references the applicable textbooks 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.

Course Content

  • 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
Classroom Training
Modality: C

Duration 5 days

Dates and Booking
 
Click on town name to book Schedule
Slovenia
02/09/2019 - 06/09/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Bucharest Course language: English Enroll
11/11/2019 - 15/11/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Budapest Course language: English Enroll
Poland
02/09/2019 - 06/09/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Bucharest Course language: English Enroll
11/11/2019 - 15/11/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Budapest Course language: English Enroll
Turkey
02/09/2019 - 06/09/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Bucharest Course language: English Enroll
11/11/2019 - 15/11/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Budapest Course language: English Enroll
Czech Republic
02/09/2019 - 06/09/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Bucharest Course language: English Enroll
11/11/2019 - 15/11/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Budapest Course language: English Enroll
Hungary
02/09/2019 - 06/09/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Bucharest Course language: English Enroll
11/11/2019 - 15/11/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Budapest Course language: English Enroll
Romania
02/09/2019 - 06/09/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Bucharest Course language: English Enroll
11/11/2019 - 15/11/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Budapest Course language: English Enroll
Slovakia
02/09/2019 - 06/09/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Bucharest Enroll
11/11/2019 - 15/11/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Budapest Enroll
Europe
Italy
20/05/2019 - 24/05/2019 Rome Enroll
26/08/2019 - 30/08/2019 Milan Enroll
11/11/2019 - 15/11/2019 Rome Enroll
Switzerland
08/07/2019 - 12/07/2019 Zurich Enroll
07/10/2019 - 11/10/2019 Zurich Enroll
United Kingdom
19/08/2019 - 23/08/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/London Enroll
02/12/2019 - 06/12/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/London Enroll
This is a FLEX course, which is delivered both virtually and in the classroom.
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!