Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
ISBN: 0735606706
EAN: 2147483647
EAN: 2147483647
Year: 1999
Pages: 114
Pages: 114
- Cover
- LOC Page
- About This Book
- Chapter 1 -- Benefits of Data Warehousing
- Lesson 1: Fundamental Data Warehousing Concepts
- Lesson 2: Benefits of Data Warehousing
- Lesson 3: Data Warehousing Features of Microsoft SQL Server 7.0
- Review
- Chapter 2 -- Applications of Data Warehousing
- Lesson 1: What Is a Data Warehouse?
- Lesson 2: Data Warehousing Life Cycle
- Lesson 3: Business Scenarios
- Review
- Chapter 3 -- Challenges of Data Warehousing
- Lesson 1: The Data Warehousing Analysis Process
- Lesson 2: An Examination of Project Management Approaches
- Lesson 3: Identifying Technical Requirements
- Review
- Chapter 4 -- Developing the Logical Design
- Lesson 1: Review of OLTP System Design
- Lesson 2: OLAP System Design
- Lesson 3: Dimensional Schema Design
- Lesson 4: Dimensions
- Lesson 5: Aggregations
- Review
- Chapter 5 -- Defining the Technical Architecture for a Solution
- Lesson 1: Microsoft Data Warehousing Framework
- Lesson 2: SQL Server 7.0 Data Warehousing Features
- Lesson 3: Setting Up the Data Warehouse Source Database
- Review
- Chapter 6 -- SQL Server Data Services
- Lesson 1: Overview of SQL Server Data Services
- Lesson 2: Introduction to Data Transformation Services
- Review
- Chapter 7 -- Replication
- Lesson 1: Introduction to Distributed Data
- Lesson 2: Introduction to SQL Server Replication
- Lesson 3: SQL Server Replication Types
- Lesson 4: Physical Replication Models
- Review
- Chapter 8 -- Advanced DTS
- Lesson 1: Planning and Creating DTS Workflows
- Lesson 2: Using Data-Driven Queries to Update the Data Warehouse
- Lesson 3: DTS Programming
- Review
- Chapter 9 -- Microsoft SQL Server OLAP Services
- Lesson 1: Moving from OLAP Data Warehouses to Cubes
- Lesson 2: Microsoft SQL Server OLAP Services
- Lesson 3: Designing and Building Cubes
- Lesson 4: Managing Cubes Using Storage Types and Partitions
- Review
- Chapter 10 -- Data Analysis Tools and Architecture
- Lesson 1: Data Analysis Concepts
- Lesson 2: Data Analysis Tools
- Lesson 3: OLAP Services and PivotTable Service Architecture
- Lesson 4: Introduction to Programming with ADO MD Objects
- Review
- Chapter 11 -- Using Microsoft English Query to Query Warehouse Data
- Lesson 1: Introduction to Microsoft English Query
- Lesson 2: Creating an English Query Application
- Lesson 3: Deploying an English Query Application
- Review
- Chapter 12 -- MDX Statements and ADO MD Objects
- Lesson 1: Introduction to MDX
- Lesson 2: Writing an MDX Query
- Lesson 3: Programming with ADO MD Objects
- Review
- Chapter 13 -- Maintaining a SQL Server Data Warehouse
- Lesson 1: Developing a Maintenance Plan
- Lesson 2: Maintaining OLAP Services Data
- Lesson 3: Backing Up and Restoring Databases
- Lesson 4: Maintaining Data and Metadata
- Review
- Chapter 14 -- Managing a SQL Server Data Warehouse
- Lesson 1: Managing Slowly Changing Dimensions
- Lesson 2: Managing Resources
- Lesson 3: Managing Security
- Lesson 4: Managing Performance
- Review
- Chapter 1
- Chapter 2
- Chapter 3
- Chapter 4
- Chapter 5
- Chapter 6
- Chapter 7
- Chapter 8
- Chapter 9
- Chapter 10
- Chapter 11
- Chapter 12
- Chapter 13
- Chapter 14
- Appendix B -- Database Schemas
- Appendix C -- Performing Basic Queries
- Lesson 1: Retrieving Data
- Lesson 2: Modifying Data
- Review
- Appendix D -- Querying Multiple Tables
- Lesson 1: Combining Data from Multiple Tables
- Lesson 2: Advanced Joins
- Review
- Appendix E -- Advanced Query Techniques
- Lesson 1: Subqueries
- Lesson 2: Using Cursors
- Lesson 3: Modifying Data
- Review
- Appendix F -- Summarizing Data
- Lesson 1: Using Aggregate Functions
- Lesson 2: GROUP BY Fundamentals
- Lesson 3: Generating Aggregate Values within Result Sets
- Review
- Glossary
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
ISBN: 0735606706
EAN: 2147483647
EAN: 2147483647
Year: 1999
Pages: 114
Pages: 114