|
Provided by: Serebra Learning Corporation Planning an SQL 7.0 Data WarehouseMS SQL Server |
![]() |
|
|
||||||||
Planning an SQL 7.0 Data WarehouseCourse Code IP1060 |
|
Contents
|
Screenshotclick to enlarge |
DescriptionThe 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 7.0. In addition, the course prepares students to take the Microsoft certification Administering Microsoft SQL Server 7.0 (70-019). AudienceAll System Administrators, Help Desk/Support personnel, and Application Developers who design and implement data warehouse solutions by using Microsoft SQL Server 7.0. PrerequisitesBefore taking this course, the user should be familiar with the relational database and data warehousing concepts and terminology and should have an experience in designing database management systems. The user should also have an understanding of Windows NT 4.0 Server and should have a knowledge of basic ANSI statements. ObjectiveUpon completion of this course, the student will be able to: identify the features of a data warehouse identify the SQL Server features that support data warehousing list the benefits of using a data warehouse describe characteristics of data marts describe the components of a data warehouse identify different types of data warehouse models that are available analyze business requirements for creating a data warehouse describe the process of extracting and loading data in a data warehouse select a schema design for a relational database build a database Topics Include
Introduction to Data Warehousing
Data Warehouse Models
Designing a Data Warehouse
Duration4 hrs Minimum RequirementsNetscape or Internet Explorer (versions 4.0 or higher). Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display. Macromedia Shockwave 6.02 or higher. Media
Web Based Training |
|
|
Serebra Learning Corporation, 1660 - 999 W Hastings St, Vancouver, BC, Canada V6C 2W2 Tel: (604) 676-5480 or 1-800-567-7766 - Fax: (604) 676-5490 E-Mail: sales@serebra.com - Web Site: www.serebra.com |
|

