SQL Server 7.0 Data Warehousing SQL Part I

This course is designed to help students gain knowledge of the core components of data warehousing application development tools and SQL management tools. The course introduces basic concepts terminology for understanding SQL Server 7.0 relational databases Structured Query Language and new or improved features. It builds on this foundation to cover client/server web applications programming replication administration security and configuration/optimization. Data Warehousing sometimes called Decision Support System (DSS) is a multi-step process of collecting cleansing and storing data for use in analyses and reporting applications making information available to a wide audience of end users. A Data Warehouse refers to an enterprise-level store of standardized and summarized information. A Data Mart refers to a targeted subset of that information. Online Analytical Processing (OLAP) is then used to process the data. Microsoft SQL Server 7.0 provides several powerful tools for building data warehouses and data marts and OLAP systems. Using the Data Transformation Services (DTS) Package Designer the user can define steps workflow and transformations necessary to build a data warehouse. Microsoft Decisions Support Services providing a robust OLAP server and the client Microsoft PivotTable Service are used to analyze data.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 5 hours Training Presented in: English

Audience

This course is written to SQL Server 7.0. Related Exam: Prepares users for both Microsoft Exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0 Database administrators Database analysts and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential. The series is designed to help the student pass the Microsoft Exam 70-028: Administering Microsoft SQL Server 7.0 and Exam 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0. This series is also appropriate for individuals who derive physical database designs develop logical data models create physical databases create data services by using Transact-SQL manage and maintain databases configure and manage security monitor and optimize databases and install and configure Microsoft SQL Server.

Prerequisites

Students understand computer system fundamentals and have user knowledge of Windows 95 Microsoft Office Internet browsing and HTML and e-mail systems. Students are expected to have successfully completed SQL Server 7.0: Introduction SQL Server 7.0: Installing and Upgrading SQL Server 7.0: Management Parts I II and III and SQL Server 7.0: Database Administration Part I and Part II courses.

Objective

Upon completion of this course the student will be able to:

Topics Include

Unit 1: Data Warehousing Framework

• Introducing the Framework
• Framework Components

Unit 2: Data Warehousing and Data Marts

• Characteristics of a Data Warehouse
• Storing Data in a Data Warehouse
• Data Marts
• Metadata

Unit 3: OLAP

• Data Warehousing OLAP Functions
• Data Cube
• Granularity
• Pivot Table Services

Duration

5 Hours

Minimum Requirements

IBM-compatible PC with 166 MHz or higher processor 32 MB RAM (64 MB RAM recommended); 800x600 SVGA color monitor with 16-bit high color display; Internet Explorer 4 or Netscape Navigator 4 or later with Shockwave 7.0.1; Windows 95 Windows 98 Windows NT; 3.5 diskette (for tracking); 28.8 kbps connection or higher for on-line use.

Media

CDROM
Web Based Training