课程信息
4.4
884 个评分
264 个审阅
100% online

100% online

立即开始,按照自己的计划学习。
可灵活调整截止日期

可灵活调整截止日期

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

初级

完成时间(小时)

完成时间大约为19 小时

建议:4 weeks of study, 3-5 hours/week...
可选语言

英语(English)

字幕:英语(English)...

您将获得的技能

Data ScienceData AnalysisSqliteSQL
100% online

100% online

立即开始,按照自己的计划学习。
可灵活调整截止日期

可灵活调整截止日期

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

初级

完成时间(小时)

完成时间大约为19 小时

建议: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....
Reading
11 个视频(共 52 分钟), 2 个阅读材料, 4 个测验
Video11 个视频
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分钟
Reading2 个阅读材料
SQL Overview15分钟
Data Modeling and ER Diagrams35分钟
Quiz4 个练习
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....
Reading
9 个视频(共 49 分钟), 1 个阅读材料, 3 个测验
Video9 个视频
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分钟
Reading1 个阅读材料
SQL for Various Data Science Languages25分钟
Quiz3 个练习
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....
Reading
10 个视频(共 56 分钟), 2 个阅读材料, 3 个测验
Video10 个视频
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分钟
Reading2 个阅读材料
SQL and Python10分钟
Union and Union All10分钟
Quiz3 个练习
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. ...
Reading
10 个视频(共 53 分钟), 3 个阅读材料, 3 个测验
Video10 个视频
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分钟
Reading3 个阅读材料
Additional SQL Resources to Explore15分钟
Welcome to Peer Review Assignments!10分钟
Yelp Dataset SQL Lookup5分钟
Quiz2 个练习
Module 4 Quiz30分钟
Module 4 Coding Questions35分钟

讲师

Avatar

Sadie St. Lawrence

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

关于 University of California, Davis

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....

常见问题

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

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

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