|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sqlintroduction/
课程评论：没有评论
**课程名称：** SQL for Data Science Bootcamp **课程概述：** 本课程深入探索 SQL 的强大功能，帮助您掌握查询、操作和组合数据集的技能。通过 Udemy 内置的编码练习，您将从零基础成长为 SQL 专家，并了解 SQL 在真实数据科学场景中的应用。您将扮演一家虚构的教育科技公司的“数据科学家”，学习如何利用 SQL 回答关于讲师、学生和课程的问题。本课程最大的特色在于，我们将立即开始 SQL 编码实践，无需任何软件安装。 **课程亮点：** * **短视频讲座：** 针对每个主题提供简明扼要的视频讲解。 * **40个动手编码练习：** 配备详细的解决方案，确保您获得 SQL 实践 mastery 所需的经验。 * **测验：** 用于评估和巩固您的学习成果。 **您将学到：** * SQL 的概念，以及 SQLite、PostgreSQL、MySQL 等不同方言的由来和区别。 * 基本的 SELECT 语句。 * ORDER BY 和 WHERE 子句的使用。 * INNER JOIN 和 LEFT JOIN 合并表。 * COUNT、SUM、AVG 等聚合函数，用于提取有意义的统计数据。 * 使用 OVER 和 PARTITION BY 的高级窗口函数，以及更多进阶内容！ **适合人群：** * 当前或未来的数据科学家和数据分析师。 * 任何希望通过互动式练习和提供详细解释的完整视频解决方案来学习 SQL 的学习者。
This course offers a deep dive into SQL's capabilities, giving you the skills to query, manipulate, and combine data sets.Using Udemy's built-in coding exercises, we will go from zero knowledge to advanced mastery of SQL, seeing how SQL is used in real-life data science situations. We will work together as data scientists for a fictional educational technology company and learn how to use SQL to answer questions regarding our instructors, students, and courses.Unlike other courses, we will start coding in SQL immediately, with no software installation required.Course Features:Short video lectures that introduce each topic40 hands-on coding exercises complete with solutions, ensuring you get the practical experience to master SQLQuizzes to assess and reinforce your understanding.What You'll Learn:What is SQL, and why are there dialects like SQLite, PostgreSQL, MySQL and others?Basic SELECT statementsORDER BYWHEREJoining tables with INNER JOIN and LEFT JOINAggregation functions like COUNT, SUM, and AVG to derive meaningful statistics.Advanced window functions with OVER and PARTITION BYand more!Who Should Enroll:Current or aspiring data scientists and data analystsAnybody who wants to learn SQL with interactive exercises and full video solutions with detailed explanations.
