Training
How We Are Different
Course Summaries
Course Logistics
Private Classes
Request for Information
Course Surveys
|
Course Summaries
Oracle and SQL Server Database
| Course Overview |
Course
Duration |
| Oracle Database 11g: New Features for Administrators
This course provides students an opportunity to learn about key enhancements in Oracle Database 11g R1. Students will examine the benefits and use of features in managing change, diagnosing and resolving problems, improving scalability and performance, strengthening security, and several other areas covering database administration. In addition, hands-on lab exercises will be used to reinforce key concepts and capabilities. |
5
days |
Oracle Database: 10g RAC for Administrators
This course provides an introduction to the features of Oracle Real Application Clusters (RAC) as well as the tasks necessary to properly install, configure and maintain an Oracle RAC cluster. Students will learn how Oracle RAC works, the components necessary to create the RAC cluster and how to administer it. This course is comprised of approximately 50% hands-on lab and 50% lecture with the primary focus on maintaining and administering Oracle RAC. |
5 days |
Oracle Database: 10g RAC Deployment Workshop
This course provides users familiar with the Oracle database experience in configuring and deploying Oracle RAC. Students will gain experience in Oracle clusterware, ASMLib, ASM, OCFS2 and Oracle RAC. The student will become proficient in configuring Oracle RAC on Linux, including the upgrade process. This course is comprised of approximately 70% hands-on lab and 30% lecture with the primary focus on configuration and tuning of Oracle RAC. The student must be familiar with Oracle 10g RAC and should have completed the Oracle 10g RAC Administration class. |
4 days |
| Performance
Tuning Oracle and RAC on Linux & UNIX
This course is designed for those that wish to learn how to tune Oracle databases and Oracle Real Application Clusters (RAC) on Linux or UNIX operating systems. Students will become proficient in all aspects
of Oracle database performance tuning, including
database and instance tuning, and SQL tuning.
The hardware and software interactions that affect
Oracle database performance are also covered in
this course and includes tuning the operating
system, Oracle I/O and storage area networks.
Hands-on lab exercises will be used to reinforce
key Oracle performance tuning concepts. |
4
days |
| Performance
Tuning Oracle and RAC on Windows
This course is designed for those that wish
to learn how to tune Oracle databases and Oracle Real Application Clusters (RAC) on Windows operating systems. Students will become proficient in all aspects
of Oracle database performance tuning, including
database and instance tuning, and SQL tuning.
The hardware and software interactions that affect
Oracle database performance are also covered in
this course and includes tuning the operating
system, Oracle I/O and storage area networks.
Hands-on lab exercises will be used to reinforce
key Oracle performance tuning concepts. |
4
days |
| Optimizing
Microsoft SQL Server 2005
This course is designed for the DBA, system designer and system architect who are familiar with SQL Server. The student will become proficient with the integration of SQL Server on a storage area network (SAN). In addition this class includes the usage and interpretation of the SQL Profiler, optimizing indexes and SQL statements and using the Query Analyzer. |
5
days |
|
top |
|
Oracle for Developers and Business Intelligence
| Course Overview |
Course
Duration |
Introduction to PL/SQL
Give your IT staff the knowledge of using Oracle’s procedural language: PL/SQL. The focus of this course is to provide students with a working knowledge of SQL and the ability to develop Oracle procedures, functions, and database triggers using PL/SQL.
The course utilizes a variety of current tools. Students will have the opportunity to learn more about SQL Developer, TOAD, as well as the Oracle tools like SQL*Plus. The instructor will cover topics including how to code PL/SQL, accessing data in a variety of methods, error handling, and will touch on debugging PL/SQL.
An optional 3rd day involves training the attendees in how to use TOAD **OR** Oracle’s free Project Raptor tool to assist with their day-to-day development needs. Attendees will be able to use TOAD or SQL Developer to do the lab exercises and learn how to use the Procedure Editor and debug their PL/SQL routines. Students will also see how to enter their SQL using the TOAD or SQL Developer interface, easily create spreadsheets from data, display data, see various application relationships, and more.
|
2 or 3
days |
Advanced PL/SQL
The focus of this course is to provide students with a working but basic knowledge of SQL and the PL/SQL languages. This course utilizes a variety of current tools. Students will have the opportunity to learn more about TOAD and SQL Developer, as well as the Oracle tools like SQL*Plus.
The attendees will learn how to find the poorly-performing components of PL/SQL routines, use Oracle’s newer DEBUG routines to find problems in PL/SQL logic and how to use the latest features of the PL/SQL language such as the new optimizing compiler and collections. |
3 days |
Discoverer for End Users Workshop
Give your technical staff that competitive edge with this Oracle Discoverer Workshop. This course introduces students to the querying and analytical capabilities of Oracle Discoverer using either the Desktop and/or web interfaces Discoverer Plus and Viewer. Students will learn to create, modify, run, and refine ad hoc queries. They will learn to view, chart, and analyze multidimensional data and produce individual ad hoc reports
|
2 days |
Discoverer for Administrators Workshop
This course gives students hands-on experience with setting up Oracle Discoverer. Students will practice administrative tasks using Discoverer’s Administration Edition tool. Students will learn to create an End User Layer and create and manage business areas. They will learn how to hide the complexity of the data source and provide a user-friendly view of the data for end users.
|
2
days |
Oracle SQL Statement Tuning Workshop
The focus of this tuning course is to illustrate coding techniques that insure a consistent response time between instances and releases of the Oracle database. This course is perfect for developers who need to know more on how Oracle works and how to get their SQL to perform better. The course utilizes a variety of current tools. Students will have the opportunity to learn more about Oracle’s free SQL Developer, TOAD, Eagle Eye, TextPAD, as well as the Oracle tools like SQL*Plus, TKProf, and Stats Pack.
Students will work with a variety of SQL statements and how to optimize their peformance. Students will also experience how to monitor their application environment, indexes, and troubleshoot problem SQL in their applications.
This course includes advanced topics which focus on a variety of parameter settings that make a big difference to Oracle-based applications (such as OPTIMIZER_INDEX_CACHING & INDEX_COST_ADJUSTMENT). This workshop includes a section on monitoring Oracle RDBMS and SQL via the v$ tables and TOAD. This course is packed full of scripts to discover a variety of issues.
|
3 days |
|
top |
|
|
|
| |
|
