Online Warehouse eLearning

ONLINE MSBI - SSIS SSAS and SSRS training with Project Hi Everyone! Are you looking for the best PRACTICAL Online Training & Projects in Microsoft Business Intelligence(MSBI)? Here you are. You reached the right place. We at SQL School, provide you in depth training on SSIS, SSAS and SSRS modules of MS BI process. Furthermore, we will also provide you one Real time Project along with documentation and implementation (solution) so that you can  more...

Decimals and Percents ... is key to any businessperson, whether tallying costs for warehouse supplies or estimating resource allocation. This course instructs the learner in the following: how to use decimals, including addition, subtraction, multiplication, and division; how to solve problems involving percentages to determine portions, a rate, a whole unit, and increases and decreases--and how to apply these  more...

International Communications Simulation ...l chains one a department store, the other a members-only warehouse for bulk goods and specialty products. In your role as DMM, you will oversee the activities of a sizable buying staff and manage purchasing relations with manufacturers and suppliers worldwide. This simulation is based on the SkillSoft series "International Communications" and contains links to the following courses: COMM0021  more...

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

OS 390 Designing DB2 Data Warehouse This course is an overview of IBM's DB2 mainframe relational database management system. It explains basic functions, features and elements of DB2 for OS/390 (known simply as DB2) and its interactions with the MVS environment. The course briefly reviews the development of DB2, including enhancements to Version 6, DB2 Universal Database for OS/390. It then familiarizes the student with the basic  more...

OS 390 Managing DB2 Data Warehouse ...resents an overview of issues involved in managing a data warehouse. Included are discussions of inflowing data from a variety of sources, converting and storing data, synchronizing data in a distributed environment, and accessing data for decision-support. The course is designed for managers and technical professionals who are considering implementing a data warehouse using DB2. Technical  more...

SAP Business Information Warehouse BW - Configuration Advanced This course shows how data is extracted from an OLTP system. The learner will then be shown how to optimize SAP BW after it has been implemented. The intended audience for this course are those who need to learn how to use SAP Business Information Warehouse, and members of project teams (organizational and conceptual phases). There are no prerequisites required for this course.  more...

SAP Business Information Warehouse BW - Configuration Overview ...w companies can benefit from using a business information warehouse. The SAP BW component, and its underlying data model, will also be presented. Furthermore, the trainee will be introduced to two key tools for configuring the BW system. The audience for this course would include students who need to learn how to use SAP Business Information Warehouse, members of project teams (organizational  more...

Data Warehousing Data Warehousing  more...

Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 1 This is the first 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 characteristics of different decision support systems and components and tools used in data warehousing; identify the  more...

Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 2 ...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 of  more...

Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 3 ...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 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 ...rmation 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.  more...

SQL Server 7.0 Data Warehousing Part II This course is a multi-step process of collecting cleansing and storing data for use in analyses and reporting applicaitions and making information available to a wide audience of end-users. Using the Data Transformation Services Package Designer the student will be able to define steps workflow and transformations necessary to build a data warehouse.  more...

Microsoft Commerce Server 2000 Design and Implementation Part 5: Infrastructure, Security, & Admin. This is the final course in a five part series that covers designing a network infrastructure to support Commerce Server 2000, describing the infrastructure components including Web Farms, staging servers and development servers, and covering network performance improvement by using switches to connect servers. The course focuses on providing network security, including configuring firewalls and  more...

Introduction to Data Warehousing This course presents an introduction to Data Warehousing. Beginning with the basic concepts of data warehousing this course helps you understand the processes involved in and the architecture of data warehousing. The tools involved in analyzing the warehouse data will also be covered. Finally you'll learn about the Oracle data warehouse.  more...

Data Warehousing Fundamentals Part 1: Designing and Planning ...ing 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 architectures commonly used to support data  more...

Data Warehousing Fundamentals Part 2: Building and Deploying Oracle Data Warehousing Fundamentals: Building and Deploying introduces the concepts and strategies necessary to build and deploy a data warehouse successfully across the enterprise. This CBT course provides students with an overview of fundamental data warehousing concepts in both business and technical terms. In addition this course examines a variety of data warehouse architectures building  more...

SAP Business Information Warehouse (BW) - Configuration Overview SAP Strategic Enterprise Management - Overview shows how companies can benefit from using a business information warehouse. The SAP BW component and its underlying data model will also be presented. Furthermore the trainee will be introduced to two key tools for configuring the BW system.  more...

SAP Business Information Warehouse (BW) - Configuration Advanced This course shows how data is extracted from an OLTP system. The learner will then be shown how to optimize SAP BW after it has been implemented.  more...

SAP R/3 WM Warehouse Management This course is designed to provide foundation skills for the effective use of R/3 WM (Warehouse Management) for all employees whose duties involve procedures and tasks which exploit or interface with WM. This course shows the basic principles of R/3 Warehouse Management and shows how to post goods movements in the WM system. It describes how to carry out a physical inventory and discusses special  more...

Business Intelligence This course builds on a series of closely related concepts. It provides you with an introduction to the basic and more advanced concepts of business intelligence and discusses the architectures of possible solutions. The content of the course is divided into two main sections. The first section takes a closer look at general principles and explains why business intelligence is necessary from the  more...

Planning an SQL 7.0 Data Warehouse ...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 7.0. In addition, the  more...

Implementing an SQL 7.0 Data Warehouse ...Warehouse course is the second course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It helps students to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of creating files and filegroups and helps students to select an application programming interface for accessing a data source. In  more...

Using SQL 7.0 OLAP Services 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. 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  more...

Optimizing a SQL 7.0 Data Warehouse ...Warehouse is the fourth course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It helps students to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query performance, optimize backup and restore operations, and perform automated administration of a data warehouse. In addition, the course prepares students to  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...

Implementing an MS SQL Server 7.0 Data Warehouse This course teaches the student how to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of crating files and filegroups and helps students to select an application programming interface for accessing a data source. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL  more...

Using MS SQL Server 7.0 OLAP Services This course provides the student 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. In addition, the course prepares students to take the  more...

Optimizing a MS SQL Server 7.0 Data Warehouse This course helps the student to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query performance, optimize backup and restore operations, and perform automated administration of a data warehouse. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019).  more...