Oracle RAC (Real Application Cluster) Administration

This course will introduce you to the general features and capabilities of Oracle Database 11g Release 1 for Oracle Real Application Clusters (RAC). You'll learn how to install and administer Oracle Cluster ware and more.

Learn To:

·         Install Oracle Cluster ware and Real Application Clusters.

·         Administer a RAC Database.

·         Administer Database Services in a RAC environment.

·         Administer Oracle Cluster ware.

·         Add/Remove a node to/from a cluster.

·         Patch Oracle Cluster ware and RAC software.

·         Administer your Database in a Real Application Clusters environment using Enterprise Manager Grid Control.

·         Configure and use database services, along with the Load Balancing Advisory in a RAC environment.

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.

Add & Remove Nodes in Clusters

This course will also teach you how to add and remove nodes in clusters. Learn how to patch both Oracle Cluster ware and Real Application Clusters software in a rolling fashion.

This course is appropriate for a 10g audience, too. There are few minor changes between 10g and 11g features.

Oracle Database 11g Advanced PLSQL

In this Oracle Database 11G Advanced PL/SQL training, expert Oracle University instructors will help you explore the advanced features of PL/SQL to design and tune PL/SQL. You'll learn how it interfaces with the database and other applications in the most efficient manner.

Learn To:

PL/SQL designing best practices.

Create PL/SQL applications that use collections.

Implement a virtual private database with fine-grained access control.

Write code to interface with external C and Java applications.

Write code to interface with large objects and use Secure File LOBs.

Write and tune PL/SQL code effectively to maximize performance.

Benefits to You

Extend the functionality of the SQL language with PL/SQL language to write application code. This will help your organization realize the full benefit of utilizing Oracle best practices.

Virtual Private Database

You'll also be introduced to Virtual Private Database (VPD) to implement security policies. Learn techniques and tools to strengthen applications against SQL injection attacks. Explore programming efficiency, use of external C and Java routines, PL/SQL server pages and fine-grained access.

Oracle 11g Administration II

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Learn To:

·         Diagnose and repair data failures with Flashback technology.

·         Manage space to optimize database storage so you can respond to growing space requirements.

·         Monitor and manage major database components, including memory, performance and resources.

·         Secure the availability of your database through appropriate backup and recovery strategies.

·         Automate DBA tasks with the Scheduler.

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.

Backup & Recovery

The concepts and architecture that support backup and recovery, along with the steps required to execute it in various ways and situations, are covered in detail. You'll learn how to define and test your own backup and recovery scenarios.

Manage Memory Effectively

You'll also learn how to manage memory effectively, as well as how to perform some performance evaluation and tuning tasks. Instructors will review all types of flashback technologies, scheduling jobs inside and outside of the database and controlling system resource usage.

Course Requirements

This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led in class or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self-Study and Knowledge Center courses DO NOT meet the Hands-on Requirement.

Oracle Database 11g Administration Workshop I

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.

Oracle 11g New Features for Administrators

This Oracle Database 11g: New Features for Administrators DBA Release 2 training explores new change management features and other key enhancements in Oracle Database 11g Release 1 and Release 2. Participating in hands-on practice sessions help reinforce your understanding of the new capabilities.

Learn To:

·         Implement manageability features to simplify database management.

·         Use change management features to master database changes.

·         Use database advisors to provide proactive database monitoring.

·         Increase data availability by using ASM, RMAN and Flashback feature enhancements.

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.

Utilize New Features to Manage Change

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 and strengthening security. Expert Oracle University instructors will also review several other areas that are of particular interest to database administrators.

Course Objectives

·         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

·         Use Data Pump in legacy mode

·         Use Data Recovery Advisor

Oracle Database Introduction to SQL

View a newer version of this course

This Oracle Database: Introduction to SQL training helps you write sub queries, 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

Gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data. 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.

Learn Advanced Features of SQL

In order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects, you'll learn to understand the advanced features of SQL. 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.

Development Tools

In this course, the main development tool used is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is appropriate for a 10g and 11g audience. There are minor changes between 10g and 11g features in SQL.

This course is a combination of Oracle Database: SQL Fundamentals I and Oracle Database: SQL Fundamentals II courses.

Oracle Reports Developer 10g Build Reports Ed 1

In this course, participants learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Developer (9.0.4.0.1). Working in the declarative environment of Reports Builder, participants learn how to retrieve, display, and format data from any data source in numerous reporting styles and publish the output to any destination.

Participants learn how to add dynamic content to a static Web page and publish reports to the Web. In addition, participants learn how to customize more complex reports, embed graphical charts, and use Oracle AS Reports Services to deploy the reports.

·         Use report parameters and customize a runtime parameter form

·         Enhance reports using graphs and PL/SQL trigger code

·         Maximize report performance using Oracle AS Reports Services and tune reports

·         Publish a report on the Web and build reports to run in various languages

·         Manage report templates, create mailing labels and letters

·         Identify the main components in a report document and how they are related

·         Identify the differences between Web and paper reports

·         Identify standard report design styles and run existing reports to various output destinations

·         Create and modify basic tabular reports and high quality Web reports

·         Create other report styles such as break reports and matrix reports

·         Create reports by accessing data from various data sources

·         Add dynamic data to an existing HTML page