|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-data-analytics-applications-in-the-real-world/
课程评论：没有评论
课程名称：SQL：真实世界中的数据分析应用 课程概述： 本课程将深入探讨如何在真实世界中应用数据分析，尤其是在各类企业和商业中使用的数据。本课程旨在扩展您在“SQL与Power BI：数据分析与可视化之旅”课程中所学到的知识，帮助您理解这些技能如何在实际中应用。 课程特色包括： - 终身访问：一旦注册，您将即时拥有所有课程章节的终身访问权，以及进行练习所需的数据文件和脚本。 - 分步学习：课程采用逐步的方法，您将不断获得更多的知识积累，帮助您掌握数据分析和数据可视化的专业技能。 - 内容丰富：课程提供超过8小时的清晰、结构化的内容，帮助您自信地开始数据分析之旅。 您将深入学习SQL，并了解如何定义和利用表之间的关系，包括： - 表模式的介绍和实际应用 - 理解表模式的方法论 - 创建表模式图以理解多个表之间的关系 - 了解主键和外键，以及如何定义和使用它们 - 创建新的表，定义数据类型和结构 - 向表中插入新数据 - 对列应用约束 - 修改表列的性质和属性 - 创建和利用公共表表达式（CTEs） 此外，课程中将包括四个独特的案例研究，应用本课程所涵盖的所有材料，这些案例基于实际场景。 学员评价： 许多学员对课程给予高度评价，称赞其内容易于理解并且能有效提升SQL应用能力，增加了在数据分析方面的自信心。 这个课程将帮助您在数据分析的旅程中迈出坚实的一步，适合希望深入了解SQL和数据分析的学员。
Reviews"Great course with easy-to-follow explanations and examples that helped me better understand how to apply SQL techniques. Well done." - Keith Franklin Talley"The instructor is extremely clear in explaining the SQL concepts" - Aman Carter"The perfect course to build up on the previous one, I felt my confidence increasing in terms of using SQL but to also take the step in to data analysis. Thank you Data Civilisation, you guys have been nothing but great" - Imran Khan"Amazing course! The cases are very clear. Concepts are well explained!"- Agustin Portilla-------------In this course, we will look at how data analytics can be applied in the real world on data which is utilised by different companies and businesses!We will be developing on the knowledge which we learnt in our ‘SQL & Power BI: Your Data Analytics & Visualisation Journey' course and understand how it can be utilised to in the real world.Upon enrolling, you'll gain instant, lifetime access to all sections of the course, as well as the data files and scripts necessary for the exercises.Our approach is a stepped approach, meaning that you will keep gaining more and more building blocks as you work through the lectures. This means you will be equipped with the necessary knowledge to conduct data analytics and visualise your data to a professional standard.You'll get access to all sections of the course that will teach you the fundamentals from the ground up, supported with over 8 hours of clear, structured content to start your data journey.In this course, you will dive deeper into SQL and understand the importance of how to define and utilise table relationships. You will also be introduced to new concepts and operations in SQL. The breakdown is as follows:An introduction into table schemas and how they can be used in real life applicationsUnderstanding the methodology of table schemasCreating table schema diagrams to understand the relationships between multiple tablesUnderstanding what Primary and Foreign keys are, and how to define and utilise themHow to create new tables where the data types and structure is definedInserting new rows of data into tablesApplying constraints to table columnsHow to alter the nature and properties of the table columnsCreating and utilising Common Table Expressions (CTEs)There will also be four unique case studies in this course which will apply all the material covered in this course. These case studies are based on real life scenarios!
