• Post category:StudyBullet-7
  • Reading time:5 mins read


Learn how to design a Microsoft SQL Server Data Warehouse

What you will learn

Setup Microsoft SQL Server

Configure database settings for data warehousing

Enable SQL Server Agent

Logical design of data warehouse

Physical design of data warehouse

Design Dimension Tables

Description

A data warehouse is a central repository of information that can be analysed to make more informed decisions. Data flows into a data warehouse from transactional systems, relational databases, and other sources, typically on a regular cadence. Business analysts, data engineers, data scientists, and decision makers access the data through business intelligence (BI) tools, SQL clients, and other analytics applications.

Data and analytics have become indispensable to businesses to stay competitive. Business users rely on reports, dashboards, and analytics tools to extract insights from their data, monitor business performance, and support decision making. Data warehouses power these reports, dashboards, and analytics tools by storing data efficiently to minimize the input and output (I/O) of data and deliver query results quickly to hundreds and thousands of users concurrently.

A data warehouse is specially designed for data analytics, which involves reading large amounts of data to understand relationships and trends across the data. A database is used to capture and store data, such as recording details of a transaction.

This course explains the design of dimension tables, physical and logical design of a data warehouse .


Get Instant Notification of New Courses on our Telegram channel.


Physical design is the creation of the database with SQL statements. During the physical design process, you convert the data gathered during the logical design phase into a description of the physical database structure. Physical design decisions are mainly driven by query performance and database maintenance aspects.

The process of logical design involves arranging data into a series of logical relationships called entities and attributes. An entity represents a chunk of information. In relational databases, an entity often maps to a table. An attribute is a component of an entity that helps define the uniqueness of the entity.

A dimension table is a table in a star schema of a data warehouse. A dimension table stores attributes, or dimensions, that describe the objects in a fact table. In data warehousing, a dimension is a collection of reference information about a measurable event.

English
language

Content

Microsoft SQL Server Setup

Introduction
What is SQL Server
SQL Server Editions
SQL Server Installation Requirements
Download SQL Server
Install SQL Server
Install SSMS
Connect SSMS to SQL Server
Install sample data warehouse database

Data Warehouse Configuration

What is a data warehouse
Database vs data warehouse
Data Warehouse Vs Enterprise Data Warehouse
Hardware requirements for data warehouse
Configure database settings for a data warehouse
FTDW Sizing Tool

Designing a Data Warehouse

Logical design of a data warehouse
Physical design of a data warehouse: Part 1
Physical design of a data warehouse: Part 2
Designing Dimension Tables