Turn Information into Action Through Business Intelligence

Published: October 23, 2002

Business intelligence solutions to suit your needs

Combine the analytical tools of Microsoft SQL Server and Microsoft Office XP for a powerful business intelligence platform. By providing the right information to the right people at the right time, business intelligence enables companies to make better decisions faster than ever before.

Microsoft training and resources can help you gain the skills needed to realize the benefits of a business intelligence solution built on Microsoft products. Find the training you need to start turning data into knowledge, knowledge into action, and action into success.

Implementing and Supporting Database Applications

Administering a Microsoft SQL Server 2000 Database (Course 2072)

This course teaches the skills required to install, configure, administer, and troubleshoot a database management system. During this five-day course, you will learn how to:

•	Plan for an SQL Server installation, and then install an instance of SQL Server.
•	Choose a login security method, configure login security, plan and implement database permissions, and describe how to help protect SQL Server in an enterprise network.
•	Monitor and optimize SQL Server performance.
•	Maintain the high availability of SQL Server.

Related Resources

•	Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
•	Book: MCSE Training Kit: Microsoft SQL Server 2000 System Administration Learn how to deliver exceptional performance and scalability to your business information systems. Lessons include hands-on exercises to gain practical experience installing, configuring, and troubleshooting SQL Server 2000.

Programming a Microsoft SQL Server 2000 Database 2000 (Course 2073)

This course teaches the skills required to program a database solution. During this five-day course, you will learn how to:

•	Design an SQL Server enterprise application architecture.
•	Create and manage databases and their related components.
•	Optimize query performance.
•	Analyze queries.
•	Manage transactions and locks to ensure data concurrency and recoverability.

Related Resources

•	Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
•	Book: MCSE Training Kit: Microsoft SQL Server 2000 Database Design and Implementation Gain practical experience designing and implementing data-driven business applications using SQL Server 2000 Enterprise Edition.

Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000 (Course 2074)

This course teaches the skills required to design, implement, and deploy OLAP solutions. During this five-day course, you will learn how to:

•	Design multidimensional data marts by using star and snowflake schemas.
•	Create dimensions from relational dimension tables.
•	Create cubes by using the Cube Wizard and Cube Editor.
•	Optimize the processing of dimensions and cubes.

Related Resources

•	Book: Data Mining with Microsoft SQL Server 2000 Technical Reference Learn how to turn mountains of raw data into useful information and take full advantage of the powerful data-mining features in SQL Server 2000 with this guide.

Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services (Course 2092)

This course teaches the skills required to design star schema structures, to design data extract, transform, and load programs, and to populate data marts. During this five-day course, you will learn how to:

•	Understand data warehousing concepts and applications.
•	Build relational data marts by using star schemas.
•	Develop a data warehouse data load strategy.
•	Implement a Data Driven Query solution.

Related Resources

•	Book: Microsoft SQL Server 2000 Resource Kit Learn to create, maintain, and optimize powerful database applications for SQL Server 2000, a key Microsoft Windows Server System.
•	Book: Microsoft SQL Server 2000 Administrator's Companion Learn to deploy, administer, and support SQL Server 2000 in organizations of any size.

Implementing Business Logic with MDX in Microsoft SQL Server 2000 (Course 2093)

This course teaches the skills required to use MDX expressions to add calculated members and other dynamically calculated values to an Analysis Services cube. During this five-day course, you will learn how to:

•	Understand and use multidimensional terminology.
•	Use MDX time functions to compare values over time.
•	Apply MDX in common customer and sales applications.
•	Apply MDX in common financial applications.

Related Resources

•	Book: Microsoft SQL Server 2000 Resource Kit Learn to create, maintain, and optimize powerful database applications for SQL Server 2000, a key Microsoft Windows Server System.

Top of page

Additional Resources

•	Microsoft SQL Server Accelerator for Business Intelligence

Top of page

Turn Information into Action Through Business Intelligence

On This Page

Implementing and Supporting Database Applications

Additional Resources