|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-engineerdata-analyst-sql-azure-etl-ssis-bi/
课程评论：没有评论
课程名称：数据工程师/数据分析师 - SQL Azure ETL SSIS BI 概述： SQL（结构化查询语言）是数据专业人员的关键工具，是数据分析或数据科学领域就业的重要语言。每分钟都会生成数百万条数据，而原始数据并不能直接传达故事。当这些数据存储在数据库中时，专业人士使用SQL提取数据以进行进一步分析。Azure SQL是一系列在Azure云中使用SQL Server数据库引擎的管控、安全和智能产品。 Azure SQL数据库：支持现代云应用的智能、管控数据库服务，包含无服务器计算功能。 Azure SQL托管实例：在规模上现代化现有的SQL Server应用，提供几乎100%与SQL Server数据库引擎兼容的全面管理实例，适合大多数云迁移。 Azure虚拟机上的SQL Server：轻松迁移SQL Server工作负载，保持100%的SQL Server兼容性以及操作系统级访问权限。 Azure SQL建立在熟悉的SQL Server引擎之上，使您能够轻松迁移应用程序，并继续使用您熟悉的工具、语言和资源。您的技能和经验可以无缝转移到云中，使您能够更加有效地利用已有的资源。 提取、转换和加载（ETL）是用于从各种来源收集数据的数据管道，依据业务规则转换数据，并将其加载到目标数据存储中。SQL服务器集成服务（SSIS）是一个强大的商业智能工具，最适合与SQL Server数据库配合使用。当您安装SQL Server数据工具（SSDT）时，SSIS将被添加到SQL Server数据库中，从而为Visual Studio提供商业智能模板，用于创建集成项目。 Power BI是一种商业分析解决方案，可以让您可视化数据，并在整个组织中共享见解，或将其嵌入到应用或网站中。可以连接数百个数据来源，以实时仪表板和报告使数据生动呈现。学习如何快速从数据中提取见解，使用Power BI这一强大的商业分析工具集（包括Power BI服务、Power BI桌面版和Power BI移动版）可以更高效地创建和共享有影响力的可视化效果。 在本课程中，初学者将学习如何开始使用这一强大工具集。课程将覆盖连接和转换基于网络的数据源，学习如何在Power BI服务上发布和共享报告及可视化效果。
SQL or Structured Query Language is a critical tool for data professionals. It is undoubtedly the most important language for getting a job in the field of data analysis or data sciences. Millions of data points are being generated every minute. And raw data does not have any story to tell. After all this data gets stored in databases and professionals use SQL to extract this data for further analysis.Azure SQL is a family of managed, secure, and intelligent products that use the SQL Server database engine in the Azure cloud.Azure SQL Database: Support modern cloud applications on an intelligent, managed database service, that includes serverless compute.Azure SQL Managed Instance: Modernize your existing SQL Server applications at scale with an intelligent fully managed instance as a service, with almost 100% feature parity with the SQL Server database engine. Best for most migrations to the cloud.SQL Server on Azure VMs: Lift-and-shift your SQL Server workloads with ease and maintain 100% SQL Server compatibility and operating system-level access.Azure SQL is built upon the familiar SQL Server engine, so you can migrate applications with ease and continue to use the tools, languages, and resources you're familiar with. Your skills and experience transfer to the cloud, so you can do even more with what you already have.Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources, transform the data according to business rules, and load it into a destination data store. SQL Server Integration Services (SSIS) is a useful and powerful Business Intelligence Tool. It is best suited to work with SQL Server Database. It is added to SQL Server Database when you install SQL Server Data Tools (SSDT)which adds the Business Intelligence Templates to Visual studio that is used to create Integration projects.Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.Discover how to quickly glean insights from your data using Power BI. This formidable set of business analytics tools-which includes the Power BI service, Power BI Desktop, and Power BI Mobile-can help you more effectively create and share impactful visualizations with others in your organization.In this beginners course you will learn how to get started with this powerful toolset. We will cover topics like connecting to and transforming web based data sources. You will learn how to publish and share your reports and visuals on the Power BI service.
