Description
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 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, for Database Administrators preparing for SQL Server Exams.
Audience
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. Everything Courseware SQL Server 7.0 Data Warehousing Using SQL Part I
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.
Course Duration
» 5 hours
Topics Include
Unit 1: Data Warehousing Framework
» Introducing the Framework
» Introducing 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

System Requirements CD-Based » Pentium class computer » 200 MHz processor (266 MHz recommended) » 32 MB RAM (64 MB recommended) » CD-ROM drive » Any one of Windows 95, Windows 98, Windows Me, Windows NT 4.0, Windows 2000 or Windows XP (both Windows NT 4.0 and Windows 2000 require at least 64 MB RAM) » SVGA monitor capable of 16-bit color and 800 x 600 screen resolution » Sound card with speakers or headphones (optional)