|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sqletldata-warehouse-developer-ms-sql-ssis-ssrs-ssas/
课程评论：没有评论
课程名称：SQL/ETL/数据仓库开发者 - (MS-SQL, SSIS, SSRS, SSAS) 课程概述：该课程旨在教授数据仓库的基础知识，数据仓库是数据分析、人工智能和机器学习的信息中央存储库。课程内容涵盖数据如何从不同的数据源（如事务数据库）流入数据仓库，并定期更新以便及时做出明智决策。 Microsoft SQL Server是微软开发的一款关系数据库管理系统，主要功能是根据其他软件应用的请求存储和检索数据。这些应用可以在同一计算机上或通过网络在其他计算机上运行。 SQL Server集成服务（SSIS）是SQL Server数据库软件的一个组件，用于执行广泛的数据迁移任务。SSIS是一个用于数据集成和工作流应用的平台，提供了一个用于数据提取、转换和加载的数据仓库工具。 SQL Server报表服务（SSRS）是微软提供的一种基于服务器的报表生成软件系统，属于Microsoft SQL Server服务套件的一部分，包括SSAS和SSIS。该服务通过Web界面进行管理，能够准备和交付各种交互式和打印报告。 Microsoft SQL Server分析服务（SSAS）是一种在线分析处理和数据挖掘工具，帮助组织分析和理解可能分布在多个数据库或不同表格或文件中的信息。 ETL（提取、转换、加载）是将来自多个来源的数据提取、转换和加载到数据仓库或其他统一数据存储库的过程。 本课程为数据专业人士提供必要的技能，帮助他们在现代数据管理和分析领域中脱颖而出。
A data warehouse is the central repository of information for data analysis, artificial intelligence, and machine learning. Data flows from different data sources like transactional databases. The data is also updated regularly to make informed decisions on time.Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications-which may run either on the same computer or on another computer across a network.SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading.SQL Server Reporting Services is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS and SSIS. Administered via a Web interface, it can be used to prepare and deliver a variety of interactive and printed reports.Microsoft SQL Server Analysis Services is an online analytical processing and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files.ETL is a process that extracts, transforms, and loads data from multiple sources to a data warehouse or other unified data repository.
