Instructor Led Microsoft Sql Server 2000 Training Classes
From Affinity IT Training, LLC
Extended Features In Microsoft SQL Server 2000 Level 3
Presents and explains advanced features, tools, and capabilities
of SQL Server 2000,
including Data Transformation Services, XML formatting, Replication,
Automated Administration, and Data Mining.
Audience:Experienced Programmers already familiar with SQL Server 2000 seeking to take advantage of advanced features and capabilities.
more...
From Microsys Technologies and Solutions Pvt. Ltd.,
Microsoft BizTalk Server 2004
...ise Architect
Microsoft Internet Information Services 6.0
Microsoft SQL Server 2000 Enterprise Edition
Microsoft SQL Server Analysis Services
Microsoft SQL Server 2000 Service Pack #3
Microsoft Visual Basic 6.0
Microsoft Office 2003 (Including Microsoft InfoPath)
WinZip 8.0
Adobe Acrobat Reader 5.0
Detailed Coverage:
Day I
Introducing Microsoft BizTalk Server 2004
What s New in
more...
Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000

Module 1: Introduction to Data Warehousing and OLAP
Module 2: Introducing Analysis Manager Wizards
Module 3: Understanding Analysis Services Architecture
Module 4: Building Dimensions Using the Dimension Editor
Module 5: Using Advanced Dimension Settings
Module 6: Working with Cubes and Measures
Module 7: Case Study - Creating the Store Expense Cube
Module 8: Managing Storage and Optimization
more...
From Hands On Technology Transfer, Inc.
Microsoft SQL Server 2000 Database Development
Description: Five days of intensive hands on training, this class will allow the student to understand relational database concepts and the Structured Query Language (Transact-SQL) in the Microsoft SQL Server environment as well as identify and configure all major aspects of a Microsoft SQL Server RDBMS. You will learn about tables and constraints; DTS packages and transformations; transact SQL
more...
From Thinkpath Training LLC
Querying MS-SQL Server 2000 & Programming a MS-SQL Server 2000 Database (Course 2071/2073)


...stom class which combines the content of 2071: Querying a Microsoft SQL Server 2000 Database with Transact-SQL and 2073: Programming a Microsoft SQL Server 2000 Database. New custom practice labs have been generated to provide the student with a linear project in which to experience and partake in the creation of a real-world database solution.
Course Objective: This course provides students
more...
From American IT
Querying Microsoft SQL Server 2000 with Transact-SQL
The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™ 2000.
more...
Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000
This course provides students with the knowledge and skills necessary to design implement and deploy OLAP solutions by using Microsoft SQL Server 2000™ Analysis Services.
more...
Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services
This course provides students with the knowledge and skills necessary to design a data warehouse and to populate data marts by using Data Transformation Services (DTS) in Microsoft SQL Server™ 2000.
more...
Implementing Business Logic with MDX in Microsoft SQL Server 2000
This course provides students with the knowledge and skills necessary to use multidimensional expressions (MDX) to add calculated members and other dynamically calculated values to a Microsoft SQL Server™ 2000 Analysis Services cube by using SQL Server 2000.
more...
Implementing Replication Using Microsoft SQL Server 2000
This three-day instructor-led course provides students with the knowledge and skills to plan deploy administer manage and troubleshoot complex replication designs over a variety of communication topologies. The course reviews SQL Server replication and then focuses in detail on snapshot transactional and merge replication as well as topics related to Enterprise-level replication.
more...
From Insider Training
Live Online:MCDBA +LIVE


Presented online by a live instructor - Online ILT Presented online with a live expert instructor (online ilt) Our complete MCDBA 2003 packages give you the expert knowledge and hands-on experience you need to master Windows 2003 and SQL Server and pass all four Microsoft exams. For one low price, you'll tap into the most powerful learning system available anywhere. The Insider Training
more...
Live Online:MCDBA +LIVE PREMIUM


Presented online by a live instructor - Online ILT Presented online with a live expert instructor (online ilt) Our complete MCDBA 2003 packages give you the expert knowledge and hands-on experience you need to master Windows 2003 and SQL Server and pass all four Microsoft exams. For one low price, you'll tap into the most powerful learning system available anywhere. The Insider Training
more...
From The Career Center
SQL Database Design & Implementation
...r
Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise
Edition.
Upon successful completion of this course, students will be able to:
Use Transact-SQL to query a SQL server.
Design, create, and manage databases.
Create and manage tables.
Implement data integrity techniques.
Design and implement indexes.
Query multiple tables through the use
more...
From Boston University Corporate Education Center
Updating Your Database Administration Skills to Microsoft SQL Server 2005
... equivalent knowledge. ? Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0. ? Knowledge of SQL Server 2000/7.0:
? Database and server architecture. ? Installation and configuration. ? Database security. ? Database recovery (backup and restore). ? SQL Server technologies used for database availability such as log shipping and clustering. ? Job
more...
Updating Your Database Development Skills to Microsoft SQL Server 2005
... or equivalent knowledge. ? Development experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0. ? Knowledge of SQL Server 2000/7.0:
? Database and server architecture. ? Database Security ? Transact SQL ? Query Engine ? DDL ? DML ? Optimization ? Schema and Objects ? Programming Objects ? UDF ? Triggers ? Stored Procedures ? Optimization ? SQL XML
more...
Designing & Implementing OLAP Solutions Using Microsoft SQL Server 2000
This course provides students with the knowledge and skills necessary to design, implement, and deploy OLAP solutions by using Microsoft SQL Server 2000 Analysis Services. There is no MCP exam associated with this course.
more...
Implementing Replication Using Microsoft SQL Server 2000
Technology Course: Implementing Replication Using Microsoft SQL Server 2000 (MSC2591)
more...
Programming a Microsoft SQL Server 2000 Database
This course provides students with the technical skills required to program a database solution by using Microsoft SQL Server 2000. This course helps you prepare for the fol-lowing Microsoft Certified Professional exams: 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
more...
Querying Microsoft SQL Server 2000 with Transact-SQL
The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2000.
more...
Administering a Microsoft SQL Server 2000 Database
...essional exam:
Exam 70-228, System Administration for Microsoft SQL Server 2000 Prerequisites Before attending this course, students must have:
Experience using the Microsoft Windows 2000 operating system to: Connect clients running Windows 2000 to networks and the Internet. Configure the Windows 2000 environment. Create and manage user accounts. Manage access to
more...
