Detaillierter Kursinhalt
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