Binding: CD-ROM EAN: 0714765293323 Feature: Identify the characteristics of different decision support systems and components and tools used in data warehousing. Format: CD Label: NetG Manufacturer: NetG Publisher: NetG Studio: NetG
Features
Identify the characteristics of different decision support systems and components and tools used in data warehousing. Identify the different techniques for gathering data. Identify the basic requirements of the data warehouse. Identify the guidelines for determining various analysis requirements.
Editorial Reviews:
The availability of data and information is a key driver in modern corporate life. To make competent informed business decisions, people need to be able to access data when they want it, be confident that the data is both timely and accurate, and get the data in the desired format. Their ability to do this is largely dependent upon the quality and strength of the data storage and retrieval system. Data warehouses serve as the central repository of all corporate information. With the release of SQL Server 7, Microsoft has created an affordable, completely integrated data warehousing solution. This 5-part curriculum is designed to teach individuals how to use SQL Server 7 to plan, design, implement, and maintain enterprise data warehouses. This curriculum begins with general coverage of data warehouse concepts and planning/design requirements, and then moves into specific implementation and maintenance capabilities found in SQL Server 7.
Spotlight customer reviews:
Customer Rating: Summary: Designing & Implementing Data Warehouses Using Microsoft SQL Comment: Course Overview
The Implementing a Database Design on Microsoft SQL Server 7.0 Curriculum is designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 7.0. This curriculum will help students prepare for Microsoft certification exam 70-029, Designing and Implementing Databases with Microsoft SQL Server 7.0. Skills taught in this series include construct and manage databases; implement data integrity; create and maintain indexes; query multiple tables using Transact-SQL statements; define transactions and set transaction isolation levels; access data by using the Stored Procedure model; access data using triggers; and set up a distributed environment to access, modify and manage remote data.
This curriculum consists of five Skill Builder courses:
Microsoft SQL Server 7.0: Implementing a Database - Part 1
Microsoft SQL Server 7.0: Implementing a Database - Part 2
Microsoft SQL Server 7.0: Implementing a Database - Part 3
Microsoft SQL Server 7.0: Implementing a Database - Part 4
Microsoft SQL Server 7.0: Implementing a Database - Part 5
Certification Requirements: This curriculum contains content that will help prepare students for the MCSE Elective, MCSE+I Elective, MCSD Elective, MCDBA Core certifications and Exam 70-029.
Learn To
See individual course descriptions for specific course objectives and scope.
Audience
These courses are designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 7.0.
