About this Course

The Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.

Learn To:

• Create and manage an Oracle Database Instance.
  
• Create and manage Storage Structures.
  
• Configure the Oracle Network Environment.
  
• Create and manage users.
  
• Monitor the database and manage performance.
  
• Learn basic information on backup and recovery techniques.
  
• Use the Oracle Support Workbench and My Oracle Support to update your Oracle Database software.
  

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Participate in Hands-On Practices and Demonstrations

Expert instruction and hands-on demonstrations will provide you with real world experience. By engaging in hands-on exercises to reinforce your learning, you'll develop in demand skills to effectively manage an Oracle Database.

COURSE OUTLINE

• Introduction
  
• Exploring the Oracle Database Architecture
  
• Managing the Database Instance
  
• Configuring the Oracle Network Environment
  
• Managing Database Storage Structures
  
• Administering User Security
  
• Managing Data Concurrency
  
• Managing Undo Data
  
• Implementing Oracle Database Auditing
  
• Performing Database Maintenance
  
• Managing Performance
  
• Managing Performance: SQL Tuning
  
• Managing Resources by Using Database Resource Manager
  
• Automating Tasks by Using Oracle Scheduler
  
• Managing Space
  
• Backup and Recovery Concepts
  
• Moving Data
  
• Working with Oracle Support
  

LEARNING OUTCOME

• Monitor the Database
  
• Manage Database Performance
  
• Implement Database Auditing
  
• Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks
  
• Schedule Jobs to Run Inside or Outside of the Database
  
• Configure Oracle Net Services
  
• Configure your Database For Backup and Recovery Operations
  
• Describe Oracle Database Architecture
  
• Manage the Oracle Database Instance
  
• Manage Oracle Database Storage structures
  
• Create and Administer User Accounts
  

TARGET AUDIENCE

This course is intended for:

• Data Warehouse Administrator
  
• Database Administrators
  
• Database Designers
  
• Support Engineer
  
• Technical Administrator
  

Required Prerequisites:

Working knowledge of SQL and use of PL/SQL packages

Suggested Prerequisites:

Basic knowledge of Linux operating system

Rate this course:

Log in to submit

Comments