Oracle Developer Training Pune

Oracle Developer Training Pune

 Course Contents

SQL

  • Introduction to SQL
  • Introduction to SQL constructs
  • In depth DML and DDL statements
  • Restricting & Sorting Data

SQL Advanced

  • Session 1. Aggregate Functions
  • Session 2. Scalar functions
  • Session 3. Joins
  • Session 4. Set Operators
  • Session 5. Subqueries
  • Session 6. GROUP BY Statement
  • Session 7. Best Practice for Sql queries

 

PL/SQL

Basics of PL/SQL:

  • PL/SQL architecture
  • PL/SQL and SQL*Plus
  • PL/SQL Basics, Variables, Constants, data types & error handling
  • PL/SQL wrapper utility

PL/SQL structures:

  • Simple blocks
  • Control structures
  • PL/SQL records
  • Recognizing the Basic PL/SQL Block and Its Sections
  • Describing the Significance of Variables in PL/SQL
  • Distinguishing Between PL/SQL and Non-PL/SQL Variables
  • Declaring Variables and Constants
  • Executing a PL/SQL Block

Exception handling:

  • Defining exceptions
  • Using the when others clause
  • Ensuring complete error checking
  • Passing error messages to calling routine

Boolean logic in PL/SQL:

  • Identifying the Uses and Types of Control Structures
  • Constructing an IF Statement
  • Constructing and Identifying Different Loop Statements
  • Controlling Block Flow Using Nested Loops and Labels
  • Using Logic Tables
  • If-then-else structure
  • Testing for numbers characters and Booleans

Cursors in PL/SQL:

  • Cursor basics
  • Using a cursor for a multi-row SQL query

Iteration in PL/SQL:

  • For loop
  • While loop

PL/SQL tables:

  • Defining PL/SQL tables
  • Reasons to use PL/SQL tables
  • Populating a PL/SQL table
  • Retrieving from a PL/SQL table

Dynamic SQL in PL/SQL:

  • Introduction to the dbms_sql package
  • Creating a dynamic SQL statement

Nested blocks in PL/SQL:

  • Introduction to the dbms_sql package
  • Creating a dynamic SQL statement

Triggers in PL/SQL:

  • Triggers and database events
  • Defining a trigger
  • Timing a trigger
  • Enabling and disabling a trigger

Stored procedures, functions and packages:

  • Basics of stored procedures
  • Basics of functions
  • Basics of packages
  • Defining stored procedures & functions
  • Function and stored procedures prototypes
  • Passing arguments to functions and stored procedures
  • Recompiling functions and stored procedures
  • Pinning packages in the SGA with dbms_shared_pool.keep
  • Package forward declaration
  • Package dependency
  • Package overloading
  • Listing package information

Bulking in PL/SQL:

  • Bulk queries
  • Bulk DML (forall statement)
  • Using cursor attributes
  • Analyzing impact of bulk operations

 Project Session

  • Interview Preparation
  • Duration: 2 Months

Oracle Developer Training Pune

Course DurationRV Technologies provides DBA Training Pune.

RV Technologies: DBA Training in Pune

Oracle DBA Course Syllabus

Sql Fundamental

Retrieving Data Using the SQL SELECT Statement

  • List the capabilities of SQL SELECT statements
  • Execute a basic SELECT statement

Restricting and Sorting Data

  • Limit the rows that are retrieved by a query
  • Sort the rows that are retrieved by a query
  • Use ampersand substitution to restrict and sort output at runtime

Using Single-Row Functions to Customize Output

  • Describe various types of functions available in SQL
  • Use character, number, and date functions in SELECT statements

Using Conversion Functions and Conditional Expressions

  • Describe various types of conversion functions that are available in SQL
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Apply conditional expressions in a SELECT statement

Reporting Aggregated Data Using the Group Functions

  • Identify the available group functions
  • Describe the use of group functions
  • Group data by using the GROUP BY clause
  • Include or exclude grouped rows by using the HAVING clause

Displaying Data from Multiple Tables

  • Write SELECT statements to access data from more than one table using equijoins and nonequijoins
  • Join a table to itself by using a self-join
  • View data that generally does not meet a join condition by using outer joins
  • Generate a Cartesian product of all rows from two or more tables

Using Subqueries to Solve Queries

  • Define subqueries
  • Describe the types of problems that the subqueries can solve
  • List the types of subqueries
  • Write single-row and multiple-row subqueries

Using the Set Operators

  • Describe set operators
  • Use a set operator to combine multiple queries into a single query
  • Control the order of rows returned

Manipulating Data

  • Describe each data manipulation language (DML) statement
  • Insert rows into a table
  • Update rows in a table
  • Delete rows from a table
  • Control transactions

Using DDL Statements to Create and Manage Tables

  • Categorize the main database objects
  • Review the table structure
  • List the data types that are available for columns
  • Create a simple table
  • Explain how constraints are created at the time of table creation
  • Describe how schema objects work

Creating Other Schema Objects

  • Create simple and complex views
  • Retrieve data from views
  • Create, maintain, and use sequences
  • Create and maintain indexes
  • Create private and public synonyms

11g Administration I

Exploring the Oracle Database Architecture

  • Explain the Memory Structures
  • Describe the Process Structures
  • Overview of Storage Structures

Preparing the Database Environment

  • Identify the tools for Administering an Oracle Database
  • Plan an Oracle Database installation
  • Install the Oracle software by using Oracle Universal Installer (OUI)
  • Creating an Oracle Database
  • Create a database by using the Database Configuration Assistant (DBCA)

Managing the Oracle Instance

  • Setting database initialization parameters
  • Describe the stages of database startup and shutdown
  • Using alert log and trace files
  • Using data dictionary and dynamic performance views

Configuring the Oracle Network Environment

  • Configure and Manage the Oracle Network
  • Using the Oracle Shared Server architecture

Managing Database Storage Structures

  • Overview of tablespace and datafiles
  • Create and manage tablespaces
  • Space management in tablespaces

Administering User Security

  • Create and manage database user accounts
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles

11g Administration II

Database Architecture and ASM 

  • Describe Automatic Storage Management (ASM)
  • Set up initialization parameter files for ASM and database instances
  • Start up and shut down ASM instances
  • Administer ASM disk groups

Configuring for Recoverability

  • Configure multiple archive log file destinations to increase availability
  • Define, apply and use a retention policy
  • Configure the Flash Recovery Area
  • Use Flash Recovery Area

Using the RMAN Recovery Catalog 

  • Identify situations that require RMAN recovery catalog
  • Create and configure a recovery catalog
  • Synchronize the recovery catalog
  • Create and Use RMAN stored scripts
  • Back up the recovery catalog
  • Create and use a virtual private catalog

Configuring Backup Specifications 

  • Configure backup settings
  • Allocate channels to use in backing up
  • Configure backup optimization

Using RMAN to Create Backups 

  • Create image file backups
  • Create a whole database backup
  • Enable fast incremental backup
  • Create duplex backup and back up backup sets
  • Create an archival backup for long-term retention
  • Create a multisection, compressed and encrypted backup
  • Report on and maintain backups

Performing User-Managed Backup and Recovery 

  • Recover from a lost TEMP file
  • Recover from a lost redo log group
  • Recover from the loss of password file
  • Perform user-managed complete database recovery
  • Perform user-managed incomplete database recovery
  • Perform user-managed and server managed backups
  • Identify the need of backup mode
  • Back up and recover a control file

Using RMAN to Perform Recovery 

  • Perform complete recovery from a critical or noncritical data file loss using RMAN
  • Perform incomplete recovery using RMAN
  • Recover using incrementally updated backups
  • Switch to image copies for fast recovery
  • Restore a database onto a new host
  • Recover using a backup control file
  • Perform Disaster recovery
  • Using RMAN to Duplicate a Database
  • Creating a duplicate database
  • Using a duplicate database
  • Performing Tablespace Point-in-Time Recovery
  • Identify the situations that require TSPITR
  • Perform automated TSPITR

Monitoring and Tuning RMAN 

  • Monitoring RMAN sessions and jobs
  • Tuning RMAN
  • Configure RMAN for Asynchronous I/O

Using Flashback Technology 

  • Restore dropped tables from the recycle bin
  • Perform Flashback Query
  • Use Flashback Transaction

Additional Flashback Operations 

  • Perform Flashback Table operations
  • Configure, Monitor Flashback Database and Perform Flashback Database operations
  • Set up and use a Flashback Data Archive

Diagnosing the Database 

  • Set up Automatic Diagnostic Repository
  • Using Support Workbench
  • Perform Block Media Recovery
  • Create and use Database Resource Manager Components

Automating Tasks with the Scheduler 

  • Create a job, program, and schedule
  • Use a time-based or event-based schedule for executing Scheduler jobs
  • Create lightweight jobs
  • Use job chains to perform a series of related tasks

Administering the Scheduler 

  • Create Windows and Job Classes
  • Use advanced Scheduler concepts to prioritize jobs

RV Technologies: DBA Training in Pune

Oracle RAC Training Pune

Oracle RAC Training Pune

Oracle Real Application Cluster

 

Course Objectives

  • Understand Oracle cluster Architecture
  • Install an Oracle cluster
  • Create a RAC database
  • Manage RAC instances
  • Use RAC utilities
  • Set up failover
  • Set up Backup and Recovery
  • Manage clusters
  • Troubleshoot RAC

Course Contents: 

Cluster Architectural

  • cluster Architecture
  • Shared Storage
  • Nodes and Interconnects
  • Virtual IP Addresses
  • Oracle Software
  • Oracle Cluster Registry (OCR)
  • The RAC Voting Disk

Oracle Clusterware

  • What is Oracle Clusterware ?
  • Oracle Clusterware Components
  • Oracle Clusterware Processes
  • Oracle Clusterware and Shared Storage
  • Oracle Clusterware Preinstallation Steps
  • Node Preparation
  • Configuraing SSH User Equivalency
  • Installing Oracle Clusterware
  • cluvfy - The Cluster Varification Utility
  • Oracle Clusterware Postinstallation

 

Installing DB Software and Creating a RAC Database

  • Installation Overview
  • Configuring the OS Envirionment
  • Verifying System REadiness with the CVU
  • Installing the Database Software
  • Troubleshooting Installation Setup
  • Recommended Postinstallation Tasks
  • Running the VIPCA
  • Creating a Cluster Database Using DBCA
  • Database Pre-Creation Tasks
  • Initialization Parameter

RAC Database Architecture

  • Oracle Single-Instance Architecture
  • Overview of RAC
  • RAC Architecture
  • RAC Instance and Parameter Files
  • RAC Database Components
  • RAC Instance Background Processes
  • Global Resource Direcotry
  • Overview of Cache Fusion
  • Cache Fusion Components - GES and GCS
  • Cache Fusion Background processes
  • Application Connection to RAC

Managing Oracle Clusterware

  • About Oracle Clusterware
  • Backing Up and Recovering Voting Disks
  • Adding and Removing Voting Disks
  • The OCR
  • Changing the OCR Configuration
  • Adding and Removing an OCR Location
  • backing Up and Recovering the OCR
  • Resotring from Automatic OCR Backups
  • Moving or Replacing the OCR
  • Repairing the OCR Configuration
  • Troubleshooting the OCR

RAC Instance Management

  • Overview of RAC Instance Management
  • Starting and Stoping a RAC Database
  • RAC Database Identical Parameters
  • RAC Database Unique Parameters
  • Changing Parameter Values
  • Administering Undeo Tablespaces in RAC
  • Administering Redo Logs in RAC

RAC Utilities

  • The ocrcheck Utilitiy
  • The ocrdump Utility
  • The crs_stat Utility
  • The crsctl Utility
  • The Server Control (SRVCTl) Utility
  • SRVCTL ADD
  • SRVCTL CONFIG
  • SRVCTL ENABLE and DISABLE
  • SRVCTL GETENV
  • SRVCTL MODIFY
  • SRVCTL RELOCATE
  • SRVCTL REMOVE
  • SRVCTL START
  • SRVCTL STOP

Services

  • Overview or Services
  • Types of Servicers
  • Creating Services with DBCA
  • Creating SErvices with SRVCTL
  • Preferred and Available Instances for Services
  • Using Services
  • Managing Services
  • Service Views
  • Tracing with Services

 

Failover

  • Transparent Application Failover (TAF)
  • Client-Side vs. Server-Side TAF
  • configuring TAF on the client
  • Configuring TAF on the Server
  • Using OEM to Configure TAF
  • Using SRVCTL to Configure TAF
  • Using DBCA to Configure TAF
  • The DBMS_SERVICE Package
  • Connecting to the Database with TAF
  • Monitoring TAF Connection

RAC Backup and Recovery

  • Overview of RAC Backup and Recovery
  • Log Archiving in RAC
  • Undo Tablespaces in RAC
  • Using Flashback Features in RAC
  • Deploying a Flash Recovery Area in RAC
  • Performing RMAN Backups of a RAC Database
  • Performing Non-RMAN Backups
  • Preparing to Restore and Recover with RMAN
  • Recover the RAC Database with RMAN
  • Recovering Without RMA

Cluster Management

  • Overview of Cluster Management Tasks
  • Extending the Clusterware Home Directory
  • Extending the ASK Home directory
  • Extending the Database Software Home Direcotory
  • Creating a Listener on the New Node
  • Creating the New Instance
  • Verifying the New Instance
  • Removing a Node

RAC Troubleshooting

  • The Oracle Clusterware Alert Log
  • Clusterware Component Log Files
  • Using crsctl to Diagonose Cluster Issues
  • Using diagcollection
  • Checking Interconnect Setting
  • cluvfy - Verifying clusterware Component Integrity
  • cluvfy - verifying Cluster Registry Integrity
  • cluvfy - Verifying Cluster Integrity
  • RAC Database Aletrts
  • The racdiag.sql Script
  • The oradebug Utility

RAC Tuning

  • RAC Tuning Methodology
  • Using Performance Views in RAC
  • Monitoring Cache Fusion
  • Global Cache Latencies
  • Monitoring Cache Transfers

Oracle RAC Training Pune