Duration
2 days
What you will learn
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.
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
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.
Audience
Database Administrators
Support Engineer
Technical Administrator
Technical Consultant
Related Training
Required Prerequisites
Basic understanding of the Linux operating system
Course Objectives
Install Oracle Database 12c
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
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
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
Programme scope, delivery arrangements and suitability are confirmed during enquiry.