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
|
Provides a hands-on introduction to SQL Server 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 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 15
|
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
| |
|
Microsoft LINQ Using Visual Basic 2008
|
Learn how to use LINQ with Visual Basic and Visual Studio 2008.
Level: Introduction
|
1 day
| |
|
Microsoft LINQ Using Visual C# 2008
|
Learn how to use LINQ with Visual C# and Visual Studio 2008
Level: Introduction
|
1 day
| |
|
Microsoft Office Access 2007
|
Learn how to use Microsoft Access 2007.
Level: Introduction
|
2 days
| |
|
Microsoft SQL Server 2008 Integration Services
|
Learn how to use the Integration Services of SQL Server 2008
Level: Introduction
|
3 days
| |
|
Microsoft SQL Server 2008 Reporting Services
|
Learn how to use SQL Server 2008
Reporting Services to create, execute, and manage reports.
Learn how to create tabular, matrix (cross-tab),
and chart reports using Visual Studio 2008 and SQL Server 2008
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: Introduction
|
3 days
| |
|
Microsoft SQL Server 2008 for Developers
|
Learn about the steps to install, and/or upgrade to SQL Server 2008 and configuring the server.
Level: Introduction
|
5 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 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
| |
|
Professional ADO.NET 3.5 with LINQ and the Entity Framework
|
Learn about the features provided by ADO.NET including
Language Integrated Query (LINQ), and the C# 3.0 and VB 9.0 language extensions to support it
using Visual Studio 2008 and the .NET Framework 3.x.
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
| |
|
SSAS Using Microsoft SQL Server 2008
|
Learn how to use the SQL Server 2008 Analysis Services
Level: Introduction
|
2 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
| |
|
Transact-SQL Server 2008
|
Learn about the features that are available in SQL Server like how to design and create
a database, and how to build basic queries using Transact-SQL, the language of SQL Server
Level: Introduction
|
4 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 Oracle and Visual Basic
|
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
| |
|
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 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 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
|
Describes how Views, Stored Procedures, Triggers, User-Defined Functions,
and Transact-SQL work in SQL Server. Presents maintenance, tuning, and security tools.
Level: Intermediate
|
2 Days
| |
|
SQL Server 2008 for Developers
|
This course shows how to code SQL and PL/SQL statements with and without the
SQL Developer tool. It also covers database design and implementation. It uses
the Oracle database.
Level: Intermediate
|
3 days
| |
|
SQL Server Analysis Tools for Data Analysts
|
Provides an introduction to Data Modeling and the implementation of databases
in SQL Server.
A review of Basic SQL is followed by more advanced topics including temporary tables,
Views, aggregating data, Joins, Cursors, Functions, and Transactions.
Level: Intermediate
|
2 Days
| |
|
SQL Server System and Database Administration
|
Learn all aspects of administering a SQL Server
from installation to configuration,
to maintaining a fast, high performance database server.
Level: Intermediate
|
5 Days
| |
|
Sybase System and Database Administration For ASE 15
|
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
| |
|
Extended Features In Microsoft SQL Server
|
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
| |
|
Java Programming with JUnit, Ant, and Eclipse
|
Hands-on survey of selected topics including:
Java 1.5 Features, JUnit 4, JDBC, Collections
Framework, JAXP, and Ant. Combination of Lecture and
Labs.
Level: Advanced
|
5 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 Advanced Transact-SQL
|
Presents advanced Transact-SQL syntax and techniques.
Level: Advanced
|
4 Days
| |
|
SQL Server Performance and Tuning
|
You need to know how to tune queries and stored procedures
for optimal performance.
This course thoroughly covers SQL Server 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
| |
|
Sybase Administrators Performance and Tuning for ASE 15
|
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 15
|
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
| |
