|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/etlsql-developer-toolkit-ms-sql-server-ssisetlssrsssas/
课程评论：没有评论
课程名称：ETL/SQL开发工具包：MS SQL Server, SSIS, ETL, SSRS, SSAS 课程概述：ETL/SQL开发工具包是构建高效、可扩展ETL管道的基本工具和技术，专注于使用微软SQL Server。本综合培训项目涵盖了ETL/SQL开发工具包的所有核心组件，包括MS SQL Server、SSIS、ETL、SSRS和SSAS。课程旨在为开发人员和数据专业人士提供设计、开发和部署复杂ETL解决方案所需的技能与知识。学生将学习如何使用T-SQL创建存储过程，这是一种用于管理和操作SQL Server数据库数据的强大语言。 课程内容包括SQL Server集成服务（SSIS），学生将学习如何创建用于数据提取、转换和加载的SSIS包。此外，课程还涵盖SQL Server报告服务（SSRS），学生将学习如何使用SSRS设计和构建报告，探索报告的发布和部署功能。课程还涉及SQL Server分析服务（SSAS），学生将学习如何使用SSAS创建表格模型。 总体而言，本课程全面概述了ETL/SQL开发工具包，涵盖了使用MS SQL Server开发高效ETL管道所需的所有基本组件和最佳实践。无论您是数据专业人士、开发人员还是IT专业人士，这门课程都是掌握微软SQL Server ETL开发的重要一步。
The ETL/SQL Developer Toolkit is an essential set of tools and techniques for building efficient and scalable ETL pipelines using Microsoft SQL Server. This comprehensive training program covers all the core components of the ETL/SQL Developer Toolkit, including MS SQL Server, SSIS, ETL, SSRS, and SSAS. The course is designed to provide developers and data professionals with the skills and knowledge they need to design, develop, and deploy complex ETL solutions using Microsoft SQL Server. Students will then learn how to use create stored procedures using T-SQL, which is a powerful language used for managing and manipulating data in SQL Server databases. The course covers core components of the ETL/SQL Developer Toolkit, beginning with SQL Server Integration Services (SSIS). Students will learn how to create SSIS packages for data extraction, transformation, and loading.The course covers how to create reports with SQL Server Reporting Services (SSRS). Students will learn how to design and build reports using SSRS, and explore features like publishing and deploying reports in SQL Server.The course also covers SQL Server Analysis Services (SSAS), which is used for designing and developing Tabular models. Students will learn how to create a Tabular model using SSAS.Overall, this course provides a comprehensive overview of the ETL/SQL Developer Toolkit, covering all the essential components and best practices for developing efficient ETL pipelines using MS SQL Server. Whether you're a data professional, developer, or IT professional, this course is an essential step towards mastering ETL development with Microsoft SQL Server.
