Online Data Warehouses eLearning

Data Management in Commerce Server 2000 To discuss data management in Commerce Server 2000 IT professionals who wish to use Commerce Server 2000 to implement and design e-commerce solutions; students preparing for Microsoft certification in the Designing and Implementing Solutions with Microsoft Commerce Server 2000 exam  more...

Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 1 ...fied Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to 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; and  more...

Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 2 ...fied Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models; identify the Data Transformation Services (DTS) components and the components of the DTS object model; identify the methods  more...

Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 3 ...fied Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to create a data warehouse database; perform the steps necessary to build and manage replication by using the Enterprise Manager; build a dimension and assign its member properties; build an aggregation and identify the guidelines for  more...

Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 4 ...fied Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data access from multidimensional data structures; identify the features and functionality of Pivot Table Service, Local  more...

Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 5 This is the final course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the features of the components of Microsoft Repository; perform the tasks related to managing a Microsoft SQL Server 7.0 data  more...

Fundamentals of Data Warehousing The Fundamentals of Data Warehousing WBT is the first course in the Data Warehousing curriculum. It provides students with an introduction to the core technologies, concepts, architecture, and various features of data warehouses and models. It also provides students with the preliminary knowledge for planning and implementing data warehouses. People who have a fairly good knowledge of the concepts  more...

Building a Data Warehouse The Building a Data Warehousing WBT is the second course in the Data Warehousing curriculum. It provides students with an overview of the core technologies, concepts, architecture, and various features of data warehouses, models, and data extraction tools. People who have a fairly good knowledge of the concepts of database systems, relational database management systems, and their architecture.  more...

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  more...

Data Warehousing Fundamentals Part 1: Designing and Planning This course explores the issues involved in planning designing implementing and managing a successful data warehouse. Students learn the reasons for data warehousing as a popular solution the business imperatives driving data warehousing common data warehousing terminology the components of a data warehouse implementation and data warehouse modeling concepts. Students also explore the computer  more...

Planning an SQL 7.0 Data Warehouse The Planning an SQL 7.0 Data Warehouse course is the first course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It provides students with an introduction to the core technologies, concepts, architecture, and various features of data warehouses. It also provides students with the preliminary knowledge for planning and implementing data warehouses using SQL Server  more...

Planning an MS SQL Server 7.0 Data Warehouse This course provides the student with an introduction to the core technologies, concepts, architecture, and various features of data warehouses. It also provides the student with the preliminary knowledge for planning and implementing data warehouses using SQL Server 7.0 In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019).  more...