



Search (advanced search) | ||||
Use this Search form before posting, asking or make a new thread.
|
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! |
|||