Oracle Certification Training in Patna & Best Oracle 11g certification Training Institute in Patna

Oracle Database 10g Administrator Certified Associate

• Retrieing Data Using the SQL SELECT Statement
• Restricting and Sorting Data
• Using Single-Row functions to customize output
• Reporting aggregated data using the group functions
• Displaying data from multiple tables
• Using sub queries to sole queries
• Using the set operations
• Manipulating data
• Using DDL statements to create and manage tables
• Managing objects with data dictionary
• Controlling user access
• Managing scheme objects
• Managing large data sets
• Generating reports by grouping related data
• Managing data in different time zones
• Retrieing data using sub queries
• Hierarchical retrieal

Oracle Database 10g Administration

• Architecture
• Installing the Oracle database software
• Creating an Oracle database
• Managing the Oracle instance
• Managing database storage structures
• Administering user security
• Managing schema objects
• Managing data and concurrency
• Managing undo data
• Implementing Oracle database security
• Configuring the Oracle network enironment
• Proactie maintenance
• Performance management
• Backup and recoery concepts
• Performing database backup
• Performing database recoery
• Performing flashback moing data

Oracle Database 11g OCA

Overview

• This hands-on course will teach you to effectively plan, install, configure, administer, query, troubleshoot and manage Oracle Databases.
• The course will prepare students for the Oracle exams, as well as deliver a foundation in the real world application of their database skills.

Training Prerequisites

• This course is designed for individuals with generic database knowledge.

Course Content Oracle11g OCA

Describing the Oracle Architecture

• Oracle Server
• SGA
• Datafiles
• Background Processes

Creating an Oracle Database

• Database Configuration Assistance
• Database Templates

Managing an Oracle Instance

• Oracle Enterprise Manager

Database Storage Structures

• Tablespaces
• Datafiles
• Tempfiles

Database Security

• System Accounts
• Application Accounts
• Database Roles

Schema Objects

• Tables
• Indexes
• Views
• Synonyms

Data Manipulation Language

• Insert
• Update
• Delete
• Database Packages
• Database Procedures

Undo Data

• Flashback Query

Database Maintenance

• Automatic Workload Repository
• Automatic Database Diagnostic Monitor

Database Performance

• Memory Advisors

Database Backup

• RMAN
• Open database Backup
• Closed database Backup

Database Recovery

• Open Database Recovery
• Closed Database Recovery

Moving Data

• Data Pump
• SQL*Loader

Course Outline

SELECT Statements

• Define projection, selection, and join terminology
• Select all columns using a wildcard notation from a table
• Write a query containing the arithmetic operators
• Create a character expression with the concatenation operator
• Using the iSQL*Plus Environment
• SQL statements versus iSQL*Plus commands

Restricting and Sorting Data

• Limit rows using a selection
• Using the WHERE clause to retrieve specific rows
• Using the comparison conditions in the WHERE clause
• Use the LIKE condition to compare literal values
• List the logical conditions AND, OR, NOT
• Describe the rules of precedence for the conditions
• Sort rows with the ORDER BY clause

Single-Row Functions

• Show the differences between single row and multiple row SQL functions
• Categorize the character functions into case manipulation and character manipulation types
• Use the character manipulation functions in the SELECT and WHERE clauses
• Explain and use the DATE and numeric functions

Aggregate Functions

• Describe and categorize the group functions
• Use the group functions
• Utilize the DISTINCT keyword with the group functions
• Describe how nulls are handled with the group functions
• Create groups of data with the GROUP BY clause
• Group data by more than one column
• Avoid illegal queries with the group functions
• Exclude groups of data with the HAVING clause

Joining Tables

• Identify Types of Joins
• Retrieve Records with Natural Joins
• Use Table Aliases to write shorter code and explicitly identify columns from multiple tables
• Create a Join with the USING clause to identify specific columns between tables
• Use the ON clause to specify arbitrary conditions or specify columns to Join
• List the Types of Outer Joins LEFT, RIGHT, and FULL
• Generating a Cartesian Product

Using Sub queries

• List the syntax for sub queries in a SELECT statements WHERE clause
• List the guidelines for using sub queries
• Describe the types of sub queries
• Execute single row sub queries and use the group functions in a sub query
• Identify illegal statements with sub queries
• Execute multiple row sub queries

Manipulating Data

• Write INSERT statements to add rows to a table
• Copy rows from another table
• Create UPDATE statements to change data in a table
• Generate DELETE statements to remove rows from a table
• Use a script to manipulate data
• Save and discard changes to a table through transaction processing
• Show how read consistency works
• Describe the TRUNCATE statement

Creating Tables

• List the main database objects and describe the naming rules for database objects
• Explain the different types of constraints
• Show resulting exceptions when constraints are violated with DML statements
• Create a table with a sub query
• Describe the ALTER TABLE functionality
• Remove a table with the DROP statement and Rename a table

Creating Objects

• Categorize simple and complex views and compare them
• Create a view
• Retrieve data from a view
• Explain a read-only view
• List the rules for performing DML on complex views
• Create a sequence
• List the basic rules for when to create and not create an index
• Create a synonym

Security

• Controlling User Access
• System versus Objects Privileges
• Using Roles to define user groups
• Changing Your Password
• Granting Object Privileges
• Confirming Privileges Granted
• Revoking Object Privileges

Schema Objects

• Using the ALTER TABLE statement
• Adding a Column
• Modifying a Column
• Dropping a Column, Set Column UNUSED
• Adding, Enabling and Disabling Constraints
• Creating Function-Based Indexes
• Performing FLASHBACK operations
• External Tables

Advanced DML Operations

• Using the MERGE Statement
• Performing DML with Sub queries
• Performing DML with a RETURNING Clause
• Tracking Changes in DML

Time Zone Changes

• Using date and time functions
• Identifying TIMESTAMP Data Types
• Differentiating between DATE and TIMESTAMP
• Performing Conversion Operations

Advanced Sub queries

• Sub query Overview
• Using a Sub query
• Comparing several columns using Multiple-Column Sub queries
• Defining a Data source Using a Sub query in the FROM Clause
• Returning one Value using Scalar Sub query Expressions
• Performing ROW by-row processing with Correlated Sub queries
• Reusing query blocks using the WITH Clause

Oracle 11g Certified Professional

Database Architecture and ASM

• Oracle Database Architecture Overview
• ASM General Architecture
• Creating an ASM Instance
• Using Enterprise Manager to Manage ASM Users
• ASM Storage Concepts
• The ASMCMD Utility
• ASM Scalability and Performance
• Configuring for Recoverability

Purpose of Backup and Recovery Functionality

• Typical Backup and Recovery Tasks
• Oracle Backup and Recovery Solutions
• Using Recovery Manager (RMAN)
• Using a Flash Recovery Area
• Flash Recovery Area Space Management
• Using the RMAN Recovery Catalog

RMAN Repository Data Storage: Comparison of Options

• Storing Information in the Recovery Catalog
• Registering a Database in the Recovery Catalog
• Recovery Catalog Resynchronization: Concepts
• Using RMAN Stored Scripts
• Backing Up and Recovering the Recovery Catalog
• Using a Virtual Private Catalog
• Configuring Backup Specifications

Using RMAN to Create Backups

• Configuring Persistent Settings for RMAN
• Using Enterprise Manager to Configure RMAN Settings
• Control File Auto-backups
• Managing Persistent Settings
• Configuring Devices for Backup
• Configuring and Allocating Channels for Use in Backups
• Configuring Backup Optimization
• Creating Backups

Creating an Oracle-Suggested Backup

• Creating Backup Sets & Image Copies
• Creating a Whole Database Backup
• RMAN Backup Types
• Monitoring Block Change Tracking
• Creating Duplex Backup Sets
• Archival Backups: Concepts
• Encrypting Backups
• Performing User-Managed Backup and Recovery

Restoring and Recovering

• Causes of File Loss
• Critical Versus Non-critical
• Recovering from a TEMPFILE Loss
• Re-creating Indexes
• Recovering from a Lost Index Tablespace
• Authentication Methods for Database Administrators
• Recovering a Read-Only Tablespace
• Using RMAN to Perform Recovery

Using RMAN RESTORE and RECOVER Commands

• Performing Recovery Using Enterprise Manager
• Recovery Using Incrementally Updated Backups
• Perform a Fast Switch to Image Copies
• Restoring and Recovering the Database on a New Host
• Performing Disaster Recovery
• Using RMAN to Duplicate a Database

Using RMAN to Create a Duplicate Database

• Creating a Duplicate Database
• Creating an Initialization Parameter File for the Auxiliary Instance
• Allocating Auxiliary Channels
• Understanding the RMAN Duplication Operation
• Using EM to Clone a Database
• Cloning a Running Database
• Performing Tablespace Point-in-time Recovery

Tablespace Point-in-Time Recovery (TSPITR) Concepts

• Tablespace Point-in-Time Recovery: Architecture
• Understanding When to Use TSPITR
• Determining the Tablespaces for the Recovery Set
• Using Enterprise Manager to Perform TSPITR
• Understanding TSPITR Processing
• Troubleshooting RMAN TSPITR
• Monitoring and Tuning RMAN

Parallelization of Backup Sets

• Monitoring RMAN Sessions
• Interpreting RMAN Message Output
• Using the DEBUG Option
• Tuning RMAN
• RMAN Multiplexing
• Comparing Synchronous and Asynchronous I/O
• Tape Subsystem Performance Rules
• Using Flashback Technology

Flashback Technology

• Transactions and Undo
• Guaranteeing Undo Retention
• Preparing Your Database for Flashback
• Flashback Drop and the Recycle Bin
• Using Flashback Technology to Query Data
• Possible Workflow
• Flashback Transaction Wizard
• Using Flashback Database

Flashback Table

• Enabling Row Movement on a Table
• Enabling Row Movement on a Table
• Flashback Database Architecture
• Configuring Flashback Database
• Performing Flashback Database Using EM
• Flashback Database Considerations
• Flashback Data Archive
• Diagnosing the Database

Automatic Diagnostic Workflow & Repository

• Location for Diagnostic Traces
• Viewing the Alert Log Using Enterprise Manager
• The Support Workbench and Oracle Configuration Manager
• Create a Service Request
• Package and upload diagnostic data to Oracle Support
• Incident Packaging Configuration
• Health Monitor Overview & Data Recovery Advisor
• Managing Memory

Oracle Memory Structures

• Automatic Memory Management Overview
• Oracle Database Memory Parameters
• Auto Memory Parameter Dependency
• Automatic Shared Memory Management: Overview
• Automatic PGA Memory Management
• Using the Memory Advisor to Size the SGA
• Memory Tuning Guidelines for the Library Cache
• Managing Database Performance

Tuning Activities

• Performance Planning & Performance Tuning Methodology
• Instance Tuning
• Troubleshooting and Tuning Views
• Automatic Workload Repository
• SQL Tuning & SQL Advisors
• Using the SQL Tuning Advisor
• SQL Access Advisor: Overview
• Using the Segment Advisor

Space Management: Overview

• Proactive Tablespace Monitoring
• Thresholds and Resolving Space Problems
• Monitoring Tablespace Space Usage
• Shrinking Segments
• Space Reclamation with ASSM
• Automatic Segment Advisor
• Minimum Compatibility Level
• Managing Resources

Database Resource Manager: Overview

• Database Resource Manager Concepts
• Accessing Resource Plans
• Default Maintenance Resource Manager Plan
• Creating Consumer Groups
• Resource Allocation Methods for Resource Plans
• Resource Allocation Methods for Resource Plans
• Monitoring the Resource Manager
• Automating Tasks with the Scheduler

Simplifying Management Tasks

• Key Components and Steps
• Creating an Event-Based Schedule
• Creating Complex Schedules
• Creating Job Chains
• Creating Job Chains
• Administering the Scheduler

Advanced Scheduler Concepts

• Job Classes
• Windows
• Prioritizing Jobs Within a Window
• Remote Jobs
• Installing the Scheduler Agent
• Dictionary Views Supporting Remote Jobs
• Globalization

Globalization Support Features

• What Every DBA Needs to Know
• Understanding Unicode
• Database Character Sets and National Character Sets
• Language- and Territory-Dependent Parameters
• Linguistic Searching and Sorting
• Case- and Accent-Insensitive Search and Sort
• NLS Data Conversion with Oracle Utilities

ORACLE DATABASE 12c ADMINISTRATOR CERTIFIED ASSOCIATE

INTRODUCTION TO ORACLE DATABASE 12c:

• Overview of the Oracle Database 12c
• Overview of the Oracle Cloud
• Relational database concepts
• Database administration tasks

ORACLE DATABASE 12c ARCHITECTURE:

• Overview of the Oracle database architecture
• The Oracle database instance
• Oracle Database memory structures
• Process architecture and structures
• Server and client processes
• The Oracle database storage architecture
• Connect to the Oracle database instance

ADMINISTER A DATABASE INSTANCE:

• Administrative tools available to a DBA
• Use SQL*Plus in Oracle to manage a database instance
• Use SQL Developer to manage a database instance
• Administer the database using Enterprise Manager (EM)
• Overview of the Enterprise Manager framework
• Access Enterprise Manager Database Express
• The Enterprise Manager Database Express Home Page
• Enterprise Manager Cloud Control
• Initialization parameter files

CONFIGURE THE ORACLE NETWORK ENVIRONMENT:

• Overview of network configuration
• Oracle Net Listener configuration and management
• Oracle Net naming methods
• Tools for configuring and managing the Oracle network
• Using the Net Configuration Assistant
• Configure client connections with Net Manager
• View listener configuration
• Start and stop the Oracle listener
• Use TNSPING to test Oracle Net connectivity
• Connect to the database
• Configure Net Services with Enterprise Manager

STORAGE STRUCTURES:

• Overview of data storage
• The database block
• Overview of tablespaces and datafiles
• Use Enterprise Manager to view the storage structure of the database
• Create and alter tablespace commands
• Temporary tablespaces
• Create and manage datafiles
• Use OMF
• Drop tablespaces and datafiles

MANAGE USERS:

• Predefined database administration accounts
• User accounts
• Create a user account
• User authentication
• Change a user's password
• Manage a user account
• Drop a user account
• Monitor user information
• Terminate user sessions

MANAGE PROFILES AND RESOURCES:

• Overview of user profiles
• Profile resource parameters
• Create profile command
• Manage passwords with profiles
• Control resource usage with profiles
• Maintain profiles

MANAGE PRIVILEGES:

• Database access
• Oracle supplied roles
• System and object level privileges
• The grant and revoke commands
• Create, modify and drop roles
• Use predefined roles

DATABASE AUDITING:

• Overview of database security
• Overview of database auditing
• Security compliance
• Standard auditing
• Unified audit trail
• Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles
• Configure the audit trail
• Specify audit options

DATA CONCURRENCY AND LOCK CONFLICTS:

• Levels of locking in Oracle
• Methods used to acquire locks
• Data concurrency
• Possible causes of contention
• DML locks
• Prevent locking problems
• Detect lock contention
• Resolve conflicts

UNDO MANAGEMENT:

• Undo data overview
• Monitor and administer undo
• Configure undo retention
• Switch undo tablespaces
• Specify the retention period
• Guarantee undo retention
• Retention period for flashback queries
• View undo space information
• Use the undo advisor
• Size the undo tablespace
• Alter an undo tablespace to a fixed size

PROACTIVE DATABASE MAINTENANCE:

• Database Maintenance
• View the alert log
• The Automatic Workload Repository
• Statistic levels
• The Automatic Database Diagnostic Monitoring
• Monitor an Oracle database
• Use the Advisors
• Set up notification rules

PERFORMANCE MANAGEMENT:

• Tuning information sources
• Performance monitoring
• Tuning activities
• Performance planning
• Instance tuning
• Performance tuning methodology
• Performance tuning data
• Monitoring performance
• Managing memory

SQL TUNING:

• SQL tuning
• The Oracle Optimizer
• SQL Plan directives
• Adaptive execution plans
• SQL Advisors
• Automatic SQL Tuning results
• Implement automatic tuning recommendations
• SQL Tuning Advisor

MOVING DATA:

• Create directory objects
• Data Pump architecture
• Data Pump data dictionary views
• Data Pump interactive mode
• Data Pump API
• Use Data Pump to export data
• Use Data Pump to import data
• Overview of SQL Loader
• Command line parameters
• Record filtering
• Control file keywords
• Datafiles
• SQL Loader data paths
• External Tables

AUTOMATE TASKS WITH THE SCHEDULER:

• Introduction to the Scheduler
• Access Rights
• Scheduler components and workflow
• Create a Job
• Job Classes
• Use time based, event based schedules
• Create an event based schedule
• Oracle Database 12c Administration Training Course

MANAGING RESOURCES WITH RESOURCE MANAGER:

• Overview of the Database Resource Manager
• Use the Resource Manager
• Create Resource Plans
• The default maintenance resource manager plan
• Create Resource Plan Directives
• Allocate resources for Resource Plans

MANAGE SPACE:

• Overview of space management
• Block space management within segments
• Segment types
• Allocate extents
• Allocate space
• Row chaining and migration
• Create tables without segments

BACKUP AND RECOVERY CONFIGURATION:

• Oracle backup solutions
• Oracle suggested backup strategy
• Overview of database backup, restore and recover
• Flashback technology
• Types of failure
• Instance recovery
• Tune instance recovery
• The MTTR Advisor
• Media failure
• Configure a database for recoverability

ORACLE SUPPORT:

• The Enterprise Manager Support Workbench
• Register for security updates
• Work with Oracle Support
• My Oracle Support integration
• Log Service Requests
• Manage patches
• Apply a patch

Oracle Certification training duration in Patna

Regular Classes( Morning, Day time & Evening)

• Duration : 7 weeks

Weekend Training Classes( Saturday, Sunday & Holidays)

• Duration : 11 Weeks

Fast Track Training Program( 8+ hours classes daily)

• Duration : within 8 weeks

Oracle Certification trainer Profile & Placement

Our Oracle Certification Trainers

• More than 9 Years of experience in Oracle Certification Technologies
• Has worked on 9 realtime Oracle Certification projects
• Working in a MNC company in Patna
• Trained 2243+ Students so far.
• Strong Theoretical & Practical Knowledge
• Oracle Certification certified Professionals

Oracle Certification (oracle 11g certification) Placement Training in Patna

• More than 2243+ students Trained
• 1676 students Placed
• 1054 Interviews Organized
• Placement Supported by InterviewDesk.com

Oracle Certification training Locations in Patna

Our Oracle 11g certification Training centers

• Gandhi Maidan
• Kankarbagh
• sri krishnapuri
• Ashiana Nagar
• Chitkohra
• Gulzar Bagh
• Kumhrar
• Rajendra nagar
• Phulwari Sharif
• Mithapur

Oracle Certification training batch size (students per class) in Patna

Regular Batch ( Morning, Day time & Evening)

• Seats Available : 7 (maximum)

Weekend Training Batch( Saturday, Sunday & Holidays)

• Seats Available : 10 (maximum)

Fast Track batch

• Seats Available : 3 (maximum)

Oracle Certification related training courses

• Oracle course
• Oracle PLSQL course
• Oracle DBA course
• Oracle Forms & Reports course
• Oracle Performance Tunning course
• Oracle RAC course
• Oracle ADF course