Cisco Training Courses

Cisco Training Courses

Insoft has been serving IT industry with authorized Cisco courses training, since 2010. Find all the relevant information on Cisco training on this page.

View More

Cisco Certifications

Experience a blended learning approach that combines the best of instructor-led training and self-paced e-learning to help you prepare for your certification exam.

View More

Cisco Learning Credits

Cisco Learning Credits (CLCs) are prepaid training vouchers redeemed directly with Cisco that make planning for your success easier when purchasing Cisco products and services.

Have CLCs and want to redeem them?

Cisco Continuing Education

The Cisco Continuing Education Program offers all active certification holders flexible options to recertify by completing a variety of eligible training items.

View More

Cisco U

Cisco U. is customized to achieve your learning needs as this provides learning paths that includes wide range of topics, including CCNA, Cloud and Network Automation Essentials.

Browse Catalogue

Cisco Business Enablement

The Cisco Business Enablement Partner Program focuses on sharpening the business skills of Cisco Channel Partners and customers.

View More

Fortinet Technical Certifications

Insoft Services´ training capabilities rely on the excellence of our exclusive Fortinet Certified Trainers (FCT). We are dedicated to providing high-quality training to Fortinet Customers and Partners.

View More

Fortinet Technical Courses

Insoft is recognised as Fortinet Authorized Training Center in selected locations across EMEA.

View More

ATC Status

Check our ATC Status across selected countries in Europe.

View More

Fortinet Services Packages

Insoft Services has developed a specific solution to streamline and simplify the process of installing or migrating to Fortinet Products.

Browse Packages

Prepforce Bootcamp

The only comprehensive source available today to prepare for Fortinet NSE 8 certification globally.

View More

Microsoft Training

Insoft Services provides Microsoft training in EMEAR. We provide Microsoft technical training and certification courses that are led by world-class instructors.

View More

Technical Training

The evolution of Extreme Networks Technical Training provides a comprehensive progressive pathway from Associate to Professional accreditation.

View More

ATP Accreditation

As an authorised training partner (ATP), Insoft Services ensures that you receive the highest standards of education available.

View More

What we do

Through our global presence and partner ecosystem, we provide strategic IT consulting services to align IT services with customers' business goals.

View More

 

We are pleased to launch pre-scoped Enterprise Networking Consulting Packages, our ready-made solutions, tailored to ensure efficiency and cost containment.

 

View More

 

We specialize in the deployment of vendor-specific automation tools as well as open-source and vendor-independent solutions, that can be tuned in accordance with the business needs of a specific organization.

 

View More

 

We provide comprehensive IoT consultancy, deployment and support solutions for businesses that want to launch or improve their use of connected technologies.

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

 

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

 

View More
Cisco Training Courses

 

We provide the highest level of expertise on Cisco consultancy services, that target audits of your current network and implementing updates for improved operational performance, secure data and compliant systems.

View More

 

We provide the highest level of expertise on Fortinet consultancy services that target audits of your current network and implementing updates for improved operational performance, secure data and compliant systems.

View More

 

Our team can help enterprises, get the most value from Extreme products and services following our predefined value-added packages or custom ones that fits business needs.

 

View More

 

TXOne Networks provides cybersecurity solutions that ensure the reliability and safety of ICS and OT environments through the OT zero trust methodology protecting assets for their entire life cycle.

 

View More

About Us

Our training portfolio includes a wide range of IT training from IP providers, including Cisco, Extreme Networks, Fortinet, Microsoft, to name a few, in EMEA.

View More

OC11GNFAR2 – Oracle Database 11g: New Features for Administrators

Contact Us

We would love to hear from you. Please complete this form to pre-book or request further information about our delivery options.

Data Protection & Privacy

I consent to receive emails and/or calls from Insoft Services related to the Insoft Services´ products and services.
I acknowledge that my data will be collected and processed as described in the Insoft Services privacy policy.

Close

OC11GNFAR2 – Oracle Database 11g: New Features for Administrators

Enroll Now
Duration
5 Days
Delivery
(Online and onsite)
Price
Price Upon Request

The Oracle Database 11g: New Features for Administrators (OC11GNFAR2) is a five-day course that gives you the opportunity to learn about and practice with the new change management features and other key enhancements in Oracle Database 11g (Release 1 and Release 2). Topics covered include the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas of particular interest to database administrators. In addition, hands-on practise sessions help reinforce understanding of the new capabilities.

Delegates will learn how to:

  • Install Oracle Grid Infrastructure
  • Install Oracle Database 11g Release 2
  • Use Oracle Restart to manage components
  • Use Automatic Storage Management (ASM) enhancements
  • Implement table compression and hybrid columnar compression
  • Implement data warehousing and partitioning enhancements
  • Use the SQL Performance Analyzer
  • Use SQL Plan Management and load SQL plan baselines
  • Use Database Replay to record and replay workloads
  • Set and manage Automatic SQL Tuning
  • Use Resource Manager enhancements
  • Use Enterprise Manager to monitor SQL commands
  • Use the new and enhanced RMAN features
  • Use Total Recall to create, protect, and use history data

Oracle Grid Infrastructure

  • Installing Oracle Grid Infrastructure for a Standalone Server
  • Creating an ASM Disk Group
  • ASM Cluster File System
  • ASM Dynamic Volume Manager
  • ASM File System Snapshot

Installation and Upgrade Enhancements

  • Installing Oracle Database 11g Release 2
  • Oracle Database Upgrade Enhancements
  • Online Patching
  • Upgrading Your Time Zone File and Timestamp with Time Zone Data

Oracle Restart

  • Controlling Oracle Restart
  • Using the srvctl Utility
  • Manually Adding Components to the Oracle Restart Configuration

ASM Enhancements

  • Setting up ASM fast mirror resync
  • Using ASM Scalability and Performance Enhancements
  • ASM Disk Group Compatibility
  • Using ASMCMD Extensions
  • ASM File Access Control
  • ASM Optimal Disk Placement

Storage Enhancements

  • Using 4 KB-Sector Disks
  • Using Table Compression
  • Hybrid Columnar Compression
  • SQL Access Advisor
  • Segment Creation on Demand

Data Warehouse and Partitioning Enhancements

  • Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
  • Degree of Parallelism Enhancements
  • In-Memory Parallel Query
  • Partitioning Enhancements
  • System-Managed Indexes for List Partitioning

Oracle SecureFiles

  • Enabling SecureFiles Storage
  • Creating SecureFiles
  • Using SecureFile Compression
  • Accessing SecureFiles Metadata
  • Migrating to SecureFiles

Security and Networking Enhancements

  • Secure Password Support
  • Automatic Secure Configuration
  • Managing Default Audits
  • Setting Database Administrator Authentication
  • Transparent Data Encryption
  • Hardware Security Module
  • Tablespace Master Key Re-Key
  • Supporting IPv6 Address Notification

SQL Performance Analyzer

  • SQL Performance Analyzer: Overview
  • Using SQL Performance Analyzer
  • Using Enterprise Manager to Access SQL Performance Analyzer
  • SQL Performance Analyzer: PL/SQL Example
  • SQL Performance Analyzer: Data Dictionary Views

SQL Plan Management

  • SQL Plan Management: Overview
  • Loading SQL Plan Baselines
  • Using the MIGRATE_STORED_OUTLINE Functions
  • Viewing Important Baseline SQL Plan Attributes
  • Loading a SQL Plan Baseline Automatically
  • Purging SQL Management Base Policy

Database Replay

  • Using Database Replay
  • Database Replay System Architecture
  • Supported Workloads
  • Database Replay Workflow in Enterprise Manager
  • Database Replay PL/SQL Procedures
  • Database Replay Data Dictionary Views

Automatic SQL Tuning

  • Automatic SQL Tuning in Oracle Database 11g
  • Selecting Potential SQL Statements for Tuning
  • Controlling the Automatic SQL Tuning Task
  • Configuring Automatic SQL Tuning
  • Using the PL/SQL Interface to Generate Reports

Intelligent Infrastructure Enhancements

  • Using New Automatic Workload Repository Views
  • Creating AWR Baselines
  • Defining Alert Thresholds Using Static Baseline
  • Controlling Automatic Maintenance Tasks
  • Fixed Policy CPU Resource Management
  • Instance Caging
  • Scheduler Enhancements

Diagnosability Enhancements

  • Setting Up Automatic Diagnostic Repository
  • ADRCI: The ADR Command-Line Tool
  • Incident Packaging Service (IPS)
  • Using the Enterprise Manager Support Workbench
  • Invoking IPS Using ADRCI
  • Running Health Checks Manually
  • Using the SQL Repair Advisor

SQL Monitoring

  • SQL Monitoring in Oracle Database 11g Release 2
  • Viewing Session Details
  • Viewing the SQL Monitoring Report

Performance Enhancements

  • Using the DBMS_ADDM Package
  • New and Modified Views
  • Enabling Automatic Memory Management
  • Using New Statistic Preferences Features
  • Locking Enhancements
  • Adaptive Cursor Sharing
  • Using Table Annotation to Control Result Caching

Application Maintenance and Upgrade Enhancements

  • Online Redefinition Enhancements
  • Creating and Using Invisible Indexes

Backup and Recovery Enhancements

  • Using New SET NEWNAME Clauses
  • Optimized Backups
  • Using New Settings for Binary Compression
  • Enhancements to Database Duplication
  • Creating Archival Backups
  • TSPITR Enhancements and Modifications
  • Creating and Using Virtual Private Catalogs
  • Introduction to Oracle Secure Backup Cloud Module

Flashback Technology, LogMiner, and Data Pump

  • Oracle Total Recall
  • Flashback Transaction Backout
  • Enterprise Manager LogMiner Interface
  • Data Pump Legacy Mode

Data Recovery Advisor

  • Assessing Data Failures
  • Data Recovery Advisor RMAN Command-Line Interface
  • Data Recovery Advisor Views
  • Setting Parameters to Detect Corruption
  • Use Data Pump in legacy mode
  • Use Data Recovery Advisor
  • Database Administrators
  • Data Warehouse Administrator
  • Technical Consultant
  • Sales Consultants
  • Support Engineer

Required:

  • Working knowledge of Oracle Database 10g

Suggested:

  • Oracle Database 10g: New Features for Administrators Release 2
  • Oracle Database 10g: Administration Workshop I Release 2
  • Oracle Database 10g: Administration Workshop II Release 2
The Oracle Database 11g: New Features for Administrators (OC11GNFAR2) is a five-day course that gives you the opportunity to learn about and practice with the new change management features and other key enhancements in Oracle Database 11g (Release 1 and Release 2). Topics covered include the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas of particular interest to database administrators. In addition, hands-on practise sessions help reinforce understanding of the new capabilities.

Delegates will learn how to:

  • Install Oracle Grid Infrastructure
  • Install Oracle Database 11g Release 2
  • Use Oracle Restart to manage components
  • Use Automatic Storage Management (ASM) enhancements
  • Implement table compression and hybrid columnar compression
  • Implement data warehousing and partitioning enhancements
  • Use the SQL Performance Analyzer
  • Use SQL Plan Management and load SQL plan baselines
  • Use Database Replay to record and replay workloads
  • Set and manage Automatic SQL Tuning
  • Use Resource Manager enhancements
  • Use Enterprise Manager to monitor SQL commands
  • Use the new and enhanced RMAN features
  • Use Total Recall to create, protect, and use history data

Oracle Grid Infrastructure

  • Installing Oracle Grid Infrastructure for a Standalone Server
  • Creating an ASM Disk Group
  • ASM Cluster File System
  • ASM Dynamic Volume Manager
  • ASM File System Snapshot

Installation and Upgrade Enhancements

  • Installing Oracle Database 11g Release 2
  • Oracle Database Upgrade Enhancements
  • Online Patching
  • Upgrading Your Time Zone File and Timestamp with Time Zone Data

Oracle Restart

  • Controlling Oracle Restart
  • Using the srvctl Utility
  • Manually Adding Components to the Oracle Restart Configuration

ASM Enhancements

  • Setting up ASM fast mirror resync
  • Using ASM Scalability and Performance Enhancements
  • ASM Disk Group Compatibility
  • Using ASMCMD Extensions
  • ASM File Access Control
  • ASM Optimal Disk Placement

Storage Enhancements

  • Using 4 KB-Sector Disks
  • Using Table Compression
  • Hybrid Columnar Compression
  • SQL Access Advisor
  • Segment Creation on Demand

Data Warehouse and Partitioning Enhancements

  • Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
  • Degree of Parallelism Enhancements
  • In-Memory Parallel Query
  • Partitioning Enhancements
  • System-Managed Indexes for List Partitioning

Oracle SecureFiles

  • Enabling SecureFiles Storage
  • Creating SecureFiles
  • Using SecureFile Compression
  • Accessing SecureFiles Metadata
  • Migrating to SecureFiles

Security and Networking Enhancements

  • Secure Password Support
  • Automatic Secure Configuration
  • Managing Default Audits
  • Setting Database Administrator Authentication
  • Transparent Data Encryption
  • Hardware Security Module
  • Tablespace Master Key Re-Key
  • Supporting IPv6 Address Notification

SQL Performance Analyzer

  • SQL Performance Analyzer: Overview
  • Using SQL Performance Analyzer
  • Using Enterprise Manager to Access SQL Performance Analyzer
  • SQL Performance Analyzer: PL/SQL Example
  • SQL Performance Analyzer: Data Dictionary Views

SQL Plan Management

  • SQL Plan Management: Overview
  • Loading SQL Plan Baselines
  • Using the MIGRATE_STORED_OUTLINE Functions
  • Viewing Important Baseline SQL Plan Attributes
  • Loading a SQL Plan Baseline Automatically
  • Purging SQL Management Base Policy

Database Replay

  • Using Database Replay
  • Database Replay System Architecture
  • Supported Workloads
  • Database Replay Workflow in Enterprise Manager
  • Database Replay PL/SQL Procedures
  • Database Replay Data Dictionary Views

Automatic SQL Tuning

  • Automatic SQL Tuning in Oracle Database 11g
  • Selecting Potential SQL Statements for Tuning
  • Controlling the Automatic SQL Tuning Task
  • Configuring Automatic SQL Tuning
  • Using the PL/SQL Interface to Generate Reports

Intelligent Infrastructure Enhancements

  • Using New Automatic Workload Repository Views
  • Creating AWR Baselines
  • Defining Alert Thresholds Using Static Baseline
  • Controlling Automatic Maintenance Tasks
  • Fixed Policy CPU Resource Management
  • Instance Caging
  • Scheduler Enhancements

Diagnosability Enhancements

  • Setting Up Automatic Diagnostic Repository
  • ADRCI: The ADR Command-Line Tool
  • Incident Packaging Service (IPS)
  • Using the Enterprise Manager Support Workbench
  • Invoking IPS Using ADRCI
  • Running Health Checks Manually
  • Using the SQL Repair Advisor

SQL Monitoring

  • SQL Monitoring in Oracle Database 11g Release 2
  • Viewing Session Details
  • Viewing the SQL Monitoring Report

Performance Enhancements

  • Using the DBMS_ADDM Package
  • New and Modified Views
  • Enabling Automatic Memory Management
  • Using New Statistic Preferences Features
  • Locking Enhancements
  • Adaptive Cursor Sharing
  • Using Table Annotation to Control Result Caching

Application Maintenance and Upgrade Enhancements

  • Online Redefinition Enhancements
  • Creating and Using Invisible Indexes

Backup and Recovery Enhancements

  • Using New SET NEWNAME Clauses
  • Optimized Backups
  • Using New Settings for Binary Compression
  • Enhancements to Database Duplication
  • Creating Archival Backups
  • TSPITR Enhancements and Modifications
  • Creating and Using Virtual Private Catalogs
  • Introduction to Oracle Secure Backup Cloud Module

Flashback Technology, LogMiner, and Data Pump

  • Oracle Total Recall
  • Flashback Transaction Backout
  • Enterprise Manager LogMiner Interface
  • Data Pump Legacy Mode

Data Recovery Advisor

  • Assessing Data Failures
  • Data Recovery Advisor RMAN Command-Line Interface
  • Data Recovery Advisor Views
  • Setting Parameters to Detect Corruption
  • Use Data Pump in legacy mode
  • Use Data Recovery Advisor
  • Database Administrators
  • Data Warehouse Administrator
  • Technical Consultant
  • Sales Consultants
  • Support Engineer

Required:

  • Working knowledge of Oracle Database 10g

Suggested:

  • Oracle Database 10g: New Features for Administrators Release 2
  • Oracle Database 10g: Administration Workshop I Release 2
  • Oracle Database 10g: Administration Workshop II Release 2