Online Microsoft Sql Server eLearning
Microsoft 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...
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...
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...
Backing Up Restoring Troubleshooting Essentials 2010

Backing Up, Restoring & Troubleshooting Essentials 2010 Microsoft
As with any IT system resource, a backup and restore plan should be documented and followed to ensure no data is lost in case of an unexpected failure. System Center Essentials 2010 is a management system that provides a central location for administrators to manage clients and servers within their organizations. Essentials
more...
Using Query Notifications Synchronizing Data With VB 2008

Using Query Notifications & Synchronizing Data With VB 2008 Microsoft
Query notifications, coupled with ADO.NET synchronization services, allow developers to create applications with the ability to display up-to-date data at all times. This course examines how to use query notifications with SQL Server and how to enable efficient, remote use of data using synchronization services. Specific
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 administrators
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 is
more...
SQL Server 2008 Security Management

... 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 users, using either Windows Authentication or Mixed Mode Authentication by creating logins and then
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 tasks
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 to
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 data
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

Creating & Implementing Database Objects in 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
more...
Creating Modifying Table Index Partitions in SQL Server 2008

Creating & Modifying Table & Index Partitions in 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
more...
Running Queries Manipulating Data in SQL Server 2008

Running Queries & Manipulating Data in 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
more...
Performing Advanced Query Techniques in SQL Server 2008

Performing Advanced Query Techniques in 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
more...
Creating Implementing Programming Objects in SQL Server 2008

Creating & Implementing Programming Objects in 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
more...
Querying Managing XML Data inSQL Server 2008

Querying & Managing XML Data inSQL 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
more...
Using SQL Server 2008 Messaging Full-Text Search Scripts Track Changes

Using 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

Gathering Performance Data in 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.
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

...elligence 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 2008 offers integration, reporting, and analysis tools to access and process the data necessary to create business
more...
Configuring SQL Server 2008 Integration Services Package

Configuring 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
more...
Deploying SQL Server 2008 Integration Services Package

Deploying 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
more...
Implementing SQL Server 2008 Reporting Services Solutions

Implementing 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
more...
Deploying Delivering SQL Server 2008 Reporting Services Reports

Deploying & Delivering 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
more...
Maintaining SQL Server 2008 Reporting Services

...nce (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 tools used and tasks involved in managing and maintaining access to Reporting Services and corresponding data. It covers the authentication subsystem
more...
Implementing SQL Server 2008 Analysis Services Solutions

Implementing 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.
more...
Querying Cubes Working with Data Mining in SSAS

Querying Cubes & Working with Data Mining in 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
more...
Managing SQL Server 2008 Analysis Services Solutions

Managing 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

Managing SSIS Packages in 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
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...
From Online Training Directory
Administering Microsoft ® SQL Server 2000 (SQL)



...dge and skills 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,
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...
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...
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

C ourse Overview
This is the third 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 identify the features of Active Server Pages (ASP); create a server script and debug the server-side script;
more...
Visual InterDev 6 0 Accessing Remote Data

...etrieve data 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
more...
SQL Server 7 0 Designing Implementing Data Warehouses Curriculum

...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 Warehouses - Part 4 MS SQL Server 7.0: Designing and
more...
SQL Server 7 0 System Administration - Part 5

...wledge to 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
more...
SQL Server 7 0 - Implementing a Database - Part 1

...th the knowledge 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
more...
SQL Server 7 0 - Implementing a Database - Part 2

...th the knowledge 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
more...
SQL Server 7 0 System Administration - Part 1

...wledge to 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
more...
SQL Server 7 0 System Administration Curriculum

The 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

...wledge to 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
more...
SQL Server 7 0 System Administration - Part 3

...wledge to 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

...wledge to 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
more...
SQL Server 7 0 - Implementing a Database - Part 3

... with the 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
more...
SQL Server 7 0 - Implementing a Database - Part 4

...th the knowledge 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
more...
SQL Server 7 0 - Implementing a Database - Part 5

... with the 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
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

Course Overview This is the final course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment. L earn To: Create a database, maintain data integrity and import data. Write SQL statements to access data from tables and manipulate the
more...
SQL Server 7 0 Designing Implementing Data Warehouses - Part 1

...m 70-019, 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
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2

...m 70-019, 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;
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3

...m 70-019, 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

...m 70-019, 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
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 5

...m 70-019, 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:
more...
SQL Server 7 0 Database Design Curriculum

The 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 Server 2000 Database Administration Curriculum

The MS 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

...0. Identify the typical hardware optimization issues for Microsoft SQL Server 2000. Select an appropriate edition of SQL Server 2000. Identify the different types of SQL Server 2000 installations. Install a default instance of SQL Server 2000. Sequence the stages of an unattended installation. Identify the types of SQL Server databases. Identify the database objects related to SQL
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 Designing Implementing Databases Curriculum

The MS 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
more...
SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server

Course Overview This is the first course in a five part series that presents students with both theoretical 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
more...
SQL Server 2000 Design Implement Databases Part 2 Managing Data

Course Overview This is the second course in a five 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
more...
SQL Server 2000 Design Implement Databases Part 3 Managing Objects

Course Overview This is the third course in a five 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
more...
SQL Server 2000 Design Implement Databases Part 4 Managing Indexes

Course Overview This is the fourth course in a five 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
more...
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks

This is the final 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
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

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...
CIW E-Commerce Designer Part 4 Site Implementation

...f the Oracle8 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
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

...f Microsoft 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
more...
BizTalk Server 2000 Part 2 Documents Mapping Managing Submitting

...f Microsoft 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
more...
BizTalk Server 2000 Part 3 Monitoring Orchestration

...f Microsoft 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
more...
BizTalk Server 2000 Part 4 Components Solutions Troubleshooting

...f Microsoft 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 -
more...
BizTalk Server 2000 Part 5 Secruity Optimization

... Learn To 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
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

...SharePoint 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
more...
Office XP Collaborative Solutions Part 2

...SharePoint 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
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

...ts and technologies (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
more...
Commerce Server 2000 Design Impl Part 2 Users Objects Catalogs

...ts and technologies (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
more...
Commerce Server 2000 Design Impl Part 3 Pipelines

...ts and technologies (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
more...
Visual Basic NET-Web Based Development Part 3

Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of SQL Server security
more...
Visual Basic NET-Web Based Development Part 3

Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of SQL Server security
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

This course, teaches about security for Windows 2000-based computers. Security templates and security baselines are covered. The learner is guided through additional security configurations including security settings for file and print resources. Web server security and Internet security are also covered. Learn To: To identify guidelines for planning
more...
Windows 2000 Implementing Security Part 2

This course, teaches about security for Windows 2000-based computers. Security templates and security baselines are covered. The learner is guided through additional security configurations including security settings for file and print resources. Web server security and Internet security are also covered. Learn To: To identify guidelines for planning
more...
Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3

Course Overview This is the third course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential
more...
Visual Basic 6 0 Designing Implementing Distributed Applications - Part 2

Course Overview This is the second course in a five part series that will provide programmers with the basic skills to build three-tier client/server solutions. L earn To: Identify the features, installation requirements, constituents, supporting services and command line utilities of Microsoft Transaction Server (MTS), and the elements and views of the MTS Explorer interface.
more...
Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3

Course Overview This is the third course in a five part series that will provide programmers with the basic skills to build three-tier client/server 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,
more...
Visual C 6 0 Designing Implementing Desktop Applications - Part 1

Course Overview This is the first course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment. L earn To: Identify the features, tools, Wizards and resource editors of Visual C++ 6.0. Install and configure SQL Server and Microsoft
more...
Commerce Server 2000 Design Impl Part 4 Ad Campaigns Websites

...ts and technologies (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,
more...
Commerce Server 2000 Design Impl Part 5 Infra Sec Admin

...ts and technologies (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 four parts of this series 74116 thru 74119. Deployment Options Internet / Intranet, Download, LAN,
more...
Microsoft NET Tech Overview Part 1 NET Platform Framework

This course gives an introduction and basic explanation of the Microsoft .NET Platform and its components, including the .NET Enterprise Servers (BizTalk Server, Application Center, Host Integration Center, Mobile Information 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
more...
Microsoft NET Tech Overview Part 1 NET Platform Framework

This course gives an introduction and basic explanation of the Microsoft .NET Platform and its components, including the .NET Enterprise Servers (BizTalk Server, Application Center, Host Integration Center, Mobile Information 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
more...
Microsoft NET Tech Overview Part 2 NET Server Infrastructure Services

This course covers the .NET Enterprise Servers infrastructure, explaining each of the servers in turn - BizTalk Server 2000, Application Center 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
more...
Microsoft NET Tech Overview Part 2 NET Server Infrastructure Services

This course covers the .NET Enterprise Servers infrastructure, explaining each of the servers in turn - BizTalk Server 2000, Application Center 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
more...
MS Project Server 2003 Introduction Part 1

This course is the first part of a two-part series. This course will focus on introduction to Project Server 2003. It will also explain the software components of Project Server 2003, its architecture, and the configuration planning process.
Learn To:
Identify features of Microsoft Office Project Server 2003.
Match the software components of Microsoft Office Project Server 2003
more...
MS Project Server 2003 Introduction Part 2

This course introduces you to the capabilities of Microsoft Office Project Server 2003. It includes how to plan, install, and configure the platform, as well as plan for client access across 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
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
ADO NET for Windows Applications Using C

This three-day intensive course teaches the essential elements of ADO. NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO. NET in a realistic setting. It is current to .NET 2. 0, Visual Studio 2005 and SQL Server 2005.
more...
ADO NET for Web Applications Using C

This three-day intensive course teaches the essential elements of ADO.NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications for the Web. The course includes a major case study demonstrating the use of ADO.NET and ASP.NET in a realistic setting. It is current to .NET 2.0, Visual Studio 2005 and
more...
ADO NET Using C

This intensive course teaches the essential elements of ADO.NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005.
The course
more...
ADO NET Using VB NET

This three-day intensive course teaches the essential elements of ADO.NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005.
The
more...
NET Framework Essentials Using C

Microsoft .NET is an advance in programming technology that greatly simplifies application development, both for traditional, proprietary applications and for the emerging paradigm of Web-based services. .NET is a complete restructuring of Microsoft? s whole system infrastructure and represents a major learning challenge for programmers developing applications on Microsoft platforms. Part of .NET
more...
From Serebra Learning Corporation
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
...ising security. 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
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...
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...
Troubleshooting and Disaster Recovery of SharePoint 2003
To describe troubleshooting and the implementation of a disaster recovery strategy for SharePoint Portal Server 2003 Administrators who intend to deploy SharePoint Portal Server 2003 and SharePoint technologies; IT professionals who wish to gain knowledge of SharePoint products and technologies
more...
Project Server 2003 Installation and Configuration
To install and configure IIS 6.0, SQL Server, and SharePoint for Project Server 2003 Systems administrators, systems engineers, systems analysts, IT consultants, and IT professionals with responsibility for planning and implementing Project Server 2003; learners preparing for MCSE certification exams
more...
Project Server 2003 Implementing Project Server and Planning Client Deployment
To install Project Server 2003 and plan client deployment Systems administrators, systems engineers, systems analysts, IT consultants, and IT professionals with responsibility for planning and implementing Project Server 2003; learners preparing for MCSE certification exams
more...
Project Server 2003 Planning Security Operations
To plan and implement the Project Server 2003 security structure and operations Systems administrators, systems engineers, systems analysts, IT consultants, and IT professionals with responsibility for planning and implementing Project Server 2003; learners preparing for MCSE certification exams
more...
Maintaining and Securing Data in SharePoint 2003
To describe how to configure and maintain databases and implement security measures in SharePoint Portal Server 2003 Administrators who intend to deploy SharePoint Portal Server 2003 and SharePoint technologies; IT professionals who wish to gain knowledge of SharePoint products and technologies
more...
Planning for Deployment of Microsoft Biztalk 2000
To describe the planning and design of a BizTalk Server 2000 deployment IT professionals and administrators seeking to gain competency in the use of Microsoft BizTalk Server 2000; candidates for Microsoft Exam 70-230: Designing and Implementing Solutions with Microsoft BizTalk Server 2000, Enterprise Edition
more...
Cisco CallManager Fundamentals
To explain how to deploy a Cisco CallManager server in a cluster using a supported IP telephony deployment model IT professionals responsible for installing, configuring, and maintaining the ongoing administration of a Cisco IP telephony solution; candidates preparing for the Cisco IP Telephony exam (642-444 CIPT)
more...
Monitoring and Managing IP Telephony Using Internal Server Tools
To demonstrate how to manage and monitor an IP telephony solution using internal server tools IT professionals responsible for installing, configuring, and maintaining the ongoing administration of a Cisco IP telephony solution; candidates preparing for the Cisco IP Telephony exam (642-444 CIPT)
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...
Office XP for the Advanced User
To provide an overview of the new features and feature enhancements in the following Microsoft Office XP applications - Access, Publisher, FrontPage, and SharePoint Team Services Advanced end-user
more...
Advanced Database Features in Access 2002
To demonstrate a range of advanced database features in Access 2002 Anyone wishing to become familiar with Microsoft Access 2002 at an advanced level; students seeking to obtain Microsoft Office User Specialist (MOUS) certification in the use of Microsoft Access 2002 at advanced level
more...
Microsoft SQL Server 7.0: System Administration - Part 1
This is the first course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: System Administration - Part 2
This is the second course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: System Administration - Part 3
This is the third course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: System Administration - Part 4
This is the fourth course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: System Administration - Part 5
This is the final course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: Implementing a Database - Part 1
This is the first course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: Implementing a Database - Part 2
This is the second course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: Implementing a Database - Part 3
This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: Implementing a Database - Part 4
This is the fourth course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0.
more...
Microsoft SQL Server 7.0: Implementing a Database - Part 5
This is the final course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.
more...
Microsoft Visual InterDev 6.0: Accessing Remote Data
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 Remote Data Services
more...
Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0 - Part 2
This is the second course in a five part series that will provide programmers with the basic skills to build three-tier client/server solutions.
more...
Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0 - Part 3
This is the third course in a five part series that will provide programmers with the basic skills to build three-tier client/server solutions.
more...
Microsoft Visual C++ 6.0: Designing and Implementing Applications - Part 1
This is the first course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment.
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 1
This is the first course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, 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
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 2
This is the second course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, 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
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 3
This is the third course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, 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
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 4
...m 70-019, 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 and Client/Server
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 5
This is the final course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, 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
more...
SQL Server 7.0 Database Admin. Part I
This course builds upon previous courses by covering database management and provides a foundation for advanced courses on data warehousing client/server application development and SQL to IIS active server pages. Related Exams: Prepares users for both Microsoft Exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0.
more...
SQL Server 7.0 Database Admin. Part II
Microsoft exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0.
more...
SQL Server 7.0 Introduction
This course presents an overview of the features and benefits of SQL Server 7.0 a major update to Microsoft's SQL Server database product. It describes the major differences between versions 6.5 and 7.0 and examines core components data warehousing application development tools and SQL management tools. This course provides an excellent foundation for advanced courses on upgrade and
more...
SQL Server 7.0 Installing and Upgrading
This course presents a comprehensive view of upgrading and installation process and its installation types and requirements. Students will learn the procedures for installing and upgrading to SQL Server 7.0. The course describes setup options that must be determined before installing SQL Server 7.0 and covers logon accounts the Windows NT User Account network protocols management tools and sort
more...
SQL Server 7.0 Management Part I
This course is designed to teach the skills necessary to take full advantage of SQL Server 7.0 features and enhancements used to manage data. SQL Server 7.0 contains two powerful tools for managing data: Transact-SQL at the command-line level and SQL Server Wizard features. This course presents a comprehensive view of the database development process by outlining the processes of creating the
more...
SQL Server 7.0 Management Part II
This course provides the skills to 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
more...
SQL Server 7.0 Management Part III
This course explains how to design a logical model of a database and identifies the components to use in order to organize and access a SQL Server database. It describes the advanced programmatic features of the SQL language which can be used to extend the functionality of SQL stored procedures.Additionally this course examines the functions of a SQL cursor including how to navigate a result set
more...
SQL Server 7.0 Data Warehousing SQL Part I
...tical Processing (OLAP) is then used to process the data. Microsoft SQL Server 7.0 provides several powerful tools for building data warehouses and data marts and OLAP systems. Using the Data Transformation Services (DTS) Package Designer the user can define steps workflow and transformations necessary to build a data warehouse. Microsoft Decisions Support Services providing a robust OLAP
more...
SQL Server 7.0 Developing SQL Client/Server Part I
This course is designed to present a comprehensive view of the client/server application. The course outlines the structure and elements of client/server architecture interfaces available strategies in accessing data from the client side through queries and tools available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server
more...
SQL Server 7.0 Developing SQL Client/Server Part II
This course is designed to present a comprehensive view of the client/server application. The course outlines the structure and elements of client/server architecture interfaces available strategies in accessing data from the client side through queries and tools available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server
more...
SQL Server 7.0 Advanced Features Part I
This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition it outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advanced
more...
SQL Server 7.0 Advanced Features Part II
This course describes this integration with Microsoft Office 2000 and Visual Studio. The course presents advanced failover support methods including server cluster management warm spares and redundant hardware. In addition It outlines linked and remote servers and techniques to manage transactions distributed over these servers. The course topics outline the syntax and function of advances
more...
SQL Server 7.0 Web Integration
This course introduces several new or enhanced technologies procedures and tools for increased dependence on the Web for business applications. The course presents a comprehensive view of Web applications with SQL Server 7.0. The course outlines Microsoft's overall Web strategy including reasons for linking the databases to Web clients possible tasks that can be accomplished through Web
more...
Microsoft Commerce Server 2000 Design and Implementation Part 5: Infrastructure, Security, & Admin.


This is the final course in a five part series that covers designing a network infrastructure to support Commerce Server 2000, describing the infrastructure components including Web Farms, staging servers and development servers, and covering network performance improvement by using switches to connect servers. The course focuses on providing network security, including configuring firewalls and
more...
Microsoft Access 2000 Designing and Implementing Database Applications Part 5 - Completing Applicati
This is the final course in a five-part series that will provide IT professionals with the knowledge and skills necessary to design and implement database solutions using Microsoft Access 2000. At the completion of this course students will learn to enhance the user interface by implementing toolbars ToolTips status bars and help project file; perform common management tasks to ensure better
more...
Microsoft .NET Technology Overview: Part 1 - .NET Platform and Framework
This course gives an introduction and basic explanation of the Microsoft .NET Platform and its components including the .NET Enterprise Servers (BizTalk Server Application Center Host Integration Center Mobile Information 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
more...
Microsoft .NET Technology Overview: Part 2 - .NET Server Infrastructure and Services
This course covers the .NET Enterprise Servers infrastructure explaining each of the servers in turn - BizTalk Server 2000 Application Center 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
more...
Microsoft SQL Server 2000 Querying with Transact-SQL Part 1: Manipulating Data
This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL.
more...
Microsoft SQL Server 2000 Querying with Transact-SQL Part 2: Working with Queries
This course will teach students how to work with queries. The course will also introduce views stored procedures triggers and user-defined functions.
more...
MS SQL Server 2000: Database Administration Part 1: Installing 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.
more...
MS SQL Server 2000: Database Administration Part 2: Managing Databases
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.
more...
MS SQL Server 2000: Database Administration Part 3: Security and Data Recovery
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.
more...
MS SQL Server 2000: Database Administration Part 4: Managing Data
This course deals with transferring data managing replication services and maintaining high availability.
more...
MS SQL Server 2000: Database Administration Part 5: Maintaining SQL Server 2000
This is the last course in a five part series that deals with managing monitoring and troubleshooting SQL Server 2000.
more...
