Welcome to Comnet Group Inc.

Courses

Oracle Database Administration (DBA) 19c or Later

Course number: CGIDBA40 - 5 Days (weekdays or on-demand)

The overall objective of this course is threefold. First, this course provides instruction in many of the day-to-day administration tasks required of an Oracle database administrator. Second, it assists in preparation for certification as an Oracle Certified Associated (OCA) database administrator. Finally, it introduces 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 eTextbooks 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
  • There are no set eligibility criteria to take this course. A basic knowledge of SQL can be helpful.
Target Audience

The target audience for this course 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
Certification

Oracle Database Administrator Certified Associate

Exam

Oracle Database Administrator Certified Associate Exam

Accreditation

Post class completion, students can appear for the Oracle Database Administrator Certified Associate Exam.

Course Content
Introduction: Managing The Database Instance

• The Database Management Tools
• EM Database Express
• EM Cloud Control
• SQL Developer
• Database Administration Duties

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

Available Formats

Live Online
Register
To use reCAPTCHA you must get an API key from https://www.google.com/recaptcha/admin