Microsoft SQL Server 2000: OLAP Professional Training Series

In this course, you will learn how to use OnLine Analytical Processsing (OLAP) solutions in Microsoft SQL Server 2000, as an integral part of a data warehousing solution.

Entire course includes...

  • 5 CDs
  • Over 7 hours of instruction
  • Over 550 pages of courseware on CD-ROM
  • Step-by-step hands-on-labs
  • Sample code
In this course, you will learn how to use Microsoft SQL Server 2000 Analysis Services for creating OLAP databases and cubes. Analysis Services is a product that ships with Microsoft SQL Server 2000. This course will explain how to use Analysis Services to provide a level of data analysis and reporting that goes beyond the capabilities of relational database systems. The course will detail how Analysis Services works and how to create OLAP databases, dimensions, and cubes. You will learn how to use Analysis Manager, the administrative tool of Analysis Services, and its many wizards, objects, and properties, to create effective OLAP cubes for data analysis.

In this course you will learn how to...

  • Use Microsoft SQL Server 2000 Analysis Services
  • Use Analysis Manager
  • Understand and use dimensions
  • Create cubes and measures
  • Design storage for cubes
  • Create partitions and virtual cubes
  • Use calculated members
  • Use MDX expressions
  • Secure OLAP databases, dimensions, and cubes
  • Deploy OLAP databases
Prerequisites: This course is appropriate for database administrators and database developers who want to learn to use Analysis Services to enhance their users’ reporting capabilities. Knowledge of SQL Server and the Enterprise Manager tool is a prerequisite for this course, but students do not have to be using SQL Server for all of their database needs, in order to benefit from this course.

SESSION 1

Introduction to Analysis Services

  • OLAP Solutions
  • OLAP Models
  • SQL Server 2000 Analysis Services
  • Analysis Manager Wizards
OLAP Dimensions
  • Dimension Structure
  • Dimension Types
SESSION 2

OLAP Dimensions (continued)

  • Properties
  • Parent-Child Dimensions
OLAP Advanced Dimensions
  • Levels and Hierarchies
  • Time Dimensions
  • Custom Rollups
  • Member Properties
  • Virtual Dimensions
SESSION 3

Cubes and Measures

  • Introduction to Cubes
  • The Cube Editor
  • Measures
  • Cube Properties
Storage, Optimization, and Processing
  • Storage
  • Optimization
  • Processing
SESSION 4

Storage, Optimization, and Processing (continued)

  • Processing (continued)
Partitions and Virtual Cubes
  • Creating Partitions
  • Advanced Partitions
  • Virtual Cubes
Calculated Members
  • MDX
  • The Calculated Member Builder
SESSION 5

Calculated Members (continued)

  • MDX Expressions
MDX Tuples
  • Members, Tuples, and Sets
  • Retrieving Values
  • Constants and Functions
  • Growth Calculations
  • Advanced MDX Expressions
Advanced OLAP Topics
  • Advanced Cube Features
  • Security in Analysis Server
  • OLAP Deployment
Microsoft OLAP Clients
  • PivotTable Service (PTS)
  • Excel 2000/XP
  • Local Cubes
  • OLAP on Web Pages
Your Instructor

Leslie Koorhan is the owner of TeraCore, where he specializes in development using Visual Studio.NET and Microsoft SQL Server 2000. Leslie is a Microsoft Certified Trainer, a Microsoft Certified Solution Developer (MCSD), a Microsoft Certified Systems Engineer (MCSE) using Windows NT 4.0 and a Microsoft Certified Database Administrator (MCDBA). Leslie has used many development products over the years, most recently Visual Basic.NET, Visual C#.NET and database technologies such as ADO.NET and ADO. He has also worked with Internet technologies such as ASP.NET, ASP, XML, and XSLT. Leslie has done courseware design, written numerous articles and has been teaching computer development courses for over nine years. Most recently, Leslie co-authored and tech edited "SAMS Teach Yourself Object-Oriented Programming with Visual Basic.NET in 21 Days."

Regular price: $695.95padSale price: $595.95pad

Click here for Secure Yahoo Order: Microsoft SQL Server 2000: OLAP Professional Training Series

Get Train in SQL
SQL Software Training

Best Regards,
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.