PL/SQL

Sample DescriptionThe Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code.

Learn To:

  • Use various features of PL/SQL.
  • Write anonymous blocks of code in PL/SQL.
  • Use various PL/SQL conditional constructs and loops in program blocks.
  • Interface the PL/SQL code with the database.
  • Use stored procedures and functions in their program blocks.
  • Handle Exceptions in PL/SQL code.

Benefits To You

Students will benefit from this course as it enables programmers with the skill of using this programming language. In the class students will learn to create anonymous PL/SQL blocks, to create procedures, functions and triggers. Students will learn to use explicit cursors in their program blocks. Demonstrations and hands-on practice reinforce the fundamental concepts. Students use Oracle SQL Developer to develop these program units. SQL*Plus is introduced as optional tools.

  • Any Graduates(B.A,B.Com,B.Sc)
  • Engineering Students(B.Tech, B.E, M.Tech)
  • BCA,MCA
  • Any Diploma Holder
  • Any Working Professionals
  • Data Warehouse Administrators
  • Database Administrators
  • Software Tester
  • Project Manager
  • MIS Support

Introduction

  • Course Objectives, Course Agenda and Class Account Information
  • The Human Resources (HR) Schema
  • Appendices Used in this Course
  • PL/SQL Development Environments

Introduction to PL/SQL

  • Understanding the benefits and structure of PL/SQL
  • Understanding PL/SQL Blocks
  • Generating output messages in PL/SQL

Declaring PL/SQL Variables

  • Identifying valid and invalid identifiers
  • Declaring and initializing variables
  • Various data types
  • Identifying the benefits of using the %TYPE attribute
  • Using bind variables

Writing Anonymous PL/SQL blocks

  • Lexical Units in a PL/SQL Block
  • Using SQL Functions in PL/SQL
  • Data Type Conversion
  • Using Nested Blocks as Statements
  • Referencing an Identifier Value in a Nested Block
  • Qualifying an Identifier with a Label
  • Operators in PL/SQL
  • Using Sequences in PL/SQL Expressions

Using SQL Statements within a PL/SQL Block

  • Using SQL Statements in PL/SQL
  • Retrieving Data in PL/SQL with the SELECT statement
  • Using Naming Conventions in DML Statements and data retrieval
  • Manipulating Data on the Server Using PL/SQL
  • SQL Cursors
  • Using SQL Cursor Attributes to Obtain Feedback on DML
  • Saving and Discarding Transactions

Writing Control Structures

  • Controlling PL/SQL Flow of Execution
  • Using IF and CASE Statements for conditional processing
  • Handling Nulls
  • Building Boolean Conditions with Logical Operators
  • Using Iterative Control with Loop Statements

Working with Composite Data Types

  • Composite Data Types of PL/SQL Records and Tables
  • Using PL/SQL Records
  • Inserting and Updating PL/SQL Records
  • Using INDEX BY Tables
  • Using Associative arrays
  • Declaring and Using VArrays

Using Explicit Cursors

  • Cursors
  • Explicit Cursor Operations
  • Controlling Explicit Cursors
  • Using Explicit Cursors to Process Rows
  • Cursors and Records
  • Cursor FOR Loops Using Subqueries
  • Explicit Cursor Attributes
  • %NOTFOUND and %ROWCOUNT Attributes

Handling Exceptions

  • Concept of Exception
  • Handling Exceptions with PL/SQL
  • Predefined Exceptions
  • Trapping Predefined and Non-predefined Oracle Server Errors
  • Functions that Return Information on Exceptions
  • Usage of PRAGMA keyword
  • Trapping User-Defined Exceptions
  • Propagating Exceptions

Creating Stored Procedures and Functions

  • Overview of Stored Procedures and Functions
  • Differentiating between anonymous blocks and subprograms
  • CREATE OR REPLACE PROCEDURE | FUNCTION
  • Understanding the Header Area of a Stored Procedure and Function
  • Creating Simple Procedures and Functions
  • Creating a Simple Procedure with an IN Parameter
  • Executing a Procedure and a Function
  • Design PL/SQL anonymous block that execute efficiently
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Handle exceptions in the program units
  • Create and execute simple stored procedures and functions
  • Write PL/SQL code to interface with the database
  • Describe the features and syntax of PL/SQL

Oracle Cloud 12C

The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.

Learn To:

  • Manage an Oracle Database instance.
  • Configure the Oracle Network environment.
  • Create and manage storage structures.
  • Manage and move data.
  • Create and manage users.
  • Monitor the database and manage performance.
  • Create and manage Database as a Cloud Service database deployments.

Benefits To You

You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.

To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

  • Any Graduates(B.A,B.Com,B.Sc)
  • Engineering Students(B.Tech, B.E, M.Tech)
  • BCA,MCA
  • Any Diploma Holder
  • Any Working Professionals
  • Data Warehouse Administrators
  • Database Administrators
  • Software Tester
  • Project Manager
  • MIS Support

Getting Started

  • Course Objectives

Exploring Oracle Database Architecture

  • Introducing Oracle Database
  • Relation Database Models
  • Oracle SQL and PL/SQL
  • Oracle Database Server Architecture
  • Connecting to Oracle Databases
  • Oracle Database Tools
  • Oracle-Supplied User Accounts
  • Querying the Oracle Data Dictionary

Managing Database Instances

  • Initialization Parameter Files
  • Starting Up Oracle Databases
  • Shutting Down Oracle Databases
  • Opening and Closing PDBs
  • Working with the Automatic Diagnostic Repository (ADR)
  • Querying Dynamic Performance Views

Creating PDBs

  • Methods and Tools to Create PDBs
  • Creating PDBs from Seed with SQL*Plus
  • Cloning PDBs with SQL*Plus
  • Unplugging and Pluggin In PDBs with SQL*Plus
  • Dropping PDBs with SQL*Plus

Configuring the Oracle Network Environment

  • Oracle Net Services
  • How Listeners Work
  • Configuring Listeners for Dynamic Service Registration
  • Configuring Listeners for Static Service Registration
  • Configuring Local Naming for Connections
  • Testing Oracle Net Connectivity with tnsping
  • Configuring Communidation Between Databases
  • Dedicated Versus Shared Server Configurations

Administering User Security

  • Creating Users
  • Granting Privileges
  • Creating and Granting Roles
  • Revoking Privileges and Roles
  • Creating and Assigning Profiles
  • Authenticating Users
  • Assigning Quotas to Users
  • Applying the Principal of Least Privilege

Creating and Managing Tablespaces

  • How Table Data is Stored
  • Creating Tablespaces in SQL*Plus
  • Altering and Dropping Tablespaces in SQL*Plus
  • Viewing Tablespace Information in SQL*Plus
  • Implementing Oracle Managed Files
  • Moving and Renaming Online Data Files in SQL*Plus

Managing Storage Space

  • Oracle Database Space Management Features
  • Block Space Management
  • Row Chaining and Migration
  • Free Space Management Within Segments
  • Types of Segments
  • Allocating Extents
  • Understanding Deferred Segment Creation
  • Space-Saving Features
Managing UNDO Data
  • Undo Data: Overview
  • Transactions and Undo Data
  • Storing Undo Information
  • Comparing Undo Data and Redo Data
  • Managing Undo
  • Local Undo Mode Versus Shared Undo Mode
  • Configuring Undo Retension
  • Categories of Undo

Moving Data

  • Moving Data: General Architecture
  • Oracle Data Pump: Overview
  • Oracle Data Pump: Benefits
  • Data Pump Export and Import Clients
  • Data Pump Utility: Interfaces and Modes
  • Data Pump Import: Transformations
  • SQL*Loader Overview
  • Loading Methods

Backup and Recovery Concepts

  • DBA Responsibilities
  • Categories of Failure
  • Understanding Instance Recovery
  • Understanding Types of Backups
  • Comparing Complete and Incomplete Recovery
  • Oracle Data Protection Solutions
  • Flashback Technology

Monitoring and Tuning Database Performance

  • Managing Performance Activities
  • Performance Planning Considerations
  • Database Maintenance
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor
  • Performance Monitoring
  • Performance Tuning Methodology
  • Database Server Statistics and Metrics

SQL Tuning

  • SQL Tuning Process
  • Oracle Optimizer
  • Optimizer Statistics
  • SQL Plan Directives
  • Adaptive Execution Plans
  • SQL Tuning Advisor
  • SQL Access Advisor
  • SQL Performance Analyzer

Oracle Database Resource Manager

  • Oracle Database Resource Manager: Overview
  • Resource Manager Elements
  • Using Resource Manager to Allocate Resources
  • Creating a Simple Resource Plan
  • Creating a Complex Resource Plan
  • Using the Active Session Pool Feature
  • Limiting CPU Utilization at the Database Level
  • Limiting CPU Utilization at the Server Level

Enterprise Manager Cloud Control

  • Controlling the Enterprise Manager Cloud Control Framework
  • Starting the Enterprise Manager Cloud Control Framework
  • Stopping the Enterprise Manager Cloud Control Framework

Introduction to Oracle Database Cloud Service

  • Oracle Cloud: Overview
  • Database Cloud Service Offerings
  • DBCS Architecture
  • Features and Tooling
  • Additional Database Configuration Options

Creating DBCS Database Deployments

  • Automated Database Provisioning
  • Creating a Database Deployment
  • How SSH Key Pairs are Used
  • Creating an SSH Key Pair
  • Storage Used for Database Files

Managing DBCS Database Deployments

  • Cloud Tooling
  • Accessing Tools and Features from the DBCS Console
  • Managing the Compute Node Associated With a Database Deployment
  • Managing Network Access to DBCS
  • Enabling Access to a Compute Node Port
  • Scaling a Database Deployment

Backing Up and Restoring DBCS Database Deployments

  • Backing Up and Recovering Databases on DBCS
  • Backup Destination Choices
  • Backup Configuration
  • Creating an On-Demand Backup
  • Customizing the Backup Configuration
  • Performing Recovery by Using the Console
  • Performing Recovery by Using the dbaascli Utility

Patching DBCS Database Deployments

  • Patching DBCS
  • Using the DBCS Console to Manage Patches
  • Using the dbaascli Utility to Manage Patches

Creating Master Encryption Keys for PDBs

  • CDB and PDB Master Encryption Keys
  • Determining Whether You Need to Create and Activate and Encryption Key for a PDB
  • Creating and Activating an Encryption Key

Tablespace Encryption by Default

  • Tablespace Encryption by Default in DBCS
  • Transparent Data Encryption (TDE) Overview
  • Components of TDE
  • Using TDE
  • Defining the Keystore Location
  • Controlling Tablespace Encryption by Default
  • Managing the Software Keystore and Master Encryption Key
  • Managing the Keystore in CDBs and PDBs
  • Deploy management agents in various forms
  • Setup a load balancer within the EM framework
  • Understand techniques for disaster recovery of EM in an HA environment
  • Implement security of EM framework
  • Maximize the use of My Oracle Support
  • Become familiar with silent and command line EM operations
  • Deploy EM with a 2-node RAC repository for High Availability and Scalability
  • Configure Oracle Management Services (OMS) and expand to multiple OMSs

SQL

This Oracle Database 12c: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

Learn To:

  • Understand the basic concepts of relational databases ensure refined code by developers.
  • Create reports of sorted and restricted data.
  • Run data manipulation statements (DML).
  • Control database access to specific objects.
  • Manage schema objects.
  • Manage objects with data dictionary views.
  • Retrieve row and column data from tables.
  • Control privileges at the object and system level.
  • Create indexes and constraints; alter existing schema objects.
  • Create and query external tables.

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 by enabling consolidation onto database clouds.

Learn Advanced Features of SQL

This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL through expert instruction.

Use Development Tools

The main development tool used in this training is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is appropriate for a 10g, 11g and 12c audience.

  • Any Graduates(B.A,B.Com,B.Sc)
  • Engineering Students(B.Tech, B.E, M.Tech)
  • BCA,MCA
  • Any Diploma Holder
  • Any Working Professionals
  • Data Warehouse Administrators
  • Database Administrators
  • Software Tester
  • Project Manager
  • MIS Support

Introduction

  • Course Objectives, Course Agenda and Appendixes Used in this Course
  • Overview of Oracle Database 12c and Related Products
  • Overview of relational database management concepts and terminologies
  • Introduction to SQL and its development environments
  • What is Oracle SQL Developer?
  • Starting SQL*Plus from Oracle SQL Developer
  • The Human Resource (HR) Schema
  • Tables used in the Course

Retrieving Data using the SQL SELECT Statement

  • Capabilities of the SELECT statement
  • Arithmetic expressions and NULL values in the SELECT statement
  • Column aliases
  • Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • Use of the DESCRIBE command

Restricting and Sorting Data

  • Limiting the Rows
  • Rules of precedence for operators in an expression
  • Substitution Variables
  • Using the DEFINE and VERIFY command

Using Single-Row Functions to Customize Output

  • Describe the differences between single row and multiple row functions
  • Manipulate strings with character function in the SELECT and WHERE clauses
  • Manipulate numbers with the ROUND, TRUNC and MOD functions
  • Perform arithmetic with date data
  • Manipulate dates with the date functions

Using Conversion Functions and Conditional Expressions

  • Describe implicit and explicit data type conversion
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Nest multiple functions
  • Apply the NVL, NULLIF, and COALESCE functions to data
  • Use conditional IF THEN ELSE logic in a SELECT statement

Reporting Aggregated Data Using the Group Functions

  • Group Functions
  • Creating Groups of Data
  • Restricting Group Results

Displaying Data from Multiple Tables Using Joins

  • Introduction to JOINS
  • Types of Joins
  • Natural join
  • Self-join
  • Non equijoins
  • OUTER join

Using Subqueries to Solve Queries

  • Introduction to Subqueries
  • Single Row Subqueries
  • Multiple Row Subqueries

Using the SET Operators

  • Set Operators
  • UNION and UNION ALL operator
  • INTERSECT operator
  • MINUS operator
  • Matching the SELECT statements
  • Using ORDER BY clause in set operations

Managing Tables using DML statements

  • Data Manipulation Language
  • Database Transactions

Introduction to Data Definition Language

  • Data Definition Language

Introduction to Data Dictionary Views

  • Introduction to Data Dictionary
  • Describe the Data Dictionary Structure
  • Using the Data Dictionary views
  • Querying the Data Dictionary Views

Creating Sequences, Synonyms, Indexes

  • Overview of sequences
  • Overview of synonyms
  • Overview of indexes

Creating Views

  • Overview of views

Managing Schema Objects

  • Managing constraints
  • Creating and using temporary tables
  • Creating and using external tables

Retrieving Data by Using Subqueries

  • Retrieving Data by Using a Subquery as Source
  • Working with Multiple-Column subqueries
  • Using Scalar subqueries in SQL
  • Correlated Subqueries
  • Working with the WITH clause

Manipulating Data by Using Subqueries

  • Using Subqueries to Manipulate Data
  • Inserting by Using a Subquery as a Target
  • Using the WITH CHECK OPTION Keyword on DML Statements
  • Using Correlated Subqueries to Update and Delete rows

Controlling User Access

  • System privileges
  • Creating a role
  • Object privileges
  • Revoking object privileges

Manipulating Data

  • Overview of the Explicit Default Feature
  • Using multitable INSERTs
  • Using the MERGE statement
  • Performing flashback operations
  • Tracking Changes in Data

Managing Data in Different Time Zones

  • Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
  • Working with INTERVAL data types
  • Identify the major structural components of the Oracle Database 12c
  • Manage objects with data dictionary views
  • Manage schema objects
  • Retrieve row and column data from tables
  • Run data manipulation statements (DML) in Oracle Database 12c
  • Use scalar and correlated sub-queries
  • Utilize views to display data
  • Write SELECT statements that include queries
  • Write multiple-column sub-queries
  • Control database access to specific objects
  • Create reports of aggregated data
  • Create reports of sorted and restricted data
  • Create tables to store data
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax
  • Employ SQL functions to retrieve customized data

RAC

This Oracle Database 12c: Clusterware & RAC Admin Accelerated training covers 8 days worth of content in only 5 days. It starts with the Oracle Database 12c: Clusterware Administration course (4 days) and then covers the Oracle RAC database architecture(4 days); learn how these products work together.In this course, you will be introduced to Oracle Database Exadata Cloud Service.

Learn To:

  • Perform Grid Infrastructure pre-installation tasks.
  • Install both Standard and Flex clusters.
  • Add and remove nodes from a cluster in addition to upgrading and patching existing Grid Homes.
  • Manage and administer both Standard Clusters and Policy-Managed Clusters.
  • Use Oracle Clusterware to make applications highly available.
  • Install Oracle RAC software.
  • Create cluster databases.
  • Administer both administrator and policy-managed Oracle RAC databases.
  • Monitor and address performance issues.
  • Learn about services in a RAC environment as well as highly available connection features including Application Continuity and Transaction Guard.
  • Create and administer a RAC One Node Database.
  • Create and manage multitennant RAC databases.
  • Gain an understanding of the Oracle Database Exadata Cloud Service.

Benefits to You

By taking this course, you'll know how to make applications highly available using Oracle Clusterware and RAC. You'll walk away with the ability to install, configure, manage and troubleshoot both Oracle Clusterware and Oracle RAC software. Ensure fast, reliable, secure and easy to manage performance as you learn to optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

  • Any Graduates(B.A,B.Com,B.Sc)
  • Engineering Students(B.Tech, B.E, M.Tech)
  • BCA,MCA
  • Any Diploma Holder
  • Any Working Professionals
  • Data Warehouse Administrators
  • Database Administrators
  • Software Tester
  • Project Manager
  • MIS Support

Grid Infrastructure: Overview

  • What is a Cluster?
  • What is a Flex Cluster ?
  • Clusterware Characteristics
  • Oracle Clusterware
  • Hardware and Software Concepts (High level)
  • RAC and Flex ASM

RAC Databases Overview & Architecture

  • Overview of Oracle RAC
  • Oracle RAC One Node (High level)
  • Cluster-Aware Storage Solutions
  • Benefits of Using RAC
  • Scaleup and Speedup
  • I/O Throughput Balanced
  • Global Resources

Installing and Configuring Oracle RAC

  • Installing the Oracle Database Software
  • Installation options
  • Creating the Cluster Database
  • Configuring Oracle RAC Reader Nodes
  • Post-installation Tasks
  • Single Instance to RAC Conversion using DBCA and rconfig

Oracle RAC Administration

  • Separation of Duty for Administering Oracle RAC
  • Use Enterprise Manager Cluster Database Pages
  • RAC Alerts
  • RAC Metrics
  • Undo Tablespaces
  • Local Temporary Tablespaces
  • Redo Threads
  • Parameters and RAC - SPFILE, Identical and Unique Parameters

Upgrading and Patching Oracle RAC

  • Ovierview of Upgrades and Patching
  • Release and Patch Set Upgrades
  • PSU, CPU and Interim Patches
  • Merge Patches
  • Performing Out of Place Database Upgrades
  • Planning and Preparing for Upgrade
  • Post Upgrade Tasks

Managing Backup and Recovery for RAC

  • Instance Failure And Recovery In RAC - LMON and SMON
  • Redo Threads and Archive Logs Configurations and Admin
  • Parameter Settings Affecting Parallel Recovery and MTTR
  • RAC and the Fast Recovery Area
  • RMAN Configuration
  • RMAN Admin for RAC: Channels, Instances, Backup Considerations

RAC Global Resource Management and Cache Fusion

  • Globally Managed Resources and Management
  • Library Cache Management
  • Row cache management
  • Buffer cache fusion
  • Buffer Cache Management Requirements
  • Accessing single blocks in RAC
  • Multi-block read considerations in RAC
  • Undo and read consistency considerations in RAC

RAC Database Monitoring and Tuning

  • OCPU and Wait Time Latencies
  • Wait Events for RAC
  • Common RAC Tuning
  • Session and System Statistics
  • RAC specific V$ Views
  • Automatic Database Diagnostic Monitor for RAC
  • Monitoring RAC with Cluster Health Advisor (CHA)

Managing High Availability of Services in a RAC Environment

  • Oracle Services
  • Services for Policy - and Administrator-Managed Databases
  • Service-Oriented Buffer Cache Access
  • Creating Services
  • Managing Services
  • Use Services with Client Applications
  • Services and Connection Load Balancing
  • Services and Transparent Application Failover

Managing High Availability of Connections

  • Types of Workload Distribution
  • Client-Side Load Balancing
  • Server-Side Load Balancing
  • Runtime Connection Load Balancing and Connection Pools
  • Fast Application Notification
  • The Load Balancing Advisory FAN Event
  • Server-Side Callouts
  • Configuring the Server-Side ONS

Application Continuity

  • What is AC?
  • What problem does it solve?
  • Benefits of AC
  • How AC works
  • AC Architecture
  • Side Effects
  • Restrictions
  • Application requirements

RAC One Node

  • RAC One Node Concepts
  • Online database migration
  • Adding Oracle RAC One Node Database to an Existing Cluster
  • Convert an Oracle RAC One Node database to a RAC database
  • Convert an Oracle RAC database to a RAC One Node database
  • Use DBCA to convert a single instance database to a RAC One Node database

Oracle Database In-Memory in RAC

  • Architecture of In-Memory Column Store
  • Implementing In-Memory Column Store in RAC
  • Implementing In-Memory FastStart

Multitenant Architecture and RAC

  • Non-CDB Architecture
  • Multitenant Architecture: Benefits
  • CDB in a Non-RAC Environment
  • Containers
  • Terminology and Data Dictionary Views
  • Connection to a Non-RAC CDB
  • Oracle RAC and Multitenant Configuration
  • Oracle RAC and Multitenant Architecture

Quality of Service Management

  • QOS Management concepts
  • Describe the benefits of using QoS Management
  • QoS Management components
  • QoS Management functionality

Oracle Database Exadata Cloud Service Overview

  • Introducing Exadata Cloud Service
  • Service Configuration Options & Service Connection Options
  • Service Architecture & Availability
  • Management Responsibilities
  • Storage Configuration & Management Details
  • Simple Web-Based Provisioning & Management
  • REST APIs
  • Migrating to Exadata Cloud Service
  • Configure Oracle RAC Reader Nodes
  • Define redo log files in a RAC environment
  • Define undo tablespaces in a RAC environment
  • Define local temporary tablespaces in a RAC environment
  • Modify initialization parameters in a RAC environment
  • Perform post-database-creation tasks
  • Configure RMAN for the RAC environment
  • Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
  • Explain the necessity of global resources
  • Describe global cache coordination
  • Explain the principles and purposes of clusters
  • Describe the Oracle Clusterware architecture
  • Describe the benefits of Oracle RAC
  • Convert a single-instance Oracle Database to RACs
  • Install the Oracle Database software
  • Create a cluster database

Oracle DBA

This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam.

Learn To:

  • Install Oracle Grid Infrastructure.
  • Create and manage users.
  • Install and configure an Oracle Database.
  • Create and manage storage structures.
  • Administer the Oracle Database.
  • Understand the Oracle database architecture and how its components work and interact with one another.
  • Perform backup and recovery.

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 by enabling smooth and rapid consolidation within your Datacenter.

Create an Operational Database

You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. This includes performance monitoring, database security, user management and backup/recovery techniques.

Training Requirements

This Oracle Database 11g: Administration Workshop I Release 2 course fulfills the training requirement for an Oracle Certification Path. Only instructor-led online (LVC, LWC), in-class (ILT) or Training On Demand courses fulfill the requirement. Please note that Self-Study Courses and Knowledge Center courses do not fulfill the training requirement.

  • Any Graduates(B.A,B.Com,B.Sc)
  • Engineering Students(B.Tech, B.E, M.Tech)
  • BCA,MCA
  • Any Diploma Holder
  • Any Working Professionals
  • Data Warehouse Administrators
  • Database Administrators
  • Software Tester
  • Project Manager
  • MIS Support

Exploring the Oracle Database Architecture

  • Oracle Database Architecture Overview
  • Oracle ASM Architecture Overview
  • Process Architecture
  • Memory structrues
  • Logical and physical storage structures
  • ASM storage components

Installing your Oracle Software

  • Tasks of an Oracle Database Administrator
  • Tools Used to Administer an Oracle Database
  • Installation: System Requirements
  • Oracle Universal Installer (OUI)
  • Installing Oracle Grid Infrastructure
  • Installing Oracle Database Software
  • Silent Install

Creating an Oracle Database

  • Planning the Database
  • Using the DBCA to Create a Database
  • Password Management
  • Creating a Database Design Template
  • Using the DBCA to Delete a Database

Managing the Oracle Database Instance

  • Start and stop the Oracle database and components
  • Use Oracle Enterprise Manager
  • Access a database with SQLPlus
  • Modify database installation parameters
  • Describe the stages of database startup
  • Describe database shutdown options
  • View the alert log
  • Access dynamic performance views

Manage the ASM Instance

  • Set up initialization parameter files for ASM instance
  • Start up and shut down ASM instances
  • Administer ASM disk groups

Configuring the Oracle Network Environment

  • Use Enterprise Manager to create and configure the Listener
  • Enable Oracle Restart to monitor the listener
  • Use tnsping to test Oracle Net connectivity
  • Identify when to use shared servers and when to use dedicated servers

Managing Database Storage Structures

  • Storage Structures
  • How Table Data Is Stored
  • Anatomy of a Database Block
  • Space Management in Tablespaces
  • Tablespaces in the Preconfigured Database
  • Actions with Tablespaces
  • Oracle Managed Files (OMF)

Administering User Security

  • Database User Accounts
  • Predefined Administrative Accounts
  • Benefits of Roles
  • Predefined Roles
  • Implementing Profiles

Managing Data Concurrency

  • Data Concurrency
  • Enqueue Mechanism
  • Resolving Lock Conflicts
  • Deadlocks

Managing Undo Data

  • Data Manipulation
  • Transactions and Undo Data
  • Undo Data Versus Redo Data
  • Configuring Undo Retention

Implementing Oracle Database Auditing

  • Describe DBA responsibilities for security
  • Enable standard database auditing
  • Specify audit options
  • Review audit information
  • Maintain the audit trail

Database Maintenance

  • Manage optimizer statistics
  • Manage the Automatic Workload Repository (AWR)
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Describe and use the advisory framework
  • Set alert thresholds
  • Use server-generated alerts
  • Use automated tasks

Performance Management

  • Performance Monitoring
  • Managing Memory Components
  • Enabling Automatic Memory Management (AMM)
  • Automatic Shared Memory Advisor
  • Using Memory Advisors
  • Dynamic Performance Statistics
  • Troubleshooting and Tuning Views
  • Invalid and Unusable Objects

Backup and Recovery Concepts

  • Part of Your Job
  • Statement Failure
  • User Error
  • Understanding Instance Recovery
  • Phases of Instance Recovery
  • Using the MTTR Advisor
  • Media Failure
  • Archive Log Files

Performing Database Backups

  • Backup Solutions: Overview
  • Oracle Secure Backup
  • User-Managed Backup
  • Terminology
  • Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Backing Up the Control File to a Trace File
  • Monitoring the Flash Recovery Area

Performing Database Recovery

  • Opening a Database
  • Data Recovery Advisor
  • Loss of a Control File
  • Loss of a Redo Log File
  • Data Recovery Advisor
  • Data Failures
  • Listing Data Failures
  • Data Recovery Advisor Views

Moving Data

  • Describe ways to move data
  • Create and use directory objects
  • Use SQL*Loader to move data
  • Use external tables to move data
  • General architecture of Oracle Data Pump
  • Use Data Pump export and import to move data

Working with Support

  • Use the Enterprise Manager Support Workbench
  • Work with Oracle Support
  • Log service requests (SR)
  • Manage patches
  • Install Oracle Grid Infrastructure
  • Install and configure Oracle Database 11g
  • Configure Oracle Net services
  • Monitor and administer undo data
  • Manage the database storage structures
  • Create and administer user accounts
  • Perform basic backup and recovery of a database
  • Manage data concurrency
  • Monitor performance
  • Describe Oracle Database Architecture

Data Guard

This Oracle Database 12c: Data Guard training teaches you how to use Oracle Data Guard. Expert Oracle University instructors will demonstrate how this solution protects your Oracle database against planned and unplanned downtime. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

Learn To:

  • Build highly available systems.
  • Offload business processing needs to another system.
  • Offload backup needs to another system.
  • Gain an understanding of Oracle Database Exadata Cloud Service.

Benefits to You

You'll walk away from this course with an understanding of how Data Guard standby databases can be used to support various production functions. These functions include reporting, querying and testing, while in a standby role.

Oracle Data Guard 12c

This course will also teach you about the new Oracle Data Guard 12c features and architecture. You'll get a chance to explore topics like Oracle Active Data Guard, Far Sync, rolling upgrades and snapshot standby databases. Furthermore, enrolling in this course will help you learn how to manage and troubleshoot a Data Guard configuration.

Introduction to Oracle Data Guard

  • What Is Oracle Data Guard?
  • Types of Standby Databases
  • Types of Data Guard Services
  • Role Transitions: Switchover and Failover
  • Oracle Data Guard Broker Framework
  • Choosing an Interface for Administering a Data Guard Configuration
  • Oracle Data Guard: Architecture(Overview)
  • Primary Database Processes

Networking for Oracle Data Guard

  • Networking Overview
  • Listener.ora Configuration
  • Statics vs. Dynamic Registration
  • Static Entries for Database Duplication and SQL Maintenence
  • Static Entries for Broker Operations
  • Oracle Network Configuration Tuning
  • Tnsnames.ora Configuration

Creating a Physical Standby Database by Using SQL and RMAN Commands

  • Steps to Create a Physical Standby Database
  • Preparing the Primary Database
  • FORCE LOGGING Mode
  • Configuring Standby Redo Logs
  • Creating Standby Redo Logs
  • Using SQL to Create Standby Redo Logs
  • Viewing Standby Redo Log Information
  • Setting Initialization Parameters on the Primary Database to Control Redo Transport
  • Any Graduates(B.A,B.Com,B.Sc)
  • Engineering Students(B.Tech, B.E, M.Tech)
  • BCA,MCA
  • Any Diploma Holder
  • Any Working Professionals
  • Data Warehouse Administrators
  • Database Administrators
  • Software Tester
  • Project Manager
  • MIS Support
AUDIENCE This Oracle Data Guard training course is designed for practicing Oracle professionals who have basic experience with Oracle. Prior experience with Oracle is not required, but experience using Oracle database is highly desirable.
01 - Introduction to Data Guard
•	What is Oracle Data Guard
•	MAA - Maximum Availability Architecture
•	Configurations
•	Primary Database
•	Standby Database
•	Physical Standby Database
•	Logical Standby Database
•	Snapshot Standby Database
•	Data Guard Services
•	Redo Transport Services
•	Apply Services
•	Role Transitions
•	Data Guard Broker
•	Protection Modes
•	Architecture
•	Primary
•	Standby
•	Physical Redo Architecture
•	Logical SQL Apply
•	Redo Transport
•	After Standby Startup
•	Standby Startup
•	Logical Apply
•	Gap Detection and Resolution
•	Complimentary Technology
•	Benefits of Using Data Guard
•	Licensing
02 - Creating a Physical Standby (SQL & RMAN)
•	Preparing the Primary
•	Force Logging
•	Configuring Standby Redo Logs
•	Logfiles on the Standby
•	Standby Redo Logs
•	Using SQL to Create SRLs
•	Initialization Parameters on Primary
•	Role-Based Destinations
•	Redo Transport Mode
•	Oracle Net for Physical Standby
•	Creating a Listener Entry
•	Copying the Primary's Password File
•	Standby Init.ora File
•	Directory Path on the Target
•	Starting the Physical Standby
•	Invoking RMAN
•	Real-Time Apply
•	Starting Redo Apply
•	Standby on the Same Server
•	Data Corruption
•	Lost Write Detection
03 - Overview of Data Guard Broker
•	Data Guard Broker Components
•	Broker Configuration
•	Data Guard Broker Architecture
•	DMON Process
•	Benefits of Using Data Guard Broker
•	DGMRL Commands
•	Enterprise Manager
04 - Creating a Data Guard Broker Configuration
•	Requirements
•	Configuration File
•	Log Files
•	Workflow
•	Changing Properties
•	Database Properties
•	Disable Broker Management
05 - Configuring Data Protection Modes
•	Data Protection Modes
•	Maximum Protection
•	Maximum Availability
•	Maximum Performance
•	Comparisons
•	How to Set the Mode
•	Using Grid Control to Set the Mode
06 - Monitoring a Data Guard Configuration
•	Monitoring Using Enterprise Manager
•	Viewing Data Guard Status
•	Data Guard Performance
•	Viewing Data Guard Performance
•	Viewing Log Files
•	Data Guard Metrics
•	Viewing Diagnostic Information
•	Destination Settings
07 - Optimizing a Data Guard Configuration
•	Monitoring Performance
•	Optimizing Redo Transport
•	Optimizing Redo Transmissions
•	MaxConnections Database Property
•	RedoCompression Property
•	Delaying the Application of Redo
08 - Using Flashback Database in a Data Guard Configuration
•	Flashback Database
•	Configuring Flashback Database
•	Enable Flashback Database
•	Flash Recovery Area
•	Flashback and Role Transitions
•	Flashback Database After Failover
•	Flashback Database Scenario
09 - Performing Role Transitions
•	Role Transitions   Role Management Services   Switchover   Switchover Using DGMGRL   Switchover •	Using Enterprise Manager   Problems
•	Failover
•	Failover Using DGMGRL
•	Re-enable Disabled Databases
•	Failover Using Enterprise Manager
•	Failover - Back on the Standby
10 - Backup and Recovery Considerations
•	RMAN in Data Guard
•	Maximum Availability Architecture (MAA)
•	Offload Backups to a Physical Standby
•	Usage   RMAN Recovery Catalog
•	Create the Recovery Catalog
•	Register the Primary Database
•	Persistent Configuration Settings
•	RMAN Parameters for Primary
•	RMAN Parameters for Standby
•	Daily Incremental
•	RMAN Script
•	Loss of Data File on Primary
•	Using a Backup
•	Using the Physical Standby
•	Recovering a File on the Standby
•	Block Media Recovery
11 - Managing Client Connectivity
•	Client Connectivity Issues
•	Helping Make the Right Connection
•	Managing Services
•	Client Failover
•	Automating Client Failover
•	Client Failover Components
•	Automatic Failover to a New Primary
•	Data Guard Broker and FAN
•	OCI Clients
•	OLE DB Clients
•	JDBC Clients
•	AFTER STARTUP Trigger
•	Service Names and tnsnames.ora File
12 - Patching & Upgrading Databases in a Data Guard Configuration
•	Data Guard Broker
•	Upgrading with a Physical Standby
•	Rolling Upgrade Workflow
•	Rolling Upgrade
  • Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups
  • Create and manage physical and logical standby databases
  • Use Enterprise Manager Cloud Control and the Data Guard command-line interface (DGMGRL) to maintain a Data Guard configuration
  • Use Data Guard to achieve a highly available Oracle database
  • Gain an understanding of Oracle Database Exadata Cloud Service

Data Science

The Introduction to Data Science class will survey the foundational topics in data science, namely:

  • Data Manipulation
  • Data Analysis with Statistics and Machine Learning
  • Data Communication with Information Visualization
  • Data at Scale -- Working with Big Data
  • Introduction to R

The class will focus on breadth and present the topics briefly instead of focusing on a single topic in depth. This will give you the opportunity to sample and apply the basic techniques of data science.

  • Any Graduates(B.A,B.Com,B.Sc)
  • Engineering Students(B.Tech, B.E, M.Tech)
  • BCA,MCA
  • Any Diploma Holder
  • Any Working Professionals
  • Data Warehouse Administrators
  • Database Administrators
  • Software Tester
  • Project Manager
  • MIS Support

Data Science Overview

Accelerate your career in data science by mastering concepts of Data Management, Statistics, Machine Learning and Big Data from most influential Data Science leaders.

Learn. Experience. Master.

  • For the Industry, By the Industry
  • Domain Specialization
  • Career Guidance

Data Science – A Definition

Data Science is the science which uses computer science, statistics and machine learning, visualization and human- computer interactions to collect, clean, integrate, analyze, visualize, and interact with data to create data products.

What is a data scientist to do?

These data scientists, who have expertise in computer applications, data modeling, statistical analysis, and more. Not only analyzing and resolving informational problems of the organization, their role in providing information security is very important.

Career Impact

Thanks to the digital revolution that is sweeping the world and India in particular, data scientists are now the most sought-after professionals by big corporations as well as startups. And companies across industries are rewarding good data analysts​ and scientists​ with desirable career growth and salaries.

Learn by Application

Learn from our comprehensive collection of case-studies, hand-picked by industry experts, to give you an in-depth understanding of how data science moves industries like telecom, transportation, e-commerce & more.

Curriculum Details

Statistics with R

  • Understanding R and its data structures
  • Descriptive statistics
  • Data Distribution
  • Hypothesis testing
  • Graphs and plots
  • Summary statistics etc

Regression analysis

  • Linear Regression and case study
  • Logistic Regression and case study
  • Case studies in Regression

Time Series Analysis

  • Stationary Process
  • Augmented Reality Process
  • Moving Average Process
  • Auto Regressive Integrated Moving Average Model
  • ARIMA Modelling using R with examples

Classification Learning Objectives

  • Meaning and types of classification
  • Decision tree classifier
  • K-nearest neighbors
  • Neural Network
  • Support vector machines
  • Naive Bayes
  • Probabilistic methods
  • Random forest classifier

Clustering Algorithms

  • What is Clustering ?
  • k-means Clustering?
  • Hierarchical clustering

Market Basket Analysis

  • What is Market Basket
  • What is Market Basket Model
  • Association Rule mining and case study
  • Case Study

    • Credit Risk evaluation using R
    • Hands on Training
    • Learners are taught to understand business intelligence and business and data analytics.
    • To understand the business data analysis through the powerful tools of data application.
    • Learn how to apply Tableau, MapReduce, and get introduced in to R and R+.
    • Understand the methods of data mining and creation of decision tree.
    • Explore different aspects of Big Data Technologies.
    • Learn the concepts of loop functions and debugging tools.