SQL Server Data Warehousing concepts Video

An introduction to SQL Server data warehousing concepts

Data warehousing Concepts
Relational warehouse Concepts
Multi-Dimensional Concepts

Data Warehouse Components

Data Sources

ETL

Relational Data warehouse (SQL Server)

Dimensional Data warehouse (Analysis Services)

Graphical User Interface Tools

  • Use SQL to query relational warehouse
  • Use MDX (Multi dimensional expressions  to query cubes)
Reblog this post [with Zemanta]
Advertisements

One response to this post.

  1. […] SQL Server Data Warehousing concepts Video […]

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: