Online Database Administrators eLearning
Database Administrators Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
SQL Server 2008 Data Management

...iciently. Importing and exporting data provides a way for database administrators to move data between tables, databases, and servers. This course demonstrates how to manage table partitions, configure data compression, as well as create and manage indexes in a database. It also shows how to import data using the BULK INSERT and OPENROWSET (BULK...) statements and how to import or export data
more...
SQL Server 2008 Data Management
SQL Server 2008 Backups Restores and Database Snapshots

...ical data. To protect and ensure the data's availability, database administrators need to establish a solid backup and restoration plan. Such plans are used to protect data in the event of a disaster by allowing complete sets of duplicate data to be restored in a timely fashion. There are multiple types of backups that can be taken to ensure the recovery of data, including a full recovery or a
more...
Oracle Database 10g SQL Fundamentals I Part 2

...cal Consultants, Forms Developers, Portal Developers, and Database Administrators.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
8 hours
Objectives:
Unit 1: DML and Schema Objects
Identify the code for using the INSERT statement.
Identify the code for using the UPDATE statement.
Identify the code for using the
more...
Oracle Database 10g SQL Fundamentals I Part 1

...cal Consultants, Forms Developers, Portal Developers, and Database Administrators.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
8 hours
Objectives:
Unit 1: Database Management in Oracle 10g
Match the different phases of system development life cycle (SDLC) with their features.
Identify features of an Entity
more...
Data Modeling - Create Basic Models

...usiness analysts, technical analysts, database designers, database administrators, and anyone responsible for the analysis and specification of data during the application development lifecycle.
T otal Learning Time
7 - 8 Hour(s)
Course Contents
Unit 1: Introduction to Relational Data Modeling
Duration: 3 Hour(s)
Identify the tasks involved in Systems Development.
more...
Data Modeling - Develop Depth to Your Models

...usiness analysts, technical analysts, database designers, database administrators, and anyone responsible for the analysis and specification of data during the application development lifecycle. Participants should have knowledge equivalent to: course 60021, Data Modeling: Create Basic Models.
T otal Learning Time
7 - 8 Hour(s)
Course Contents
Unit 1: Adding Complexity to an
more...
Introduction to Data Warehousing

...A udience
Application developers, business analysts, database administrators, managers, project managers, and system analysts. Participants should have a business-level understanding of Oracle technology.
T otal Learning Time
7 - 8 Hour(s)
Course Contents
Unit 1: Basic Concepts of Data Warehousing
Duration: 2 Hour(s)
Identify the characteristics of a data
more...
Oracle SQL Specifics Retrieving and Formatting Data

... A udience
Application Developers, System Analysts, Database Administrators, Technical Support Personnel. Prior knowledge of SQL.
T otal Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Oracle Environment Overview
Duration: 1 - 2 Hour(s)
Identify three Relational Model concepts.
Match the five database objects to their definitions.
Identify features of
more...
Oracle SQL Specifics Creating and Managing Database Objects

... A udience
Application Developers, System Analysts, Database Administrators, Technical Support Personnel. Prior knowledge of SQL and first course in this series, Oracle SQL Specifics: Retrieving and Formatting Data (Course 60116).
T otal Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Creating and Managing Tables
Duration: 1.5 - 2 Hour(s)
Match each Oracle8
more...
Oracle SQL and SQL Plus Advanced SELECT Statements

...
Skills-Based
A udience
Application developers, database administrators, system designer/developers, and technical support professionals. Learners should be familiar with the basic principles of SQL and PL/SQL using Procedure Builder or have completed courses 60111, 60112 and 60113.
T otal Learning Time
7 - 8 Hour(s)
Course Contents
Unit 1: Single-Row Subqueries
more...
Oracle SQL and SQL Plus SQL Plus and Reporting

...
Skills-Based
A udience
Application developers, database administrators, system designers/developers, and technical support professionals. Learners should be familiar with the basic principles of SQL and PL/SQL using Procedure Builder, or have completed courses 60111, 60112 and 60113. In addition, the first part of this series should have been taken, course 60121 Oracle SQL and
more...
Oracle SQL Tuning Diagnostics and Tuning Schema

...
Skills-Based
A udience
Application Developers, Database Administrators, and Designer/Developers.
T otal Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Managing Performance
Duration: 2 - 3 Hour(s)
Identify the causes of SQL performance problems.
Identify the main system areas that can be addressed with the tuning process.
Sequence the steps involved
more...
Oracle SQL Tuning Tuning SQL and the Optimizer

...
Skills-Based
A udience
Application Developers, Database Administrators, and Designer/Developers.
T otal Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: SQL and Parsing
Duration: 2 - 3 Hour(s)
Identify the advantages of using array processing.
Enable array processing in SQL*Plus.
Identify the advantages of using server-side code.
Identify whether a
more...
Oracle Form Builder Forms Fundamentals

...
Skills-Based
A udience
Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113.
T otal Learning Time
7 - 8 Hour(s)
Course Contents
Unit 1: Developer/2000 and Form
more...
Oracle Form Builder Enhancing the User Interface

...
Skills-Based
A udience
Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first part of the Oracle Form Builder series: Course
more...
Oracle Form Builder Writing and Debugging Code

...
Skills-Based
A udience
Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first two parts of the Oracle Form Builder series,
more...
Oracle Form Builder Managing Module Types

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition participants should have taken the first three parts of the Oracle Form Builder series,
more...
Oracle Form Builder Handling Multiple Object Relationships

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first four parts of the Oracle Form Builder series,
more...
Oracle Form Builder Including Reusable Oracle Components

...
Skills-Based
A udience
Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first five parts of the Oracle Form Builder series,
more...
Oracle Report Builder Report Fundamentals

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should familiar with SQL and PL/SQL using Procedure Builder and PL/SQL Database Programming, or have taken courses 60111, 60112, 60113 and 60131. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit
more...
Oracle Report Builder Enhancing Reports

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder and PL/SQL Database Programming, or have taken courses 60111, 60112, 60113 and 60131. In addition, participants should have taken the first part in
more...
Oracle Report Builder Controlling Reports

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder and PL/SQL Database Programming, or have taken courses 60111, 60112, 60113 and 60131. In addition, participants should have taken the first two parts
more...
Oracle8 Database Administration - Manage an Instance

...
C ontent Emphasis
Skills-Based
A udience
Database Administrators, system administrators, network administrators and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113.
T otal Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1:
more...
Oracle8 Database Administration - Create Databases

...
C ontent Emphasis
Skills-Based
A udience
Database Administrators, system administrators, network administrators, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first part of the Oracle8
more...
Oracle8 Database Administration - Manage Storage Structures

...
C ontent Emphasis
Skills-Based
A udience
Database Administrators, system administrators, network administrators, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first two parts of the Oracle8
more...
Oracle8 Performance Tuning Strategies and Techniques

...
C ontent Emphasis
Skills-Based
A udience
Database administrators, system administrators, applications designers and developers, and technical support professionals.
Prior to taking this course, participants should be familiar with administering an Oracle8 database and have experience using Oracle Enterprise Manager (OEM), or have taken the Oracle8 Database Administration
more...
Oracle8 Performance Tuning Managing Memory and Disk I O

...
C ontent Emphasis
Skills-Based
A udience
Database administrators, system administrators, applications designers and developers, and technical support professionals.
Prior to taking this course, participants should be familiar with administering an Oracle8 database, or have taken the Oracle8 Database Administration series (courses 61311-61315). In addition, they should
more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention

...
C ontent Emphasis
Skills-Based
A udience
Database administrators, system administrators, applications designers and developers, and technical support professionals.
Prior to taking this course, participants should familiar with administering an Oracle8 database, or have taken the Oracle8 Database Administration series (courses 61311-61315). In addition, they should
more...
Oracle Form Builder R6 Forms Fundamentals

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures,
more...
Oracle Form Builder R6 Enhancing the User Interface

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures,
more...
Oracle Form Builder R6 Writing and Debugging Code

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures,
more...
Oracle Form Builder R6 Project Builder and Menu Modules

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures,
more...
Oracle Form Builder R6 Controlling the User Interface Programmatically

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures,
more...
Oracle Form Builder R6 Including Reusable Oracle Components

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures,
more...
Oracle Reports R6 Control Reports

... Skills-Based A udience Application Developers, Database Administrators, Designer/Developers and Technical Support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures,
more...
Windows 2000 Planning Implementing Active Directories - Part 1

...MIS Directors, Technical Managers, System Administrators, Database Administrators and System Analysts. It is recommenced that participants have completed NETg course 72400, Microsoft Windows 2000: Technical Overview and 72401, Microsoft Windows 2000: New Features or have equivalent knowledge. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Active Directory Basics
more...
SQL and PL SQL PL SQL Basics

... Skills-Based A udience Application Developers, Database Administrators, System Analysts and Technical Support Professionals. Prior to taking this course students should have knowledge equivalent to the computer based training (CBT) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112) and Oracle 8i. T otal
more...
SQL and PL SQL Basic SELECT

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be able to use a graphical user interface (GUI) and should be familiar with data processing concepts and techniques. Some prior knowledge of programming languages would be an advantage. This course will help
more...
SQL and PL SQL Data Retrieval Techniques

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be able to use a graphical user interface (GUI) and should be familiar with data processing concepts and techniques. Some prior knowledge of programming languages would be an advantage. In addition,
more...
SQL and PL SQL DML and DDL

... Skills-Based A udience Application Developers, Database Administrators, Designer/Developers, System Analysts, and Technical Support Professionals. Prior to taking this course, participants should be able to use a graphical user interface (GUI) and should be familiar with data processing concepts and techniques. Some prior knowledge of programming languages would be an advantage. In
more...
Oracle8i Database Admin Create Databases

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i
more...
Oracle8i Database Admin Manage Storage Structures

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i
more...
Oracle8i Database Admin Manage Data Storage

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i
more...
Oracle8i Database Admin Manage Security

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i
more...
Oracle8i Performance Tuning Architecture Strategy

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and experience using Oracle Enterprise Manager (OEM). This course will help candidates prepare for
more...
Oracle8i Performance Tuning Managing Memory Disk I O

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and Oracle8i Performance Tuning: Strategies and Techniques (63331). This course will help candidates
more...
Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and Oracle8i Performance Tuning: Strategies and Techniques (63331) and Oracle8i Performance Tuning:
more...
Oracle8i Backup and Recovery Strategies Backups

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course. This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA)
more...
Oracle8i Backup and Recovery Troubleshooting Recovery

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and Oracle8i Backup and Recovery: Strategies and Backups (63321). This course will help candidates
more...
Oracle8i Network Administration Net8 Architecture Strategy

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315). This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA) Track Exam 5, 1Z0-026. T
more...
Oracle8i Network Administration Net8 Additional Config Troubleshooting

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315), and the first part in this series, Oracle8i Network Administration: Net8 Architecture and Basic Configuration (63326). This
more...
Oracle Designer 6i First Class Analysis

...ers; Web Application Developers; Data Administrators, and Database Administrators. There are no prerequisites for this course. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Oracle Designer: Introduction Duration: 2 - 3 Hour(s) Identify the phases of the development life cycle. Identify the features of Oracle Designer. Identify the uses of the Process Modeller
more...
Oracle Designer 6i First Class Design Generation

...ers; Web Application Developers; Data Administrators, and Database Administrators. Participants should have taken the first part in this series Oracle Designer 6i: First Class Analysis (course 61414). Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits CEU credits: 0.70 CEUs Language Options American English Total
more...
UNIX--Part 2 Advanced Topics for Users

...stem Analysts, System Administrators, Software Engineers, Database Administrators, Help Desk/Support. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Hardware and Processes Duration: 1 - 2 Hour(s) Identify the hardware requirements for a UNIX system. Identify the memory requirements of a UNIX system. Identify the features of job control. Track multiple
more...
Oracle PL SQL Procedures Functions Packages

... Skills-Based A udience Application Developers, Database Administrators, and Technical Support Professionals. Prior to taking this course, students should have knowledge equivalent to the computer based training (CBT) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112). T otal Learning Time 6 - 8
more...
Oracle PL SQL Database Programming

... Skills-Based A udience Application Developers, Database Administrators, and Technical Support Professionals. Prior to taking this course, students should have knowledge equivalent to the computer based training (CBT) courses entitled: Oracle SQL and SQL *Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL *Plus: DML and DDL (course 61112), Oracle PL/SQL: Basics (course
more...
IBM DB2 Universal Database V6 1--Fundamentals

...database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language (SQL), and managing databases. L earn To:
more...
IBM DB2 Universal Database V6 1--Fundamentals

...database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language (SQL), and managing databases. L earn To:
more...
Solaris Administration Curriculum

Course Overview This curriculum covers basic user and system administration in the Solaris environment. It focuses on the common skills that an administrator will perform and how they are handled in this flavor of Unix. Students will learn internetworking connectivity, systems, services, and security. Wherever possible, there is a focus on the tools and features specific to Solaris. L earn
more...
SQL Server 2000 Database Admin Part 1 Install SQL Server 2000

This is the first course in a five part series that presents the students with both theoretical and practical instruction in the subject of installing SQL Server 2000. Learn To Identify the features and functions of SQL Server. Identify the components involved in the client-server communication process. Identify the steps in the client-server communication process. Identify the minimum
more...
SQL Server 2000 Database Admin Part 2 Manag Databases

Course Overview This is the second course in a five part series that will teach students how to plan for managing databases with SQL Server 2000. This course also includes both theoretical and practical instruction in the creation and management of objects. Learn To Identify the database option categories. Identify features of the tools used to view database properties. View database
more...
SQL Server 2000 Database Admin Part 3 Security Data Recovery

Course Overview This is the third course in a five part series that deals with the backup and restore strategies for SQL Server 2000 and with managing security and permissions with SQL Server 2000. Learn To Identify how login accounts are processed. Identify the characteristics of the two authentication modes. Sequence the steps to implement an authentication mode. Identify the
more...
SQL Server 2000 Database Admin Part 4 Managing Data

Course Overview This course deals with transferring data, managing replication services, and maintaining high availability. Learn To Identify guidelines for importing and exporting data. Match SQL Server 2000 tools used to import and export data with their functions. Identify the features and functions of the Data Transformation Services (DTS) process. Identify the features of
more...
SQL Server 2000 Database Admin Part 5 Maint SQL Server 2000

Course Overview This is the last course in a five part series that deals with managing, monitoring, and troubleshooting SQL Server 2000. Learn To Identify guidelines for configuring SQL Server Agent. Identify guidelines for using SQLAgentMail and SQL Mail. Configure a Microsoft Outlook Exchange profile for your administrative account. Identify the goals of SQL Server 2000 monitoring.
more...
SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data

Course Overview This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL. Learn To Identify the basic types of statements used in Transact-Structured Query Language (SQL). Identify the functions of Data Definition Language (DDL) statements. Identify the functions of Data Control Language (DCL) statements.
more...
SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries

Course Overview This course will teach students how to work with queries. The course will also introduce views, stored procedures, triggers, and user-defined functions. Learn To Identify advantages of using aliases for table names. Identify the guidelines for using joins. Identify the considerations for using inner joins. Identify considerations for using subqueries. Create a derived
more...
IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies

Course Overview This is the first course in a two part series that students will learn about OLAP functionality, SQL and AD Enhancements. Additionally, this course covers Federated Databases and Extenders and what has been added in these areas. Learn To Identify the enhancements that emerged with each version of DB2. Identify the six main product editions of the DB2 family. Identify
more...
IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies

Course Overview This is the first course in a two part series that students will learn about OLAP functionality, SQL and AD Enhancements. Additionally, this course covers Federated Databases and Extenders and what has been added in these areas. Learn To Identify the enhancements that emerged with each version of DB2. Identify the six main product editions of the DB2 family. Identify
more...
IBM DB2 Univ Database V7 1 Transition Part 2 Business Intelligence

Course Overview This is the second course in a two part series that students will be introduced to the concept of business intelligence. This course also covers administrative enhancements, and it discusses DB2 family enhancements. Learn To Identify the components of the data warehousing process. Identify the enhancements in Business Intelligence (BI) products available for DB2 version
more...
IBM DB2 Univ Database V7 1 Transition Part 2 Business Intelligence

Course Overview This is the second course in a two part series that students will be introduced to the concept of business intelligence. This course also covers administrative enhancements, and it discusses DB2 family enhancements. Learn To Identify the components of the data warehousing process. Identify the enhancements in Business Intelligence (BI) products available for DB2 version
more...
Access XP Fundamentals

...retarial, Web Designer-Developers, System Administrators, Database Administrators. Access 2002 Fundamentals doesn't require any previous database knowledge. Its audience could include a range of other job types such as Junior Secretarial, Customer Service etc. Typically learners will work in an office environment (possibly networked) producing documents/spreadsheets and/or databases/Web pages.
more...
Access XP Proficient User

...rial, Web Designer-Developers, System Administrators, and Database Administrators. Typically learners will work in an office environment (possibly networked) producing documents/spreadsheets and/or databases/Web pages. Learners will need a basic knowledge of either Microsoft Office 97 or 2000 programs and be familiar with Windows 9X or later operating system(s). Content Emphasis
more...
Access XP Expert User

...rial, Web Designer-Developers, System Administrators, and Database Administrators. Typically learners will work in an office environment (possibly networked) producing documents/spreadsheets and/or databases/Web pages. Learners will need a basic knowledge of either Microsoft Office 97 or 2000 programs and be familiar with Windows 9X or later operating system(s). Content Emphasis
more...
Outlook XP Fundamentals

...nagers Web Designer-Developers System Administrators, and Database Administrators. Typically learners will work in a networked environment that requires using e-mail for one-to-one, as well as group contacts and for arranging meetings and appointments through Microsoft Outlook. Learners will need a basic knowledge of either Microsoft Office 97 or 2000 programs and be familiar with Windows 9X or
more...
Outlook XP Proficient User

...gers, Web Designer-Developers, System Administrators, and Database Administrators. Typically learners will work in a networked environment which requires using e-mail for one-to-one, as well as group contacts as well as for arranging meetings and appointments through Microsoft Outlook. Outlook Proficient User requires a higher level of skill as it presupposes some familiarity with the software.
more...
Outlook XP Expert User

...gers, Web Designer-Developers, System Administrators, and Database Administrators. Typically learners will work in a networked environment which requires using e-mail for one-to-one, as well as group contacts as well as for arranging meetings and appointments through Microsoft Outlook. Microsoft Outlook 2002 Expert User requires a higher level of skill as it presupposes some familiarity with
more...
BizTalk Server 2000 Curriculum

...ience for this curriculum includes System Administrators, Database Administrators, Application Developers, System Analysts, and Network Designers who operate in medium to very large computing environments that use Microsoft BizTalk Server 2000. Learners should have a minimum of one year's experience designing and developing distributed applications by using Microsoft technologies. Prerequisites
more...
BizTalk Server 2000 Part 1 Intro to BizTalk Server 2000

... audience for this course includes System Administrators, Database Administrators, Application Developers, System Analysts, and Network Designers who operate in medium to very large computing environments that use Microsoft BizTalk Server 2000. Learners should have a minimum of one year's experience designing and developing distributed applications by using Microsoft technologies. Prerequisites
more...
BizTalk Server 2000 Part 2 Documents Mapping Managing Submitting

... audience for this course includes System Administrators, Database Administrators, Application Developers, System Analysts, and Network Designers. Prerequisites include experience with XML and it is recommended that learners have experience with XSLT. Learners should also have a working knowledge of COM+, including development tools such as Microsoft Visual Basic and Microsoft Visual C++, and a
more...
BizTalk Server 2000 Part 3 Monitoring Orchestration

...ence for this course would include System Administrators, Database Administrators, Application Developers, System Analysts, and Network Designers. Prerequisite knowledge would include expertise with XML, and experience with XSLT recommended. Working knowledge of COM+, including development tools such as Microsoft Visual Basic and Microsoft Visual C++, and a working knowledge of Microsoft
more...
BizTalk Server 2000 Part 4 Components Solutions Troubleshooting

...e The audience for this course includes Administrators, Database Administrators, Application Developers, System Analysts, and Network Designers who operate in medium to very large computing environments that use Microsoft BizTalk Server 2000. Learners should have a minimum of one year's experience designing and developing distributed applications by using Microsoft technologies. Prerequisites
more...
BizTalk Server 2000 Part 5 Secruity Optimization

...e The audience for this course includes Administrators, Database Administrators, Application Developers, System Analysts, and Network Designers who operate in medium to very large computing environments that use Microsoft BizTalk Server 2000. Learners should have a minimum of one year's experience designing and developing distributed applications by using Microsoft technologies. Prerequisites
more...
Oracle9i SQL Basic SELECT Statements

... Audience The target audience for this course includes database administrators and application developers. This course will help students prepare for the Oracle9i DBA certification, and is mapped to Exam 1Z0-007. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English, Brazilian Portuguese,
more...
Oracle9i SQL Data Retrieval Techniques

...substitution variable. Audience The audience includes database administrators, designers, developers, technical support professionals, and application developers. This course will help students prepare for the Oracle9i DBA certification, and is mapped to Exam 1Z0-007. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits
more...
Oracle9i SQL DML and DDL

...y. Audience The intended audience for this course are Database Administrators. Required prerequisite knowledge includes Oracle9i SQL: Basic SELECT Statements 61130 and Oracle9i SQL: Data Retrieval Techniques 61131. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English, Brazilian
more...
Oracle9i Database Admin Manage an Instance

... Audience The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures,
more...
Oracle9i Database Admin Create a Database

Course Overview The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this course discusses how to
more...
Oracle9i Database Admin Manage Storage Structures

... Audience The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Additionally, learners should have taken the first two parts of this series 64311 and 64312. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL:
more...
Oracle9i Database Admin Manage Data Storage

... Audience The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Additionally, learners should have taken the first three parts of this series 64311-64313. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML
more...
Oracle9i Database Admin Manage Security

... Audience The intended audience for this course include Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Additionally, learners should have taken the first four parts of this series (64311-64314). Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL:
more...
Oracle9i Database Admin Perform Database Backups

... Audience The intended audience for this course include Database administrators, IT managers, and technical professionals. There are no prerequisites for this course. Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 64321 Objectives Unit 1: Oracle
more...
Oracle9i Database Admin Recover Databases

... Audience The intended audience for this course include Database Administrators, IT managers, and technical professionals. There are no required prerequisites. Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 64322 Objectives Unit 1: Oracle Recovery
more...
Oracle9i Database Admin Set Up Oracle Net Services

... Audience The intended audience for this course are Database administrators. Required prerequisites are Oracle SQL, Oracle PL/SQL. Suggested prerequisites include Oracle9i Database Administration: Manage an Instance (64311), and Oracle9i Database Administration: Create a Database (64312). Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE
more...
Oracle9i Performance Tuning Architecture Strategy

.... Audience This intended audience for this course are Database Administrators. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English, Brazilian Portuguese, Spanish Total Learning Time 6 to 8 hours 64331 Objectives Unit 1: Tuning the Oracle9i Server: Overview 1 - 2 hours o Match
more...
Oracle9i Peformance Tuning Managing Memory and Disk I O

... Audience The intended audience for this course includes Database Administrators, Technical Support Professionals, and System Administrators. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English, Portuguese, Spanish Total Learning Time 6 to 8 hours 64332 Objectives Unit 1: SQL
more...
Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention

... Audience The intended audience for this course includes database administrators and application developers, regardless of role or experience level. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English, Brazilian Portuguese, Spanish Total Learning Time 6 to 8 hours 64333 Objectives
more...
Crystal Reports 8 5 Introductory Report Design Part 1

...ce The audience for this course includes End Users, and Database Administrators. Students should have prerequisite knowledge of database concepts, including tables, fields, and records. Content Emphasis Conceptual Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total
more...
Crystal Reports 8 5 Introductory Report Design Part 2

...ce The audience for this course includes End Users, and Database Administrators. Learners should have prerequisite knowledge of database concepts, including tables, fields, and records. In addition, learners should have taken the first course in the series (13889). Content Emphasis Conceptual Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA
more...
Oracle SQL PL SQL Using Procedure Builder Curriculum

...jectives and scope. Audience Application developers, database administrators, designer/ developers, and technical support professionals. Prior to taking this curriculum, participants should be able to use a graphical user interface (GUI) and should be familiar with data processing concepts and techniques. Some prior knowledge of programming languages would be an advantage. This curriculum
more...
Oracle 9i New Features Database Administration

...hancements. Audience The audience for this course are Database Administrators. Required prerequisites include SQL, PL/SQL, DBA I, DBA II. Deployment Options e-Learning Accreditation NASBA credits: 4 CPE Credits CEU credits: 0.50 CEUs Language Options German, Korean, US English Total Learning Time 6 to 8 hours Objectives Unit 1: Server-side Manageability
more...
CIW Enterprise Specialist Part 1 CORBA Intro IDL Clients

...ded audience for this course includes Technical Managers, Database Administrators, Application Developers, Systems Analysts, Software Engineers, Other Software Designers, and Project Managers. Candidates for this curriculum employ distributed application architecture technologies (including JavaBeans and CORBA), synthesize knowledge of system architecture design, database design and
more...
CIW Enterprise Specialist Part 2 CORBA Servers Adv Features Security

...ded audience for this course includes Technical Managers, Database Administrators, Application Developers, Systems Analysts, Software Engineers, Software Designers, and Project Managers. Learners should have knowledge of Object-Oriented Programming. This course helps candidates prepare for CIW Enterprise Specialist exam number 1D0-442. In addition, the learner should have taken the first part
more...
CIW Enterprise Specialist Part 3 EJB Framework Session Beans

...ded audience for this course includes Technical Managers, Database Administrators, Application Developers, Systems Analysts, Software Engineers, Software Designers, and Project Managers. Learners should have knowledge of Object-Oriented Programming. This course helps candidates prepare for CIW Enterprise Specialist exam number 1D0-442. In addition, learners should have taken the first two parts
more...
CIW Enterprise Specialist Part 4 EJB Deployment EJB Clients Entity Beans

...ded audience for this course includes Technical Managers, Database Administrators, Application Developers, Systems Analysts, Software Engineers, Software Designers, and Project Managers. Learners should have knowledge of Object-Oriented Programming. This course helps candidates prepare for CIW Enterprise Specialist exam number 1D0-442. In addition, learners should have taken the first three
more...
CIW Enterprise Specialist Part 5 CMP EJB Transactions Security

...ded audience for this course includes Technical Managers, Database Administrators, Application Developers, Systems Analysts, Software Engineers, Software Designers, and Project Managers. Learners should have knowledge of Object-Oriented Programming. This course helps candidates prepare for CIW Enterprise Specialist exam number 1D0-442. In addition, learners should have taken the first four
more...
Database Technologies Relational Database Fundamentals

...nologies, and database maintenance. Audience Associate database administrators, technical support consultants, and associate programmer/analysts are some of the types of people who would benefit from this course. This course is intended for people who are relatively new to the world of corporate IT and databases. They will most likely either be new to the workforce or have recently been
more...
Database Technologies Introduction to SQL

The second in a two-part series, this course will teach students the fundamental skills and knowledge needed to acquire a foundation-level understanding of SQL. Building on the basic relational database skills and knowledge acquired in the first course, this course teaches students the essential SQL statements, and associated variations, needed to perform fundamental data access and manipulation
more...
Visual Basic NET-Distributed Applications Part 1

...g a Windows Service. Audience This course is aimed at database administrators, application developers, systems analysts, and software engineers. Typically, students will may be working in a medium to large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. Candidates should have at least one year of experience developing middle-tier components.
more...
Visual Basic NET-Distributed Applications Part 2

The Microsoft Visual Basic .NET-Distributed Applications Pt 2: COM+ and Interop course covers how to create and consume serviced components and how to create and manage transaction services by using Visual Studio .NET and the Microsoft .NET Framework. This course also covers how to work with unmanaged code. Learn To: a To identify benefits of COM-based applications. a To
more...
Visual Basic NET-Distributed Applications Part 3

...hemas into DataSets. Audience This course is aimed at database administrators, application developers, systems analysts, and software engineers. Typically, students will may be working in a medium to large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. Candidates should have at least one year of experience developing middle-tier components.
more...
Visual Basic NET-Distributed Applications Part 4

... their descriptions. Audience This course is aimed at database administrators, application developers, systems analysts, and software engineers. Typically, students will may be working in a medium to large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. Deployment Options e-Learning Accreditation NASBA credits: 4 CPE Credits CEU
more...
Visual Basic NET-Distributed Applications Part 5

...gest authentication. Audience This course is aimed at database administrators, application developers, systems analysts, and software engineers. Typically, students will may be working in a medium to large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. Candidates should have at least one year of experience developing middle-tier components.
more...
Oracle8 Database Administration - Manage Data

...
C ontent Emphasis
Skills-Based
A udience
Database Administrators, system administrators, network administrators, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first three parts of the
more...
Oracle8 Database Administration - Manage Security

...
C ontent Emphasis
Skills-Based
A udience
Database administrators, system administrators, network administrators, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112, 60113, and 60114. In addition, participants should have taken the first four parts of
more...
Oracle8 Backup and Recovery - Strategies and Backups

...
Skills-Based
A udience
Network Administrators, Database Administrators, Technical Support Analysts, System Administrators, Application Developers, and MIS Managers. Prior to taking this course, participants should be familiar with SQL and PL/SQL Using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the Oracle8 Database
more...
Oracle8 Backup and Recovery - Troubleshooting and Recovery

...
Skills-Based
A udience
Network Administrators, Database Administrators, Technical Support Analysts, System Administrators, Application Developers, and MIS Managers. Prior to taking this course, participants should be familiar with SQL and PL/SQL Using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the Oracle8 Database
more...
Oracle8 Network Administration Net8 Architecture Configuration

... Skills-Based A udience Network administrators, database administrators, technical support analysts, system administrators, application developers, and MIS managers. Participants should be familiar with Oracle8 database administration, or have taken courses 61311, 61312, 61313, 61314, and 61315. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Net8 Overview
more...
Oracle8 Network Administration Net8 Configuration and Troubleshooting

... Skills-Based A udience Network administrators, database administrators, technical support analysts, system administrators, application developers, and MIS managers. Participants should be familiar with Oracle8 database administration, or have taken courses 61311, 61312, 61313, 61314, and 61315. Also, the first part of this series, course 61326, should have been taken. T otal
more...
Oracle8i Database Admin Manage an Instance

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113). This
more...
IBM DB2 Universal Database V6 1 Admin Curriculum

...lls-Based A udience These courses are intended for database administrators. Students should have a fundamental understanding of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and
more...
IBM DB2 Universal Database V6 1 Admin Curriculum

...lls-Based A udience These courses are intended for database administrators. Students should have a fundamental understanding of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and
more...
IBM DB2 Universal Database V6 1--Fundamentals

...database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language (SQL), and managing databases. L earn To:
more...
IBM DB2 Universal Database V6 1--Fundamentals

...database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language (SQL), and managing databases. L earn To:
more...
IBM DB2 Universal Database V6 1--Administration

...database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement a new DB2 database or application.
more...
IBM DB2 Universal Database V6 1--Administration

...database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement a new DB2 database or application.
more...
HTML 4 Part 1 HTML Fundamentals

...audience for this course includes, System Administrators, Database Administrators, Help Desk/Support, Application Developers, System Analysts and Software Engineers. Learners are expected to have an understanding of basic Internet and Website concepts. Content Emphasis Skills-Based Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options American
more...
HTML 4 Part 1 HTML Fundamentals

...audience for this course includes, System Administrators, Database Administrators, Help Desk/Support, Application Developers, System Analysts and Software Engineers. Learners are expected to have an understanding of basic Internet and Website concepts. Content Emphasis Skills-Based Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options American
more...
HTML 4 Part 2 Advanced Topics

...audience for this course includes, System Administrators, Database Administrators, Help Desk/Support, Application Developers, System Analysts and Software Engineers. Learners are expected to have an understanding of basic Internet and Website concepts. In addition, students should have taken the first part of this series (86041). Content Emphasis Skills-Based Deployment Options
more...
HTML 4 Part 2 Advanced Topics

...audience for this course includes, System Administrators, Database Administrators, Help Desk/Support, Application Developers, System Analysts and Software Engineers. Learners are expected to have an understanding of basic Internet and Website concepts. In addition, students should have taken the first part of this series (86041). Content Emphasis Skills-Based Deployment Options
more...
Dir Database Integration Using DirXML Part 1 DirXML Deploy

...l managers, system administrators, network engineers, and database administrators having work experience of 2 to 10 years. This course is designed to help candidates prepare for the CDE certification. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours
more...
Dir Database Integration Using DirXML Part 2 MS Exchange Synchronization

...l managers, system administrators, network engineers, and database administrators who have 2 to 10 years of experience. This course is designed to help candidates prepare for the CDE certification. The course teaches how to synchronize Microsoft Exchange and eDirectory using DirXML. In addition, learners should have taken the first part of the series 82721. Deployment Options Internet /
more...
Dir Database Int Using DirXML Part 3 Netscape Dir Server eDirectory

...l managers, system administrators, network engineers, and database administrators who have 2 to 10 years of experience. This course is designed to help candidates prepare for the CDE certification. The course teaches how to synchronize Microsoft Exchange and eDirectory using DirXML. In addition, learners should have taken the first two parts of the series 82721 and 82722. Deployment Options
more...
Dir Database Int Using DirXML Part 4 XDS Docs XSLT Stylesheets

...l managers, system administrators, network engineers, and database administrators who have 2 to 10 years of experience. This course is designed to help candidates prepare for the CDE certification. The course teaches how to synchronize Microsoft Exchange and eDirectory using DirXML. In addition, learners should have taken the first three parts of the series 82721 thru 82723. Deployment
more...
CCNT Basic Data Communications v6 0 Part 1

...itles include: Network Administrators, Network Engineers, Database Administrators, Telecommunications Technicians, Help Desk/Supports, IT/Data Product Managers, and Data/Internet/Telecommunications Sales Personnel.
Deployment:
e-Learning
Language Options:
US English
Total Learning Time:
7 hours
Objectives:
Unit 1: Networks and Signals (3.5 hours)
more...
CCNT Basic Data Communications v6 0 Part 2

...itles include: Network Administrators, Network Engineers, Database Administrators, Telecommunications Technicians, Help Desk/Supports, IT/Data Product Managers, and Data/Internet/Telecommunications Sales Personnel.
Deployment:
e-Learning
Language Options:
US English
Total Learning Time:
6 - 8 hours
Objectives:
Unit 1: Networks, SNA, and TCP/IP (2
more...
CCNT Basic Data Communications v6 0 Part 3

...itles include: Network Administrators, Network Engineers, Database Administrators, Telecommunications Technicians, Help Desk/Supports, IT/Data Product Managers, and Data/Internet/Telecommunications Sales Personnel.
Deployment:
e-Learning
Language Options:
US English
Total Learning Time:
6 - 8 hours
Objectives:
Unit 1: LANs and Communications
more...
Oracle Application Server 10g Administration II Part 1

...uting.
Audience:
The audience for the course is database administrators and technical consultants.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
8 hours
Objectives:
Unit 1: OracleAS Topologies and Deployments
Identify enhancements in Oracle Enterprise Manager (OEM) Application Server Control to manage a
more...
Oracle Application Server 10g Administration II Part 2

...nment.
Audience:
The audience for the course is database administrators and technical consultants.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
8 hours
Objectives:
Unit 1: Web Cache Clusters
Identify features of Oracle Application Server (OracleAS) 10g Web Cache clusters.
Identify benefits of running an
more...
Oracle Application Server 10g Administration II Part 3

...ework.
Audience:
The audience for the course is database administrators and technical consultants.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
8 hours
Objectives:
Unit 1: OracleAS Discoverer
Match the components of Oracle Application Server (OracleAS) 10g Discoverer with their descriptions.
Identify
more...
Oracle Application Server 10g Administration II Part 4

...) 10g.
Audience:
The audience for the course is database administrators and technical consultants.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
8 hours
Objectives:
Unit 1: Monitoring Oracle AS
Identify features of Oracle Diagnostic Logging (ODL).
Identify options for configuring component logging.
more...
From Serebra Learning Corporation
Security in a Microsoft SQL Server 2000 Environment
To explain how to plan and implement security on a SQL 2000 database Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Transferring and Transforming Data in SQL Server 2000
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Transferring and Transforming Data in SQL Server 2000
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Visual Basic 6 0 Database Access Part II
This course provides a detailed look at the ActiveX Data Object (ADO)that acts as the bridge between your application and a database. Designed for intermediate to advanced Visual Basic application programmers Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential.
more...
OS 390 Introduction to CICS Transaction Server
The OS/390 CICS course provides general information about Customer Information Control System (CICS) and methods for employing it to perform basic Online Transaction Processing (OLTP) tasks in a mainframe environment. The course reviews the overall structure and purpose of CICS and introduces basic command levels for CICS in the following areas: management of data and databases, data communication
more...
CCNT Basic Data Communications v6 0 Part 1
This course gives students an introduction to data networks, signals and to data transmission. The Data Networks and Signals section teaches about data terminal equipment (DTE), data communication equipment (DCE), the OSI model, and analog and digital signals. The Data Transmission section teaches about half-duplex and full-duplex circuits, and switched and non-switched data circuits. This section
more...
CCNT Basic Data Communications v6 0 Part 2
This course teaches students about networks and transmission principles. The networks section teaches about local area networks (LANs), wide-area networks (WANs), hierarchical WANs, and LAN components. This section also teaches about system network architecture (SNA), and TCP/IP. The Transmission Principles section teaches about data protocols, DTE to DCE interface standards, and transmission
more...
Backup and Recovery Overview and Configuration in Oracle9i
To describe backup and recovery operations, the backup components, and how to configure these components in an Oracle9i database Oracle database administrators and database operators
more...
CCNT Basic Data Communications v6 0 Part 3
This course teaches students about data communications equipment and media. The LANs and Communications equipment section teaches about the Institute for Electrical and Electronic Engineering (IEEE), analog and digital communication, modulation, multiplexers, and the Synchronous Optical Networks (SONET) protocol. The Transmission Media section teaches about transmission media cables and wireless
more...
User-Managed and RMAN Backup and Recovery in Oracle9i
To describe how to perform user-managed and Recovery Manager backup and recovery in an Oracle9i database Oracle database administrators and database operators
more...
Recovery Manager Maintenance in Oracle9i
To describe how to maintain the Recovery Manager (RMAN) and how to create and maintain the recovery catalog in an Oracle9i database Oracle database administrators and database operators
more...
Transporting and Loading Data in Oracle9i
To describe how to transport and load data in an Oracle9i database Oracle database administrators and database operators
more...
Networking Overview for Oracle9i Administrators
To provide an overview of the networking solutions and the components of the network architecture in an Oracle9i database Oracle database administrators and database operators
more...
Oracle Network Configuration in Oracle9i
To explain how to configure client/server Oracle Net Services and a Shared Server for an Oracle9i database Oracle database administrators and database operators
more...
Introduction to Oracle and SQL in Oracle 9i
To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements Junior database administrators, application developers, and database operators
more...
SQL Functions in Oracle 9i
To describe how to use SQL functions for data retrieval Junior database administrators, application developers, and database operators
more...
Subqueries Reporting and User-Access Control in Oracle 9i
To describe the use of subqueries, reporting, and user-access control in an Oracle9i database Junior database administrators, application developers, and database operators
more...
Defining and Manipulating Data in Oracle 9i
To describe how to define database objects and manipulate the data stored within them in an Oracle9i database Junior database administrators, application developers, and database operators
more...
Introducing Oracle9i Database
To introduce the components and architecture of Oracle9i, the application of Oracle9i, and migrating and upgrading to Oracle9i Oracle database administrators; developers interested in the technical aspects of Oracle9i database
more...
Manageability Enhancements in Oracle9i
To describe the manageability enhancements of an Oracle9i database Oracle database administrators; developers interested in the technical aspects of Oracle9i database
more...
Using Flashback Technology in Oracle 10g
To outline the considerations and procedures for using Flashback features Oracle database administrators and database operators
more...
Performing and Managing Backups in Oracle 10g
To outline the processes and considerations for using RMAN to perform and monitor backups Oracle database administrators and database operators
more...
Advanced Database Recovery and Repair in Oracle 10g
To outline the processes for recovering non-critical files, performing incomplete recoveries, and repairing corrupted components of databases Oracle database administrators and database operators
more...
Controlling the Oracle Listener and Enabling Distributed Transactions in Oracle 10g
To outline the concepts and processes to secure the Oracle listener and to work with remote and distributed transactions Oracle database administrators and database operators
more...
Using Globalization Support in Oracle 10g
To outline the considerations and procedures for globalizing a database Oracle database administrators and database operators
more...
Optimizing Database Performance in Oracle 10g
To outline the processes and considerations for optimizing an Oracle database using alerts, trace files, and advisors Oracle database administrators and database operators
more...
Managing Storage and System Resources in Oracle 10g
To outline the processes and considerations for using the Automatic Storage Management and Database Resource Manager features Oracle database administrators and database operators
more...
Using the Scheduler to Automate Tasks in Oracle 10g
To outline the processes and considerations for using the Scheduler tool Oracle database administrators and database operators
more...
Using Advanced Features in Oracle 10g
To outline the processes and considerations for using the advanced features of Oracle Database 10g Oracle database administrators and database operators
more...
PL SQL Packages
To create and work with Oracle 10g packages Database administrators, application developers, and database operators
more...
Oracle-Supplied Packages and DBMS_SCHEDULER
To use Oracle-supplied packages Database administrators, application developers, and database operators
more...
Managing Dependencies
To manage dependencies and recompile PL/SQL units Database administrators, application developers, and database operators
more...
Manipulating Large Objects in PL SQL
To use LOBs and the DBMS_LOB package Database administrators, application developers, and database operators
more...
PL SQL Triggers
To create and manage triggers Database administrators, application developers, and database operators
more...
Dynamic SQL and Metadata
To write dynamic SQL and use the DBMS_METADATA package Database administrators, application developers, and database operators
more...
Introduction to PL SQL
To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL Database administrators, application developers, and database operators
more...
Using PL SQL with an Oracle Server
To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block Database administrators, application developers, and database operators
more...
Using Control Structures
To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct Database administrators, application developers, and database operators
more...
Using Composite Data Types
To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records Database administrators, application developers, and database operators
more...
Explicit Cursors and Exception Errors
To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled Database administrators, application developers, and database operators
more...
Creating Stored Procedures and Functions
To create and execute a stored function and call, and remove and view stored functions in PL/SQL Database administrators, application developers, and database operators
more...
Introduction to Oracle and SQL in Oracle Database 10g
To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements Database administrators, application developers, and database operators
more...
SQL Functions in Oracle Database 10g
To describe how to use SQL functions for data retrieval Database administrators, application developers, and database operators
more...
Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g
To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases Database administrators, application developers, and database operators
more...
Group and Datetime Functions in Oracle Database 10g
To demonstrate how to use group and datetime functions in Oracle 10g Database administrators, application developers, and database operators
more...
Subqueries and Hierarchical Queries in Oracle Database 10g
To demonstrate how to use subqueries and hierarchical queries in Oracle 10g Database administrators, application developers, and database operators
more...
Regular Expressions and User Access in Oracle Database 10g
To demonstrate how to use regular expression support and control user access in Oracle 10g Database administrators, application developers, and database operators
more...
Installing Configuring and Upgrading SQL Server 2000
To describe how to install, configure, and upgrade SQL Server Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Overview of SQL Server 2000
To provide a high-level overview of SQL Server Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Managing SQL Server 2000 Databases
To guide students in configuring, performing, and automating routine administrative tasks Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
SQL Server 2000 Databases
To describe how to create and modify SQL Server 2000 databases Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Backing Up SQL Server 2000 Databases
To explain how to back up SQL Server databases Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Restoring SQL Server 2000 Databases
To describe the process involved in restoring SQL Server databases Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
SQL Server 2000 Replication
To describe how to implement the SQL 2000 replication models Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Monitoring SQL Server 2000 Performance
To explain how to monitor SQL Server for optimal performance Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Fundamentals of Microsoft Visual InterDev 6 0
This course gives an overview of the fundamental concepts of Visual InterDev 6.0. It teaches how to create simple web projects using the Web Project Wizard, as well as how to create site diagrams, manage links between pages, apply links, style sheets, and themes to a project. In addition, it prepares students to take the Microsoft certification exam: Designing and Implementing Web Solutions with
more...
Scripting with MS Visual InterDev 6 0
This course provides students an insight into the scripting skills necessary to utilize Visual InterDev 6.0 to create dynamic and enhanced Web application. In addition, it prepares students to take the Microsoft certification exam: Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. This course is intended for Web Developers, Web Masters, Web Server Administrators, System
more...
Developing Applications using MS Visual InterDev 6 0
This course provides students with skills to develop web applications using databases with Visual InterDev 6.0. The students will also be taught the process of deploying web applications on web servers. In addition, this course prepares students to take the Microsoft certification exam: Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. This course is intended for Web
more...
DB2 Design Administration I ver 4 x
Provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance. Database administrators, analysts and systems designers.
more...
DB2 Design Administration II ver 4 x
Provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance. Database administrators, analysts and systems designers.
more...
Data Warehousing
This course will provide an overview of Data Warehousing, an emerging technique for storage and retrieval of data from distributed heterogeneous sources. Students will be given an overview of Data Warehousing, study the various components of Data Warehousing Systems, and learn how to build, use and maintain a Data Warehousing System. Information systems managers, database administrators and other
more...
Data Modeling
To be able to use a database to store data, you have to design it. The first step in designing a database is data modeling. Data modeling enables a database designer to create a model that represents the way in which information is likely to be organized in the database. This data model is then reviewed by the people who are expected to use the final database. Subsequent steps in database
more...
IBM DB2 UDB Essentials Part 2 - System and Database Administration
Following on from the first course in this curriculum this course focuses on the roles and principal tasks of the System Administrator and Database Administrators in IBM DB2. Administrative utilities and security are covered. The course also provides comprehensive introduction to the areas of database modelling database design and distributed data processing all core concepts within IBM DB2 UDB.
more...
SQL Server 7.0 Management Part II
...database administrators managers and users so that they may take full advantage of SQL Server 7.0 features. It explains how to use the fundamental elements of Transact-SQL how to use the SELECT statement and how to monitor database performance. It also examines stored procedures and joins. Related Exam: Prepares users for both Microsoft Exams #070-028 Administering Microsoft SQL Server 7.0 and
more...
IBM DB2 Universal Database V6.1 Fundamentals
This course will provide both database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX Windows or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1 creating and accessing database objects basic Structured Query Language (SQL) and managing
more...
IBM DB2 Universal Database V6.1 Administration
This course will provide database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX Windows or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database.
more...
DB2 Design & Administration (Rel 2.3)


Provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance.
more...
DB2 Design & Administration (ver 3.1)


Provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance.
more...
DB2 Design & Administration (ver 4.x)


This course provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance.
more...
From ProTrain Online
MCTS .NET Framework


Microsoft Certified Technology Specialist (MCTS): .NET Framework certifications enable professionals to target specific technologies and to distinguish themselves by demonstrating in-depth knowledge and expertise in the various Microsoft specialized technologies. A MCTS Certification in Microsoft teaches technicians how to implement and maintain databases using specific instructions and
more...
From The Virtual Training Company
Microsoft SQL Server 2005 Administration
SQL Server 2005 is Microsoft's latest release of their enterprise database solution product. SQL Server 2005 is the result of five years of research, development and collection of suggestions and wish lists from database administrators and developers. Microsoft continues to drive the enterprise database market with the added features and capabilities of this new product. Microsoft Certified
more...
From Skillspride Online Training
Microsoft SQL Server 7.0 Administration
SQL Server is a scaleable RDBMS designed for client/server applications. This course will prepare Database Administrators to set up and maintain MS SQL systems in a networked environment. It provides both the theory and practical experience of installing, backing up, replicating and monitoring and tuning an SQL Server 7.0 system.
more...
Microsoft SQL Server 6.5 Administration
SQL Server is a scaleable RDBMS designed for client/server applications. This course will prepare Database Administrators to set up and maintain an MSSQL systems in a networked environment. It provides both the theory and practical experience of installing, backing up, replicating and monitoring and tuning an SQL Server 6.x system.
more...
