Course Details

Send A Message

COURSE DESCRIPTION

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. ... Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications.

COURSE CONTENT

    INTRODUCTION
  • What is a database
  • Role of a DBA
  • OLTP vs OLAP Databases
  • What is oracle 11g
  • What is oracle 12c
  • Oracle Instance vs Database
  • ORACLE PROCESS ARCHITECTURE
  • Log writer Process
  • PMON Process
  • RECO Process
  • Archiver Process
  • ORACLE MEMORY ARCHITECTURE
  • Memory Architecture
  • Shared Pool
  • REDO log buffer
  • Java Pool and Streams Pool
  • Buffer Cache
  • PGA in a Shared Envrionment
  • SOFTWARE INSTALLATION

  • Virtual Machine Installation
  • Oracle Software Installation
  • Oracle Parameter Files
  • Database creation - Manual Method Demo
  • Verify Database creation
  • Oracle Shutdown methods
  • Oracle 12c Upgrade
  • TABLESPACE MANAGEMENT
  • How data is stored in a Database?
  • Tablespace Concepts
  • Tablespace Demo 2
  • Let's create a Tablespace...
  • Let's add more space to the Database...
  • Tablespace Demo 2
  • Tablespaces with different block sizes
  • Temporary Tablespace Groups
  • Extent Management (Local vs Dictionary managed)
  • UNDO MANAGEMENT

  • UNDO Concepts
  • ORA-01555 snapshot too old error
  • Automatic Undo Management
  • UNDO Managemen
  • Configuring Undo Retention Period
  • Retention Guarantee!!
  • REDO MANAGEMENT

  • REDO Concepts
  • REDO Logfile Management Demo1
  • REDO Logfile Management Demo2
  • Archival Concepts
  • Archival Log Mode Demo
  • USER MANAGEMENT

  • User Management Concepts
  • User Management Demo 1
  • User Management Demo 2 Privileges
  • System Privileges Demo
  • Object Privileges Demo
  • Revoking User Privileges
  • Revoking System Privileges
  • Revoking Object Privileges
  • Let's practice what we learnt so far...
  • Role Management Concepts
  • Role Management Demo
  • User Profiles
  • User Profile Demo
  • Managing Passwords using Profiles
  • ORACLE NETWORKING

  • Networking Concepts
  • Listener Configuration Demo
  • TNSNAMES Configuration Demo
  • Database Link Concepts
  • Public Database Link
  • Private Database Link
  • ORACLE DATABASE ADMINSTATION WORKSHOP (12C AND HIGHER) INTRODUCTIONS AND FOUNDATIONS

    BASIC INTRODUCTION

  • Brief History of Oracle Database
  • Oracle DB editions
  • DATA BASE V/S DATABASE INSTANCE
  • sever processes and the PGA
  • System Global Area Part 1
  • System Global Area Part 2
  • Background Processes
  • Database Files
  • Logical Storage Structure
  • Default tablespaces
  • Multitenant Database 12c /18
  • DBA Tasks and tools
  • Installation Methods and OS
  • DOWNLOADING & INSTALLING + BASIC LINUX COMMANDS

  • Overview about installation steps
  • Downloading and installing Oracle Vbox
  • Downloading oracle Linux image
  • Creating our virtual machine for this course
  • Installing oracle Linux
  • Installing gust additions
  • Creating shared folder
  • Basic Linux commands part 1
  • Basic Linux commands part 2
  • Basic Linux commands part 3
  • Prerequisites for installing oracle DB 18c
  • Valuable information about the installation Prerequisites
  • OS configurations for oracle user
  • Downloading and installing oracle DB 18c
  • DATABASE STARTUP,SHUTDOWN AND CONNECTIONS

  • Database Startup part 1
  • Database Startup part 2
  • Shutdown database part 1
  • Shutdown database part 2
  • Understanding oracle listener and Listener.ora
  • Understanding service name
  • Understanding tnsnames.ora
  • How client connections work
  • Installing Putty and so connections
  • Installing winSCP and so connections
  • Installing Oracle SQL developer (client side)
  • Connecting sys user in many methods
  • Moving from container to pluggable
  • Starting and stopping the listener
  • Easy connect method
  • connecting using tnsnames
  • unlock the hr schema in the pluggable database
  • saving and runing scripts
  • HELPFUL QUERIES TO EXPLORE ORACLE DBA ARCHITECTURE

  • Oracle data dictionary concepts
  • Common uses VS local users part 1
  • Common uses VS local users part 2
  • Understanding Dynamic Performance Views
  • cdb_ & dba_ when you are inside a pluggable
  • query the data files
  • query the temps files
  • V$DATABASE / v$version / v$instance
  • V$CONTAINERS / cdb_PDBS
  • V$DATAFILE
  • cdb_tablespaces / V$TABLESPACE
  • v$logfile / V$CONTROLFILE
  • Pluggable Database Save state
  • MANAGING DATABASE INSTANCE

  • Initialization Parameters & Parameters Files
  • Search order for a parameter file
  • Uses of Initialization Parameters
  • Types of Initialization Parameters
  • About Modifying Initialization Parameters
  • Alter session example
  • v$parameter VS v$parameter2
  • v$system_parameter VS v$system_parameter2
  • example: Search order for a parameter file and creating pfile
  • Understanding the parameter spfile
  • creating non default name for pfile and startup
  • alter system example ( memory )
  • alter system example ( spfile )
  • alter system example ( both )
  • Default scope in alter statement part 1
  • Default scope in alter statement part 2
  • CONTAINER clause in alter system & Inheritance 1
  • CONTAINER clause in alter system & Inheritance 2
  • About Automatic Diagnostic Repository
  • The alert log Part 1
  • The alert log Part 2
  • View alert log using ADRCI
  • Trace files and Purging Part 1
  • Trace files and Purging Part 2
  • Enable DDL logging
  • V$SPPARAMETER
  • CREATING PDBs

  • About creating PDBs
  • Creating PDB from seed part 1
  • Creating PDB from seed part 2
  • Connecting to the new PDB
  • Creating PDB from seed (DBCA)
  • Dropping pluggable using SQL
  • Dropping pluggable using DBCA
  • Cloning PDBs part 1
  • Cloning PDBs part 2
  • Unplugging and plugging in PDBs part 1
  • Unplugging and plugging in PDBs part 2
  • Unplugging and plugging in PDBs part 3
  • CONFIGURING THE ORACLE NETWORK ENVIRONMENT

  • Establishing a connection and session
  • The default listener
  • The default listener exercise
  • Using non-default port
  • creating dynamic listener example
  • creating static listener example
  • Oracle net configuration assistant (netca)
  • Oracle Net Manager (netmgr )
  • CREATE DATABASE LINK
  • CREATE DATABASE LINK example part 1
  • CREATE DATABASE LINK example part 2
  • ADMINISTRATING USER SECURITY

  • basic knowledge for controlling user access
  • System and objects privileges part 1
  • System and objects privileges part 2
  • Creating private roles examples
  • common users and common privileges
  • common roles
  • More About Users accounts
  • Oracle- supplied administrator accounts
  • Special system privileges for administrators
  • Oracle –supplied roles
  • Best practice to create user like SYS
  • Best practice to create pluggable admin
  • Role granted to another role
  • Understanding the role PDB_DBA (DBCA method)
  • system privileges with admin option
  • About user profile
  • Password Parameters
  • Oracle-supplied password verification functions
  • Resource parameters
  • Creating common profile example
  • Creating local profile example
  • Password verification full example
  • CREATING AND MANAGING TABLESPACES

  • Review tablespaces basic information
  • How table data is stored
  • Database block content
  • About creating tablespace part 1
  • About creating tablespace part 2
  • About creating tablespace part 3
  • Creating new PDB for practice
  • Helpful queries for tablespaces
  • Create permanent tablespace example
  • managing tablespace using SQL developer wizard
  • Alter tablespace and datafile
  • Moving and Renaming Online Data Files
  • last tips for this chapter
  • MANAGING STORAGE SPACE

  • Space can be automatically managed by Oracle
  • Segments,Extents & blocks using SQL 1
  • Segments,Extents & blocks using SQL 2
  • Availability and Optimization of Free Space in a Data Block
  • Row Chaining and Migrating
  • Types of Segments
  • Controlling Deferred Segment Creation
  • Space-Saving Features (UNUSABLE index)
  • basic compression part 1
  • basic compression part 2
  • Advanced row compression
  • Monitoring Tablespace Space Usage
  • DBMS_SERVER_ALERT.SET_THRESHOLD example
  • Reclaiming Wasted Space
  • Segment Advisor
  • Segment Advisor and shrink exercise
  • Managing Resumable Space Allocation
  • MANAGING UNDO DATA

  • Undo Data Overview
  • Transactions and Undo Data
  • Comparing Undo Data and Redo Data
  • Creating new pluggable for practice
  • CREATE UNDO TABLESPACE
  • Local Undo Mode Versus Shared Undo part 1
  • Local Undo Mode Versus Shared Undo part 2
  • Overview of Automatic Undo Management
  • About the Undo Retention Period
  • Categories of Undo
  • Flashback table and Flashback Version Query
  • Automatic Tuning of Undo Retention 1
  • Automatic Tuning of Undo Retention 2
  • MOVING DATA

  • SQL*Loader part 1
  • SQL*Loader part 2
  • External Tables Part 1
  • External Tables Part 2
  • Moving Data from One PDB to Another 1
  • Moving Data from One PDB to Another 2
  • Moving Data from One PDB to Another 3
  • Exporting schema (using user has DBA role)
  • SQL loader Discard file Example
  • Conventional Load Part 1
  • Conventional Load Part 2
  • Direct Path Load part 1
  • `
  • Direct Path Load part 2
  • SQL*Loader express mode
  • External table with PARTITIONS
  • BACKUP AND RECOVERY CONCEPTS

  • DBA Responsibilities
  • Categories of Failure
  • incomplete vs. complete recovery
  • redo logs and archived redo logs
  • Prerequisites of point-in-time-recovery
  • Oracle Backup Technologies
  • Enabling ARCHIVELOG mode
  • Configuring fast recovery area
  • Make free space by dropping some pluggables
  • Doing full backup for CDB and restoring
  • Doing backup for pluggable db
  • point-in-time recovery of the CDB
  • point-in-time recovery of pluggable
  • Deleting backup
  • ORACLE DATABASE PERFORMANCE TUNING

  • Introduction to Oracle Database Performance Tuning 1 of 3
  • Introduction to Oracle Database Performance Tuning 2 of 3
  • Introduction to Oracle Database Performance Tuning 3 of 3
  • ABOUT PERFORMANCE TUNING IN IT SYSTEM

  • About Performance Tuning in IT Systems 1 of 2
  • About Performance Tuning in IT Systems 2 of 2
  • INTRODUCTION TO ORACLE DATABASE PERFORMANCE TUNING TOOLS

  • Introduction to Oracle Database Performance Tuning Tools
  • USING TIME MODLE

  • Using Time Model 1 of 3
  • Using Time Model 2 of 3
  • Using Time Model 3 of 3
  • Using Time Model 1 of 2
  • Using Time Model 2 of 2
  • USING INSTANCE ACTIVITY STATISTICS

C-DAC (Centre for Development of Advanced Computing) ) is an Indian autonomous scientific society, operating under the Ministry of Communication and Information Technology. C-DAC provides several certification courses in the field of advanced computing and software development. Certification from C-DAC is Government of India accredited, and institute providing Government certification, thereby being more authentic, assured and market accepted as compared to other standalone players having limited authenticity.

About us

This philosophy guides us every day to strive towards providing quality computer education to the larger masses. It is our way of influencing lifes’ of individuals around us. Our approach towards education is simply to turn mirrors into windows for our students.
Jai Enterprises,C-DAC’s franchisee in Chembur, is one of the oldest computer institute and training centre in Mumbai. It has been designated as Grade A centre in Maharashtra for last 19 years, a feat achieved by only a handful centres. Gradation primarily depends on the quality of computer education produced, diversity of faculty and their credentials and feedback from students. On all these parameters, we have stood the test of times and have been able to achieve, maintain and provide the highest standards of computer education.
We are Authorized Training Centre of C-DAC GIST PACE. Over the years, we have been aiding and helping students and professionals learn various hardware, software and diploma in computer courses, which have been well-received and appreciated. Our students express this through Testimonials. We have also been associated with disseminating computer education through various social initiatives and imparting computer courses to underprivileged children. Jai Enterprises, through its partners MKCL (MS-CIT), ETH (University of Pune) and MKCL (KLiC Courses) provides its course seekers acompetitive edge over other players in the market.

about images
  • Duration:
  • 140 hours