Price 20,000.00 GST

Course Features
language
Language: English
access_time
60 hours
spellcheck
Study Level: Intermediate
terrain
Certificate of Completion

Oracle DBA & Cloud Course

Training Highlights

➢ Job Support

➢ Complete Practical

➢ Real-Time Scenarios

➢ Resume Preparation

➢ Lab Access

➢ Placement Support

➢ Support Certification

➢ Interview Preparation

➢ Material, Practice Labs ➢ 100%PlacementAssistance

Oracle DBA Course Content

Modules -1- Linux/UNIX Installation & Commands

Chapter 1- Getting Started with UNIX

What is UNIX? * UNIX Architecture [Hardware, Kernel, Shell, Command & Utilities] * How to Login & Logout in UNIX? * Changing the Password of Logged in User * Listing the Files & Directories * List out the logged in Users * Modes of Shutdown the Linux/Unix OS

Chapter 2- UNIX File Management & the UNIX VI Editor

List the files & Hidden files * Meta characters * Creating the files using various commands * Display the Content of the files * Editing the Files using vi Editor * Counting the Lines, Words and Characters in a file * Copy, Rename and Delete a file

Chapter 3- UNIX Directories Management

Home Directory * Absolute & Relative Pathnames * Create Directories & Creating Parent Directories * Copying and Renaming Directories * Removing Directories * Changing Directories * The directories (. dot) and (.. dot dot)

 

Chapter 4- UNIX File & Directory Permission Setup

The Permission Indicators * File Access Modes [Read r, Write w, Execute x] * Directory Access Modes [Read r, Write w, Execute x] * Changing the Permissions Using chmod with Symbolic Permissions * Changing the Permissions Using chmod with Absolute Permissions * Changing the Ownership of File & Directory [chown command] * Changing the Group Ownership of File & Directory [chgrp command]

Chapter 5- UNIX User & Group Creation & Set the Environment

How to create Group? * How to create User? * How to modify User? * The .profile or .bash_profile file * Setting the Path

Module – 2 ORACLE SQL COMMANDS Chapter 6- Introduction to SQL Statements

SQL Fundaments [Types of SQL Commands (DML, DDL, TCL, DCL) & Description] * Oracle Data Types & Limitation of Data Types * Using the SELECT Statement * Column Alias Name * Use of DISTINCT Keyword * Use of DUAL Table * Use of WHERE clause with Comparison Operators [=, !=, <, <=, >, >=] * Use of Logical Operators [AND, OR, NOT]* Use of Other Operators [IN, NOT IN, BETWEEN, EXITS, IS NULL, IS NOT NULL, LIKE] * Sorting Rows by using ORDER BY clause * HAVING Clause * The CASE Expression * Using Ampersand Substitution Variables

Chapter 7- Single Row Function

Single Row Function Fundamental * Using Single Row Character Function * Using Single Row Numeric Function * Using Single Row Date Function * Using Single Row Conversion Function * Using GROUP function

Chapter 8- Using Join & Sub Queries

Inner Join (Simple Inner Join) * Using Table Alias * Natural Join * Left Outer Join * Right Outer Join * Full Outer Join * SELF Join * Single Row Sub Queries * Multiple-Row Sub Queries

Chapter 9- Using DML Operation & Understanding Transaction Control

Insert New Records * Update Existing Records * Delete Records & TRUNCATE the Table * Commit * Rollback * SAVEPOINT * Rollback to Save-point

Chapter 10- Creating Table and Constraints

Database Object Overview * Creating Tables * Modifying Table [Adding Column, Dropping Column and Hiding Column] * Types of Constraints * Creating Constraint * Enabling & Disabling Constraint * Validating Constraints * Dropping Constraint * Renaming Table * Making Table READ ONLY * Dropping Table

Module – 3 ORACLE DATABASE ARCHITECTURE & INSTALLATION

Chapter 11- Introduction Database & Oracle DBA

What is Database? * Why do we need of Database? * List of major Databases and Database vendors * Tasks of Database Administrator (DBA) * Database related tools and utilities.

Chapter 12- Oracle Database Instance Architecture & Storage Structure

What is Oracle Database 11g & 12c? * What is Database Instance? * Oracle Database Instance Memory Architecture (SGA & PGA) * Subcomponents of Shared/System Global Area (SGA) * Oracle Database Process Architecture [PMON (CLMN), SMON, LREG, CKPT, DBWn, LGWR, MMON…] * Oracle Database Storage Structure * Oracle DB Logical Storage Structure [OS Block, Oracle Data block, Extents, Segment, Table-space] * Oracle DB Physical Storage Structure [Control file, Data files, Online Redo log files, Parameter files] * Oracle Database 12c Multitenant Architecture * Oracle Database 12c Container Database [CDB$ROOT] & Non Container Database * Oracle Database 12c SEED Database [PDB$SEED] * Oracle Database 12c Pluggable database [Application Container Database]

Chapter 13- Oracle Software Installation & Database Creation

Understand prerequisites for a successful Oracle RDBMS software installation. * Installation of Oracle 12cR1 database software with the latest patch set. * Installation of Oracle 12cR2 database software * Planning for Oracle Database Creation * Database Creation using DBCA (Database Configuration Assistance) GUI * Database Creation using script manually with CREATE DATABASE statement * Exploring the Database components Logical & Physically

Chapter 14- Oracle Database Start & Stop and Parameter

Oracle Database Startup modes [STARTUP, STARTUP NOMOUNT, STARTUP MOUNT, OPEN, FORCE] * Oracle Database Open Read Only & Restricted Modes * Oracle Database Shutdown modes [SHUTDOWN NORMAL, TRANSACTIONL, IMMEDIATE, ABORT]—- Parameters —- * Initialization Parameters * Static & Dynamic Parameters * System & Session Level Parameters * Parameter files (Initialization Parameter & Server Parameter files) * Changing the Parameter Value—-Data Dictionary—- * Understanding Data Dictionary * Static & Dynamic Performance Views [V$…,X$……, DBA_, ALL_, USER_] * Using Data Dictionary Views [ DICT, V$FIXED_TABLE]

Chapter 15- User Management & Database Security

What is Oracle Database Users? * Types of Database Users on the basis of Authentication [Database & External (OS) User] * Database 12c Common (C##Username) User & Local User * Create the Database Common User & Local User * Alter the Database Common User &Local User * Types of Privileges [System Level & Object Level Privileges] & Roles * Grant and Revoke the Privileges from Database Users * What is profile? * Assign the Profile to Database User * Create & Alter the Profile * Killing the Session of the Connected User

Module – 4 ORACLE DATABASE ADMINISTRATIONS Chapter 16- Table-space Administration & Data file Administration

Create, Alter & Drop the Permanent Table-space * Add & Resize the data files * Understand Segment space management * Understand the Extent Management * Create Big File Table- space * Table-space Quotas * Configuring the Multi-block Table-space support * Table- space related views [DBA_Tablespaces, DBA_data_files, V$Tablespace, V$Datafile]

Chapter 17- Undo Table-space

Create Undo Table-space and add data file to undo Table-space * Change the Undo Table- space on the Database level * Managing the Transaction & Undo Data * Configuring the Undo Table-space Chapter 18- Temporary Table-space

Create Temporary Table-space * Adding and Resize the temporary file * Temporary Table- space Group * Temporary Table-space views [DBA_temp_files, V$tempfile]

 

Chapter 19- Managing the Control File

Understanding Control Files * Multiplexing Control Files * Backing up Control Files * Control file related view (V$controlfile) Chapter 20- Managing Online Redo log files

Redo Log Files & Archiving * Online & Archived Redo Log Files * Managing Online Redo Log Files * Fast Recovery Area (FRA) * Configuring Database Archive mode * Views related Log [V$LOG, V$LOG_FILE, V$LOGSTDBY, V$LOG_HISTORY, V$RECOVERY_LOG, V$STANDBY_LOG]

Chapter 21- Oracle Net Service Architecture

Overview of Oracle Net Services & It’s component * How Oracle Net Service works? * The Oracle Net Listener * Types of Listener & Oracle Listener configuration [Dynamic and Static Listeners] * Oracle netca (Network Configuration Assistant) utility to Create Listener * Oracle netmgr (Network Manager) utility to Create & Configure the Listener * Oracle Dedicated Server Architecture * Oracle Shared Server Architecture * Oracle Listener Administration and TNS_ADMIN environment variable

Chapter 22- Oracle Database Link

Overview about Oracle Database Link * Type of Database Link [Private & Public Database link] * How to create Oracle Database Link * How to Drop the Oracle Database Link

Module –5 Database Backup Concept (Logical & Physical Backup)

Chapter 23- Oracle Database Logical Backup (Oracle Data Pump)

Oracle Database Data Movement Utilities: * Data Pump Export (Export) expdp & exp * Data Pump Import (Import) impdp & imp * Oracle Data Pump Components DBMS_DATAPUMP & DBMS_METADATA Package * Export & Import Table, Schema, Table- space, Database Chapter

24- Backup, Restore & Recovery using RMAN

Introduction Backup and Recovery * Introduction to RMAN (Recovery Manager) Architecture * Configuring the RMAN Environment * RMAN Backup Concepts like Backup Sets & Image Copy Backup * RMAN Control file & Parameter file backup * RMAN full database & Incremental Backup * RMAN Backup Retention Policy * List out the Archive log backup & Database Backups * RMAN related Views * Concept of Repository Catalog Database * Benefit & Use of Repository Database * RMAN backup CDB & PDB Databases [Backup database root; Backup pluggable database hr_appcont;]

Chapter 25- Oracle Database Flashback & Restore Point

Overview of Flashback Database, Restore Points and Guaranteed Restore Points * About Logging for Flashback Database and Guaranteed Restore Points * Prerequisites for Flashback Database and Guaranteed Restore Points * Using Normal and Guaranteed Restore Points * Using Flashback Database, Table-space, Table

Chapter 26- Oracle Database RMAN Duplicate Cloning

Cloning Concept & Consideration * Cloning Technologies * Cloning Oracle Home * RMAN Duplicate Database Cloning

Chapter 27- Oracle Database Disaster Setup (Standby Database/ Data Guard)

Introduction Oracle Data Guard * Types of Standby Databases & Data Guard Services * Difference between Physical, Logical & Snapshot Standby databases * Oracle Data Guard Architecture * Processes related to Primary & Standby Databases * Creating Physical Standby Database using SQL & RMAN Duplicate command * Open The Physical Standby database to Real Time Apply * Oracle Data Guard Overview

Chapter 28- Oracle Database Performance Tuning

How to handle performance issues in the real world * V$ dynamic views for performance monitoring and analysis * How to define size of Oracle database memory structures for optimal performance * Oracle database wait events * Explain Oracle temporary space internals and sizing. * How to trace database sessions using DBMS_MONITOR and DBMS_SESSION packages * How to format SQL trace files using the tkprof utility * Index Monitoring and internals of index maintenance by Oracle * Statistics data collection for Oracle database optimizer * What is Oracle automatic workload repository (AWR) and how to obtain AWR reports

Chapter 29- Oracle Database Patching

Introduction to Oracle versions and how to understand a version * How to upgrade from one patch-set to another patch-set within the same maintenance release * What are Oracle interim patches? * How to apply SPU patches (Security Patch Updates). * How to apply a Patch Set Update (PSU) * Learn about Oracle Interim Patch Installer (OPATCH) Real world life of an Oracle DBA

Type of Oracle errors & valid errors and internal exceptions (ORA-00600 & ORA-07445 errors) * How to work with Oracle Support https://support.oracle.com to create Service Requests * Parlance and terminology used by Oracle DBAs * Productivity tools required when you join the work place. * Scheduling JOBS and scripts through UNIX/LINUX crontab utility * Oracle DBAAS (Database as a Service) * Navigate with My Services Dashboard. * Oracle 12c ASM (Automatic Storage Management) * Oracle 12c Database Content

Applicable for Plan A, C

Chapter 1- Overview of Oracle Cloud Services

Oracle cloud services [IaaS, PaaS, SaaS, DaaS] * Oracle Cloud Infrastructure as a Services (IaaS) * Oracle Cloud Platform as a Services (PaaS) * Oracle Cloud Software as a Services (SaaS) * Oracle Cloud Data as a Services (DaaS) * Oracle Database Cloud Offerings * Oracle Cloud Subscription Offerings * Subscribe to Oracle Cloud Service

Chapter 2- Creating a Database Deployment

Overview of Database Deployment and an Database Instance * Database Cloud Service Architecture * Features and Tooling * Automated Database Provisioning * Comparison: Database Cloud Service Deployment (DBCS) and on-premises Database * Using the Wizard to Create Database Deployment * Creating a Quick Start Database Deployment *

Standard Editions: Included Capabilities * General Purpose Shapes * High Memory Shapes * How SSH Key Pair are Used * Creating an SSH Key Pair * Additional Database Configuration & Hybrid Disaster Recovery Deployment * Storage Used for Database Files and File System Lay Out * Creating a Database Deployment by using Cold Backup * Creating a Database Deployment from Snapshot * Database Cloud Service Architecture

Chapter 3- Administering a Database Deployment

Oracle Cloud My Services Dashboard and Viewing the Services details * Database Cloud Service Console * Configuring Connections to the Compute Node * Oracle Cloud User Roles and Privileges * Administering Users, Roles and Privileges * Adding and Managing Compute Node Users * Managing Database Users and Privileges * Administering Compute Node Storage * Scaling up a Database Deployment * Cleaning up log and Diagnostic Files * Stopping and Restarting Database Deployment * Patching and Upgrading a Database Deployment Overview * Upgrading a Database Deployment method * Deleting a Database Deployment Chapter 4- Backing UP and Recovering

Backing up and Recovering Database Deployment * Using Utilities to Backup and Recover Database Deployment * Choosing and Changing the Backup Destination * Default and Customizing the Backup Configuration * Creating On-Demand Backup * Performing Recovery by using Console * Performing Recovery by Using the dbaascli Utility Chapter 5-Use Case: Create Database Deployment by Using Production Database

Backup

Creating a Database Deployment from a Production Database backup * Pre-requisites for Restoring a Database Backup Using Backup Cloud Services * High Level Steps for High Provisioning * Provisioning for 18C Database Instance in DBCS Chapter 6- Overview of Oracle Cloud Security

Cloud Security Guideline * Enforcing Security in Database Deployment * Physical and Operating System Security of the Compute Node * User Authentication: Services and Compute Node Access * User Authentication: Database Access Chapter 7- Configuring Network Access to Database Deployment

Describing Network Access to the Compute Node and Database * Creating Security Lists * Configuring Connection to Computer Node * Implementing Fine-Grained Control of Network Traffic * Controlling Network Traffic: Compute Nodes in the Same Security List * Controlling Network Traffic: Compute Nodes in the Different Security List * Controlling Network Traffic: Compute Nodes and External Hosts * Configuring Network Security: Create Security Lists * Configuring Network Security: Associates Compute Nodes to Security Lists * Define Security Rules * Security Rules Example: SSH Protocol * Accessing the Database by using Enterprise Manager Cloud Control * Accessing the Oracle Application Express Console Chapter 8- Using Oracle SQL Developer Web

Enabling a Schema for SQL Developer Web * Accessing SQL Developer web * Managing & Monitoring the database * Monitoring the Listener * Monitoring the Operating System Chapter 9- Implementing Database Deployment Security

Secure Access to Configuration Files on the Compute Node * Backing UP Operating

System and Database Configuration file * Restricting Access to the Database * Protecting Data in Database Deployment * Tablespace Encryption by Default * Transparent Data Encryption (TDE): Overview * Auditing: Compute Node connection, Actions and Database Chapter 10- Use Cases: Configuring Network Isolation

Configuring Network Isolation * Achieving Network Isolation: Use Case * Overview steps for Implementing Network Isolation of Production & Nonproduction servers.* Creating Security Lists * Adding Instance to Security Lists * Creating Security IP Lists * Permitting Access to Oracle Cloud Service Instances Chapter 11- Overview of Migrating to Oracle Database Cloud Service

Choosing a Migration Method: Considerations * Choosing a Migration Method: Understanding the requirement * Choosing a Method: Oracle Data Pump Consideration * Choosing a Method: Unplug/Plug and Remote Cloning Consideration * Choosing a Method: RMAN, SQL * Loader and Golden Gate consideration * Applicable Migration methods Chapter 12- Using SQL Developer to migrate

Overview of Using SQL Developer * Using SQL Developer and INSERT Statements to Migrate Selected Object * Using SQL Developer and SQL * Loader to Migrate Selected Objects Chapter 13- Use Case: Automated Patching of Database Cloud Service

Applying Patches to Database Cloud Service Deployment * Procedures to Apply Patch

Chapter 14- Overview of DBCS Performance Management

Performance Management in the Database Cloud Environment * Performance Monitoring and Tuning * Tuning Methodology * Effective Tuning Goals * General Tuning Session * What can be tuned in a DBCS environment?

Chapter 15- Tuning Performance Issues

Tools for Performance Management * Oracle SQL Developer Web: Database Information * Oracle SQL Developer Web: Operating System Information * Identifying Performance Issues by Using SQL Developer and OEM Express* Diagnose Performance Issues using ADDM and SQL Tuning advisor Chapter 16- Tuning Performance Issues

Database Resource Manager: Overview and Concept * Resource Manager to control PDB Resource Usage * Controlling Resource Usage by Consumer Group * Determining when to scale up the Database Deployment * Scaling up CPU and Memory Chapter 17- Using REST APIs to manage Oracle Database Cloud Service

What is Oracle REST Database Services (ORDS)? * Key Principle of Representational State Transfer (REST). * What does RDS do? * ORDS and Database Cloud Services * Using REST APIs with Database Cloud Service * Using CURL and REST APIs * Viewing and Deleting Database Deployment

Chapter 18- Deleting a Database Deployment

What happens When you delete a Database deployment * How can you delete a Database Deployment.

chat_bubble_outlineReviews

Average Rating

0
No Votes 0 Votes
20,000.00 GST
0 Ratings

Detailed Rating

5 Stars
0
4 Stars
0
3 Stars
0
2 Stars
0
1 Stars
0

There are no reviews yet.

Be the first to review “Oracle DBA”

Your email address will not be published. Required fields are marked *