Oracle DBA 12c
=====
Course Id : DATA-ODBA
Duration : 24 Hours
Overview
—–
* Oracle 12C supports cloud computing
* Oracle 12C has high performance and management benefits, along with efficient and fast Cloud provisioning
* In this course you will learn how to create and manage an Oracle Database environment
* This course covers monitoring the Database also
Pre-Requisites
——-
* Participants should have the basic knowledge of SQL
* Should know the basic UNIX/LINUX commands
Training Objectives
——
* Learn the fundamentals of relational databases
* Control database access to specific objects
* Manage schema objects
* Create and query external tables
* Installing Oracle Database 12c
* Creating and maintaining Oracle Database Instances
* Understand building and managing Storage Structures
* Understand how to configure and manage the Network Environment
* Understand creating and managing users
* Learn to monitor and troubleshoot the database while ensuring performance
* Learning basic backup and recovery techniques
Course Structure
—–
* We provide more focus on hands-on in our technical courses (typically 80% hands-on/20% theory)
* Students get the capability to apply the material they learn to real-world problems
Materials Provided
—–
* PDF of slides and hands-on exercises
* Access to instance with lab environment
Software Requirements
—–
Any of the following
* Any current internet browser
* vnc client
* rdp client
Hardware Requirements
—–
* Processor: 1.2 GHz
* RAM: 512 MB
* Disk space: 1 GB
* Network Connection with low latency (<250ms) to Internet
Course Outline
## Daywise course outline
—–
## Day 1
—–
* Unit 1 : Introduction to SQL
* Unit 2 : Introduction to DDL
## Day 2
—–
* Unit 3 : Architecture
* Unit 4 : Install and Upgrade
* Unit 5 : Administration
## Day 3
—–
* Unit 6 : Backup and Recovery Concepts
* Unit 7 : Managing Database Performance
* Unit 8 : Oracle Database Cloud Service: Overview
## Detailed Course Outline
—–
Unit 1 : Introduction to SQL
—–
* Introduction
* Retrieving Data using the SQL SELECT Statement
* Restricting and Sorting Data
* Using Single-Row Functions to Customize Output
* Using Conversion Functions and Conditional Expressions
* Reporting Aggregated Data Using the Group Functions
* Displaying Data from Multiple Tables Using Joins
* Using Subqueries to Solve Queries
* Using the SET Operators
* Managing Tables using DML statements
Unit 2 : Introduction to DDL
—–
* Introduction to Data Definition Language
* Introduction to Data Dictionary Views
* Creating Sequences, Synonyms, Indexes
* Creating Views
* Managing Schema Objects
* Retrieving Data by Using Subqueries
* Manipulating Data by Using Subqueries
* Controlling User Access
* Manipulating Data
* Managing Data in Different Time Zones
Unit 3 : Architecture
—–
* Introduction
* Exploring the Oracle Database Architecture
* Oracle Software Installation Basics
Unit 4 : Install and Upgrade
—–
* Installing Oracle Database Software
* Creating an Oracle Database by Using DBCA
* Oracle Database Management Tools
* Managing the Database Instance
* Configuring the Oracle Network Environment
Unit 5 : Administration
—–
* Administering User Security
* Managing Database Storage Structures
* Managing Space
* Managing Undo Data
* Managing Data Concurrency
* Implementing Oracle Database Auditing
Unit 6 : Backup and Recovery Concepts
—–
* Backup and Recovery Configuration
* Performing Database Backups
* Performing Database Recovery
* Moving Data
Unit 7 : Managing Database Performance
—–
* Managing Performance
Unit 8 : Oracle Database Cloud Service: Overview
—–