07-25-2023, 07:51 PM
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!
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!