Oracle Database 11g: Advanced DBA Track - Self-Study Course

Total time

Oracle Database 11g: Advanced DBA Track - Self-Study Course

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

The SQL Tuning Workshop SSCD teaches different ways in which data can be accessed, which ones are most efficient under specific circumstances, and how to ensure that the best method is used. Partitioning topics are covered, in addition to taking advantage of hints, bind variables, and different types of indexes.

The Terformance Tuning SSCD teaches the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement performance, and tuning the Oracle Database Instance components. Throughout the course, students practice the art of tuning an Oracle Instance.

Real Application Clusters (RAC) SSCD teaches the installation and administration of Oracle Clusterware, Real …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle 11G, Oracle, CompTIA A+ / Network+ / Security+, IT Security, and Retail (Management).

The SQL Tuning Workshop SSCD teaches different ways in which data can be accessed, which ones are most efficient under specific circumstances, and how to ensure that the best method is used. Partitioning topics are covered, in addition to taking advantage of hints, bind variables, and different types of indexes.

The Terformance Tuning SSCD teaches the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement performance, and tuning the Oracle Database Instance components. Throughout the course, students practice the art of tuning an Oracle Instance.

Real Application Clusters (RAC) SSCD teaches the installation and administration of Oracle Clusterware, Real Application Clusters, and Automatic Storage Management. Students also learn how to administer their Database in a Real Application Clusters environment using Enterprise Manager Grid Control. Also, learn how to add and remove nodes in clusters and how to patch both Oracle Clusterware and Real Application Clusters software in a rolling fashion.

The New Features SSCD is designed to teach you about installation and upgrade enhancements, storage enhancements, SQL plan management and change, database replay, automatic SQL tuning, Flashback, and LogMiner. It covers enhancements in partitioning, RMAN, diagnosabilty, security, and intelligent infrastructure, and how to use the Data Recovery Advisor, Oracle SecureFiles, and other new features.

SQL and PL/SQL New Features SSCD is designed to teach you about the various enhancements in language functionality and triggers and demonstrates language usability enhancements and performance improvement features, such as inlining and flashback. It also demonstrates how to maintain greater control over triggers as well as enhancements to dynamic SQL.

Oracle Secure Backup SSCD teaches how to use Oracle Secure Backup, which supplies reliable tape backup of the database through direct integration with RMAN and it also provides general file system backup to tape. Students also learn how to perform advanced management tasks, such as, tape vaulting.


Audience
  • Data Warehouse Developer
  • Security Administrators
  • Support Engineer
  • Technical Administrator
  • Data Warehouse Administrator
  • PL/SQL Developer
  • Database Administrators

Course Topics Oracle Database 11g: SQL Tuning Workshop - Self-Study CD Course Oracle Database 11g: Performance Tuning - Self-Study CD Course Oracle Database 11g: RAC Administration - Self-Study CD Course Oracle Database 11g: New Features for Administrators - Self-Study CD Course Oracle Database 11g: SQL and PL/SQL New Features - Self-Study CD Course Oracle Database 11g: Oracle Secure Backup - Self-Study CD Course
Course Objectives
  • Identify and optimize SQL Performance
  • Learn to use Oracle Database 11g automatic tuning features
  • Learn the general features and capabilities of Oracle Real Application Clusters (RAC)
  • Learn the enhancements from 10g to 11g
  • New features and enhancements to SQL and PL/SQL
  • Learn to use Oracle Secure Backup

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.