|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-and-databases/
课程评论：没有评论
课程名称：从0到1：SQL和数据库 - 数据处理重任 课程概述：该课程不需要任何先决条件，了解SQL命令和数据库管理系统（DBMS）基础知识是足够的。如果您希望在课程结束项目中运行源代码，具备基本的Python编程知识会有所帮助。课程由斯坦福大学毕业的前谷歌员工教授，拥有数十年的量化交易、分析和电子商务实践经验。该课程旨在帮助您应对日益增长的数据挑战，内容强大却友好，风趣而深刻，生动而深思。 当数据量过大时，Excel成为一个基本的决策和建模工具，但一旦数据超出了Excel的处理范围，就需要转向数据库。该课程的设计让您在转向数据库时不会感到害怕，不论数据集有多大或复杂，都能让您理解。课程内容深入探讨人们通常觉得困难的主题，如关联、聚合运算符等，同时保持幽默感。该课程内容非常直观，借助动画帮助理解，且实用性强，查询详细解释，索引也得以解密，同时标记潜在的职业限制陷阱（如Drop, Alter），避免您误入雷区。 课程特点独特，实例风趣，包含许多小细节，如重复、全局视角、活跃学习和大量测验，配以活泼的背景音乐和艺术表现，旨在提高认知和记忆。课程内容涵盖：深度学习SQL、数据库基础知识、实用例子 - 在MySQL和SQLite中的查询以及Python代码。 此课程适合希望深入学习SQL和数据库的人士，带您从零基础开始走向数据处理的更高阶段。
Prerequisites: No prerequisites are needed for the SQL commands and DBMS fundamentals. Basic knowledge of programming in Python would be helpful if you want to run the source code in the course-ending project. Taught by Stanford-educated, ex-Googlers. This team has decades of practical experience in quant trading, analytics and e-commerce. Your bodyguard for when data gets too big, this course is strong but friendly, funny yet deep, animated yet thoughtful. Let's parse that. Your bodyguard for when data gets too big: Most business folks (and quite a few engineers) use Excel as a basic tool of decision making and modeling, but when you can't fit the data you'd like into an Excel spreadsheet that you can easily open, its time to move to a database. The course is strong but friendly: This course will help you move to a database without being intimidated by the new environment. Don't let anyone tell you that any dataset is too large or too complicated for you to understand (and people will try, most likely) The course is funny yet deep: It goes really deep into the topics that folks often find hard to understand, such as joins, aggregate operators and interfacing with databases from a programming language. But it never takes itself too seriously:-) The course is very visual: most of the techniques are explained with the help of animations to help you understand better. This course is practical as well: Queries are explained in excruciating detail, indices are demystified, and potentially career-limiting traps (Drop, Alter) are marked with bright yellow tape markers so you can steer clear. The course is also quirky. The examples are irreverent. Lots of little touches: repetition, zooming out so we remember the big picture, active learning with plenty of quizzes. There's also a peppy soundtrack, and art - all shown by studies to improve cognition and recall. What's Covered: SQL In Great Depth Database Fundamentals and Just Enough Theory Practical Examples - Queries in MySQL and SQLite, and code in Python
