0345 4506120

Oracle 12c DBA Fundamentals 1

The Oracle 12c hands on practical course for database administrators  provides attendees with the essential skills tool kit to undertake the  day-to-day administration tasks  required of an Oracle 12c database  administrator.

Pre-Requisites

The following skills are recommended:

  • Oracle Database 12c: SQL Fundamentals

Course Content

The Oracle 12c hands on practical course for database administrators  provides attendees with the essential skills tool kit to undertake the  day-to-day administration tasks  required of an Oracle 12c database  administrator.

The Oracle 12c hands on practical course for database administrators provides attendees with the essential skills tool kit to undertake the day-to-day administration tasks  required of an Oracle 12c database administrator.  Attendees will be introduces to many of the key administration tasks and took in the Oracle 12c enterprise environment.  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. The courses introduces the many powerful capabilities of the  Oracle database and references the applicable resources and areas Oracle database administrators may need to consult.

Course content is designed to help assist those in preparation  for certification as an  Oracle Certified Associated (OCA) database  administrator.

Course Contents

Introduction: Managing The Database Instance • The Database Management Tools • EM Database Express • EM Cloud Control • SQL Developer • Database Administration Duties
Introduction: Database Architecture Review • Database Instance Configurations • Memory Structures • Process Structures • Storage Architecture
Introduction: Starting & Stopping Database Services • Start & Stop The Database Listener • About Database Startup/Shutdown • SYSOPER • SYSDBA • Database State & Stages • Startup With EM Cloud Control • Startup With SQL*PLUS • Shutdown With EM Cloud Control • Shutdown With SQL*PLUS • Using MS Windows Services
Introduction: Oracle Network Environment • Oracle NET Services Architecture • Oracle NET Configuration Assistant • Oracle NET Manager • Using EM Cloud Control • Advanced Network Compression • Troubleshooting Network Problems
Introduction: Diagnostics & Oracle Support • About Database Diagnostics • Fault Diagnosability Infrastructure • Database Instance Health Snapshot • The Support Workbench • Proactive Database Health Checks • Package Diagnostic Data • Working With The Knowledge Base
Storage: Tablespace Management • Starter Tablespaces • Create Tablespace With EM CC • Create Tablespace With SQL • Manage Tablespaces With EM CC • Manage Tablespaces With EM DE • Manage Tablespaces With SQL • DROP Tablespace • ALTER Tablespace
Storage: Advanced Tablespace Management • Managing Temporary Tablespaces • Temp Tablespace Groups With EM • Temp Tablespace Groups With SQL • Default Permanent Tablespaces • Bigfile Tablespaces • Managing The SYSAUX Tablespace
Storage: Data Files & Temp Files Management • Manage Data Files With EM • Access Metadata With SQL • Manage Data Files With SQL • Manage Temp Files • Oracle-Managed Files (OMF)
Storage: Undo Data & Undo Tablespaces • About Undo Space Management • Configure Undo Management • Guarantee Undo Retention • Monitor Undo Space With SQL • Use The EM Undo Advisor
Security & Schemas: Security Overview & Database Privileges • Database Security Principles • Database System Privileges • Database Object Privileges • Super Administrator Roles • Privilege Analysis
Security & Schemas: User Security • Create & Manage User Accounts • Manage Users With EM • Manage Users With SQL • CREATE User • ALTER User • DROP User • Grant & Revoke Privileges • Resource Limits Via Profiles • ALTER Profile • DROP Profile • Password Management Via Profiles • Role-Based Security Management • Alter User...Default Role • Set Role • Delegating Privilege Authorization • With Admin Option & System Privileges • With Grant Option & Object Privileges • Principle Of Least Privilege Checklist
Security & Schemas: Database Auditing • Auditing Database Activity • Traditional Auditing • Unified Auditing • Create Audit Policy
Security & Schemas: SQL Loader • Loader Concepts • Loader From The Command Line • Control File Options • Load Methods • Loader Express Mode • Loader From EM
Security & Schemas: Export & Import • Manage Directory Objects • The Data Pump Architecture • Data Pump Export • Data Pump Import • Data Pump Dictionary Views • Using The EM Cc Interface
Performance & Availability: Managing Performance & SQL Tuning • Management Advisory Framework • Performance Monitoring & AWR • The SQL Tuning Advisor • Monitoring Exceptions With Metrics
Performance & Availability: Data Concurrency • About System & User Locks • Monitor & Manage User Locks • Monitor Locks With Data Dictionary • Manage Locks With EM
Performance & Availability: Backup & Recovery Concepts • Backup & Recovery Structures • Managing Redo Data • Configuring For Recoverability • Instance Recovery • Recoverability Checklist

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Virtual Classroom

Virtual classrooms provide all the benefits of attending a classroom course without the need to arrange travel and accomodation. Please note that virtual courses are attended in real-time, commencing on a specified date.

Virtual Course Dates

Our Customers Include