|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/azure-data-fundamentals-hands-on-course-with-sims/
课程评论：没有评论
课程名称：DP-900 Azure 数据基础实践课程与模拟 课程概述：本课程由一位具有超过25年教学经验的讲师授课，他曾培训数千人，并拥有微软认证讲师资格。课程内容远远超出一般在线课程，特别适合数据领域新手。课程通过易于理解的讲解结合实践，让学员在没有经验的情况下也能跟随学习。通过实践和模拟，学员可以在真实环境中应用所学知识。 课程涵盖的主题包括： 1. 课程简介 2. 理解微软环境 3. Active Directory 域基础 4. RAS、DMZ 和虚拟化基础 5. 微软云服务基础 6. 手动实践准备 7. 创建免费的 Azure 账户 8. 激活 Entra ID P2 许可证 9. 数据表示方式 10. 结构化、半结构化和非结构化数据特征 11. 数据存储选项 12. 数据文件格式 13. 关系数据库与非关系数据库 14. 在 Azure 中创建关系数据库和非关系数据库 15. 常见数据工作负载及其特征 16. 数据库管理员和数据工程师的职责与权限 17. 关系概念及 Azure 关系数据服务 18. Azure 存储的功能及特色 19. 大规模分析的常见元素 20. 实时数据分析的考虑因素 21. Microsoft Power BI 中的数据可视化 课堂实践包括：使用 SQL、创建 Azure 虚拟机、使用 Azure Data Factory 复制数据、创建 Azure Synapse 工作区及清理实验环境等。 本课程全面深入，不仅让学员理解数据基础知识，还提供了实际操作的机会，帮助学员在未来的工作中更有效地使用 Azure 数据服务和工具。
We really hope you'll agree, this training is way more than the average course on Udemy! Have access to the following:Training from an instructor of over 25 years who has trained thousands of people and also a Microsoft Certified TrainerLecture that explains the concepts in an easy to learn method for someone that is just starting out with this materialInstructor led hands on and simulations to practice that can be followed even if you have little to no experienceTOPICS COVERED INCLUDING HANDS ON LECTURE AND PRACTICE TUTORIALS:IntroductionWelcome to the courseUnderstanding the Microsoft EnvironmentHaving a Solid Foundation of Active Directory DomainsHaving a Solid Foundation of RAS, DMZ, and VirtualizationHaving a Solid Foundation of the Microsoft Cloud ServicesOrder of concepts covered in the courseSetting up for hands onIMPORTANT Using Assignments in the courseCreating a free Azure AccountActivating Entra ID P2 licenseDescribe ways to represent dataFeatures of structured dataFeatures of semi-structuredFeatures of unstructured dataIdentify options for data storageUnderstanding formats for data filesRelational databases as a type of data storageCreating a relational database in Azure using Microsoft SQLInstalling SQL Server Management Studio (SSMS) for connecting to SQLConnecting to a SQL database with SSMSNon-relational databases as a type of data storageCreating a non-relational database in Azure using Microsoft CosmosConnecting to a Microsoft Cosmos databaseDescribe common data workloadsFeatures of transactional workloadsFeatures of analytical workloadsIdentify roles and responsibilities for data workloadsResponsibilities for database administratorsPermissions in Azure regarding a database administratorResponsibilities for data engineersPermissions in Azure regarding a data engineersResponsibilities for data analystsPermissions regarding a data analystsDescribe relational conceptsFeatures of relational dataNormalization and why it is usedCreating an Azure VM with Microsoft SQL serverUsing common structured query language (SQL) statementsA look at common database objectsDescribe relational Azure data servicesAzure SQL Family: Azure SQL Database, SQL Managed Instance, SQL Server on VMsAzure database services for open-source database systemsDescribe capabilities of Azure storageUnderstanding the capabilities of Azure storage accountsCreating a storage account to explore Blob, File, & Table storage capabilitiesSecuring a Azure storage accountUtilizing Azure Blob storageUtilizing Azure File storageUtilizing Azure Table storageDescribe capabilities and features of Azure Cosmos DBUse cases for Azure Cosmos DBUnderstanding the Azure Cosmos DB APIsDeleting the existing Cosmos DB before moving onCreating a new Cosmos DB account for NoSQLAdding and querying data within a Cosmos DB for NoSQLCleaning up our lab environment to this pointDescribe common elements of large-scale analyticsConsiderations for data ingestion and processingUnderstanding Azure Data Lake storageCreating an Azure Data Lake storage accountUnderstanding Azure DatabricksVisualizing Azure Synapse AnalyticsRegistering Azure Synapse as a resource provider in AzureSetting up a SQL DB and server for use with Azure Synapse AnalyticsCreating a Azure Synapse workspace and Data Lake Storage accountConcepts of SQL Pool usage with Azure Synapse AnalyticsPurposes of Azure HDInsightUnderstanding Azure Data FactorySetting up an Azure Data Factory resourcesUsing Azure Data Factory to copy data into Azure Synapse Analytics Describe consideration for real-time data analyticsUnderstanding the difference between batch and streaming dataConcepts of Azure Stream AnalyticsCreating an Azure Stream Analytics job for real-time analyticsBenefits of using Apache SparkCleaning up the existing resources before moving onDescribe data visualization in Microsoft Power BICapabilities of Power BIDownloading and installing Power BI DesktopCreating a database with data for testing Power BConnecting Power BI to a SQL database and performing an importFeatures of data models in Power BIUsing the appropriate visualizations for data
