Using SQL 7.0 OLAP Services

Training Provided by Teach Me IT The Using SQL 7.0 OLAP Services course is the third course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. This curriculum prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019) exam. It provides students with an introduction to the concepts, architecture, and various features of the Online Analytical Processing (OLAP) Services . It also provides students with the preliminary knowledge for creating a data warehouse for use with OLAP Services. The students will be able to design and optimize an OLAP database. After completing this course, the student will be able to:

Describe the components, architecture, and features of OLAP Services
Install OLAP Services
Build an OLAP database for use with a data warehouse
Build an OLAP cube
Create cube partitions
Optimize partition of a cube or a partition
Implement database security for OLAP Services

Using SQL 7.0 OLAP Services

Other Courses in the Curriculum  Planning an SQL 7.0 Data Warehouse  Implementing an SQL 7.0 Data Warehouse  Optimizing an SQL 7.0 Data Warehouse Course Name Using SQL 7.0 OLAP Services Audience All System Administrators, Help Desk/Support personnel, and Application Developers who design and implement data warehouse solutions by using Microsoft SQL Server 7.0.  Course Requirements You need Microsoft Internet Explorer 5.0 or above OR Netscape Navigator/Communicator 4.78 or above. Plug-in Requirements  ØMacromedia Shockwave plug-in for Windows for IE/NN  ØMacromedia Flash plug-in for Windows for IE/NN Note: Macromedia Flash plug-in comes built in with IE 5.5 and above and NN 6.x. To download the plug-ins, click on the relevant icon below.   Pre-requisites Before taking this course, the user should be familiar with the relational database and data warehousing concepts and terminology, and should have an experience in designing database management systems. The user should also have an understanding of Windows NT 4.0 Server and should have a knowledge of basic ANSI statements.  Course Duration 2.5  hours Course Objectives The Using SQL 7.0 OLAP Services course is the third course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. This curriculum prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019) exam. It provides students with an introduction to the concepts, architecture, and various features of the Online Analytical Processing (OLAP) Services . It also provides students with the preliminary knowledge for creating a data warehouse for use with OLAP Services. The students will be able to design and optimize an OLAP database. After completing this course, the student will be able to: Describe the components, architecture, and features of OLAP Services Install OLAP Services Build an OLAP database for use with a data warehouse Build an OLAP cube Create cube partitions Optimize partition of a cube or a partition Implement database security for OLAP Services   Course Outline Introducing SQL OLAP Services Features of OLAP Services Installing OLAP Services Quiz Building an OLAP Database Designing an OLAP Database Building OLAP Cubes Quiz Optimizing an OLAP Database Partitioning Cube Data Optimizing Database Performance Implementing Database Security Quiz

About The Training Provider: Teach Me IT

More SQL Server 7.0 - Data Warehousing Training from Teach Me IT

• Implementing an SQL 7.0 Data Warehouse
• Optimizing an SQL 7.0 Data Warehouse
• Planning an SQL 7.0 Data Warehouse