9.gif

Search (advanced search)
Use this Search form before posting, asking or make a new thread.
Tips: Use Quotation mark to search words (eg. "How To Make Money Online")

07-25-2023, 07:51 PM (This post was last modified: 07-25-2023 07:51 PM by Mr_SARS.)
Post: #1
[F4LT] Design a Data Warehouse with SQL Server and AdventureWorksDB
Leveraging AdventureWorks2016: Building a Data Warehouse from Scratch

New
Rating: 4.1 out of 5 (3 ratings)
683 students
1hr 8min of on-demand video
Created by Bluelime Learning Solutions
English
English [Auto]

What you'll learn:
An introduction to SQL and Transact-SQL (T-SQL).
Understanding the SQL Server as a Database Management System (DBMS).
The fundamentals of the AdventureWorks2016 database.
The concept and usage of a Relational Database Management System (RDBMS).
Basic SQL Server operations.
The core concepts of data warehousing.
The architecture and design of different types of data warehouses.
The importance and applications of Business Intelligence (BI).
How to design a Star Schema and Snowflake Schema in a data warehouse.
The creation and usage of Dimension and Fact tables.
The utilization of indexes and partitioning to optimize database performance.
The step-by-step process of designing a data warehouse.
Creation of a new data warehouse database.
Applying the learned concepts in a capstone project to design a data warehouse using the AdventureWorks2016 database.


Free Course:

https://www.udemy.com/course/design-a-data-warehouse-with-sql-server-and-adventureworksdb/

Have a nice day!




42.gif
Free counters!