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
WebLogic: The Definitive Guide
Using JNDI in a Clustered Environment
Using CMP and EJB QL
EJB QL
Domain Backups
SOAP Message Handlers
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Point-to-Point Protocol (PPP)
Internet Protocol (IP) Addressing
Transmission Control Protocol (TCP) Basics
Transmission Control Protocol (TCP) Data Flow
Virtual Private Networks (VPNs)
Sap Bw: a Step By Step Guide for Bw 2.0
Entering the Master Data, Text, and Hierarchy Manually
Using a Variable to Access a Hierarchy Node Directly
Business Content
Data Maintenance
Development Class
.NET System Management Services
.NET Framework and Windows Management Instrumentation
Querying WMI
Handling WMI Events
Instrumenting .NET Applications with WMI
WMI Providers
FileMaker 8 Functions and Scripts Desk Reference
Abs()
Get(HighContrastColor)
Replace()
TextColor()
Query Parameters for XML/XSLT URL Requests
Digital Character Animation 3 (No. 3)
Conclusion
Chapter Five. Creating Strong Poses
Chapter Seven. Facial and Dialogue Animation
Chapter Ten. Directing and Filmmaking
Conclusion
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