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
Identifying and Managing Project Risk: Essential Tools for Failure-Proofing Your Project
Planning for Risk Management
Identifying Project Schedule Risk
Identifying Project Resource Risk
Managing Project Risk
Conclusion
Oracle Developer Forms Techniques
Advanced GUI Development: Developing Beyond GUI
Myths About the Form Filename, Form Module Name , and Form ID
Sharing a Record Group Across Forms
Intelligence with Regard to Form Wizards
When to Use WHEN-VALIDATE-RECORD and When to Use WHEN-VALIDATE-ITEM
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter Four Precall Planning and Research
Chapter Eight Creating Visions Biased to Your Solution
Chapter Nine Selling When You re Not First
Appendix A Value Justification Example
Appendix B Solution Selling: A Scalable Approach
Information Dashboard Design: The Effective Visual Communication of Data
Typical Dashboard Data
Designing an Unattractive Visual Display
An Ideal Library of Dashboard Display Media
Summary
Putting It All Together
Cisco ASA: All-in-One Firewall, IPS, and VPN Adaptive Security Appliance
Authentication, Authorization, and Accounting (AAA)
XDMCP
Transparent Firewalls
Advanced WebVPN Features
Monitoring and Troubleshooting WebVPN
Java All-In-One Desk Reference For Dummies
Working with Numbers and Expressions
Network Programming
Using Layout Managers
Book VIII - Files and Databases
Using File Streams
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