OR1906

Ladda ner som PDF

Oracle Database 12c R2: Administration Workshop

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.

Audience

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

Prior knowledge

Before attending this course, students must have:
Working knowledge of SQL and use of PL/SQL packages

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

Objectives

  • Back up, restore, and patch DBCS database deployments
  • Describe the DBaaS and on-premises Oracle Database architectures
  • Manage database instances
  • Manage UNDO data
  • Move data between databases
  • Implement basic backup and recovery procedures
  • Monitor and tune database performance
  • Tune SQL to improve performance
  • Manage resources with Oracle Database Resource Manager
  • Create pluggable databases (PDBs)
  • Configure the Oracle network environment
  • Administer user security and implement auditing
  • Create and manage... Läs mer

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

Objectives

  • Back up, restore, and patch DBCS database deployments
  • Describe the DBaaS and on-premises Oracle Database architectures
  • Manage database instances
  • Manage UNDO data
  • Move data between databases
  • Implement basic backup and recovery procedures
  • Monitor and tune database performance
  • Tune SQL to improve performance
  • Manage resources with Oracle Database Resource Manager
  • Create pluggable databases (PDBs)
  • Configure the Oracle network environment
  • Administer user security and implement auditing
  • Create and manage tablespaces
  • Manage storage space
  • Create and manage Database as a Cloud Service (DBCS) database deployments
  • Register databases and manage performance with Enterprise Manager Cloud Control

Topics

  • Getting Started
  • Exploring Oracle Database Architecture
  • Managing Database Instances
  • Creating PDBs
  • Configuring the Oracle Network Environment
  • Administering User Security
  • Creating and Managing Tablespaces
  • Managing Storage Space
  • Managing UNDO Data
  • Moving Data
  • Backup and Recovery Concepts
  • Monitoring and Tuning Database Performance
  • SQL Tuning
  • Oracle Database Resource Manager
  • Enterprise Manager Cloud Control
  • Introduction to Oracle Database Cloud Service
  • Creating DBCS Database Deployments
  • Managing DBCS Database Deployments
  • Backing Up and Restoring DBCS Database Deployments
  • Patching DBCS Database Deployments
  • Creating Master Encryption Keys for PDBs
  • Tablespace Encryption by Default

Utbildningen levereras i samarbete med

Kursfakta

Kurs-ID: OR1906
Längd: 5 dagar
Pris exkl moms: 32 000 kr
Inregistrering: 09.00
Kursstart: 09.30
Kursslut (ca): 17.00

Frågor om kursen?

Har du frågor om kursens innehåll, leveransdatum/ort eller behöver en företagsanpassad variant? Fyll i formuläret nedan!


Kan betalas med:
TRAINING CARD

Avtalsrabatter och kampanjer kan ej nyttjas på denna kurs.


Ort och datum

Stockholm
3 feb-7 feb
Boka nu!
4 maj-8 maj
Boka nu!
Malmö
3 feb-7 feb
Boka nu!
4 maj-8 maj
Boka nu!

Tipsa