Online Sql 2000 Server eLearning - Training Resources
Sql 2000 Server Training Provider? - Tell us about your Training!
From Online Training Directory
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
This course is a complete set of 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,
more...
From 123-CBT Computer Based Training
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...
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...
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...
BizTalk Server 2000 Part 5 Secruity Optimization

Course Overview This is the last course in a five part series that deals with the securing of the BizTalk Server 2000 environment and the configuring of servers and groups of servers and optimization of server group performance. This course covers the use of tools and utilities to monitor the status of the BizTalk Server 2000 environment. Learn To Identify Microsoft Windows 2000 and
more...
BizTalk Server 2000 Part 4 Components Solutions Troubleshooting

Course Overview This is the fourth course in a five part series that presents the knowledge and skills necessary to create application integration components (AICs) for use with BizTalk Messaging Services. It also covers the deployment and management of an automated business process between trading partners using BizTalk Server 2000. In this respect, it presents a type of practical application
more...
BizTalk Server 2000 Part 3 Monitoring Orchestration

Course Overview This is the third course in a five part series that deals with the tracking of interchanges and business documents using BizTalk Document Tracking. It also covers the orchestration of the business process using BizTalk Orchestration Designer. The learner will review the core procedures necessary for using both these tools and has an opportunity to practice their use in the three
more...
BizTalk Server 2000 Part 2 Documents Mapping Managing Submitting

Course Overview This is the second course in a five part series that deals with the mapping and managing of document flow. This course covers creating maps using BizTalk Mapper, creating objects in and managing BizTalk Messaging Manager, and the submission of documents to BizTalk Server. The course continues to build upon the scenario companies that form the scenario core of the curriculum,
more...
BizTalk Server 2000 Part 1 Intro to BizTalk Server 2000

Course Overview This is the first course in a five part series that introduces the learner to the context of BizTalk operations, identifying the main challenges of EAI and B2B communications. BizTalk is contextualized in terms of a solution to these various challenges. This course covers the BizTalk administration model and its tools and services. It also covers the installation requirements
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...
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...
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...
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 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 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 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 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 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 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 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 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 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 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 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 1 Install SQL Server 2000

This is the first course in a five part series that presents the students with both theoretical and practical instruction in the subject of installing SQL Server 2000. Learn To Identify the features and functions of SQL Server. Identify the components involved in the client-server communication process. Identify the steps in the client-server communication process. Identify the minimum
more...
SQL Server 2000 Database 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...
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.
L
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 basic
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

This is the first course in a two part series that 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 course begins with an introduction to SharePoint Team Services and Team Services site architecture. It covers administrative issues and user roles, and then moves
more...
Office XP Collaborative Solutions Part 2

This is the second course in a two-part series that provides the learner with an introduction to Knowledge Management, and how SharePoint Portal Server facilitates this. Topics include, portal server's difference from team services, principal areas of data sharing within SharePoint Portal Server, data access and search mechanisms. Digital dashboards are covered in considerable detail of setup,
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

This is the first course in a five part series that covers Commerce Server 2000, focusing on business, functional, and integration requirements that need to be considered in preparation for its deployment. The course then covers Business to Consumer Web sites and fundamental elements of Commerce Server 2000, including installation, administration tools, site packaging, and Commerce Server Manager.
more...
Commerce Server 2000 Design Impl Part 2 Users Objects Catalogs

This is the second course in a five part series that covers the importance of user authentication and how to set up identification, authentication, and profiling systems for anonymous and registered users. The course also focuses on catalogs in a Commerce Server Web site, the tools used to create one, and the skills required to build Web pages to browse and search catalogs. Learn To: o
more...
Commerce Server 2000 Design Impl Part 3 Pipelines

This is the third course in a five part series that focuses on pipelines and their use in running ad campaigns. It covers how to define and run a pipeline in Microsoft Commerce Server 2000, and how to create custom components - Scriptor and Compiled - that can be added to a pipeline. The course also covers the code used to implement campaigns built and designed by Commerce Server 2000. Learn To:
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...
Commerce Server 2000 Design Impl Part 4 Ad Campaigns Websites

This is the fourth course in a five part series that teaches how to build ad, discount, and direct mail campaigns. It provides basic coverage of what packaging is, how it works, and when and why the learner will want to package their Commerce Server Web sites. Topics that teach how to manage user accounts and managing orders are also covered. Learn To: o Identify features of Commerce Server
more...
Commerce Server 2000 Design Impl Part 5 Infra Sec 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 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 with
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 manually
more...
From Serebra Learning Corporation
Security in a Microsoft SQL Server 2000 Environment
To explain how to plan and implement security on a SQL 2000 database Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Transferring and Transforming Data in SQL Server 2000
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
Transferring and Transforming Data in SQL Server 2000
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition
more...
What Microsoft NET Means for IT Professionals
To introduce the concepts and components of Microsoft .NET Business managers, IT professionals
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...
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...
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...
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...
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...
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...
MS SQL Server 2000: Design and Implementation Part 1: Introduction to SQL Server


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.
more...
MS SQL Server 2000: Design and Implementation Part 2: Managing Data


This is the second course in a five part series that will teach students how to work with SQL Server data.
more...
MS SQL Server 2000: Design and Implementation Part 3: Managing Objects


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.
more...
MS SQL Server 2000: Design and Implementation Part 4: Managing Indexes


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.
more...
MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and 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.
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 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...
MS SQL Server 2000: Design and Implementation Part 1: Introduction to SQL Server
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.
more...
MS SQL Server 2000: Design and Implementation Part 2: Managing Data
This is the second course in a five part series that will teach students how to work with SQL Server data.
more...
MS SQL Server 2000: Design and Implementation Part 3: Managing Objects
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.
more...
MS SQL Server 2000: Design and Implementation Part 4: Managing Indexes
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.
more...
MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and 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.
more...
From Software Training Academy, Inc
SQL Server 2005 Transact SQL T-SQL with Additional Topics

In this course, you'll start by learning about the basic features that are available in SQL Server, including how to design and create a database and how to build queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You'll learn about the new enhancements to the
more...
SQL Server 2005 Analysis Services SSAS

In this course, you will learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to
more...
From Teach Me IT
Getting Started with SQL Server 2000

The Getting Started with SQL Server 2000 course is the first course in the SQL Server 2000 Database Implementation curriculum. This course introduces the features and components of SQL Server 2000. It describes the architecture of SQL Server 2000 and the various programming tools that are used to work with Transact SQL statements. It also teaches the various methods to create and manage databases
more...
Retrieving Data in SQL Server 2000

The Retrieving Data in SQL Server 2000 is the second course in the SQL Server 2000 curriculum. SQL Server 2000 curriculum prepares the students for the Microsoft Certification exam Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition (70-229). This course teaches how to insert data in a SQL Server table and use views to retrieve data. It also introduces users to
more...
From Skillspride Online Training
Microsoft SQL Server 2000; Introduction to Databases and Programming
This course introduces readers to the major topics of databases and programming using Microsoft SQL Server 2000. The reader will learn about system databases, tables, data definition, creating tables, retrieving data, modifying data, indices, data integrity, views, triggers, stored procedures, programmability, distributed data and distributed transactions. Throughout the course there are practical
more...
Microsoft SQL Server 2000 Administration
This intensive course will introduce readers to administration of Microsoft SQL Server 2000 databases. The general objective of the course is to install SQL Server, create databases, import data, set up security, automate jobs and alerts, set up replication and create a robust backup regime.
more...
Microsoft SQL Server 2000 Programming Part 1
This course along with our " SQL Server 2000 Programming Part 2 course will introduce readers to the major topics of building database applications with Microsoft SQL Server 2000. The key focus of the course is on server database design and implementation using SQL Server 2000, but it also covers some client development including Access 2000's ADP format, Visual Basic using ADO, and ASP with XML.
more...
Microsoft SQL Server 2000 Programming Part 2
This course along with our " SQL Server 2000 Programming Part 1 course will introduce readers to the major topics of building database applications with Microsoft SQL Server 2000. The key focus of the course is on server database design and implementation using SQL Server 2000, but it also covers some client development including Access 2000's ADP format, Visual Basic using ADO, and ASP with XML.
more...
