Oracle Database 12c: Fundamentals for Developers and System Administrators

Oracle Database 12c: Fundamentals for Developers and System Administrators

Kód: D79228
Időtartam:2 nap
Nehézségi szint:
  • Haladó
192 000 Ft-tól
(Bruttó ár: 243 840 Ft-tól)
Kérdésem van!
Képzési forma
Egyedi igények szerint Nyílt
Képzés nyelve
- + Jelentkezem


This course is ideal for Database Administrators of small to medium sized businesses. This Oracle Database 12c: Fundamentals for Developers and System Administrators course helps you perform basic Oracle Database 12c administration tasks needed to keep the database operational.In this course, you will be introduced to Oracle Database Cloud Service.

Learn To:

  • Install Oracle Database 12c software and create a database.
  • Use Enterprise Manager Database Express to manage the database.
  • Manage database storage structures and schema objects.
  • Administer users and security.
  • Backup and recover the Oracle Database.
  • Monitor the database and use the Advisors.
  • Gain an understanding of the Oracle Database Cloud Service.

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.

Install and Manage Oracle Database 12c

The goal of this course is to teach you how to install the Oracle Database 12c software and perform the tasks required to manage an Oracle database. You will start with installation of the Oracle Software and reviewing installation configuration details.

Self-Managing Capabilities and Automatic Features of Oracle Database 12c

Throughout this course, expert Oracle instructors will teach you how to quickly accomplish required tasks using Enterprise Manager. This training places particular emphasis on the self-managing capabilities and automatic features of Oracle Database 12c.



Kinek ajánljuk

  • Database Administrators

  • Support Engineer

  • Technical Administrator

  • Technical Consultant

Szükséges előképzettség

  • Basic understanding of the Linux operating system


Course Overview

Course Objectives

Course Agenda

Course Environment

Additional Resources

Oracle Database: Overview

Relational Databases: Introduction

Relational Database Terminology

Relating Multiple Tables

Structured Query Language (SQL)

SQL Statements

Using SQL to Access the Database

Development Tools for Oracle Database

Oracle Instance and Database: Overview

Installing and Creating a Database

Installation Workflow

Oracle Universal Installer

Installation Prerequisites

Setting Environment Variables

Installation Steps

Configuring Security Updates

Downloading Software Updates

Specifying Installation Options

Using Oracle Enterprise Manager Database Express and SQL-Based Management Tools

Management Framework

Enterprise Manager Database Express: Overview

Configuring the HTTPS Port for EM Express

Accessing EM Express

Using the Database Home Page

Navigating Through EM Express

Granting Access to EM Express


Configuring the Oracle Network Environment

Network Configuration: Overview

Oracle Net Listener: Configuration and Management

Tools for Configuring and Managing the Oracle Network

Using the Listener Control Utility

Connecting to an Oracle Database

Name Resolution

Oracle Net: Naming Methods

Managing the Oracle Instance

Oracle Instance Management

Initialization Parameters

Oracle Processes

Oracle Memory Structures

Starting and Shutting Down an Instance

States of an Instance

Stopping and Starting an Instance by Using SQL*Plus

Stopping and Starting an Instance by Using SQL Developer

Managing Database Storage Structures

Oracle Database Structures

Exploring the Storage Structure of the Oracle Database

Control File

Redo Log Files

Multiplexing the Redo Log

Tablespaces and Data Files

Tablespaces in the Preconfigured Database

Enlarging the Database

Administering Users and Security

Overview of Users and Security

Oracle-Defined Users

Creating Users

Modifying Users

Dropping Users

Locking and Unlocking Accounts

Unlocking a User Account and Resetting the Password

Setting the Password Policy

Managing Schema Objects

What Is a Schema?


Accessing Schema Objects

Specifying Data Types in Tables

Creating and Modifying Tables

Modifying a Table

Understanding Data Integrity

Defining Constraints

Performing Backup and Recovery

Oracle Recovery Features

Backup File Types

Types of Backups

Media Recovery Options

Media Recovery Step

Configuring the Database for Backup and Recovery

Configuring the Fast Recovery Area

Credentials Required to Perform Backup and Recovery

Monitoring the Database and Using the Advisors

Proactive Database Monitoring

Monitoring General Database State and Workload

Monitoring Performance

Diagnosing Performance Problems

Types of ADDM Findings

Viewing a Summary of ADDM Performance Findings

Responding to Findings

Using Advisors

Managing the Software

Understanding Software Management and Patch Releases

Patching Oracle Database Software

Using the Database Upgrade Assistant to Upgrade the Database

Removing Oracle Database Software

Oracle Database Cloud Service: Overview

Database as a Service Architecture, Features and Tooling

Software Editions: Included Database Options and Management Packs

Automated Database Provisioning

Managing the Compute Node Associated With a Database Deployment

Managing Network Access to Database as a Service

Enabling Access to a Compute Node Port

Scaling a Database Deployment & Patching Database as a Service

Using the Oracle Database Cloud Service Console to Manage Patches

Tanfolyami naptár