|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-bootcamp-learn-mysql-for-data-analysis/
课程评论：没有评论
## 成为数据分析师必备技能 Coursera SQL 数据分析训练营总结 本课程是 Coursera 上的 "SQL BootCamp - Learn MySQL for Data Analysis"，专为希望从数据中获取洞察、获得竞争优势并希望进入数据库领域工作的学习者设计。该课程提供了超过14小时的内容，旨在教授学员掌握 SQL 的基础知识、数据库概念，并能够熟练编写 SQL 查询，帮助学员成功获得数据分析师职位。 **课程核心内容与大纲：** 1. **SQL 导论：** 介绍 SQL 的基本概念以及课程的学习目标。 2. **环境搭建：** 指导学员安装必要的工具，包括 MySQL 和示例数据库。 3. **SELECT 语句详解：** 重点讲解 SQL 的核心——SELECT 语句，并练习编写不同子句的查询。 4. **MySQL 内置函数：** 深入学习日期函数、NULL 值函数等各类内置函数。 5. **JOIN 操作：** 教授如何连接两个不同的数据表。 6. **集合运算符：** 介绍 SQL 中的各种集合运算符。 7. **高级 SELECT 语句：** 更深入地探讨 SELECT 语句的高级用法。 8. **数据修改：** 学习使用 SQL 修改现有数据。 9. **数据库与表创建：** 演示如何创建自己的数据库和表。 10. **其他 DDL 命令：** 学习 Drop、Truncate 等其他数据定义语言 (DDL) 命令。 11. **高级 SQL：** 探讨存储过程、索引、视图等高级 SQL 主题。 12. **附加内容：** 分享作者在数据分析领域的宝贵经验和技巧，并持续更新。 本课程无需任何 SQL 基础，将从零开始教授，并通过每个章节后的测验帮助学员巩固和提升技能。通过本课程的学习，学员将为成为一名优秀的数据分析师打下坚实的基础。
Do you want to be able to gain insights from your data? Will you like to have a competitive advantage over your peers? Do you want to be work with Databases but do not know where to start? If your answer is Yes! then this course is for you. This mega course offers over 14 hours of content and teaches you all you need to Land that SQL data analyst Job. SQL is one of the most in demand skills of Data analysts and with this course you will learn the foundations of SQL, Database concepts and practice writing SQL queries. I have also provided quizzes after every section to help you hone your skills. Course Outline1. IntroductionIn this section we introduce SQL and what we are going to learn2. Environment SetupHere we install all the tools we will use (MySQL and all the sample databases)3. All about selectSelect is the backbone of SQL. Here we practice writing select queries and also different clauses in SQL4. FunctionsHere we discuss in detail MySQL in-built functions like Date Functions, Null functions etc5. JoinsWe discuss how you can join two different tables 6. Set OperatorsHere we talk about the different set operators SQL handles7. Advanced select statementsWe look in More detail at the SQL select statements8. Modifying DataWe talk about how you can modify existing data using SQL9. Creating Databases and TablesHere we look at how you can create your own Databases and Tables10. Other DDL commandsWe look into Other DML commands like Drop, Truncate etc11.Advanced SQLHere we look at Stored procedures, Indexes, views etc12. Bonus SectionHere I give any important information that has helped me in the field. I will always be updating this for your benefit.This is an exciting Journey that I hope you take with me. I am not expecting you to know anything at all about SQL and will start from scratch. Cheers!Sandra
