|
MCSD Microsoft Certified Solution Developer |
|
Microsoft Certified Solution Developer (MCSD)
Includes both Visual Basic and C++ Paths
IT professionals planning to become certified as an MCSD are required to pass a total of four exams
- one "Desktop Applications Development" exam, one "Distributed Applications" exam, one "Solution
Architecture" exam and one "Elective" exam. For more detailed information regarding MCSD Certification path vist the highlighted link.
|
MCSD Combo Visual Basic with C++ Training Kit Special Price
|
n72212d
|
$1699.00
|
|
Path 1- Visual Basic Path MCSD |
|
Path 2 Visual C++ MCSD Training |
|
Desktop Applications Development (1 exam required) *Exam 70-176: |
|
Designing and Implementing Desktop Applications with Microsoft® Visual Basic® 6.0
Part 1- Course Overview
This is the first 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 be introduced to the Visual Basic environment and its main options and
characteristics. Students will also learn the strategy for Universal Data Access and the visual data access tools that make it easy for Visual Basic programmers to create data access applications.
Learn To: Develop a simple application using Visual Basic 6.0. Access, organize, and present data
using Visual Basic's Universal Data Access features.
Audience: This course is designed for programmers who need to create basic applications with Microsoft Visual Basic 6.0.
Total Learning Time: 6 - 8 hours
Unit 1: Visual Basic Essentials - 3 - 4 hours
Unit 2: Visual Data Access Tools - 3 - 4 hours
Top
Part 2 - Course Overview:
This is the second course in a five part series that will provide students with the skills to write a
Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use class modules to define and create an instance of a component.
Students will also be provided with the basic instruction on the ActiveX Controls feature of Visual Basic 6.0.
Learn To: Create a COM component that exposes properties, methods and events. Create property pages for an ActiveX control.
Audience:This course is designed for programmers who need to create basic applications with
Microsoft Visual Basic 6.0. Participants should have completed the first course in this series.
Total Learning Time:6 - 8 hours
Unit 1: Class Modules - 3 - 4 hours
Unit 2: ActiveX Controls - 3 - 4 hours
Top
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 integrity.
Learn To: Use ActiveX Data Objects to access and manipulate data sources. Understand SQL
Server security implementations. Implement an appropriate cursor for a recordset object.
Audience: This course is designed for programmers who need to create basic applications with
Microsoft Visual Basic 6.0. Participants should have completed the first two courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: Using ActiveX Data Objects (ADO) - 3 - 4 hours
Unit 2: Advanced Data Access Issues - 3 - 4 hours
Top
Part 4- Course Overview
This is the fourth 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 integrity.
Learn To Use external COM components to extend the functionality of a Visual Basic 6.0
application. Build Visual Basic 6.0 COM components that can be reused by other applications. Test COM components, design good COM components and use Visual Component Manager.
Audience This course is designed for programmers who need to create basic applications with
Microsoft Visual Basic 6.0. Participants should have completed the first three courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: COM Components: Client Side - 2 - 3 hours
Unit 2: Building Reusable COM Components - 2 - 3 hours
Unit 3
: Testing and Managing COM Components - 2 - 3 hours
Top
Part 5- Course Overview
This is the final 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 integrity.
Learn To Optimize the usability and performance of an application. Use the tools provided with
Visual Basic 6.0 to develop applications more efficiently. Create different kinds of components and applications for the Internet.
Audience This course is designed for programmers who need to create basic applications with
Microsoft Visual Basic 6.0. Participants should have completed the first four courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: Optimizing Applications - 2 - 3 hours
Unit 2: Packaging and Deploying Applications - 2 - 3 hours
Unit 3
: Building Internet Application - 2 - 3 hours
Top
Distributed Applications Development *Exam 70-175 |
|
Designing and Implementing Distributed Applications with Microsoft® Visual Basic® 6.0
Part 1- Course Overview
This is the first course in a five part series that will provide programmers with the basic skills to build
three-tier client/server solutions.
Learn To Identify the features of the client/server architectures, Microsoft Enterprise Development
Strategy, phases of the Microsoft Solutions Framework (MSF) process model and the services of the MSF Application model, and the Visual Studio 6 Enterprise Edition development tools. Identify
the attributes of an interface and conditions of using the interfaces and the functions of the different types of interfaces. Create, implement and access an interface. Identify the type of binding to be
implemented and handle errors in an interface. Identify the advantages of COM components. Create a project to test a DLL and pass an error back to a client application.
Audience This course is designed for programmers using Visual Basic 6.0 and are currently
building desktop applications and accessing corporate databases. Participants should have completed Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0
(Courses 72590 - 72594).
Total Learning Time 6 - 8 hours
Unit 1: Microsoft Enterprise Development Strategy - 2 - 3 hours
Unit 2: Interfaces - 2 - 3 hours
Unit 3
: Component Object Model - 2 - 3 hours
Basic® 6.0
Top
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.
Learn 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. Manage and deploy packages in MTS. Implement security in MTS and SQL Server.
Audience This course is designed for programmers using Visual Basic 6.0 and are currently
building desktop applications and accessing corporate databases. Participants should have completed the first course in this series.
Total Learning Time 6 - 8 hours
Unit 1: Microsoft Transaction Server (MTS) - 2 - 3 hours
Unit 2: Maintaining Packages in MTS - 2 - 3 hours
Unit 3
: MTS and SQL Server Security - 2 - 3 hours
Top
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.
Learn To Identify features of SQL Server and select the data integrity to implement in a given
situation. Use the ActiveX Data Object (ADO) types for establishing a connection, executing a command, navigating recordsets, modifying data and executing stored procedures.
Audience This course is designed for programmers using Visual Basic 6.0 and are currently
building desktop applications and accessing corporate databases. Participants should have completed the first three courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: MTS Transaction Services - 2 - 3 hours
Unit 2: Debugging and Error Handling - 2 - 3 hours
Unit 3
: Advanced Client/Server Technologies - 2 - 3 hours
Top
Part 4- Course Overview
This is the fourth course in a five part series that will provide programmers with the basic skills to
build three-tier client/server solutions.
Learn To Identify the ACID properties of an Microsoft Transaction Server (MTS) transaction. Build
MTS components using various Visual Basic methods. Identify the different types of MTS errors and debug MTS components. Work with advanced client/server technologies.
Audience This course is designed for programmers using Visual Basic 6.0 and are currently
building desktop applications and accessing corporate databases. Participants should have completed the first four courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: ActiveX Document - 1 - 2 hours
Unit 2: Active Server Pages (ASP) - 1 - 2 hours
Unit 3
: DCOM and Load Balancing - 1 - 2 hours
Unit 4: Packaging and Deploying - 1 - 2 hours
Top
Part 5- Course Overview
This is the final course in a five part series that will provide programmers with the basic skills to build three-tier client/server solutions
Learn To Create an ActiveX document project and its objects by using Visual Basic 6.0. Work
with Active Server Pages (ASP) files, dynamic web pages, ASP objects and the IIS Application project. Configure DCOM on a client computer and on a server computer. Implement load balancing
in a distributed application environment. Create HTML help in a project by using HTML Help Workshop and package. Deploy and manage scripts by using the Package and Deployment Wizard.
Audience This course is designed for programmers using Visual Basic 6.0 and are currently
building desktop applications and accessing corporate databases. Participants should have completed the first four courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: ActiveX Document 1 - 2 hours
Unit 2:
Active Server Pages (ASP)1 - 2 hours
Unit 3: DCOM and Load Balancing 1 - 2 hours
Unit 4: Packaging and Deploying 1 - 2 hours
Top
Designing and Implementing Distributed Applications with Visual C++ 6.0
*(The difference between Exam 70-016 and 70-015 is that 70-015 training has one extra part, training
contains all eight parts)
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.
Learn To Identify the features, tools, Wizards and resource editors of Visual C++ 6.0. Install and
configure SQL Server and Microsoft Message Queue Server (MSMQ). Describe two-tier and three-tier applications. Identify the element of Microsoft Transaction Server (MTS) environment and
the steps to configure a client to use an MTS component. Install and configure Visual SourceSafe (VSS) and establish the source-code control environment.
Audience This course is designed for programmers looking to develop applications using MFC library and Microsoft Visual C++.
Total Learning Time 6 - 8 hours
Unit 1: Visual C++ 6.0: IDE Interface - 1 - 2 hours
Unit 2: SQL Server 6.5 and MSMQ - 1 - 2 hours
Unit 3
: MTS and Application Types - 1 - 2 hours
Unit 4: VSS and Source-Code Control - 1 - 2 hours
Top
Part 2- Course Overview
This is the second 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.
Learn To Identify the definition, features of MFC key classes and the differences between SDK and
MFC, static and dynamic and regular vs. extension MFC DLLs. Identify the benefits and key classes of the Document View architecture. Create View objects. Identify the fundamental
component types and identify the rules and guidelines for designing a component interface. Identify the benefits of using data access, the data access capabilities of different libraries and the benefits
of various data access technologies.
Audience This course is designed for programmers looking to develop applications using MFC
library and Microsoft Visual C++. Participants should have completed the first course in this series.
Total Learning Time 6 - 8 hours
Unit 1: Microsoft Foundation Classes - 1 - 2 hours
Unit 2: Document View Architecture - 1 - 2 hours
Unit 3
: Introduction to Component Design - 1 - 2 hours
Unit 4: Determining Data Access Requirements - 1 - 2 hours
Top
Part 3 - Course Overview
This is the third 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.
Learn To Extend the functionality of an application by using mechanisms for extending classes
and controls. Create various kinds of menus, dialog boxes, property sheets, property pages and forms. Add and edit the controls on an user interface.
Audience This course is designed for programmers looking to develop applications using MFC
library and Microsoft Visual C++. Participants should have completed the first two courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: Extending Functionality - 2 - 3 hours
Unit 2: Menus, Dialog Boxes & Property Sheets - 2 - 3 hours
Unit 3
: Adding & Editing User Interface Controls - 2 - 3 hours
Top
Part 4 - Course Overview
This is the fourth course in an eight part series for programmers. This series provides the C++
programmers the necessary skills to develop applications using MFC library and the Microsoft Visual C++ 6 development environment.
Learn To Identify the types of help techniques and implement a help system for an application.
Identify the exception handling architecture and implement exception handling in an MFC application. Implement threading in an MFC application. Create a dynamic user interface and an
ISAPI DLL that dynamically updates the content in a Web page. Identify the features and benefits of ActiveX controls and COM components and incorporate them in MFC applications.
Audience This course is designed for programmers looking to develop applications using MFC
library and Microsoft Visual C++. Participants should have completed the first three courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: Online User Assistance - 1.5 - 2 hours
Unit 2: Exception Handling - 1.5 - 2 hours
Unit 3
: Implementing Asynchronous Processing - 1.5 - 2 hours
Unit 4: Creating Dynamic Content - 1.5 - 2 hours
Unit 5: Incorporating COM and ActiveX - 1.5 - 2 hours
Top
Part 5- Course Overview
This is the fifth 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.
Learn To Store and retrieve data from a file and registry by using MFC. Implement remote
communication by using the Socket and Serial connection. Create applications using MFC classes to access and manipulate a database by adding records, deleting records and editing records.
Create ADO database applications for accessing and manipulating a database in the Visual C++ environment.
Audience This course is designed for programmers looking to develop applications using MFC
library and Microsoft Visual C++. Participants should have completed the first four courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: Accessing System Data - 1 - 2 hours
Unit 2: Remote Communication - 1 - 2 hours
Unit 3
: Database Access: ODBC and DAO - 1 - 2 hours
Unit 4: Database Access: ADO and RDO - 1 - 2 hours
Top
Part 6- Course Overview
This is the sixth 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.
Learn To Create ActiveX controls. Create Component Object Model (COM) components. Create
COM servers and clients. Implement advanced COM tasks and active documents. Create components and packages that support transactions and asynchronous processing.
Audience This course is designed for programmers looking to develop applications using MFC
library and Microsoft Visual C++. Participants should have completed the first five courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: ActiveX Controls - 1 - 2 hours
Unit 2: Component Object Model - 1 - 2 hours
Unit 3
: Advanced Component Implementation - 1 - 2 hours
Unit 4: Microsoft Transaction Server - 1 - 2 hours
Top
Part 7- Course Overview
This is the seventh 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.
Learn To Test and debug a Visual C++ application. Deploy a Visual C++ application. Maintain and support Visual C++ applications.
Audience This course is designed for programmers looking to develop applications using MFC
library and Microsoft Visual C++. Participants should have completed the first six courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: Testing and Debugging Applications - 2 - 3 hours
Unit 2: Deploying a Visual C++ Application - 2 - 3 hours
Unit 3
: Maintaining and Supporting Applications - 2 - 3 hours
Top
Part 8 - 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.
Learn To Create a database, maintain data integrity and import data. Write SQL statements to
access data from tables and manipulate the data. Implement data access in applications through stored procedure model and cursors. Create transactions and implement locking strategies.
Audience This course is designed for programmers looking to develop applications using MFC
library and Microsoft Visual C++. Participants should have completed the first seven courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: Creating and Accessing Databases 3 - 4 hours
Unit 2: Implementing Data Access in Applications 3 - 4 hours
Top
Solution Architecture (required) Exam 70-100 |
|
Analyzing Requirements and Defining Solution Architectures
Solutions Development Discipline
Part 1- Course Overview
This course is the first part of a three part series for IT Professionals. This series will discuss
Microsoft's philosophy on team organization, introduces a milestone-driven process model to manage the risks inherent in a dynamic environment, and provides an architectural framework for
multithreaded development that emphasizes reusability and distribution.
Learn To Identify the opportunities for the IT industry in the current business climate and the
reasons for the success or failure of an IT project. Identify the purpose and components of the Microsoft Solutions Framework (MSF) and the components of the Solutions Development Discipline
(SDD). Identify the features, purpose and implementation of Team, Process and Application models. Define risk, articulate the components of risk statement and identify the risk management process.
Audience This course series is designed for IT Professionals. This series will discuss Microsoft's
philosophy on team organization, introduces a milestone-driven process model to manage the risks inherent in a dynamic environment, and provides an architectural framework for multithreaded
development that emphasizes reusability and distribution.
Total Learning Time 6 - 8 hours
Unit 1: Microsoft Solutions Framework (MSF) 2 - 3 hours
Unit 2: SDD Models 2 - 3 hours
Unit 3
: Risk Management 2 - 3 hours
Top
Part 2- Course Overview
This course is the second part of a three part series for IT Professionals. This series will discuss
Microsoft's philosophy on team organization, introduces a milestone-driven process model to manage the risks inherent in a dynamic environment, and provides an architectural framework for
multithreaded development that emphasizes reusability and distribution.
Learn To Identify the importance of shared vision and how different team roles help in defining a
shared vision that addresses business problems and balances the same with the scope of the product. Identify the importance of planning from the perspective of different roles. Define the
functional specification and project plan. Identify the focus of different teams in developing phase and describe the tasks and deliverables to reach the Scope Complete/First Use Milestone. Identify the
contribution of each team in the stabilizing phase, the interim milestones and deliverables, and how release-tradeoff decisions are implemented.
Audience This course series is designed for IT Professionals. This series will discuss Microsoft's
philosophy on team organization, introduces a milestone-driven process model to manage the risks inherent in a dynamic environment, and provides an architectural framework for multithreaded
development that emphasizes reusability and distribution. Participants should have completed the first course in the series.
Total Learning Time 6 - 8 hours
Unit 1: Vision/Scope Approved Milestone 1 - 2 hours
Unit 2: Project Plan Approved Milestone 1 - 2 hours
Unit 3
: Scope Complete/First Use Milestone 1 - 2 hours
Unit 4: Release Milestone 1 - 2 hours
Top
Part 3 - Course Overview
This course is the final part of a three part series for IT Professionals. This series will discuss
Microsoft's philosophy on team organization, introduces a milestone-driven process model to manage the risks inherent in a dynamic environment, and provides an architectural framework for
multithreaded development that emphasizes reusability and distribution.
Learn To Identify the importance of a shared vision and how different team roles contribute in
defining a shared vision that addresses business problems and balances the same with the scope of the product. Identify the team focus and the importance of planning in terms of the interim
milestones and deliverables of the Project Plan Approved milestone of infrastructural deployment. Describe the interim milestones, deliverables and Team Focus of the Scope Complete/First Use
milestone of infrastructural deployment. Describe the interim milestones, deliverables and Team Focus of the Release milestone of infrastructural deployment.
Audience This course series is designed for IT Professionals. This series will discuss Microsoft's
philosophy on team organization, introduces a milestone-driven process model to manage the risks inherent in a dynamic environment, and provides an architectural framework for multithreaded
development that emphasizes reusability and distribution. Participants should have completed the first two courses in the series.
Total Learning Time 6 - 8 hours
Unit 1: Vision/Scope Approved Milestone 1 - 2 hours
Unit 2: Project Plan Approved Milestone 1 - 2 hours
Unit 3
: Scope Complete/First Use Milestone 1 - 2 hours
Unit 4: Release Milestone 1 - 2 hours
Top
Designing Component Solutions
Part 1- Course Overview
This course is the first part of a two part series for IT Professionals. This series will present a
practical design framework for achieving flexible, user-centric solutions built from components.
Learn To Identify the requirements from the information systems in the current business
environments, the challenges faced by IT organizations and the key causes for design defects. Identify the purpose of conceptual design and its activities. Capture the essence of the use of
conceptual design to understand the business perspective of a project. Identify the intent of the use of scenarios during conceptual designing of a system. Study the redesign of business processes in
an organization.
Audience This course series is designed for IT Professionals. Participants should have completed
Solutions Development Discipline series (Courses 72211 - 72213).
Total Learning Time 6 - 8 hours
Unit 1: Component Solutions: An Overview 2 - 3 hours
Unit 2: Conceptual Design: Process 2 - 3 hours
Unit 3
: Conceptual Design: Concept of Scenarios 2 - 3 hours
Top
Part 2 - Course Overview
This course is the final part of a two part series for IT Professionals. This series will present a
practical design framework for achieving flexible, user-centric solutions built from components.
Learn To Identify the purpose of logical design. Organize functional modules. Identify the
characteristics of key principles of modular design. Apply the logical design process to a business scenario. Identify the logical design from the view of user interface and database design.
Audience This course series is designed for IT Professionals. Participants should have completed
Solutions Development Discipline series (Courses 72211 - 72213) and the first course in this series.
Total Learning Time 6 - 8 hours
Unit 1: Logical Design: An Introduction 2 - 3 hours
Unit 2: Logical Design Process 2 - 3 hours
Unit 3
: Integrated Design 2 - 3 hours
Top
Distributed Application Design & Development Using Visual Studio 6.0
Part 1- Course Overview
This is the first course in a three part series designed for developers. This series will introduce them
to the opportunities and challenges of creating enterprise-level applications. Participants will see how creating such flexible and scalable applications can be challenging and will learn how to
address these challenges by employing appropriate design, tools, and technology.
Learn To Identify the characteristics of a changing business environment and the guidelines for
achieving a business focus. Analyze the performance, maintainability, availability and extensibility requirements of a system.
Audience This course is intended for developers who want to create enterprise-level applications.
Participants should have completed Solutions Development Discipline (Courses 72211, 72212 and 72213) and Designing Component Solutions (Courses 72214 and 72215).
Total Learning Time 6 - 8 hours
Unit 1: Determining Business Requirements 3 - 4 hours
Unit 2: Analyzing System Requirements 3 - 4 hours
Top
Part 2- Course Overview
This is the second course in a three part series designed for developers. This series will introduce
them to the opportunities and challenges of creating enterprise-level applications. Participants will
see how creating such flexible and scalable applications can be challenging and will learn how to address these challenges by employing appropriate design, tools, and technology.
Learn To Identify the features of different types of application architectures and the role of
distributed applications in business computing. Identify the tasks involved in defining the application architecture of an application and create a logical model by using the Visual Modeler. Identify the
various functions in implementing data tier and use the tools to implement the data tier.
Audience This course is intended for developers who want to create enterprise-level applications.
Participants should have completed Solutions Development Discipline (Courses 72211, 72212 and 72213), Designing Component Solutions (Courses 72214 and 72215) and the first course in this series.
Total Learning Time 6 - 8 hours
Unit 1: Defining Distributed Applications 2 - 3 hours
Unit 2: Application Architecture 2 - 3 hours
Unit 3
: Implementing a Data Tier 2 - 3 hours
Top
Part 3- Course Overview
This is the final course in a three part series designed for developers. This series will introduce them
to the opportunities and challenges of creating enterprise-level applications. Participants will see how creating such flexible and scalable applications can be challenging and will learn how to
address these challenges by employing appropriate design, tools, and technology.
Learn To Create Component Object Model (COM) components by deploying Visual Studio tools
and identify their features. Build components that take advantage of the Microsoft Transaction Server (MTS) services. Identify the functions of Presentation Interface, the features of HTML and
different HTML scripting types.
Audience This course is intended for developers who want to create enterprise-level applications.
Participants should have completed Solutions Development Discipline (Courses 72211, 72212 and 72213), Designing Component Solutions (Courses 72214 and 72215) and the first two courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: Component Object Model Components 1 - 2 hours
Unit 2: Business Tier: Implementation 1 - 2 hours
Unit 3: Presentation Tier: Implementation 1 - 2 hours
Unit 4: Windows Applications Design 1 - 2 hours
Top
MCSD Elective Exams (1 exam required) Exam 70-019 |
|
Exam 70-019 Designing and Implementing Data Warehouses with SQL Server 7.0
Part 1- Course Overview
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 different techniques for gathering data; identify the basic requirements of the data warehouse; and
identify the guidelines for determining various analysis requirements.
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. Identify the guidelines for determining various analysis requirements.
Audience This course series is designed for IT professionals responsible for planning,
implementing, and maintaining a data warehouse using Microsoft SQL Server client/server database management system version 7.0. This series will help students prepare for the Microsoft Certified
Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. It is recommended that participants take NETg course series 72470-72474, Microsoft
SQL Server 7.0: System Administration and course series 72475-72479, Microsoft SQL Server 7.0: Implementing a Database or have equivalent knowledge.
Total Learning Time 6 - 8 hours
Unit 1: Data Warehousing: Basic Concepts 2 - 3 hours
Unit 2: Data Gathering 2 - 3 hours
Unit 3
: Analyzing Requirements 2 - 3 hours
Top
Part 2- Course Overview
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 Transformation Services (DTS) components and the components of the DTS object
model; identify the methods of distributing data; and identify the replication types and techniques.
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. Identify the
replication types and techniques.
Audience This course series is designed for IT professionals responsible for planning,
implementing, and maintaining a data warehouse using Microsoft SQL Server client/server database management system version 7.0. This series will help students prepare for the Microsoft Certified
Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. It is recommended that participants take NETg course series 72470-72474, Microsoft
SQL Server 7.0: System Administration and course series 72475-72479, Microsoft SQL Server 7.0: Implementing a Database or have equivalent knowledge and have completed the first course in this series.
Total Learning Time 6 - 8 hours
Unit 1: OLAP Systems 1 - 2 hours
Unit 2: The Data Warehousing Process 1 - 2 hours
Unit 3
: Data Transformation Services (DTS) 1 - 2 hours
Unit 4: Replication in SQL Server 7.0 1 - 2 hours
Top
Part 3 - Course Overview
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 dimension and assign its member properties; build an aggregation and identify the
guidelines for optimizing aggregation performance; and build a cube and a partition and manage them.
Learn To Create a data warehouse database. Perform the steps necessary to build and manage
replication by using the Enterprise Manager. Identify OLAP Manager functions and the contents of DSOs. Build a dimension and assign its member properties. Build an aggregation and identify the
guidelines for optimizing aggregation performance. Build a cube and a partition and manage them.
Audience This course series is designed for IT professionals responsible for planning,
implementing, and maintaining a data warehouse using Microsoft SQL Server client/server database management system version 7.0. This series will help students prepare for the Microsoft Certified
Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. It is recommended that participants take NETg course series 72470-72474, Microsoft
SQL Server 7.0: System Administration and course series 72475-72479, Microsoft SQL Server 7.0: Implementing a Database or have equivalent knowledge and have completed the first two courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: Data Warehouse Implementation 1 - 2 hours
Unit 2: Replication 1 - 2 hours
Unit 3
: OLAP Services, Dimension and Aggregation 1 - 2 hours
Unit 4: Cube Management 1 - 2 hours
Top
Part 4 - Course Overview
This is the fourth 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 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 Cache; identify the features of MS English Query; and create and deploy an English Query application.
Learn To Identify the methods of aggregating and accessing data from relational data structures.
Create an MDX. Identify the methods of data access from multidimensional data structures. Identify the features and functionality of Pivot Table Service, Local Cubes and Client/Server Cache. Identify
the features of MS English Query. Create and deploy an English Query application.
Audience This course series is designed for IT professionals responsible for planning,
implementing and maintaining a data warehouse using Microsoft SQL Server client/server database management system version 7.0. This series will help students prepare for the Microsoft Certified
Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. It is recommended that participants take NETg course series 72470-72474, Microsoft
SQL Server 7.0: System Administration and course series 72475-72479, Microsoft SQL Server 7.0: Implementing a Database or have equivalent knowledge and have completed the first three courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: Data Access: Relational Data Structures 1 - 2 hours
Unit 2
: Data Access: Multidimensional Structures 1 - 2 hours
Unit 3: Pivot Table Service 1 - 2 hours
Unit 4: MS English Query 1 - 2 hours
Top
Part 5- Course Overview
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 warehouse; and perform the tasks related to database maintenance in Microsoft SQL Server 7.0.
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. Perform the tasks related to database maintenance in Microsoft SQL Server 7.0.
Audience This course series is designed for IT professionals responsible for planning,
implementing, and maintaining a data warehouse using Microsoft SQL Server client/server database management system version 7.0. This series will help students prepare for the Microsoft Certified
Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. It is recommended that participants take NETg course series 72470-72474, Microsoft
SQL Server 7.0: System Administration and course series 72475-72479, Microsoft SQL Server 7.0: Implementing a Database or have equivalent knowledge and have completed the first four courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: Microsoft Repository 2 - 3 hours
Unit 2: Data Warehouse Management 2 - 3 hours
Unit 3
: Data Warehouse Maintenance 2 - 3 hours
Top
Designing and Implementing Databases with Microsoft® SQL Server 7.0
Part 1- Course Overview
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.
Learn 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.
Audience This course is designed for IT professionals responsible for implementing a database
solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System Administration (Course Series 72470 - 72474).
Total Learning Time 6 - 8 hours
Unit 1: SQL Server Fundamentals 2 - 3 hours
Unit 2: Working with Transact-SQL 2 - 3 hours
Unit 3
: Constructing Databases 2 - 3 hours
Top
Part 2- Course Overview
Course Overview 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.
Learn To Implement data integrity. Create and maintain indexes.
Audience This course is designed for IT professionals responsible for implementing a database
solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System Administration (Course Series 72470 - 72474) and the first course in this series.
Total Learning Time 6 - 8 hours
Unit 1: Implementing Data Integrity 3 - 4 hours
Unit 2: Planning and Creating Indexes 3 - 4 hours
Top
Part 3 - Course Overview
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.
Learn To Query multiple tables using Transact-SQL statements. Retrieve and modify data using advanced query techniques.
Audience This course is designed for IT professionals responsible for implementing a database
solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System Administration (Course Series 72470 - 72474) and the first two courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: Querying Multiple Tables 3 - 4 hours
Unit 2: Advanced Query Techniques 3 - 4 hours
Top
Part 4 - Course Overview
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.
Learn 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.
Audience This course is designed for IT professionals responsible for implementing a database
solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System Administration (Course Series 72470 - 72474) and the first three courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: Summarizing Data 2 - 3 hours
Unit 2: Transactions and Locks Management 2 - 3 hours
Unit 3
: Implementing Views 2 - 3 hours
Top
Part 5- Course Overview
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.
Learn ToAccess data by using the Stored Procedure model. Access data using triggers. Set up a
distributed environment to access, modify and manage remote data.
Audience This course is designed for IT professionals responsible for implementing a database
solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System Administration (Course Series 72470 - 72474) and the first four courses in this series.
Total Learning Time 6 - 8 hours
Unit 1: Implementing Stored Procedures 2 - 3 hours
Unit 2: Implementing Triggers 2 - 3 hours
Unit 3
: Distributed Data 2 - 3 hours
Top
|
