Click one of the database products on the left,
or find the course you are interested below:
| Title | Description | Duration | Outline |
|---|
|
DB2 -- Fast Track to Programming
|
Students will gain hands-on experience with the newest features of IBM's DB2 Version 9.
Students will learn to create tables and manipulate data, tables and other database objects using ANSI-standard SQL and SQL Procedural Language extensions.
Coverage includes the special features and functions of the DB2, such as control of transactions, stored procedures, triggers, and cursors.
Good programming techniques and develop strategies for writing efficient applications will be emphasized.
Level: Introduction
|
3 Days
| |
|
Introduction To Microsoft SQL Server 2000 (Level 1)
|
Provides a hands-on introduction to SQL Server 2000 for experienced Programmers.
Covers database design, creation, and basic SQL Statements.
Level: Introduction
|
1 Day
| |
|
Introduction To MySQL
|
Learn to create tables and manipulate data, tables and other database objects
using ANSI-standard SQL and SQL extensions, and gain hands-on experience using MYSQL databases.
You will also learn the special features and functions of the MYSQL,
such as automatic recovery of transactions, stored procedures, triggers, and cursors.
In addition, you will learn to use good programming techniques
and develop strategies for writing efficient applications.
Level: Introduction
|
5 Days
| |
|
Introduction To Oracle 9i
|
This class will develop database-programming skills
using SQL and PL/SQL. Students will learn the Oracle9i architecture,
relational design concepts, simple and complex query skills, PL/SQL
programming skills, proper software engineering techniques for
database programming, Oracle problem solving, and performance tuning
skills.
Level: Introduction
|
5 Days
| |
|
Introduction To Sybase
|
Presents the basics of Sybase Adaptive Server
and its SQL programming language including
the use of stored procedures, cursors, and triggers.
Level: Introduction
|
3 Days
| |
|
Introduction To Sybase ASE 12.5.1
|
Learn to create tables and manipulate data,
tables and other database objects
using ANSI-standard SQL and Sybases Transact-SQL extensions,
and gain hands-on experience using Adaptive Server databases.
You will also learn the special features and functions of the Adaptive Server,
such as automatic recovery of transactions, stored procedures, triggers, and cursors.
In addition, you will learn to use good programming techniques
and develop strategies for writing efficient applications.
Level: Introduction
|
5 Days
| |
|
Introduction To Sybase Transact-SQL
|
Introduces Sybase Transact-SQL, the language used to interact with Sybase Adaptive Server.
Level: Introduction
|
1-2 Days
| |
|
Object Oriented Web Development using PHP and MySQL
|
Prepares students to design and implement Web Applications using the
PHP Scripting Language and the MySQL Database.
Examines all language syntax, significant Classes, and commonly used functions.
Object Oriented design methods and strategies are emphasized.
PHP 5 and MySQL 4.0 capabilities are presented,
PEAR Packages are selectively surveyed (and optionally included) in an Appendix.
Level: Introduction
|
2-3 Days (Depending on breadth of PEAR coverage required).
| |
|
Oracle 9i DBA Fundamentals I
|
This class will develop the fundamental skills necessary to be an Oracle DBA.
Students will design and create a server using the Optimal Flexible Architecture
(OFA), configure logical and physical structures, set up database and user
security, add and administer users, and monitor and tune main server areas. Each
student will create a toolkit of administration scripts for database management
and tuning by the end of this class. This class will also address issues for
DBAs having to support Oracle8i and Oracle9i databases.
Level: Introduction
|
3 Days
| |
|
Oracle 9i SQL Programming
|
This class will develop
database programming skills using SQL.
Relational and object concepts will be covered.
Students will learn
complex SQL programming skills,
features, and tools.
Level: Introduction
|
3 Days
| |
|
Oracle Database 11g: SQL Fundamentals - Complete Coverage
|
The objective of this course is to provide an introduction to
the SQL database language within the context of an Oracle database,
based upon the latest features available. The primary objective of
this course is to consider advanced subjects and techniques
pertaining to the SQL database language, based upon the latest
features available with the Oracle release. Even professionals
experienced in other implementations of the industry-standard SQL
language will benefit from the advanced and Oracle-specific
features of SQL discussed in this course.
Level: Introduction
|
5 Days
| |
|
Oracle Database 11g: SQL Fundamentals I
|
This course is a common starting point in the Oracle database curriculum
for administrators, developers and business users. The objective of this
course is to provide an introduction to the SQL database language within
the context of an Oracle database, based upon the latest features available.
Level: Introduction
|
3 Days
| |
|
Relational Database Design
|
This course is one common starting point for the entire database curriculum.
The objective of this course is to consider the logical design of relational
databases using a methodology known as semantic data modeling and related
practical techniques.
Level: Introduction
|
2 or 3 Days
| |
|
Structured Query Language (SQL) Using Sybase
|
Provides an introduction to all standard SQL statements and constructs.
Treatment of SQL is platform neutral, but will be delivered in the
Sybase environment. Coverage of Sybase ASE provides an introduction
to Transact-SQL, Transaction Managment, Stored Procedures, and Triggers.
Delivery format is a combination of Lectures and Labs.
Level: Introduction
|
2 Days
| |
|
ADO .NET Using C#
|
An intensive course that
presents the essential elements of ADO.NET
to enable the programmer to utilize
the tremendous database manipulation powers
available with .NET development and be prepared
to build effective database applications.
The course includes a major case study
demonstrating the use of ADO.NET in a realistic setting.
Level: Intermediate
|
3 Days
| |
|
ADO .NET Using Oracle and C#
|
This course presents
the essential elements of ADO.NET and how
to build effective Oracle database applications.
The course includes coverage of
the Oracle Data Provider for .NET (ODP.NET).
There is a practical discussion of data binding and its use in both
Windows Forms and Web Forms (ASP.NET) applications. Students will
gain a familiarity with creating a Data Access Layer, as it
applies to traditional three-tier application architecture.
Level: Intermediate
|
3 Days
| |
|
ADO.NET Using Visual Basic 2005
|
Learn about the features provided by ADO.NET 2.0 including
connecting to data sources, the various ADO.NET classes,
stored procedures, parameters, return values, how to
search, sort, and filter data stored in a DataSet or DataTable.
Become familiar with strongly typed DataSets and learn their advantages.
See how to leverage the power of XML through various means. Examine new
ADO.NET features that support SQL Server 2005 technologies, including
asynchronous commands, Multiple
Active Result Sets, bulk inserts, and more.
Level: Intermediate
|
3 Days
| |
|
ADO.NET Using Visual C# 2005
|
Learn about the features provided by ADO.NET 2.0 including
connecting to data sources, the various ADO.NET classes,
stored procedures, parameters, return values, how to
search, sort, and filter data stored in a DataSet or DataTable.
Become familiar with strongly typed DataSets and learn their advantages.
See how to leverage the power of XML through various means. Examine new
ADO.NET features that support SQL Server 2005 technologies, including
asynchronous commands, Multiple
Active Result Sets, bulk inserts, and more.
Level: Intermediate
|
3 Days
| |
|
DB2 -- Performance and Tuning
|
This course provides experienced SQL developers with a fast-paced transition to DB2 performance and tuning.
Following a review of the DB2 architecture, environment, and data structures,
course coverage includes index internals, block index MDC's,
access methods, and how to write effective SQL predicates.
'Explain' tables and tools are covered in detail as well as additional performance tools.
The optimizer is studied along with RUNSTATS to understand why index methods are chosen by the access plan.
Then MQT's, database partitions and table partitions are explored and their relationships.
Finally, monitoring with admin views is covered along with some performance suggestions
Level: Intermediate
|
2 Days
| |
|
Introduction to IBM DB2 Universal Database for Sybase Developers
|
Provides the student that has prior SQL or Sybase ASE experience
with the necessary basic skills
and fundamental knowledge of IBM DB2 UDB.
It includes information on the overall architecture of DB2 UDB,
basic to advanced DB2 UDB SQL syntax,
creating and using SQL Stored Procedures,
and an overview of basic administrative tasks
including creation of databases, tables, views, indexes,
the extraction and insertion of data, security,
and backup and restore.
Level: Intermediate
|
3-4 Days
| |
|
Java Database Connectivity (JDBC) 3.0
|
Presents the JDBC 3.0 API classes and techniques used to access Relational Databases
within Java programs. Prepares Java programmers to integrate database
access into their implementations. Features the Java DB as the default RDBMS.
Level: Intermediate
|
1 Day
| |
|
Oracle 9i DBA Fundamentals II
|
Presents the fundamentals of setting up Oracle Net Services,
configuring the shared server architecture, and backup and recovery. This class
covers the different ways an Oracle9i instance and database can fail and the
best options for recovery. Students will learn how to perform backup and
recovery with and without RMAN. Students will learn how to minimize points of
failure and reduce the Mean Time To Recover. Through the numerous backup and
recovery labs, students will gain confidence that they can recover a database
after an Oracle9i server goes down.
Level: Intermediate
|
3 Days
| |
|
Oracle 9i PL/SQL Programming
|
Students will learn
the fundamentals of the PL/SQL programming language. Stored procedures,
functions, packages and triggers implement complex business rules in Oracle.
Students will learn programming, management and security issues of working with
PL/SQL program units.
Numerous exercises and labs will introduce
students to the new PL/SQL features in Oracle9.
Level: Intermediate
|
3 Days
| |
|
Oracle Applications using ADO .NET and C#
|
A comprehensive course that provides
an introduction to Oracle Database programming
for use within the .NET environment.
Level: Intermediate
|
5 Days
| |
|
Oracle Database 11g: PL/SQL Fundamentals - Complete Coverage
|
The primary objective of this course is to provide an introduction to
the PL/SQL database programming language, based upon the latest
features available with the Oracle database. Syntax, structure and
features of the language are discussed in the context of database
applications and programming. This course equips students to develop
database server-side PL/SQL program units within an Oracle database.
Level: Intermediate
|
5 Days
| |
|
Oracle Database 11g: PL/SQL Fundamentals I
|
The primary objective of this course is to provide an introduction
to the PL/SQL database programming language, based upon the latest
features available with the Oracle database.
Syntax, structure and features of the language are discussed in
the context of database applications and programming.
Level: Intermediate
|
2 Days
| |
|
Oracle Database 11g: PL/SQL Fundamentals II
|
The objective of this course is to equip students to develop
database server-side PL/SQL program units within an Oracle
database.
Level: Intermediate
|
3 Days
| |
|
Oracle Database 11g: SQL Fundamentals II
|
The primary objective of this course is to consider advanced subjects and
techniques pertaining to the SQL database language, based upon the latest
features available with the Oracle release. Even professionals experienced
in other implementations of the industry-standard SQL language will benefit
from the advanced and Oracle-specific features of SQL discussed in this
course. This enhanced and expanded revision includes many new and expanded
conceptual subjects.
Level: Intermediate
|
3 Days
| |
|
Programming Databases with Microsoft SQL Server 2000 (Level 2)
|
Describes how Views, Stored Procedures, Triggers, User-Defined Functions,
and Transact-SQL work in SQL Server 2000. Presents maintenance, tuning, and security tools.
Level: Intermediate
|
2 Days
| |
|
SQL Server 2000 System and Database Administration
|
Learn all aspects of administering a SQL Server 2000
from installation to configuration,
to maintaining a fast, high performance database server.
Level: Intermediate
|
5 Days
| |
|
SQL Server 2005 Administration
|
Learn about the features of SQL Server; how to design and create a
database; and how to build basic queries using Transact-SQL.
Learn how to build effective views, stored procedures,
triggers, and user-defined functions, using Transact-SQL.
Learn about the new enhancements to the Transact-SQL
programming language including improved support for error handling
and hierarchical queries, and programmers can now use .NET languages
like C# and Visual Basic to build database objects.
Level: Intermediate
|
5 Days
| |
|
SQL Server 2005 Analysis Services
|
Learn to use Microsoft SQL Server 2005 Analysis Services (SSAS)
to design and implement OnLine Analytical Processing (OLAP)
cubes and data mining models to support Business Intelligence (BI)
solutions. Includes concepts, procedures and practices
based on real-world experience giving both the novice and experienced
SQL Server 2005 developer the tools to build data warehousing and
decision support system solutions. Learn about end-user tools
including Microsoft Excel 2003/2007 and Microsoft SQL Server
2005 Reporting Services.
Level: Intermediate
|
3 Days
| |
|
SQL Server 2005 Integration Services
|
In this course you will learn about the SQL Server Management Studio
(SSMS) and building Database Maintenance Plans.
Level: Intermediate
|
3 Days
| |
|
SQL Server 2005 Reporting Services
|
Learn how to use SQL Server 2005
Reporting Services to create, execute, and manage reports.
Learn how to create tabular, matrix (cross-tab),
and chart reports using Visual Studio 2005 and SQL Server 2005
Business Intelligence Studio. Explore creating reports with
groups, expressions, conditional formatting, and parameters.
Explore the deployment and printing of reports and the
export of reports to PDF, Excel, and other formats.
Gain a thorough understanding of Reporting Services security,
report snapshots, subscriptions, and the use of custom assemblies.
Discover how to integrate reports into your ASP.NET and other
applications
Level: Intermediate
|
3 Days
| |
|
SQL Server 2005 T-SQL
|
Learn how to build basic queries using Transact-SQL, the language of
SQL Server. Learn how to build effective views, stored procedures,
triggers, and user-defined functions using Transact-SQL.
Learn about the new enhancements to the Transact-SQL programming
language including improved support for error handling and
hierarchical queries, and how programmers can now use .NET languages
like C# and Visual Basic to build database objects.
Level: Intermediate
|
3 Days
| |
|
Sybase System and Database Administration For ASE 12.5.1
|
Through a combination of lectures and hands-on labs,
you will identify the major tasks of Sybase system and database administration.
You will practice these tasks using your own Adaptive Servers (12.5)
in a safe and controlled environment.
Emphasis is given to resource management (memory, disk, and CPU)
with a goal of creating a reliable Adaptive Server environment.
The course also presents fundamental monitoring and troubleshooting methods,
as well as details about the servers locking schemes
and system and user-defined roles.
Level: Intermediate
|
5 Days
| |
|
Understanding ADO.NET
|
In this course, you will learn how to retrieve and manipulate data using Microsoft's new
ADO.NET library. Understand how to work with the new ADO.NET object model,
including the DataReader, DataAdapter, and DataSet. See how to apply constraints
and relationships to disconnected data. Learn how to update data, including how
to handle stored procedures, parameters, and return values. Understand how to
search, sort, and filter data using Select, Find, and DataViews.
Level: Intermediate
|
3 Days
| |
|
Advanced SQL Server 2000 Administration
|
Gain a hands-on, in-depth look at SQL Server 2000
by examining relevant internal data structures
and learning practical troubleshooting techniques.
Diagnose and prevent potentially disastrous situations
and learn how to make optimal use of the features of SQL Server 2000
for normal administrative tasks.
Real-world benefits include learning how to perform mission-critical administrative tasks more efficiently,
improving system performance for end users,
and troubleshooting disaster scenarios for data recovery.
Level: Advanced
|
5 Days
| |
|
Applying ADO.NET
|
In this advanced course, you will become familiar with strongly typed DataSets and learn
their advantages and see how to leverage the power of XML through serialization,
Diffgrams,and the XMLDataDocument object. You will understand migrating and
interoperability issues with ADO, as well as handling errors. Learn valuable
techniques for building both Web and Windows applications.
Level: Advanced
|
2 Days
| |
|
Extended Features In Microsoft SQL Server 2000 (Level 3)
|
2 Days
| |
|
Java Persistence API
|
New J2EE 5 capabilities empower Java Class designers
with the ability to easily persist instances into
relational data-stores. Even plain-old Java objects (POJOs)
can be defined as persistent "Entities",
dramatically reducing the amount of database-related coding effort.
This class prepares experienced Java programmers
to utilize the Persistence capabilities
provided with J2EE 5.
Level: Advanced
|
1-2 Days
| |
|
Oracle 9i Advanced PL/SQL Programming
|
This class will focus on developing advanced PL/SQL programming skills.
Topics will include the built-in packages that come with Oracle, the creation of triggers
and advanced stored procedure features. The class will also cover
object-relational concepts, performance tuning and dynamic SQL. The Oracle9
release has greatly enhanced the features and functionality of PL/SQL.
Numerous exercises and labs will introduce students to these new features.
Level: Advanced
|
3 Days
| |
|
Oracle 9i Server Performance Tuning
|
This class teaches DBAs how to tune an Oracle9i server.
Participants will learn the different areas that impact performance,
how to detect performance issues,
verify the performance problem, determine what to tune, understand the
ramifications of making changes, and then verify the results. Tuning Oracle
memory areas, contention and waits, physical I/O, checkpoints, undo segments,
temporary segments, archiving versus noarchiving, will be covered. Students will
learn how to work with different Oracle performance and diagnostic tools. Labs
involve running scripts to generate activity, detecting performance problems,
and then learning how to fix the performance issues.
Level: Advanced
|
3 Days
| |
|
Oracle Database 11g: Administration I
|
The overall objective of this course is to allow the student to gain
the skills necessary for day-today administration of an Oracle
database. This course is the starting point for Oracle database
administrators and also sets the foundation for advanced administrator
training and certification.
Level: Advanced
|
5 Days
| |
|
Oracle Database 11g: Administration II
|
The overall objective of this course is to bring database
administrators beyond a basic understanding of their environment
and to focus attention on more advanced skills needed to effectively
configure, administer, monitor and tune the database within a
large-scale enterprise.
Level: Advanced
|
5 Days
| |
|
Oracle Database 11g: New Features For Administrators
|
The purpose of this course is to present some of the most advanced
features available to database administrators which were either
introduced with the Oracle 11g release or have been substantially
improved with that release.
Level: Advanced
|
5 Days
| |
|
SQL Server 2000 Advanced Transact-SQL
|
Presents advanced Transact-SQL syntax and techniques.
Level: Advanced
|
4 Days
| |
|
SQL Server 2000 Performance and Tuning
|
You need to know how to tune queries and stored procedures
for optimal performance.
This course thoroughly covers SQL Server 2000 Query Optimizer.
You will learn techniques to write high performance queries,
allowing the optimizer to use the most efficient query plan,
and diagnose and correct performance problems with already existing queries.
Additionally, you will learn to interpret optimizer statistics and how to use simulated statistics.
Finally, you are presented with a benchmarking tuning methodology.
Level: Advanced
|
5 Days
| |
|
SQL Server 2005 Additional Topics
|
This course examines SQL Server 2005 essential application, support,
and maintenance topics - features you can use for high-availability,
stability, reliability, and scalability of databases, plus
enhancements for processing large amounts of data, handling complex
data structures, implementing asynchronous messaging, and working
with XML.
Level: Advanced
|
3 Days
| |
|
Sybase Administrators Performance and Tuning for ASE 12.5.1
|
This course teaches database administrators
how to tune an Adaptive Server for optimal performance.
It explores Adaptive Server architecture in depth,
and includes sections on designing databases for performance,
managing Adaptive Server system resources (CPUs, disks, I/O),
choosing appropriate locking schemes, optimizer statistics,
SMP features, relevant data structures, and parallel processing.
Level: Advanced
|
5 Days
| |
|
Sybase Advanced Transact-SQL for ASE 12.5.1
|
In this course you will learn
valuable tips, techniques and topics
beyond what was encountered in the Introduction to ASE 12.5.1
course to help solve and prevent common problems.
This course also emphasizes good coding practices,
report formatting, advanced functions, characteristic functions,
applied case logic, and bcp (bulkcopy),
as well as generalized methods for solving specific information management problems.
Level: Advanced
|
4 Days
| |
