课程信息
382,014 次近期查看

100% 在线

立即开始,按照自己的计划学习。

可灵活调整截止日期

根据您的日程表重置截止日期。

初级

完成时间大约为20 小时

建议:4 weeks of study, 3-5 hours/week...

英语(English)

字幕:英语(English)

您将获得的技能

Data ScienceData AnalysisSqliteSQL

100% 在线

立即开始,按照自己的计划学习。

可灵活调整截止日期

根据您的日程表重置截止日期。

初级

完成时间大约为20 小时

建议:4 weeks of study, 3-5 hours/week...

英语(English)

字幕:英语(English)

教学大纲 - 您将从这门课程中学到什么

1
完成时间为 3 小时

Getting Started and Selecting & Retrieving Data with SQL

In this module, you will be able to define SQL and discuss how SQL differs from other computer languages. You will be able to compare and contrast the roles of a database administrator and a data scientist, and explain the differences between one-to-one, one-to-many, and many-to-many relationships with databases. You will be able to use the SELECT statement and talk about some basic syntax rules. You will be able to add comments in your code and synthesize its importance.

...
11 个视频 (总计 52 分钟), 2 个阅读材料, 4 个测验
11 个视频
Module Introduction1分钟
What is SQL Anyway?7分钟
Data Models, Part 1: Thinking About Your Data5分钟
Data Models, Part 2: The Evolution of Data Models3分钟
Data Models, Part 3: Relational vs. Transactional Models5分钟
Retrieving Data with a SELECT Statement4分钟
Creating Tables7分钟
Creating Temporary Tables4分钟
Adding Comments to SQL5分钟
Summary1分钟
2 个阅读材料
SQL Overview15分钟
Data Modeling and ER Diagrams35分钟
4 个练习
Let's Practice!10分钟
Practice Simple Select Queries20分钟
Module 1 Quiz30分钟
Module 1 Coding Questions10分钟
2
完成时间为 3 小时

Filtering, Sorting, and Calculating Data with SQL

In this module, you will be able to use several more new clauses and operators including WHERE, BETWEEN, IN, OR, NOT, LIKE, ORDER BY, and GROUP BY. You will be able to use the wildcard function to search for more specific or parts of records, including their advantages and disadvantages, and how best to use them. You will be able to discuss how to use basic math operators, as well as aggregate functions like AVERAGE, COUNT, MAX, MIN, and others to begin analyzing our data.

...
9 个视频 (总计 49 分钟), 1 个阅读材料, 3 个测验
9 个视频
Basics of Filtering with SQL8分钟
Advanced Filtering: IN, OR, and NOT7分钟
Using Wildcards in SQL6分钟
Sorting with ORDER BY4分钟
Math Operations4分钟
Aggregate Functions6分钟
Grouping Data with SQL5分钟
Putting it All Together3分钟
1 个阅读材料
SQL for Various Data Science Languages25分钟
3 个练习
Module 2 Practice Quiz22分钟
Module 2 Quiz30分钟
Module 2 Coding Assignment45分钟
3
完成时间为 3 小时

Subqueries and Joins in SQL

In this module, you will be able to discuss subqueries, including their advantages and disadvantages, and when to use them. You will be able to recall the concept of a key field and discuss how these help us link data together with JOINs. You will be able to identify and define several types of JOINs, including the Cartesian join, an inner join, left and right joins, full outer joins, and a self join. You will be able to use aliases and pre-qualifiers to make your SQL code cleaner and efficient.

...
10 个视频 (总计 56 分钟), 2 个阅读材料, 3 个测验
10 个视频
Using Subqueries6分钟
Subquery Best Practices and Considerations5分钟
Joining Tables: An Introduction5分钟
Cartesian (Cross) Joins4分钟
Inner Joins8分钟
Aliases and Self Joins6分钟
Advanced Joins: Left, Right, and Full Outer Joins7分钟
Unions5分钟
Summary5分钟
2 个阅读材料
SQL and Python10分钟
Union and Union All10分钟
3 个练习
Practice Quiz - Writing Queries10分钟
Module 3 Quiz30分钟
Module 3 Coding Assignment45分钟
4
完成时间为 5 小时

Modifying and Analyzing Data with SQL

In this module, you will be able to discuss how to modify strings by concatenating, trimming, changing the case, and using the substring function. You will be able to discuss the date and time strings specifically. You will be able to use case statements and finish this module by discussing data governance and profiling. You will also be able to apply fundamental principles when using SQL for data science. You'll be able to use tips and tricks to apply SQL in a data science context.

...
10 个视频 (总计 53 分钟), 3 个阅读材料, 3 个测验
10 个视频
Working with Text Strings7分钟
Working with Date and Time Strings5分钟
Date and Time Strings Examples5分钟
Case Statements7分钟
Views6分钟
Data Governance and Profiling5分钟
Using SQL for Data Science, Part 15分钟
Using SQL for Data Science, Part 26分钟
Course Summary2分钟
3 个阅读材料
Additional SQL Resources to Explore15分钟
Welcome to Peer Review Assignments!10分钟
Yelp Dataset SQL Lookup5分钟
2 个练习
Module 4 Quiz30分钟
Module 4 Coding Questions35分钟
4.5
491 个审阅Chevron Right

42%

完成这些课程后已开始新的职业生涯

35%

通过此课程获得实实在在的工作福利

10%

加薪或升职

来自SQL for Data Science的热门评论

创建者 AMJun 8th 2019

Great introductory to the SQL programming. This will definitely not only add another programming skill but also give me more capabilities programming in SAS. I would recommend this to anyone.

创建者 MSMar 11th 2019

Great course i had a very good learning experience from this course and what i was expecting from this course i got that knowledge and i am very happy to take this course. thank you so much.

讲师

Avatar

Sadie St. Lawrence

Data Scientist at VSP Global
Founder and CEO Women in Data (WID)

关于 加州大学戴维斯分校

UC Davis, one of the nation’s top-ranked research universities, is a global leader in agriculture, veterinary medicine, sustainability, environmental and biological sciences, and technology. With four colleges and six professional schools, UC Davis and its students and alumni are known for their academic excellence, meaningful public service and profound international impact....

常见问题

  • 注册以便获得证书后,您将有权访问所有视频、测验和编程作业(如果适用)。只有在您的班次开课之后,才可以提交和审阅同学互评作业。如果您选择在不购买的情况下浏览课程,可能无法访问某些作业。

  • 您购买证书后,将有权访问所有课程材料,包括评分作业。完成课程后,您的电子课程证书将添加到您的成就页中,您可以通过该页打印您的课程证书或将其添加到您的领英档案中。如果您只想阅读和查看课程内容,可以免费旁听课程。

还有其他问题吗?请访问 学生帮助中心