Oracle Database 12c Fundamentals for Developers and System Admins Training & Placements in Chennai "ISQL Global"

Oracle Database 12c: Fundamentals for Developers and System Administrators
(Course Materials and Course Completion Certificates are directly delivered from Oracle University to those required for Foreign Opportunity)

(Government of India Approved Education Center)

This Oracle Database 12c: Fundamentals for Developers and System Administrators training helps you perform basic Oracle Database 12c administration tasks. Learn how to keep the database operational.In this course, you will be introduced to Oracle Database Cloud Service.
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:

• InstallOracle Database 12c software and create a database.
• UseEnterprise Manager Database Express to manage the database.
• Manage database storage structures and schema objects.
• AdministerUsers and security.
• Backup and recover the Oracle Database.
• Monitorthe 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 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.
Prerequisites
Suggested Prerequisite

• Basicunderstanding of the Linux operating system

Audience

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

Course Objectives

• UseEnterprise Manager Database Express to manage the database
• Manage database storage structures and schema objects
• AdministerUsers and security
• Backup and recover the Oracle database
• Monitorthe database and use the Advisors
• InstallOracle Database 12c
• Create a Database
• Gain an understanding of the Oracle Database Cloud Service

Course Topics
Course Overview

• AdditionalResources
• Course Objectives
• CourseAgenda
• Course Environment

Oracle Database: Overview

• Oracle Instance and Database: Overview
• Relating Multiple Tables
• Relational Databases: Introduction
• SQLStatements
• StructuredQuery Language (SQL)
• Relational Database Terminology
• Using SQL to Access the Database
• DevelopmentTools for Oracle Database

Installing and Creating a Database

• Configuring Security Updates
• Specifying Installation Options
• InstallationWorkflow
• InstallationSteps
• Setting Environment Variables
• OracleUniversal Installer
• Downloading Software Updates
• Installation Prerequisites

Using Oracle Enterprise Manager Database Express and SQL-Based Management Tools

• Granting Access to EM Express
• ManagementFramework
• Accessing EM Express
• Enterprise Manager Database Express: Overview
• Navigating Through EM Express
• Using the Database Home Page
• SQL*Plus
• Configuring the https Port for EM Express

Configuring the Oracle Network Environment

• Network Configuration: Overview
• Oracle Net Listener: Configuration and Management
• Toolsfor Configuring and Managing the Oracle Network
• Oracle Net: Naming Methods
• NameResolution
• Connecting to an Oracle Database
• Using the Listener Control Utility

Managing the Oracle Instance

• OracleProcesses
• OracleMemory Structures
• Initialization Parameters
• Oracle Instance Management
• Starting and Shutting Down an Instance
• Statesof an Instance
• Stopping and Starting an Instance by Using SQL Developer
• Stopping and Starting an Instance by Using SQL*Plus

Managing Database Storage Structures

• Table spaces and Data Files
• Table spacesin the Preconfigured Database
• Exploring the Storage Structure of the Oracle Database
• Enlarging the Database
• Control File
• Multiplexing the Redo Log
• RedoLog Files
• Oracle Database Structures

Administering Users and Security

• Unlocking a User Account and Resetting the Password
• Setting the Password Policy
• Creating Users
• Dropping Users
• Locking and Unlocking Accounts
• Overview of Users and Security
• Oracle-Define dUsers
• Modifying Users

Managing Schema Objects

• Modifying a Table
• Schemas
• Creating and Modifying Tables
• Understanding Data Integrity
• WhatIs a Schema?
• Accessing Schema Objects
• Specifying Data Types in Tables
• Defining Constraints

Performing Backup and Recovery

• Oracle Recovery Features
• Configuring the Fast Recovery Area
• Backup File Types
• Types of Backups
• MediaRecovery Step
• MediaRecovery Options
• Configuring the Database for Backup and Recovery
• CredentialsRequired to Perform Backup and Recovery

Monitoring the Database and Using the Advisors

• Types of ADDM Findings
• Proactive Database Monitoring
• Responding to Findings
• Viewing a Summary of ADDM Performance Findings
• Diagnosing Performance Problems
• Monitoring Performance
• Using Advisors
• Monitoring General Database State and Workload

Managing the Software

• Patching Oracle Database Software
• Understanding Software Management and Patch Releases
• Using the Database Upgrade Assistant to Upgrade the Database
• Removing Oracle Database Software

Oracle Database Cloud Service: Overview

• Software Editions: Included Database Options and Management Packs
• Automated Database Provisioning
• Using the Oracle Database Cloud Service Console to Manage Patches
• Managing the Compute Node Associated With a Database Deployment
• Database as a Service Architecture, Features and Tooling
• Scaling a Database Deployment & Patching Database as a Service
• Enabling Access to a Compute Node Port
• Managing Network Access to Database as a Service