|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-azure-database-and-analytics/
课程评论:没有评论
课程名称:初学者的Azure数据工程技术[捆绑课程] 概述:微软Azure数据工程是数据科学从业者中增长最快、需求最强的职业之一。根据2019年Dice的报告,数据工程师的职位发布数量同比增长88%,是所有技术职位中增长率最高的。如果你对这个领域感兴趣,现在是学习这些微软Azure数据解决方案技术的最佳时机。 预期成果: 通过本课程,学员将能够: - Microsoft Azure SQL Server:识别合适的Azure SQL Server部署选项、购买模型和服务级别,并在云中进行部署,做好数据库安全配置。 - Microsoft Azure SQL数据仓库:在Azure云环境中部署Azure Synapse Analytics(前身为Azure SQL数据仓库),了解内部MPP架构,分析本地数据仓库并迁移数据至Azure数据仓库。 - Microsoft Azure数据湖:创建Azure数据湖存储账户,使用不同工具填充数据,并利用Databricks和HDInsight进行分析。 - Microsoft Azure数据工厂:理解Azure数据工厂的关键组成部分和优势,能够创建、调度和监控简单的管道。 - Hadoop基础知识:学习Hadoop生态系统的基本知识和三个主要构建块,为在Azure云中使用HDInsight学习大数据做准备。 - Microsoft Azure HDInsight:理解如何简化Hadoop的使用,通过示范从数据湖提取数据、通过Hive处理数据并存储到SQL Server。 - Cosmos DB:掌握Cosmos DB的基本概念,创建新数据库、容器和文档,选择合适的分区键,配置全球分布及使用其他重要功能。 目标受众: - 对微软Azure平台感兴趣的初学者 - Microsoft Azure数据工程师 - Microsoft Azure数据科学家 - 数据库和BI开发人员 - 数据库管理员 - 数据分析师或类似职位 - 希望学习如何在Azure云中实施这些技术的本地数据库相关职位 - 有意向成为Azure数据工程师的任何人 课程内容: 本课程提供视频讲座、PPT、演示资源、测验、作业等,学员将获得终身访问及未来更新,结业后颁发课程证书,并提供30天退款保证。 课程更新: 定期添加新内容和讲座,保持课程的现代性和实用性。 学生反馈: 许多学员认为本课程讲解清晰详尽,适合初学者,并表示教授对课程主题有深厚的理解,非常推荐给希望进入这一领域的人。
Why Microsoft Azure Data Engineer?Microsoft Azure Date Engineering is one of the fastest-growing and in-demand occupations among Data Science practitioners. According to a 2019 Dice report, there was an 88% year-over-year growth in job postings for data engineers, which was the highest growth rate among all technology jobs.If you are interested in this domain, there cannot be a better time to start learning these Microsoft Azure Data Solution technologies. Expected OutcomesAfter this course:Microsoft Azure SQL Server - You will be able to identify the right Azure SQL Server deployment option, purchasing model and service tier according to requirements and will be able to deploy it in the cloud. You will be able to set up a security configuration to secure your database.Microsoft Azure SQL Data Warehouse - You will able to deploy Azure Synapse Analytics (formerly known as Azure SQL Data warehouse) in Azure Cloud environment. You will have good internal MPP architecture understanding, and so you will be able to analyze your on-premises data warehouse and migrate data to Azure Data Warehouse. Microsoft Azure Data Lake - You will be able to create Azure Data Lake storage account, populate it will data using different tools and analyze it using Databricks and HDInsightMicrosoft Azure Data Factory - You will understand Azure Data Factory's key components and advantages. You will be able to create, schedule and monitor simple pipelines.Hadoop Basics - You will learn the fundamental understanding of the Hadoop Ecosystem and 3 main building blocks. This module will prepare you to start learning Big Data in Azure Cloud using HDInsight.Microsoft Azure HDInsight - We will understand how HDInsight makes Hadoop easy, and we will go through simple demo where we'll fetch data from Data Lake, process it through Hive and later will store data in SQL Server.Cosmos DB - You will understand all basic concepts of Cosmos DB, and will be able to create a new database, container, documents, and choose right partition key, configure the global distribution and use other important featuresStreaming Service - I will add details soonDatabricks - Video lessons added, I will add details here soonStorage Service - Video lessons added, I will add details soonIntended AudienceBeginners in Microsoft Azure PlatformMicrosoft Azure Data EngineersMicrosoft Azure Data ScientistDatabase and BI developersDatabase AdministratorsData Analyst or similar profilesOn-Premises Database related profiles who want to learn how to implement these technologies in Azure Cloud.Anyone who is looking forward to starting his career as an Azure Data Engineer.LevelBeginners (100)"if you are already experienced and working on these technologies, this may not be the best course for you."I have a few crash courses (Free) for absolute beginners, you can find links on my website. PrerequisitesBasic T-SQL and Database conceptsMicrosoft Azure Free trial SubscriptionLanguageEnglishIf you are not comfortable in English, please do not take a course, captions are not good enough to understand the course.What's insideVideo lectures, PPTs, Demo Resources, Quiz, Assignment, other important linksFull lifetime access with all future updatesCertificate of course completion30-Day Money-Back GuaranteeCourse updatesI am consistently adding new content in terms of both lectures and demos. Please find below logs for past and upcoming changes. Previous Updates:Jan 2021 - Revised Synapse module with all new changesAug 2020 - Data Encryption related lessons addedJuly 2020 - Monitoring and Optimization of servicesJuly 2020 - AMS (Azure Monitoring Service)July 2020 - Re-recorded Azure Data Factory with all new updatesJuly 2020 - NoSQL Databases in Microsoft Azure (Azure Blob Storage)July 2020 - Added Azure Databricks ModuleJuly 2020 - Added Azure Streaming Analytics ModuleJune 2020 - Added Azure Cosmos DB ModuleMay 2020 - Full-length course on Data LakeApr 2020 - Added modules on Azure cloud computing basics, and Data Engineer profileApr 2020 - Added crash course on cloud computing and data warehouseMar 2020 - Added Azure Synapse AnalyticsFeb 2020 - Added Azure SQL DatabaseOct 2019 - Added Azure HDInsightSep 2019 - Added Azure Data FactoryAug 2019 - Course Created on Azure Data LakeCourse In DetailBy the end of this courseMicrosoft Azure SQL Server - You will know the advantages of Azure Database over on-premises DatabaseYou will be able to provision all three types of Azure Database PaaS Deployments (Single, Elastic Pool, Managed Instance)You will learn different purchasing models and Service tiers and how to configure them according to requirements.You will be able to provision Azure Database in Virtual Machine (IaaS)You will be able to deploy Elastic Pool Database and able to add/remove more databases from the pool.You will be able to deploy the Managed Instance Database, configure it and connect it with your SQL Server Management studio.Microsoft Azure Synapse Analytics ServiceYou will learn why we should consider warehousing solutions in the cloud.You will learn about Microsoft's brand new Azure Synapse analytics service, and how this service brings together enterprise data warehousing and Big Data analytics, and provide a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.You will learn the difference between Traditional vs Modern vs Synapse Architecture.You will learn Azure famous MPP (Massive Parallel Processing) architectureYou will also learn many internal concepts like Data Distribution, Sharding, and partitioning. You will learn different migration methods and best practices.You will learn PolyBase setup (Best Loading method)You will perform a lot of demos to migrate data to Azure SQL Data warehouse using SSIS, Data Factory and PolyBase.Microsoft Azure Data Lake Gen1You will learn the limitations of traditional database systems to handle the Big Data revolution. You will learn the difference between Azure Data Lake, SSIS, Hadoop and Data Warehouse. You will be able to create Azure Data Lake Gen1 storage account, populate it will data and analyze it using U-SQL Language. Microsoft Azure Data Factory - You will understand Azure Data Factory's key components and advantages. You will be able to create, schedule and monitor simple pipelines.Hadoop Basics You will learn a fundamental understanding of the Hadoop Ecosystem and 3 main building blocks. This module will prepare you to start learning Big Data in Azure Cloud using HDInsight.Microsoft HDInsight - You will learn what are the challenges with Hadoop and how HDInsight solves these challenges. You will also learn Cluster types, HDInsight Architecture and other important aspects of Azure HDInsight.You will also go through demo where we'll fetch data from Data Lake, process it through Hive and later will store data in SQL Server.Some students FeedbackOne of the most amazing courses i have ever taken on Udemy. Please don't hesitate to take this course. The instructor is really professional and has a great experience about the subject of the course. - Khadija BadaryVery nicely explained most of the concepts. a must have course for beginners - Manoranjan SwainI appreciate this course explaining everything in great detail for a beginner. This will assist me in overcoming challenges at my work - Benjamin CurtisGood course for Beginners. Labs are really helpful to grasp the concept. Thank you - Sapna