Home
System Analyze Method
An Imaginary System
About iPC e-Market Inc.,
iPC Process Flow Diagram
Component of iPC System
iPC Management Reports
iPC Database Architecure
iPC Deployment Diagram
System Analyze Q & A
Determine & Define System
Process Flow Diagram
History of Flowchart
Flowchart Symbols
Cross-Functional Flowchart
Transform Process into Diagram
Data Flow Diagram
History of DFD
Context Diagram
Component of DFD
DFD Presentation Technique
Transform Data into Diagram
Why Need Data Architecture?
Network Architecture
Computer Network Model
History of Network
OSI Network Model
Type of Network
Network Devices
Network Media Types
Network Topology
Internet Technology
History of Internet
TCP/IP Network Model
List of Internet Protocol
List of Services on Internet
Internet and Security
Client Server Architecture
Client Server Architecture
Application Program Code
Centralized Network Architecture
2 - Tier Client Server Architecture
3 - Tier Client Server Architecture
N - Tier Client Server Architecture
Data Architecture
Types of Database
History of Database
File Management System
Physical Data Storage Method
Relational Database
Relational Database Model
Relational Algebra Operators
E.F. Codd's 12 Rules
History of RDBMS
Component of RDBMS
Database Constraints
Database Design Theory
Database Normalization
Entity Relationship Model
History of E-R Model
Component of E-R Model
E-R Model Notation
Crow's Foot Notation
Employee Management System
Conceptual Data Model
Logical Data Model
Physical Data Model
Generalization Hierarchies
Accountability of Data Architect
Transform Data into Architecture
Dimensional Data Model
Data Warehouse Concept
Dimensional Data Model
Examine FACT
Determine Dimension
Data Hierarchy
Surrogate Key
Types of Schemas
Data Cleaning Process
Development Lifecycle of Data Warehouse
Data Modeling Tools
Article Box
About Me
MS SQL Server 2008
History of SQL Server
Download and Install
SSMS - SQL Server Management Studio
System Databases
System Data Types
System Tables
Structure Query Language
History of SQL
DDL Statements
Operators
DML Statements
Clauses
Constraints
Data Joins
Set Operators
Special Operators
Subquery
View
TCL Statements
Programming in MS SQL Server with T-SQL
Statement
Data Types
Conditional Statements
User Defined Function
Build-In Function
Stored Procedure
SET OPTION ON / OFF
Trigger
Cursor
INDEX in SQL Server 2008
Monitor and Optimize Database
Using SQL Server Profiler
Design Optimization Technique
Query Optimization Technique
Program Optimization Technique
SSIS - MSDN Tutorials
SSAS - MSDN Tutorials
SSRS - MSDN Tutorials
White Papers
Q & A
Webcasts
SQL Server Analysis Services - MSDN Tutorials
Session 07
07.01. Lesson 6: Defining Calculations
07.01.01. Defining Calculated Members
07.01.02. Defining Named Sets
07.01.03. Defining Scoped Assignments Using Script Commands
Session 08
08.01. Lesson 7: Defining Key Performance Indicators (KPIs)
08.01.01. Defining and Browsing KPIs
Session 09
09.01. Lesson 8: Defining Actions
09.01.01. Defining and Using a Drillthrough Action
Session 10
10.01. Lesson 9: Defining Perspectives and Translations
10.01.01. Defining and Browsing Perspectives
10.01.02. Defining and Browsing Translations
Session 11
11.01. Lesson 10: Defining Administrative Roles
11.01.01. Granting Process Database Permissions
Session 12
12.01. Creating an Analysis Services Project (SQL Server Video)
12.02. Defining and Deploying a Cube (SQL Server Video)
12.03. Modifying Measures, Attributes and Hierarchies (SQL Server Video)
Session 13
13.01. SQL Server Analysis Services Product Samples
<< Previous
Your Comment To AUTHOR
Download e-Book
Copyright © 2010 data-e-education.com. All rights reserved.
Terms of Use