Fundamentals for Developers and SysAdmins syllabus and Training in Chennai SQL STAR

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 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.
Suggested Prerequisite

• Basic understanding of the Linux operating system

Audience

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

Course Objective

• 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

Course Topics

Course Overview

• Additional Resources
• Course Objectives
• Course Agenda
• Course Environment

Oracle Database: Overview

• Oracle Instance and Database: Overview
• Relating Multiple Tables
• Relational Databases: Introduction
• SQL Statements
• Structured Query Language (SQL)
• Relational Database Terminology
• Using SQL to Access the Database
• Development Tools for Oracle Database

Installing and Creating a Database

• Configuring Security Updates
• Specifying Installation Options
• Installation Workflow
• Installation Steps
• Setting Environment Variables
• Oracle Universal Installer
• Downloading Software Updates
• Installation Prerequisites

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

• Granting Access to EM Express
• Management Framework
• 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
• Tools for Configuring and Managing the Oracle Network
• Oracle Net: Naming Methods
• Name Resolution
• Connecting to an Oracle Database
• Using the Listener Control Utility

Managing the Oracle Instance

• Oracle Processes
• Oracle Memory Structures
• Initialization Parameters
• Oracle Instance Management
• Starting and Shutting Down an Instance
• States of 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 spaces in the Preconfigured Database
• Exploring the Storage Structure of the Oracle Database
• Enlarging the Database
• Control File
• Multiplexing the Redo Log
• Redo Log 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 d Users
• Modifying Users

Managing Schema Objects

• Modifying a Table
• Schemas
• Creating and Modifying Tables
• Understanding Data Integrity
• What Is 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
• Media Recovery Step
• Media Recovery Options
• Configuring the Database for Backup and Recovery
• Credentials Required 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