Online Sql Server eLearning
Sql Server Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Installing SQL Server 2005

Installing SQL Server 2005 Microsoft
To install SQL Server 2005 and upgrade to SQL Server 2005 from previous versions
more...
Installing SQL Server 2005
Configuring SQL Server 2005

Configuring SQL Server 2005 Microsoft
To configure a SQL Server instance and create a database, configure logins, users, and schemas for a database, and set up a linked server configuration
more...
Creating and Implementing Database Objects in SQL Server 2005

Creating and Implementing Database Objects in SQL Server 2005 Microsoft
To create and implement key database objects in SQL Server 2005
more...
Retrieving Data and Running Queries in SQL Server 2005

Retrieving Data and Running Queries in SQL Server 2005 Microsoft
To perform relational data and XML data management tasks, and work with assemblies and transactions in SQL Server 2005
more...
SQL Server 2005 Messaging and Querying Tools

SQL Server 2005 Messaging and Querying Tools Microsoft
To implement Service Broker components and use full-text search in SQL Server 2005
more...
Managing and Maintaining SQL Server 2005 Databases

Managing and Maintaining SQL Server 2005 Databases Microsoft
To manage and maintain SQL Server 2005 databases
more...
SQL Server 2005 Database Performance and Optimization

SQL Server 2005 Database Performance and Optimization Microsoft
To monitor and optimize database performance using SQL Server utilities
more...
Monitoring and Diagnosing Database Problems in SQL Server 2005

Monitoring and Diagnosing Database Problems in SQL Server 2005 Microsoft
To monitor and resolve database blocks, and connect to the server using a dedicated administrator connection (DAC)
more...
SQL Server 2005 High Availability and Disaster Recovery

SQL Server 2005 High Availability and Disaster Recovery Microsoft
To implement database mirroring, log shipping, database snapshots, and data replication in SQL Server 2005
more...
SQL Server 2005 Backup and Restores

SQL Server 2005 Backup and Restores Microsoft
To back up and restore a database in SQL Server 2005
more...
Oracle Application Server 10g mod_pl sql CGI Scripts and Database Providers

Oracle Application Server 10g: mod_pl sql, CGI Scripts, and Database Providers Oracle
To demonstrate how to configure mod_plsql, CGI-script execution, and database providers in OracleAS
more...
Designing a Database Server Infrastructure for SQL Server 2005

Designing a Database Server Infrastructure for SQL Server 2005 Microsoft
To specify the appropriate requirements for implementing SQL Server 2005, identify suitable instance and physical storage strategies, and determine the appropriate way to design a database consolidation plan, given a SQL Server scenario
more...
Using PL SQL with an Oracle Server

Using PL/SQL with an Oracle Server Oracle
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
more...
Designing an Application Solution for SQL Server 2005

Designing an Application Solution for SQL Server 2005 Microsoft
recognize how to design and build a database model and a physical database, and how to secure it
more...
Designing Database Objects

Designing Database Objects Microsoft
recognize how to design database objects according to your requirements
more...
Programming with SQL Server 2005

Programming with SQL Server 2005 Microsoft
recognize how to implement SQL Server 2005 programming features to work with database data
more...
Using XML

Using XML Microsoft
recognize how to use, implement, retrieve and manipulate XML data in SQL Server 2005 using XQuery language
more...
CLR Integration

CLR Integration Microsoft
recognize how to use CLR integration in SQL Server 2005 to create, implement and work with data, and how to execute .NET assemblies to achieve this
more...
Database Testing and Code Management

Database Testing and Code Management Microsoft
recognize how to implement version control, unit testing and performance benchmarking and improvements in SQL Server 2005
more...
Developing Applications that Use SQL Server Support Services

Developing Applications that Use SQL Server Support Services Microsoft
recognize how to develop and deploy SQL Service Support solutions with Notification Services and Service Broker
more...
Developing Applications that Use SQL Server Business Intelligence Services

Developing Applications that Use SQL Server Business Intelligence Services Microsoft
recognize how to implement Reporting Services to generate reports and Integration Services to manipulate data according to your requirements
more...
Database Deployment and Data Distribution

Database Deployment and Data Distribution Microsoft
recognize how to design, deploy and utilize database deployment and database distribution solutions
more...
Designing Access to SQL Server Data

Designing Access to SQL Server Data Microsoft
recognize how to design and utilize data access technologies to manage SQL Server and access SQL Server Data
more...
Designing Efficient Application Access

Designing Efficient Application Access Microsoft
recognize how to efficiently utilize client libraries for database access using automation management objects, server Network Interface and MARS for queries and row management
more...
Designing Queries in SQL 2005

Designing Queries in SQL 2005 Microsoft
recognize how to design and execute queries in SQL Server 2005, utilizing XQuery and the XML Data Modification Language
more...
Designing a SQL Server 2005 Cursor Strategy

Designing a SQL Server 2005 Cursor Strategy Microsoft
recognize how to design and implement an appropriate cursor strategy in SQL Server 2005
more...
Designing a SQL Server 2005 Transaction Strategy

Designing a SQL Server 2005 Transaction Strategy Microsoft
recognize the different levels of isolation and granularity to manage concurrency and execute a transaction strategy in SQL Server 2005
more...
SQL Server 2005 Error Handling Techniques

SQL Server 2005 Error Handling Techniques Microsoft
recognize how to design code for validating input, for error handling and for user-defined messages in SQL Server 2005
more...
Optimizing Query Performance and Index Strategies

Optimizing Query Performance and Index Strategies Microsoft
recognize how to optimize query performance and indexing strategies in SQL Server 2005
more...
Optimizing Storage in SQL Server 2005

Optimizing Storage in SQL Server 2005 Microsoft
recognize how to optimize database storage and SQL Server performance
more...
Scaling Applications and Resolving Performance Issues

Scaling Applications and Resolving Performance Issues Microsoft
recognize how to scale out applications to enterprise level and troubleshoot and identify performance issues that result
more...
Designing Security for a Database Server Infrastructure for SQL Server 2005

Designing Security for a Database Server Infrastructure for SQL Server 2005 Microsoft
To identify business security requirements, select the appropriate authentication method, and specify a security design for different levels of the SQL Server environment
more...
Designing the Physical Database for SQL Server 2005

Designing the Physical Database for SQL Server 2005 Microsoft
To identify physical database requirements, select the appropriate strategy for designing database objects, and determine suitable database naming standards and change control procedures
more...
Designing a Database Server High Availability Solution for SQL Server 2005

Designing a Database Server High Availability Solution for SQL Server 2005 Microsoft
To select the appropriate database storage design for a high availability scenario and identify a suitable replication solution
more...
Designing a Database Failover Solution for SQL Server 2005

Designing a Database Failover Solution for SQL Server 2005 Microsoft
To identify the appropriate cluster configuration solution, database mirroring solution, and log shipping solution for a database
more...
Designing a Database Server Data Recovery Solution for SQL Server 2005

Designing a Database Server Data Recovery Solution for SQL Server 2005 Microsoft
To select the appropriate data backup and recovery solution for a SQL Server 2005 database
more...
Optimizing SQL Server 2005 Performance

Optimizing SQL Server 2005 Performance Microsoft
To identify ways of optimizing the performance of SQL Server 2005
more...
Optimizing a Database Data Recovery Plan for SQL Server 2005

Optimizing a Database Data Recovery Plan for SQL Server 2005 Microsoft
To identify potential causes of database failure, and select the appropriate fault tolerance and restore strategies for a scenario
more...
Monitoring and Maintaining a Database in SQL Server 2005

Monitoring and Maintaining a Database in SQL Server 2005 Microsoft
To monitor a database, automate database maintenance tasks, and configure reporting services for SQL Server 2005
more...
Managing Database Data in a SQL Server 2005 Environment

Managing Database Data in a SQL Server 2005 Environment Microsoft
To recognize how to create and deploy SSIS packages, and enforce data quality and data integrity in a SQL Server 2005 database
more...
Managing Data Between Servers and Databases

Managing Data Between Servers and Databases Microsoft
To recognize how to manage change, configure and work with linked servers, and manage and tune replication in SQL Server 2005
more...
Managing and Maintaining Database Security in SQL Server 2005

Managing and Maintaining Database Security in SQL Server 2005 Microsoft
To identify strategies for auditing database security at the server and user levels, and determine the appropriate way to protect against and respond to different types of attack on SQL Server
more...
MICROSOFT SQL SERVER 2005 DESIGNING DATABASE SOLUTIONS

MICROSOFT SQL SERVER 2005: DESIGNING DATABASE SOLUTIONS Microsoft
more...
MICROSOFT SQL SERVER 2005 DESIGNING OPTIMIZING DATA ACCESS

MICROSOFT SQL SERVER 2005: DESIGNING & OPTIMIZING DATA ACCESS Microsoft
more...
MICROSOFT SQL SERVER 2005 IMPLEMENTATION AND MAINTENANCE

MICROSOFT SQL SERVER 2005: IMPLEMENTATION AND MAINTENANCE Microsoft
more...
MICROSOFT SQL SERVER 2005 INFRASTRUCTURE DESIGN

MICROSOFT SQL SERVER 2005: INFRASTRUCTURE DESIGN Microsoft
more...
MICROSOFT SQL SERVER 2005 DATABASE MAINTENANCE

MICROSOFT SQL SERVER 2005: DATABASE MAINTENANCE Microsoft
more...
Oracle Database 11g R2 Managing Database Memory Performance

Oracle Database 11g R2: Managing Database Memory & Performance Oracle
Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which
more...
Data Management Localization Encryption in Linux

Data Management, Localization, & Encryption in Linux CompTIA CompTIA Linux Powered by LPI LX0-102 CompTIA Linux
The Linux environment is capable of supporting many simultaneous users and processes. This course will discuss the use of basic database SQL commands, the internationalization, and localization of the Linux environment, and Linux data security using GnuPG and OpenSSH. This course
more...
Querying XML Data With XPath and XQuery

Querying XML Data With XPath and XQuery
The XML Path Language, XPath, is designed to allow the developer to select specific parts of an XML document. XPath is also used extensively with the XML query language, or XQuery. This course will cover how to use these languages to both navigate and query XML data. Specific topics covered include XPath basics, XPath functions, as well XQuery built-in
more...
Backing Up Restoring Troubleshooting Essentials 2010

... within their organizations. Essentials uses databases in SQL Server to store all the data that is recorded during the management of the computers, and these databases need to be backed up to ensure this information is not lost. If there is a failure, there also needs to be a documented plan for restoring the data to have Essential back online with minimal downtime. To troubleshoot issues with
more...
Data Management Localization Encryption in Linux

Data Management, Localization & Encryption in Linux Linux Professional Institute LPI: Junior Level Linux Professional Exam 102: Junior Level Linux Professional (LPIC-1)
The Linux environment is capable of supporting many simultaneous users and processes. This course will discuss the use of basic database SQL commands, the internationalization, and localization of the Linux environment, and
more...
Using Query Notifications Synchronizing Data With VB 2008

... This course examines how to use query notifications with SQL Server and how to enable efficient, remote use of data using synchronization services. Specific topics covered include using query notifications, and SqlDependency and SqlCacheDependency. Topics also look at the various aspects of synchronizing data, including creating a synchronization services application and configuring
more...
SQL Server 2008 Installation

...SQL Server 2008: Installation Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432)
SQL Server 2008 is a comprehensive database platform, consisting of components and management tools such as SQL Server Management Studio, Business Intelligence Development studio, and the SQL Server Database Engine. These tools allow
more...
SQL Server 2008 Instance Database Configuration

...SQL Server 2008: Instance & Database Configuration Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432)
SQL Server 2008's core component is its Database Engine, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. Another feature of SQL Server 2008
more...
SQL Server 2008 Security Management

...SQL Server 2008: Security Management Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432)
Microsoft SQL Server 2008 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2008 security features, administrators can guarantee that access to a SQL Server instance is granted only to specified
more...
SQL Server 2008 Database Management

...SQL Server 2008: Database Management Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432)
Database maintenance is an ongoing task for SQL Server 2008 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files are the correct sizes, and maintenance
more...
SQL Server 2008 Data Management

...SQL Server 2008: Data Management Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432)
SQL Server 2008 provides table and index partitioning to allow data to be stored across multiple filegroups within a database. This makes tables and indexes that contain large amounts of data more manageable. Partitions in the database may need
more...
SQL Server 2008 Database Monitoring and Performance

...SQL Server 2008: Database Monitoring and Performance Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432)
To keep SQL Server 2008 databases running as efficiently as possible, administrators use a variety of performance tuning and monitoring tools. The SQL Server Profiler enables administrators to use trace files and logs to
more...
SQL Server 2008 Backups Restores and Database Snapshots

...SQL Server 2008: Backups, Restores and Database Snapshots Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432)
Enterprises use databases to store their most critical 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
more...
SQL Server 2008 High Availability and Disaster Recovery

...SQL Server 2008: High Availability and Disaster Recovery Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432)
SQL Server 2008 provides several key features that improve the availability of servers and databases so that downtime for users is minimized. These solutions include database mirroring, log shipping, replication, and
more...
SQL SERVER 2008 IMPLEMENTATION AND MAINTENANCE

SQL SERVER 2008: IMPLEMENTATION AND MAINTENANCE Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432)
more...
Creating Implementing Database Objects in SQL Server 2008

...SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433)
SQL Server 2008 is a robust database system that provides a number of database objects used to store and view data. In order to configure a SQL Server 2008 database to meet business requirements, administrators and developers must fully understand how to design, create,
more...
Creating Modifying Table Index Partitions in SQL Server 2008

...SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433)
SQL Server 2008 offers the use of partitions to manage subsets of data for large tables and indexes. Partitions can be used to improve the read/write performance on tables within a database by allowing the data within tables to be spread across multiple filegroups,
more...
Running Queries Manipulating Data in SQL Server 2008

...SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433)
SQL Server 2008 includes the SQL Server Management Studio which allows access to SQL Server databases and enables you to access database data. This data can be retrieved and modified through the use of Transact-SQL within the Query Edit window of the Management Studio
more...
Performing Advanced Query Techniques in SQL Server 2008

...SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433)
Transact-SQL offers advanced query techniques, such as built-in aggregate, scalar, and ranking functions, and common table expressions to manipulate the result set for a query. To manipulate the result sets and generate rollup information, such as totals, the CUBE,
more...
Creating Implementing Programming Objects in SQL Server 2008

...SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433)
In SQL Server 2008 you can use Transact-SQL statements to access data in the databases. Transact-SQL statements can be grouped together in a number of ways to create more complex queries when one Transact-SQL statement will not retrieve the desired results. You can group
more...
Querying Managing XML Data inSQL Server 2008

...SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433)
XML has been integrated into SQL Server 2008 so that XML data can be stored within databases using the XML data type. You can query this data using the XQuery language within the XML data type methods. SQL Server 2008 also provides support for using FOR XML to extract
more...
Using SQL Server 2008 Messaging Full-Text Search Scripts Track Changes

...SQL Server 2008 Messaging, Full-Text Search, Scripts & Track Changes Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433)
SQL Server 2008 provides many components to ensure that database developers can perform many tasks within the database without having to create custom applications. SQL Server's Service Broker component allows
more...
Gathering Performance Data in SQL Server 2008

...SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433)
In order to keep SQL Server 2008 running as efficiently as possible, SQL Server 2008 provides a variety of performance tuning and optimization utilities. Among these utilities are the SQL Server Profiler and the Database Engine Tuning Advisor. The SQL Server Profiler
more...
SQL SERVER 2008 DATABASE DEVELOPMENT

SQL SERVER 2008: DATABASE DEVELOPMENT Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433)
more...
Implementing SQL Server 2008 Integration Services

...SQL Server 2008 Integration Services Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448)
Microsoft SQL Server 2008 offers a combination of powerful Business Intelligence services to help clients develop and manage sophisticated business intelligence solutions. With the Database Engine at its core, SQL Server
more...
Configuring SQL Server 2008 Integration Services Package

...SQL Server 2008 Integration Services Package Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448)
This course explores the various components that make up an SSIS package. This includes elements of package control flow, such as containers used to provide the structure in packages, the actual tasks that provide
more...
Deploying SQL Server 2008 Integration Services Package

...SQL Server 2008 Integration Services Package Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448)
This course discusses the deployment and execution of SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server. This course gives an overview
more...
Implementing SQL Server 2008 Reporting Services Solutions

...SQL Server 2008 Reporting Services Solutions Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448)
SQL Server 2008 Reporting Services provides powerful and flexible solutions for enterprise reporting needs. This course introduces the reporting services functionality, tools, installation, and enhancements
more...
Deploying Delivering SQL Server 2008 Reporting Services Reports

...SQL Server 2008 Reporting Services Reports Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448)
This course discusses features and tasks performed by administrators when working with SQL Server 2008 Reporting Services (SSRS) reports and content. After reports have been created and formatted, it is time to make
more...
Maintaining SQL Server 2008 Reporting Services

...SQL Server 2008 Reporting Services Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448)
Administration and maintenance of Microsoft SQL Server 2008 Reporting Services and its components is key in providing customers and clients access to the Business Intelligence information they need. This course outlines the
more...
Implementing SQL Server 2008 Analysis Services Solutions

...SQL Server 2008 Analysis Services Solutions Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448)
SQL Server 2008 Analysis Services gives you the opportunity to take the vast amount of information in your databases and analyze it so that you can use the information to improve your overall business. This course
more...
Querying Cubes Working with Data Mining in SSAS

... SSAS Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448)
SQL Server 2008 Analysis Services takes relational data and provides a robust way to analyze it in a meaningful way through MDX queries and data mining. This course will introduce the fundamentals of querying multi-dimensional data. It will introduce
more...
Managing SQL Server 2008 Analysis Services Solutions

...SQL Server 2008 Analysis Services Solutions Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448)
SQL Server 2008 Analysis Services provides a powerful solution for analyzing extremely large amounts of data in a relational database. This course looks at Analysis Services from a management perspective. It
more...
Managing SSIS Packages in SQL Server 2008

...SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448)
This course discusses managing SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server and then managed by administrator and users. This course gives an overview of the
more...
SQL SERVER 2008 BUSINESS INTELLIGENCE DEVELOPMENT MAINTENANCE

SQL SERVER 2008: BUSINESS INTELLIGENCE DEVELOPMENT & MAINTENANCE Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448)
more...
Oracle Database 11g Architecture SQL Tuning Optimization

Oracle Database 11g: Architecture, SQL Tuning & Optimization Oracle
The Oracle Database server consists of an Oracle Database and one or more Oracle Database instances. SQL (Structured Query Language) is the language with which all programs and users access an Oracle Database. Monitoring the performance of and tuning database components, as well as the SQL statements used to access and
more...
Oracle Database 11g Application Tracing Automatic SQL Tuning

Oracle Database 11g: Application Tracing & Automatic SQL Tuning Oracle
Oracle Database implements tracing by generating a trace file for each server process when you enable the tracing mechanism. This course explores configuring the SQL Trace facility to collect session statistics, using the TRCSESS utility to consolidate SQL trace files, formatting trace files using the tkprof utility, and
more...
Oracle Database 11g R2 ASM Storage Partitioning Enhancements

Oracle Database 11g R2: ASM, Storage & Partitioning Enhancements Oracle
Oracle Database 11g Release 2 provides many improvements from its previous releases. This includes enhancements to ASM and storage to improve performance and to reduce server maintenance down time. This course identifies the enhancements in each of these areas. It also demonstrates how to use ASM fast mirror resync,
more...
From Online Training Directory
Administering Microsoft ® SQL Server 2000 (SQL)



...ills required to install, manage and administer Microsoft SQL Server 2000 (SQL) databases.
This course is design to help students master the concept of administering Microsoft? SQL Server 2000 (SQL) databases effectively. When a student completes this course he/she will be able to plan and complete a successful installation or upgrade, configure and tune SQL Server 2000 databases, manage users
more...
Administering Microsoft ® SQL Server 2000 (SQL)
SQL Server 2000 Implementing and Designing Databases
This course teaches you to design, implement, administer and troubleshoot information systems that incorporate Microsoft SQL Server 2000.
This course prepares you to design and implement database solutions by using Microsoft SQL Server 2000.
This course covers subjects such as: Developing a Logical Data Model, Implementing the Physical Database, Retrieving and Modifying Data, Programming
more...
SQL Server 2000 Administration
This course will teach techniques for installing, configuring, and administering SQL Server 2000.
This course is designed to teach the student all the necessary knowledge to successfully pass the Microsoft exam 70-228 required for MCDBA. (Installing, Configuring, and Administering Microsoft SQL Server 2000.) This indepth course covers all necessary materials to accomplish outcomes listed below.
more...
SQL Server 2000 Data Warehousing
This course will teach you the knowledge and skills necessary to design a data warehouse and to populate data marts by using Data Transformation Services (DTS) in Micorsoft SQL Server 2000
This course will teach you the ins and outs of in Micorsoft SQL Server 2000 by providing the knowledge and skills necessary to understand the underlying design and principles of a data warehouse.
You will
more...
SQL Server 2000 - XML-Enabled Applications Using SQL 2000
This course is designed to teach students the basics of SQL and XML in building and combining applications where database functions are required
This course will give students a good understanding of how to use SQL 2000 in building and integrating applications that use or require a database and are enabled with XML. Course includes a primer for SQL and XML calls for SQL. Course also covers using
more...
SQL Server 2000 Complete Course
...SQL Server 2000 Administration, SQL Server 2000 Desing and Implementation, Datawarehousing and XML Enabled Applications using SQL 2000.
This course teaches you to administer and troubleshoot information systems that incorporate the SQL Server 2000 Enterprise Edition. Learn how to install and configure a SQL 2000 Server, plan, design, and create SQL 2000 databases, manage, monitor and
more...
From 123-CBT Computer Based Training
Project Server 2003 Installation and Configuration
To install and configure IIS 6.0, SQL Server, and SharePoint for Project Server 2003
more...
Project Server 2003 Installation and Configuration
Small Business Server 2000
To provide an overview of Microsoft Small Business Server (SBS) 2000 and its main features, such as its management consoles and monitoring tools, and to show how Microsoft Exchange 2000, ISA Server 2000, and Microsoft SQL Server 2000 integrate with SBS 2000
more...
Dreamweaver MX Web Applications
...ating Queries How Queries are Created Creating Indexes MS SQL Server 2000 Upsizing to MS SQL 2000 What are Stored Procedures What are Views SQL What is SQL Select Statements Using Where & Order By Retrieving Data Using LIKE Connecting to Databases Web & Application Servers Types of Application Servers Installing Personal Web Server Configuring PWS Configuring IIS Interfacing with Databases
more...
Installing Configuring and Upgrading SQL Server 2000
To describe how to install, configure, and upgrade SQL Server
more...
Transferring and Transforming Data in SQL Server 2000
To enable students to extract and transform data in SQL Server 2000
more...
Security in a Microsoft SQL Server 2000 Environment
To explain how to plan and implement security on a SQL 2000 database
more...
Managing SQL Server 2000 Databases
To guide students in configuring, performing, and automating routine administrative tasks
more...
Restoring SQL Server 2000 Databases
To describe the process involved in restoring SQL Server databases
more...
Monitoring SQL Server 2000 Performance
To explain how to monitor SQL Server for optimal performance
more...
SQL Server 2000 XML and the Web
To outline the relationship between SQL Server 2000, XML, and the Web
more...
Transferring and Transforming Data in SQL Server 2000
To enable students to extract and transform data in SQL Server 2000
more...
SQL Server 2000 XML and the Web
To outline the relationship between SQL Server 2000, XML, and the Web
more...
Designing and Implementing Security in SQL Server 2000
To use programming logic to implement security and describe the different levels of security
more...
The SQL Server 2000 Logical Data Model
To describe SQL Server data entities and their normalization
more...
Using T-SQL in SQL Server 2000
To discuss Transact-SQL and its elements and view and define data using Transact-SQL statements
more...
SQL Server 2000 Programming Business Logic
To demonstrate how to implement views, stored procedures, triggers and user-defined functions as means for programming business logic
more...
SQL Server 2000 Transactions and Distributed Data
To demonstrate how to utilize transactions and distributed data
more...
Analyzing and Optimizing SQL Server 2000 Queries
To show how to analyze and optimize queries
more...
Visual InterDev 6 0 Active Server Pages and Data Access

...d in the login authentication process for connecting to a SQL Server database.
Add the connection information for connecting to a SQL Server database.
Add a data connection to a project.
Identify the features of a data command.
Match the Query Designer panes with their functions.
Add a data command to the data environment.
Identify the data display and data manipulation controls.
more...
Visual InterDev 6 0 Accessing Remote Data

...ta from a database by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
Add a record to a database table by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
Update a record from a database table by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
Delete a record from a database table by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
Create a stored procedure to retrieve
more...
SQL Server 7 0 Designing Implementing Data Warehouses Curriculum

...esigning and Implementing Data Warehouses Using Microsoft SQL Server 7.0 Curriculum consists of the following courses: MS SQL Server 7.0: Designing and Implementing Data Warehouses - Part 1 MS SQL Server 7.0: Designing and Implementing Data Warehouses - Part 2 MS SQL Server 7.0: Designing and Implementing Data Warehouses - Part 3 MS SQL Server 7.0: Designing and Implementing Data
more...
Oracle Workflow 11i10 Components Planning Workflow Processes

This course covers the benefits of using Oracle Workflow in an e-business environment. It provides an overview of the architecture and components of Oracle Workflow. It also covers the components of a workflow process. Further, it covers the steps to plan a workflow process. It also covers various standard activities.
Learn To:
Identify benefits of Oracle Workflow.
Identify
more...
Introduction to Data Warehousing

Course Overview
This course presents an introduction to Data Warehousing. Beginning with the basic concepts of data warehousing, this course helps you understand the processes involved in and the architecture of data warehousing. The tools involved in analyzing the warehouse data will also be covered. Finally, you'll learn about the Oracle data warehouse.
L earn To:
Identify the
more...
Oracle SQL Specifics Retrieving and Formatting Data

Course Overview
This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands, functions, and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will
more...
Oracle SQL Tuning Tuning SQL and the Optimizer

Course Overview
This course is the second in a two-part series on SQL Statement Tuning. This course will help application developers to design SQL statements that can reuse parsing and influence the optimizer to improve performance.
L earn To:
Identify the factors that affect network traffic.
Identify the factors that affect parsing.
Identify the guidelines for the reuse
more...
Oracle Form Builder Including Reusable Oracle Components

Course Overview
This course is the sixth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants learn how to implement methods to use data sources, and to integrate charts, reports and timers in Forms. In addition, reusing components, objects and code will be taught. Finally, Form Builder's new features will be covered.
more...
Oracle8 Database Administration - Manage an Instance

Course Overview
This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support.
L earn To:
more...
Oracle8 Database Administration - Manage Storage Structures

Course Overview
This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes.
L earn To:
more...
Oracle8 Performance Tuning Managing Memory and Disk I O

Course Overview
This course is the second in a three-part Oracle8 Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log
more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention

Course Overview
This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student
more...
Oracle Form Builder R6 Including Reusable Oracle Components

Course Overview This course is the sixth in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course will enable learners to implement methods to use additional data sources, to work with Oracle8 objects, and to integrate charts, reports, and timers in form modules. In addition, the course covers the procedures to reuse components, objects, and code and to
more...
Oracle Reports R6 Control Reports

Course Overview This course is the third in a three-part Oracle Reports series that is based on Oracle Reports Release 6. This course introduces the learner to features of Oracle Reports that can be used to control report output. This course covers developing templates, creating and using parameters, coding PL/SQL triggers, exporing built-in package procedures, using the Reports Server, and
more...
SQL Server 7 0 System Administration - Part 5

...install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
L earn To:
Identify the methods and attributes of SQL Server 7.0 replication.
Identify and apply techniques for planning and setting up SQL Server 7.0 replication.
Identify the procedures for replication maintenance.
C ontent Emphasis
Skills-Based
A udience
This course is
more...
SQL Server 7 0 - Implementing a Database - Part 1

...wledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Identify the components of SQL Server 7.0. Identify the characteristics of Transact-SQL and its processing. Perform the skills to construct and manage databases. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a
more...
SQL Server 7 0 - Implementing a Database - Part 2

...wledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Implement data integrity. Create and maintain indexes. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0:
more...
SQL Server 7 0 System Administration - Part 1

...install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
L earn To:
Identify the main components of the SQL Server.
Understand the properties of SQL Server Architecture, including the underlying technical details.
Understand the components of SQL Server installation, including hardware and software requirements, types of installations, and installation
more...
SQL Server 7 0 System Administration Curriculum

...SQL Server 7.0 System Administration Curriculum consists of the following courses:
SQL Server 7.0 System Administration - Part 1
SQL Server 7.0 System Administration - Part 2
SQL Server 7.0 System Administration - Part 3
SQL Server 7.0 System Administration - Part 4
SQL Server 7.0 System Administration - Part 5
To review individual course descriptions, please return to the
more...
SQL Server 7 0 System Administration - Part 2

...install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
L earn To:
Work with Microsoft SQL Server is and Work with Microsoft SQL Server 7.0, its architecture, security, and database structure.
Understand the basics of SQL Server databases and how to create databases and other objects.
Modify databases; manage data on multiple disks; assess database size
more...
SQL Server 7 0 System Administration - Part 3

...install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
L earn To:
Identify the concepts, interfaces and fixed roles involved in performing backups.
Gain a working knowledge of database, transaction log and filegroup backups and perform these backups as a system administrator.
Restore damaged or incomplete databases.
C ontent Emphasis
more...
SQL Server 7 0 System Administration - Part 4

...install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
L earn To:
Automate SQL Server 7.0 administrative tasks.
Identify and use the SQL Server 7.0 tools for transferring and transforming data.
Identify and use the tools for monitoring and maintaining SQL Server 7.0.
C ontent Emphasis
Skills-Based
A udience
This course is designed
more...
SQL Server 7 0 - Implementing a Database - Part 3

...knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Query multiple tables using Transact-SQL statements. Retrieve and modify data using advanced query techniques. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 7.0.
more...
SQL Server 7 0 - Implementing a Database - Part 4

...wledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Generate summary value and summary data as well as generate control break reports using aggregate functions. Define transactions and set transaction isolation levels. Identify the purpose and benefits of using views. C ontent Emphasis Skills-Based A udience This course is designed
more...
SQL Server 7 0 - Implementing a Database - Part 5

...knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Access data by using the Stored Procedure model. Access data using triggers. Set up a distributed environment to access, modify and manage remote data. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database
more...
Visual InterDev 6 0 Accessing Remote Data

Course Overview
This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to work with database records and identify the methods of managing recordset size; identify the components of
more...
Visual C 6 0 Designing Implementing Distributed Applications - Part 3

...s Duration: 3 - 4 Hour(s) Identify the features of SQL Server 7.0. Identify the features of physical database architecture components. Modify the properties of a database by using Enterprise Manager. Create a table by using Enterprise Manager. Create an index by using Enterprise Manager. Create a relationship between two tables to enforce referential integrity. Import data from an
more...
SQL Server 7 0 Designing Implementing Data Warehouses - Part 1

...Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the characteristics of different decision support systems and components and tools used in data warehousing; identify the different techniques for gathering data; identify the basic requirements of the data warehouse; and identify the guidelines for
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2

...Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models; identify the Data Transformation Services (DTS) components and the components of the DTS object model; identify the methods of distributing data; and
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3

...Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to create a data warehouse database; perform the steps necessary to build and manage replication by using the Enterprise Manager; build a dimension and assign its member properties; build an aggregation and identify the guidelines for optimizing aggregation
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4

...Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data access from multidimensional data structures; identify the features and functionality of Pivot Table Service, Local Cubes, Client/Server Cache;
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 5

...Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the features of the components of Microsoft Repository; perform the tasks related to managing a Microsoft SQL Server 7.0 data warehouse; and perform the tasks related to database maintenance in Microsoft SQL Server 7.0. L earn To: Identify the
more...
SQL Server 7 0 Database Design Curriculum

...SQL Server 7.0 Database Design Curriculum consists of the following courses: SQL Server 7.0 Implementing a Database - Part 1 SQL Server 7.0 Implementing a Database - Part 2 SQL Server 7.0 Implementing a Database - Part 3 SQL Server 7.0 Implementing a Database - Part 4 SQL Server 7.0 Implementing a Database - Part 5 To review individual course descriptions, please return to the
more...
SQL and PL SQL PL SQL Basics

Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.
more...
SQL and PL SQL Basic SELECT

Course Overview This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic
more...
Oracle8i Database Admin Manage Storage Structures

Course Overview This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes. L earn To: Identify
more...
Oracle8i Performance Tuning Architecture Strategy

Course Overview This course is the first in a three-part Oracle8i Performance Tuning series. This interactive course will introduce participants to tools and techniques used to improve the performance of the Oracle8i server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally,
more...
Oracle8i Performance Tuning Managing Memory Disk I O

Course Overview This course is the second in a three-part Oracle8i Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log
more...
Oracle 11i 2 6 Implement Workflow Fundamentals Part 1

The course deals with fundamentals of Oracle Workflow 2.6, which is provided by Oracle E-Business Suite for Oracle Application 11i. Oracle Workflow enables you to create, modify and automate business processes.
Learn To:
Identify features of Workflow-driven business processes.
Identify features of business processes integration using Oracle Workflow.
Match Oracle Workflow
more...
Oracle Database 10g Administration Workshop II Part 1

This course will teach learners to configure an Oracle database for multilingual applications and distributed database access. Students will also practice various methods of recovering the database, using RMAN, SQL, and Flashback technology.
Learn To:
Match goals of Oracle Database 10g manageability features with the methods of achieving them.
Identify features of the Oracle
more...
Oracle Database 10g New Features for Administrators Part 2

Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as automatic management, manageability infrastructure, and application tuning and monitoring.
Learn To:
Identify features of Automatic Database Diagnostic Monitor
more...
Oracle Database 10g New Features for Administrators Part 4

Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as flash backup and recovery.
Learn To:
Identify features of the flash backup and recovery strategy.
Identify tasks that you perform when using the flash
more...
Oracle Database 10g New Features for Administrators Part 5

Oracle Database 10g is designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. Oracle Database 10g supports the Oracle vision of creating a self-aware, self-learning, and completely self-managing database. This course covers new features of Oracle Database 10g such as automatic storage management, upgrade methods, RMAN backup, flash
more...
Oracle PL SQL Procedures Functions Packages

61114 Course Overview This course is the second in a series of three titles. It introduces the learner to the basics of PL/SQL subprograms. This course covers the building and invoking of procedures and functions. Additionally, this course introduces the basics of creating and using packages. L earn To: Identify the types and components of a subprogram. Create a subprogram. Create
more...
Oracle PL SQL Database Programming

Course Overview This course is the third in a series of three titles, and discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored
more...
IBM DB2 Universal Database V6 1--Fundamentals

Course Overview 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
more...
IBM DB2 Universal Database V6 1--Fundamentals

Course Overview 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
more...
Oracle SQL for End Users--Part 1

Course Overview Oracle SQL and SQL*Plus are powerful components of Oracle's relational and object relational database management systems. This course is designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties, introduces the Oracle server, and indicates how SQL and SQL*Plus are used in the
more...
SQL Server 2000 Database Administration Curriculum

...SQL Server 2000 Database Administration Curriculum includes the following courses: MS SQL Server 2000: Database Admin. Part 1(Install. SQL Server 2000) MS SQL Server 2000: Database Admin. Part 2(Managing Databases) MS SQL Server 2000: Database Admin. Part 3(Security & Data Recovery) MS SQL Server 2000: Database Admin. Part 4(Managing Data) MS SQL Server 2000: Database Admin. Part
more...
SQL Server 2000 Database Admin Part 1 Install SQL Server 2000

...al 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 hardware requirements for SQL Server 2000. Identify the typical hardware optimization
more...
SQL Server 2000 Database Admin Part 2 Manag Databases

...ll 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 information by using SQL Server Enterprise Manager. Match the different
more...
SQL Server 2000 Database Admin Part 3 Security Data Recovery

...ies 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 guidelines for preventing data loss. Match database recovery
more...
SQL Server 2000 Database Admin Part 4 Managing Data

...ntify 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 distributed data. Identify the different methods of distributing data. Identify the features of the publisher-subscriber metaphor. Identify the
more...
SQL Server 2000 Database Admin Part 5 Maint SQL Server 2000

...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. Identify guidelines for performance tuning. Identify the
more...
SQL Server 2000 Designing Implementing Databases Curriculum

...SQL Server 2000 Designing & Implementing Database Curriculum includes the following courses: MS SQL Server 2000: Design & Implement Databases Part 1(Intro. to SQL Server) MS SQL Server 2000: Design & Implement Databases Part 2 (Managing Data) MS SQL Server 2000: Design & Implement Databases Part 3(Managing Objects) MS SQL Server 2000: Design & Implement Databases Part 4(Managing Indexes)
more...
SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server

... and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases. Learn To Identify the features and functions of SQL Server 2000. Match the components of the client-server communication process with their features. Identify the features and functions of SQL Server 2000 services. Match the basic types of statements used in
more...
SQL Server 2000 Design Implement Databases Part 2 Managing Data

...ive part series that will teach students how to work with SQL Server data. Learn To Identify the SQL Server 2000 system-supplied data types. Add a user defined data type. Match the parts of a data row with their features. Identify characteristics of entity modeling. Identify features of attributes. Identify requirements for logical modeling. Identify the login authentication modes
more...
SQL Server 2000 Design Implement Databases Part 3 Managing Objects

...ive part series that will teach students how to work with SQL Server data objects. Students will learn how to create and manage view, stored procedures, user-defined functions, and triggers. Learn To Identify the features of views. Identify the considerations for creating views. Create a view by using Transact-SQL. Match the different user-defined functions with their characteristics.
more...
SQL Server 2000 Design Implement Databases Part 4 Managing Indexes

...ive part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries. Learn To Identify the features of clustered indexes. Identify the features of nonclustered indexes. Retrieve information from the sysindexes
more...
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks

...l course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking. Learn To: o Identify guidelines for
more...
SQL Server 2000 Querying with Transact SQL Curriculum

The MS SQL Server 2000 Querying with Transact SQL Curriculum includes the following courses: MS SQL Server 2000: Querying with Transact SQL Part 1(Manipulating Data) MS SQL Server 2000: Querying with Transact SQL Part 2(Working with Queries) To review individual course descriptions, please return to the previous page and select the desired title(s).
more...
SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data

...e in medium to very large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. The general categories include: system administrators, database administrators, application developers, system analysts, and software engineers. Students are expected
more...
SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries

...e in medium to very large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. The general categories include: system administrators, database administrators, application developers, system analysts, and software engineers. Students are expected
more...
CIW E-Commerce Designer Part 4 Site Implementation

...le8 package. Identify the main capabilities of Microsoft SQL Server. Audience Candidates for this exam design and implement commerce-driven Web sites, identify customer needs, monitor customer usage patterns, determine order processes and service after sales, and consider how e-business solutions can increase sales. Candidates include system administrators, application developers, and
more...
MCDBA Curriculum Version II

The Complete MCDBA Curriculum includes the following curriculums: Microsoft Windows 2000 Administration Curriculum (ID#7578) Microsoft Windows 2000 Installation, Configuration & Admin. Curriculum (ID#7586) Microsoft SQL Server 2000: Database Administration Curriculum (ID#7895) Microsoft SQL Server 2000: Designing & Implementing Databases Curriculum (ID#7901) MS Win 2000 Network
more...
BizTalk Server 2000 Curriculum

Course Overview This curriculum introduces the learner to the context of BizTalk operations, identifying the main challenges of EAI and B2B communications. This curriculum covers creating maps using BizTalk Mapper, creating objects in and managing BizTalk Messaging Manager, and the submission of documents to BizTalk Server. Additionally, it covers the tracking of interchanges and business
more...
BizTalk Server 2000 Part 1 Intro to BizTalk Server 2000

...t Internet Information Services (IIS), ASP, and Microsoft SQL Server 2000 Enterprise Edition. Content Emphasis Skills-Based Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 74310 Objectives Unit 1: BizTalk Server 2000 Overview 1 -
more...
BizTalk Server 2000 Part 2 Documents Mapping Managing Submitting

...t Internet Information Services (IIS), ASP, and Microsoft SQL Server 2000 Enterprise Edition. Content Emphasis Skills-Based Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 74311 Objectives Unit 1: BizTalk Mapper 2 - 3 hours
more...
BizTalk Server 2000 Part 3 Monitoring Orchestration

...t Internet Information Services (IIS), ASP, and Microsoft SQL Server Enterprise Edition. Content Emphasis Conceptual Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 74312 Objectives Unit 1: BizTalk Orchestration Designer 3 - 4
more...
BizTalk Server 2000 Part 4 Components Solutions Troubleshooting

...t Internet Information Services (IIS), ASP, and Microsoft SQL Server 2000 Enterprise Edition. Content Emphasis Skills-Based Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 74313 Objectives Unit 1: BizTalk Components 2 - 3 hours
more...
BizTalk Server 2000 Part 5 Secruity Optimization

...o Identify Microsoft Windows 2000 and Microsoft SQL Server 2000 security features that are used by Microsoft BizTalk Server 2000. Identify the tasks that can be performed by the BizTalk Server Administrators group and by the Windows 2000 Administrators group. Identify features of logon properties and service accounts in the Microsoft BizTalk Server 2000 environment.
more...
Oracle9i SQL Basic SELECT Statements

This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. Learn To: o Identify the components of the relational
more...
Oracle9i SQL DML and DDL

The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.
more...
Oracle9i Database Admin Perform Database Backups

Course Overview This course introduces students to backup methods for Oracle9i database administration. The backup concepts covered by this course include backup strategies and requirements, Oracle Architecture, archiving data, backup methods, and working with a standby database. Students perform backup procedures using operating system utilities, Oracle9i utilities such as RMAN, standard
more...
Oracle9i Database Admin Set Up Oracle Net Services

Course Overview This course covers the architecture and configuration of Oracle Net Services. It details client-server and web implementations, in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This course also discusses the configuration of the Oracle Shared Server and Oracle Names Server. Learn To
more...
WebSphere MQ Integration Message Broker

The purpose of this course is to provide learners with a general overview of the WebSphere Business Integration Message Broker product. The course introduces the business and technical reasons for a message broker, and the main features of WebSphere Business Integration Message Broker are then outlined. Students are given a basic understanding of how the product works and what tasks can be done
more...
Office XP - Planning Collaborative Solutions Curriculum

The Microsoft Office XP - Planning Collaborative Solutions Curriculum presents the learner with a comprehensive introduction to SharePoint Team Services and the principal technologies within Office XP that facilitate sharing of line-of-business data. The curriculum begins with an introduction to SharePoint Team Services and Team Services site architecture. It covers administrative issues and user
more...
Office XP Collaborative Solutions Part 1

... Portal Server, Microsoft Exchange 2000 Server, Microsoft SQL Server 2000, or Microsoft BizTalk. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits CEU credits: 0.70 CEUs Language Options American English Total Learning Time 6 to 8 hours 74101 Objectives Unit 1: SharePoint Team Services 3 - 4 hours o Identify
more...
Office XP Collaborative Solutions Part 2

... Portal Server, Microsoft Exchange 2000 Server, Microsoft SQL Server 2000, or Microsoft BizTalk. In addition, learners should have taken the first part of this series 74101. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits CEU credits: 0.70 CEUs Language Options American English Total Learning Time 6 to 8 hours
more...
Oracle 9i New Features Database Administration

This course introduces learners to the Oracle9i enhancements in server-side manageability, Oracle Enterprise Manager, and globalization. Learn To Identify memory and space management improvements. Describe segment and index management improvements. Identify improvements in database operations and performance.
more...
Commerce Server 2000 Design Implementation Curriculum

The Commerce Server 2002 provides users with the skills necessary for user profiling, catalog management and advanced online business analytics including installation, administration tools, site packaging, and Commerce Server Manager. This curriculum consists of five Skill Builder courses. Course 74116 MS Commerce Server 2000: Design and Imp. Part 1 - Intro, 74117 MS Commerce Server 2000: Design
more...
Commerce Server 2000 Design Impl Part 1 Intro

...hnologies (Internet Information services (IIS), Microsoft SQL Server (tm)) and COM+. Suggest knowledge of Web development, databases, datawarehousing, VB, COM and e-commerce concepts. This course prepares learners for exam 70-234. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English Total
more...
Commerce Server 2000 Design Impl Part 2 Users Objects Catalogs

...hnologies (Internet Information services (IIS), Microsoft SQL Server (tm)) and COM+. Suggest knowledge of Web development, databases, datawarehousing, VB, COM and e-commerce concepts. This course prepares learners for exam 70-234. In addition, learners should have taken the first part of this series 74116. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation
more...
Commerce Server 2000 Design Impl Part 3 Pipelines

...hnologies (Internet Information services (IIS), Microsoft SQL Server (tm)) and COM+. Suggest knowledge of Web development, databases, datawarehousing, VB, COM and e-commerce concepts. This course prepares learners for exam 70-234. In addition, learners should have taken the first two parts of this series 74116 and 74117. Deployment Options Accreditation NASBA credits: 4 CPE Credits
more...
Systems Analysis Using Client Server Model Part 1 Client Server Env

This is the first course in a three part series that presents the students with instruction in the subject of fundamental client server concepts. This course will cover client server computing fundamentals, client server environment, development in the client server environment, and migrating to client server environment. Learn To: o Identify factors responsible for changes in the business
more...
Visual Basic NET-Web Based Development Part 3

... of the ADO.NET object model. o To identify features of SQL Server security authentication. o To mtch connection string parameters with their functions. o To identify characteristics of a DataAdapter. Audience This course is designed for beginning Web developers and Microsoft Visual Basic developers who want to learn Visual Studio .NET and ASP.NET. Beginner Web developers have minimal
more...
Visual Basic NET-Web Based Development Part 3

... of the ADO.NET object model. o To identify features of SQL Server security authentication. o To mtch connection string parameters with their functions. o To identify characteristics of a DataAdapter. Audience This course is designed for beginning Web developers and Microsoft Visual Basic developers who want to learn Visual Studio .NET and ASP.NET. Beginner Web developers have minimal
more...
MCSE Windows 2000 Electives Curriculum

The MCSE Windows 2000 Electives Curriculum includes the following: MS Windows 2000: Migrating from MS Windows NT 4.0 Curriculum (ID#7556) Installing, Configuring & Administering Microsoft Exchange 2000 Server Curriculum (ID#7732) Microsoft ISA Server 2000 Curriculum (ID#8041) MS SQL Server 2000 Database Administration Curriculum (ID#7895) To review individual descriptions, please select
more...
Windows 2000 Implementing Security Part 2

...curity methods. To match SQL Server roles with their descriptions. To identify security features of Exchange 2000 Server. To sort the benefits of NTFS file system and FAT. To identify guidelines for protecting a private network from a virus.
more...
Windows 2000 Implementing Security Part 2

...curity methods. To match SQL Server roles with their descriptions. To identify security features of Exchange 2000 Server. To sort the benefits of NTFS file system and FAT. To identify guidelines for protecting a private network from a virus.
more...
Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3

...jects to access and manipulate data sources. Understand SQL Server security implementations. Implement an appropriate cursor for a recordset object. C ontent Emphasis Skills-Based A udience This course is designed for programmers who need to create basic applications with Microsoft Visual Basic 6.0. Participants should have completed the first two courses in this series. T
more...
Visual Basic 6 0 Designing Implementing Distributed Applications - Part 2

...d deploy packages in MTS. Implement security in MTS and SQL Server. C ontent Emphasis Skills-Based A udience This course is designed for programmers using Visual Basic 6.0 and are currently building desktop applications and accessing corporate databases. Participants should have completed the first course in this series. T otal Learning Time 6 - 8 Hour(s) Course
more...
Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3

...rver solutions. L earn To: Identify features of SQL Server and select the data integrity to implement in a given situation. Use the ActiveX Data Object (ADO) types for establishing a connection, executing a command, navigating recordsets, modifying data and executing stored procedures. C ontent Emphasis Skills-Based A udience This course is designed for programmers
more...
Visual C 6 0 Designing Implementing Desktop Applications - Part 1

...source editors of Visual C++ 6.0. Install and configure SQL Server and Microsoft Message Queue Server (MSMQ). Describe two-tier and three-tier applications. Identify the element of Microsoft Transaction Server (MTS) environment and the steps to configure a client to use an MTS component. Install and configure Visual SourceSafe (VSS) and establish the source-code control environment.
more...
Oracle8 Database Administration - Manage Data

Course Overview
This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data.
L
more...
Oracle8 Database Administration - Manage Security

Course Overview
This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and tasks associated with managing security.
L earn To:
Define and maintain the security domains for users in a given environment.
Define and maintain a named set of
more...
Oracle8 Backup and Recovery - Strategies and Backups

Course Overview
This is the first course in a two-part series that will introduce participants to the critical task of planning and implementing database backup strategies. In this course, users will be introduced to backup concepts and the Oracle architecture. They will learn how to change the archive mode of a database and configure a database for archive processing. Additionally, users will
more...
Oracle8 Backup and Recovery - Troubleshooting and Recovery

Course Overview
This course is the second course in a two-part series that introduces participants to the critical task of planning and implementing database recovery strategies. This course will identify ways of handling different types of failures, diagnosing errors and detecting corruption. Additionally, users will be introduced to the different types of Oracle recovery methods and how to
more...
Oracle8i Database Admin Manage an Instance

Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:
more...
IBM DB2 Universal Database V6 1--Fundamentals

Course Overview 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
more...
IBM DB2 Universal Database V6 1--Fundamentals

Course Overview 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
more...
CIW Dynamic Server Pages Part 1

Course Overview This is the first course in a three part series that introduces students to PHP Hypertext Processor and provides the foundational knowledge for the course series. Additionally, this course will cover an introduction to PHP, PHP fundamentals, string manipulation and file input/output, and PHP and databases. Learn To Identify PHP. Identify the basic and
more...
CIW Dynamic Server Pages Part 3

Course Overview This is the final course in a three part series that students will learn about ActiveX Data Objects, error handling and dubugging ASP applications, project management in application development, and data integrity and security issues. Learn To Identify the situations in which ADO would be used. Identify ASP application development, error handling, and
more...
WebSphere MQ Integration Message Broker

The purpose of this course is to provide learners with a general overview of the WebSphere Business Integration Message Broker product. The course introduces the business and technical reasons for a message broker, and the main features of WebSphere Business Integration Message Broker are then outlined. Students are given a basic understanding of how the product works and what tasks can be done
more...
Commerce Server 2000 Design Impl Part 4 Ad Campaigns Websites

...hnologies (Internet Information services (IIS), Microsoft SQL Server (tm)) and COM+. Suggest knowledge of Web development, databases, datawarehousing, VB, COM and e-commerce concepts. This course prepares learners for exam 70-234. In addition, learners should have taken the first three parts of this series 74116 thru 74118. Deployment Options Internet / Intranet, Download, LAN, Workstation
more...
Commerce Server 2000 Design Impl Part 5 Infra Sec Admin

...00 support servers with their descriptions. o Configure SQL Server to use mixed mode for authentication. o Create a new SQL Server login account. o Create a new SQL Server data source to store user profile information. o Identify guidelines for monitoring performance. o Identify functions of SQL Profiler. o Start the Predictor resource by using Commerce Server Manager. Audience
more...
Microsoft NET Tech Overview Part 1 NET Platform Framework

...tion Center Internet Security and Acceleration Server and SQL Server) as well as development tools and technologies (XML, ASP.NET, Visual Studio.NET, and SOAP). Other areas such as Universal Description, Discovery, and Integration (UDDI) and the .NET user experiences are also addressed at a high level. This course introduces the learner to the context of the .NET technology initiative, placing
more...
Microsoft NET Tech Overview Part 1 NET Platform Framework

...tion Center Internet Security and Acceleration Server and SQL Server) as well as development tools and technologies (XML, ASP.NET, Visual Studio.NET, and SOAP). Other areas such as Universal Description, Discovery, and Integration (UDDI) and the .NET user experiences are also addressed at a high level. This course introduces the learner to the context of the .NET technology initiative, placing
more...
Microsoft NET Tech Overview Part 2 NET Server Infrastructure Services

...nter 2000, Commerce Server 2000, Host Integration Server, SQL Server 2000, Exchange Server 2000, ISA Server 2000, Mobile Information 2001 Server. It then covers each of the chief products of the .NET initiative and each of the chief services. The course concludes with security and standards, third party services and the benefits of the .NET initiative. Learn To: o Identify features of the
more...
Microsoft NET Tech Overview Part 2 NET Server Infrastructure Services

...nter 2000, Commerce Server 2000, Host Integration Server, SQL Server 2000, Exchange Server 2000, ISA Server 2000, Mobile Information 2001 Server. It then covers each of the chief products of the .NET initiative and each of the chief services. The course concludes with security and standards, third party services and the benefits of the .NET initiative. Learn To: o Identify features of the
more...
MS Project Server 2003 Introduction Part 1

... Solution.
Create a Windows user account.
Create a SQL Server 2000 account.
Identify the steps to create a SQL Server 2000 login using Enterprise Manager.
Audience:
This course is intended for IT professionals and network administrators who are responsible for configuring and managing an organization's enterprise project management solution. They have one to three years of
more...
MS Project Server 2003 Introduction Part 2

...cross the organization.
Learn To:
Configure SQL Server authentication for Microsoft Office Project Server 2003.
Identify features of SQL Server 2000 Analysis Services.
Sequence the steps to manually create a Microsoft Office Project Server 2003 database.
Identify the deployment options for installing Microsoft Office Project Server 2003.
Identify key concepts related to
more...
Oracle Application Server 10g Administration Part 3

Oracle Application Server 10g is an integrated, standards-based software platform that allows organizations of all sizes to be more responsive to changing business requirements. This course covers managing, configuring OC4J applications, maintaining OC4J Application pages, OracleAS Portal, managing portal users and groups, exporting and importing portal objects, and Oracle portal advanced
more...
Oracle Application Server 10g Administration II Part 3

This course introduces the various Business Intelligence components such as Discoverer, Reports, Forms, and XML applications. The users learn about configuring and managing OracleAS Discoverer, OracleAS Reports Services, OracleAS Forms, and XML applications. They also learn how to deploy and manage OracleAS Web Services.
Learn To:
Match the components of Oracle Application Server
more...
From Sql Server Online Training
ONLINE MSBI - SSIS SSAS and SSRS training with Project






Hi Everyone!
Are you looking for the best PRACTICAL Online Training & Projects in Microsoft Business Intelligence(MSBI)? Here you are.
You reached the right place. We at SQL School, provide you in depth training on SSIS, SSAS and SSRS modules of MS BI process. Furthermore, we will also provide you one Real time Project along with documentation and implementation (solution) so that you can
more...
From Software Training Academy, Inc
Java Server Pages JSP

This four-day course develops skills in JavaServer Pages, or JSP, which is the standard means of authoring dynamic content for Web applications under the Java Enterprise platform. It treats JSP 2.0, including older features such as scriptlets but focusing on newer features and techniques, including JSP expressions and the JSTL. At the end of the course, students will be well prepared to author
more...
ADO NET for Windows Applications Using C

...tting. It is current to .NET 2. 0, Visual Studio 2005 and SQL Server 2005.
For students pursuing MCTS certification, the course provides helpful preparation for Exam 70-526: Microsoft .NET Framework 2. 0? Windows-Based Client Development.
The course opens with an overview of ADO. NET and its relation to previous Microsoft data access technologies, including ADO. It includes a discussion
more...
ADO NET for Web Applications Using C

...etting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005.
For students pursuing MCTS certification, the course provides helpful preparation for Exam 70-528: Microsoft .NET Framework 2.0?Web-Based Client Development.
The course opens with an overview of ADO.NET and its relation to previous Microsoft data access technologies, including ADO. It includes a discussion of
more...
ADO NET Using C

...etting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005.
The course opens with an overview of ADO.NET and its relation to previous Microsoft data access technologies, including ADO. It includes a discussion of ADO.NET architecture, main interfaces and classes, and programming with both the connected and disconnected models. The database for the case study is introduced.
more...
ADO NET Using VB NET

...etting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005.
The course opens with an overview of ADO.NET and its relation to previous Microsoft data access technologies, including ADO. It includes a discussion of ADO.NET architecture, main interfaces and classes, and programming with both the connected and disconnected models. The database for the case study is introduced.
more...
NET Framework Essentials Using C

...h an introduction to database programming using ADO. NET. SQL Server 2005 Express Edition is used in database examples.
The course is practical, with many examples and a case study. The goal is to equip you to begin building significant applications using the .NET Framework. The student will receive a comprehensive set of materials, including course notes and all the programming examples.
more...
From Serebra Learning Corporation
Relational Database Design and Administration
This course covers the design methodologies and techniques utilized when building an application based on a Relational Database Management System (RDBMS), using Structured Query Language (SQL). The course is based on RDBMS technology and will identify and explain the details and implementation. Designed for individuals in the design and administration of relational databases.
more...
Visual Basic 6 0 Database Access Part I
This course provides an introduction to Visual Basic's capabilities relating to database access and manipulation in an online environment. It explains how databases are organized, how information is retrieved and manipulated in databases, and what technologies are available to ensure cross-platform and uniform access to database information. This course describes the fundamentals of viewing
more...
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 Advanced Enterprise Client Server Dev Part I
...rity. The different security modes available to Microsoft SQL Server 7.0 and previous versions of SQL Server are explained, as well as their respective advantages. It also explains creating Windows NT accounts and user groups. This course discusses the merits of using SQL stored procedures for business services and data integrity checks. It describes how to create, write, and debug stored
more...
What Microsoft NET Means for IT Professionals
To introduce the concepts and components of Microsoft .NET Business managers, IT professionals
more...
Data Integration with C 2005 and ASP NET 2 0
To configure data controls and to establish and configure database connections in .NET 2.0 web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, C# 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam
more...
Data Integration with Visual Basic 2005 and ASP NET 2 0
To configure data controls and to establish and configure database connections in .NET 2.0 web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, Visual Basic 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam
more...
XML Data Access in VB NET
To use the .NET Framework to manage XML data All Microsoft VB.NET developers wanting to write enterprise applications with serviced components, Windows Services, or .NET Remoting, or studying for the 70-310 exam Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
more...
Oracle Application Server 10g mod_plsql CGI Scripts and Database Providers
To demonstrate how to configure mod_plsql, CGI-script execution, and database providers in OracleAS DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g
more...
Small Business Server 2000
To provide an overview of Microsoft Small Business Server (SBS) 2000 and its main features, such as its management consoles and monitoring tools, and to show how Microsoft Exchange 2000, ISA Server 2000, and Microsoft SQL Server 2000 integrate with SBS 2000 Network administrators for companies of up to 50 users; IT solutions companies that wish to deploy SBS 2000
more...
