|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-warehouse-developer-sql-serveretlssisssasssrst-sql/
课程评论：没有评论
课程名称：数据仓库开发者-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL 课程简介：本课程旨在教授如何设计和实施数据仓库解决方案。学生将学习如何使用Microsoft SQL Server创建数据仓库，通过SQL Server集成服务（ETL）实现数据提取、转换和加载，并使用SQL Server数据质量服务和主数据服务对数据进行验证和清洗。数据仓库开发者的主要责任包括：实施数据仓库、开发用于数据提取、转换和加载的SSIS包、使用主数据服务确保数据完整性、利用数据质量服务进行数据清洗。 课程要求：学生需具备关系数据库的工作经验，包括设计规范化数据库、创建表和关系、利用Transact-SQL进行查询，同时需有基本编程构造（如循环和分支）的基础知识。了解收入、盈利能力和财务会计等关键商业优先事项的背景会有所帮助。 课程内容： - 部署和配置SSIS包。 - 下载和安装SQL Server。 - 下载和附加AdventureworksDW数据库。 - 下载和安装SSDT。 - 下载和安装Visual Studio。 - 描述数据仓库概念及架构考虑。 - 选择合适的数据仓库硬件平台。 - 设计和实施数据仓库。 - 在SSIS包中实现数据流和控制流。 - 调试和排除SSIS包的故障。 - 实施支持增量数据提取和加载的ETL解决方案。 - 通过Microsoft数据质量服务进行数据清洗。 - 实施主数据服务以确保数据完整性。 - 使用自定义脚本和组件扩展SSIS。 在课程中，学生还将学习如何在数据仓库中消费数据、选择星型和雪花设计模式、探索源数据、实施数据流等内容。随着数据量的不断增加，SQL（结构化查询语言）作为标准的数据库交互语言，在诸如Microsoft SQL Server、Oracle、PostgreSQL和MySQL等关系管理数据库系统中应用广泛。学生将掌握SQL和Transact-SQL的基础知识，包括创建数据库、创建表、创建视图、读取和更新数据、备份和恢复数据库等技能。
This course describes how to design and implement a data warehouse solution. students will learn how to create a data warehouse with Microsoft SQL Server implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. The Primary responsibilities of a data warehouse developer include:Implementing a data warehouse.Developing SSIS packages for data extraction, transformation, and loading.Enforcing data integrity by using Master Data Services.Cleansing data by using Data Quality Services.Prerequisites:Experience of working with relational databases, including:Designing a normalized database.Creating tables and relationships.Querying with Transact-SQL.Some exposure to basic programming constructs (such as looping and branching).An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.Students will learn how to:••Deploy and Configure SSIS packages.••Download and installing SQL Server ••Download and attaching AdventureworksDW database••Download and installing SSDT••Download and installing Visual studio••Describe data warehouse concepts and architecture considerations.••Select an appropriate hardware platform for a data warehouse.••Design and implement a data warehouse.••Implement Data Flow in an SSIS Package.••Implement Control Flow in an SSIS Package.••Debug and Troubleshoot SSIS packages.••Implement an ETL solution that supports incremental data extraction.••Implement an ETL solution that supports incremental data loading.••Implement data cleansing by using Microsoft Data Quality Services.••Implement Master Data Services to enforce data integrity.••Extend SSIS with custom scripts and components.••Databases vs. Data warehouses••Choose between star and snowflake design schemas••Explore source data••Implement data flow••Debug an SSIS package••Extract and load modified data••Enforce data quality••Consume data in a data warehouseThe volume of data available is huge and increasing daily. Structured Query Language -SQL (pronounced as sequel) is the standard language used to communicate and interact with data stored in relational management database systems like Microsoft SQL Server Oracle, PostgreSQL,MySQL etc.Different database management systems have their own proprietary version of the SQL language but they all conform to using some commands in SQL the same way. Microsoft SQL Server's version of SQL is known as Transact-SQL (T-SQL).You will learn the basics of the SQL language and Transact-SQL since both use certain commands in the same way.What You will learn includes:Installing SQL ServerInstall SSMSBasic Database ConceptsCreating DatabaseCreating TableCreating ViewsCreating stored proceduresReading data from a databaseUpdating database recordsBacking up databaseDeleting RecordsTruncating TableDropping TableDropping DatabaseRestore Database
