RSS
GoldenLine
Facebook
Nowoczesna Firma
Blog
Tablet 7"
z Androidem 4.4
Tablet 10 cali dla uczestników
dla uczestników



Oracle Database 12c: Fundamentals for Developers and System Administrators (D79228GC10)

Autoryzacja

Szkolenie autoryzowane Oracle

Format prowadzenia szkolenia

ILT - szkolenie klasyczne, w sali szkoleniowej, z trenerem

Kod szkolenia

D79228GC10

Dla kogo

  • Database Administrators
  • Support Engineer
  • Technical Administrator
  • Technical Consultant

Czas trwania

2 dni

Cena bazowa

PLN 2980

Cel

  • 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
  • Install Oracle Database 12c
  • Create a Database
  • Gain an understanding of the Oracle Database Cloud Service

Opis

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 12cThroughout 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.

Tematy

  1. Course Overview
    • Course Objectives
    • Course Agenda
    • Course Environment
    • Additional Resources
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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

Wymagania

    • Basic understanding of the Linux operating system

Zgłaszanie chęci uczestnictwa

W celu zgłoszenia chęci uczestnictwa w szkoleniu prosimy o pobranie i wypełnienie formularza lub wygenerowanie go ze strony, a następnie przeslanie faksem na numer (22) 398 47 82.

Pobierz formularz zgłoszenia w formacie DOC
Pobierz formularz zgłoszenia w formacie PDF

Jeśli potrzebują Państwo wsparcia, mają pytania lub chcą się upewnić odnośnie wyboru szkolenia prosimy o kontakt pod numerem 0-801 009 706. Nasi przedstawiciele chętnie odpowiedzą na Państwa pytania oraz pomogą w podjęciu trafnej decyzji.