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
Beginning Cryptography with Java
The JCA and the JCE
Symmetric Key Cryptography
Asymmetric Key Cryptography
SSL and TLS
Appendix A Solutions to Exercises
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Initial Startup and Common Pitfalls
Improving the Kanban
Appendix C Two-Bin Kanban Systems
Appendix D Organizational Changes Required for Kanban
Appendix H Case Study 1: Motor Plant Casting Kanban
The CISSP and CAP Prep Guide: Platinum Edition
Security Architecture and Design
Continuous Monitoring Process
Appendix A Answers to Assessment Questions
Appendix D The Information System Security Engineering Professional (ISSEP) Certification
Appendix F Security Control Catalog
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
The Internationalization of the Retail Supply Chain
Logistics in Tesco: Past, Present and Future
Temperature-Controlled Supply Chains
Rethinking Efficient Replenishment in the Grocery Sector
The Development of E-tail Logistics
Comparing, Designing, and Deploying VPNs
Designing and Implementing AToM-Based Layer 2 VPNs
MPLS Layer 3 VPNs Overview
Supporting Multicast Transport in MPLS Layer 3 VPNs
Designing and Implementing L2TP Compulsory/NAS-Initiated Tunnel Mode Remote Access VPNs
Designing and Building SSL Remote Access VPNs (WebVPN)
VBScript in a Nutshell, 2nd Edition
Common Problem Areas and How to Avoid Them
Accessing Other Object Models
Windows Script Components
Section A.7. Dictionary Object
Section B.4. Date Format Constants
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