Flylib.com
Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
ISBN: 0735606706
EAN: 2147483647
Year: 1999
Pages: 114
Authors:
Microsoft Corporation
,
Microsoft Corporation Staff
BUY ON AMAZON
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
Year: 1999
Pages: 114
Authors:
Microsoft Corporation
,
Microsoft Corporation Staff
BUY ON AMAZON
Interprocess Communications in Linux: The Nooks and Crannies
Summary
Summary
Scheduling Threads
Summary
C.4. Some RPC Examples
OpenSSH: A Survival Guide for Secure Shell Handling (Version 1.0)
Step 1.1 Install OpenSSH to Replace the Remote Access Protocols with Encrypted Versions
Step 1.2 Install SSH Windows Clients to Access Remote Machines Securely
Step 3.4 Use PuTTYs Tools to Transfer Files from the Windows Command Line
Step 4.5 How to use OpenSSH Passphrase Agents
Appendix - Sample sshd_config File
Adobe After Effects 7.0 Studio Techniques
Organization
Fixing Typical Problems
32 Bits per Channel
Sky Replacement
Firearms
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
The Internationalization of the Retail Supply Chain
Fashion Logistics and Quick Response
Logistics in Tesco: Past, Present and Future
Temperature-Controlled Supply Chains
Enterprise Resource Planning (ERP) Systems: Issues in Implementation
Ruby Cookbook (Cookbooks (OReilly))
Classifying Text with a Bayesian Analyzer
Listing Methods Unique to an Object
A Real-World HTTP Client
Creating a Login System
Generating Forms for Manipulating Model Objects
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
Objects, Interfaces, and Patterns
Multithreading
Network Programming
Reflection
Useful COM Interop
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies