Caricamento...
ORA1135

Oracle Database 12c: Fundamentals for Developers and System Administrators

Prezzo

€ 890.00
(Iva esclusa)

Scheda tecnica

Scarica

Giorni

2 gg

Questo corso è ideale per gli amministratori di database di piccole e medie imprese. Questo corso Oracle Database 12c: Fondamenti per gli sviluppatori e amministratori di sistema consente di eseguire le operazioni di base sul Database Oracle necessari per mantenere il database operativo.


OBIETTIVI

Al termine del corso gli allievi saranno in grado di:

  • Installare Oracle Database 12c
  • Creare un database
  • Utilizzare Enterprise Manager Database Express per gestire il database
  • Gestire strutture di stoccaggio di database e gli oggetti dello schema
  • Amministrare utenti e sicurezza
  • Backup e ripristinare il database Oracle
  • Monitorare il database e utilizzare i Advisors
Amministratori di database e consulenti tecnici.

Per partecipare con profitto a questo corso è necessario che gli allievi possiedano i seguenti prerequisiti:

  • Conoscenza di base del sistema operativo Linux

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
  • SQL*Plus

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?
  • Schemas
  • 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


Sede Data P