Instructor Led Microsoft Sql Server 2000 Training Classes

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

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

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

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

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

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

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