|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/design-a-data-warehouse-with-sql-server-and-adventureworksdb/
课程评论：没有评论
课程名称：使用 SQL Server 和 AdventureWorksDB 设计数据仓库 课程概述：本课程旨在让学生掌握设计和实施数据仓库所需的基础知识和技能，数据仓库是现代数据基础设施的核心组成部分。通过对 SQL Server 这一领先数据库管理系统和 AdventureWorks2016 数据库（提供真实商业数据）的深度探索，学生将在数据仓库领域获得身临其境的体验。 课程的初始阶段将使学生熟悉关键数据仓库概念，这对于理解数据仓库的必要性至关重要。课程将覆盖数据仓库的具体需求，强调它们如何为企业提供复杂的数据分析、报告和决策支持。学生将深入了解数据仓库的组成部分以及不同类型的数据仓库，从而拓宽对数据存储结构多样性的理解。 课程还将介绍商业智能（Business Intelligence）与数据仓库之间的密切关系，让学生了解数据仓库如何支持数据驱动的决策，应用于各个行业。 课程的重点是掌握 SQL Server，这一创建和管理数据仓库的平台。学生不仅会熟悉软件，还将学习安装前提条件，确保他们能舒适地设置 SQL Server 环境。此外，课程还将介绍 SQL Server 内的重要操作及与数据库通信的查询语言 Transact-SQL（T-SQL）。 在整个课程中，AdventureWorks2016 数据库将作为实践工具，提供学生动手学习的机会，允许他们立即应用所学概念。通过这个多维样本数据库，学生将探索数据库管理系统（DBMS）和关系型数据库管理系统（RDBMS）的基础知识，增强对数据组织、访问和管理的理解。 随着课程的深入，学生将理解模式（schemas）这一关键概念，特别是星型（Star）和雪花（Snowflake）模式。通过逐步的 SQL 代码示例，他们将学习构建这些模式，从而获取构建和可视化数据仓库设计的实用知识。 数据仓库的一个重要方面是使用维度表（Dimension tables）和事实表（Fact tables）。学生将学习如何使用 AdventureWorks2016 数据库创建这些表，从而理解如何在仓库中结构化和连接不同类型的数据。课程还将教导如何通过索引（Indexes）和分区（Partitioning）优化数据库性能，这是在大型数据库中高效数据检索所必需的。 课程的最后一个项目将涉及使用 AdventureWorks2016 数据库设计数据仓库。学生将学习创建数据仓库数据库，并应用他们在模式、事实表、维度表和性能优化方面的综合知识。 本课程非常适合有志于成为数据专业人士的学生，强调实践应用和理论知识的结合，提供对数据仓库的全面理解。无论您是想成为数据分析师、数据库管理员还是数据科学家，还是希望增强商业数据处理技能，本课程都提供了有关使用 SQL Server 进行数据仓库的全面、有价值的见解。
In this course, students will acquire the foundational knowledge and skills necessary to design and implement a data warehouse - a core component of modern data infrastructure. This course offers an immersive exploration into the world of data warehousing using SQL Server, a leading database management system, and the AdventureWorks2016 database, which provides real-world business data.The initial phase of the course familiarizes students with key data warehousing concepts, an indispensable part of understanding the rationale behind data warehousing. It covers the specific need for data warehouses, highlighting how they facilitate complex data analysis, reporting, and decision-making tasks for businesses. Students will also delve into the components that constitute a data warehouse and learn about various types of data warehouses, thereby broadening their understanding of the diversity in data storage structures.The course transitions to Business Intelligence, revealing its integral relationship with data warehousing. Students will grasp how data warehouses underpin business intelligence processes, supporting data-driven decision-making across various industries.A significant focus of the course lies in mastering SQL Server, the platform used to create and manage the data warehouse. Students will not only familiarize themselves with the software but also learn the installation prerequisites, ensuring they can comfortably set up SQL Server environments. Essential operations within SQL Server will be covered alongside an introduction to Transact-SQL (T-SQL), the query language used for communicating with the database.The AdventureWorks2016 database will be utilized as a practical tool throughout the course. This multi-dimensional, sample database offers students a hands-on learning experience, allowing them to implement learned concepts immediately. Through this database, students will explore DBMS and RDBMS fundamentals, enhancing their comprehension of how data is organized, accessed, and managed.As the course advances, students will comprehend the critical concept of schemas, particularly Star and Snowflake schemas. Through step-by-step SQL code examples, they will learn to build these schemas, providing them with practical knowledge to construct and visualize data warehouse designs.A pivotal aspect of data warehousing is the use of Dimension and Fact tables. Students will learn to create these using the AdventureWorks2016 database, thereby understanding how to structure and connect different types of data within the warehouse. The course will also teach how to enhance database performance through Indexes and Partitioning, crucial for efficient data retrieval in large databases.The capstone of the course will involve designing a Data Warehouse using AdventureWorks2016. Students will learn to create a Data Warehouse Database and apply their cumulative knowledge of schemas, fact tables, dimension tables, and performance optimization to this process.Ideal for aspiring data professionals, this course emphasizes practical application alongside theoretical knowledge, providing a well-rounded understanding of data warehousing. Whether you're aiming for a role as a data analyst, database administrator, or data scientist, or just looking to augment your skills in handling business data, this course offers comprehensive, valuable insights into data warehousing using SQL Server.
