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
Lotus Notes and Domino 6 Development (2nd Edition)
Creating Subforms
Testing and Debugging Agents, the Agent Log, and Agent Properties
A Look at JavaScript in Domino
Creating the Activity
Implementing Document-Level Security
PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases
Returning Multiple Values from an Extension Function
Prerequisites
ODBC Architecture Overview
Client 3Query Processing
Npgsql: The .NET Data Provider
Cisco CallManager Fundamentals (2nd Edition)
Regions
SIP
Creation and Usage of CDR Data
Understanding Field Data in CMRs
H.323 Signaling
Microsoft WSH and VBScript Programming for the Absolute Beginner
Overview of the Windows Script Host
VBScript Basics
Constants, Variables, and Arrays
Processing Collections of Data
Appendix A WSH Administrative Scripting
Web Systems Design and Online Consumer Behavior
Chapter IV How Consumers Think About Interactive Aspects of Web Advertising
Chapter VI Web Site Quality and Usability in E-Commerce
Chapter IX Extrinsic Plus Intrinsic Human Factors Influencing the Web Usage
Chapter XV Customer Trust in Online Commerce
Chapter XVI Turning Web Surfers into Loyal Customers: Cognitive Lock-In Through Interface Design and Web Site Usability
HTI+ Home Technology Integrator & CEDIA Installer I All-In-One Exam Guide
Designing and Installing Distributed Audio Systems
Home Access Control Systems
Home Automation Controllers
Other Home Technology Integration Devices
Appendix C Home Technology Industry Associations and Organizations
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