本課程是 Learn SQL Basics for Data Science 專項課程專項課程的一部分

4.6
星
14,359 個評分

Sadie St. Lawrence

487,279 人已註冊

提供方

Learn SQL Basics for Data Science 專項課程加州大学戴维斯分校

課程信息

865,107 次近期查看

As data collection has increased exponentially, so has the need for people skilled at using and interacting with data; to be able to think critically, and provide insights to make better decisions and optimize their businesses. This is a data scientist, “part mathematician, part computer scientist, and part trend spotter” (SAS Institute, Inc.). According to Glassdoor, being a data scientist is the best job in America; with a median base salary of $110,000 and thousands of job openings at a time. The skills necessary to be a good data scientist include being able to retrieve and work with data, and to do that you need to be well versed in SQL, the standard language for communicating with database systems.
This course is designed to give you a primer in the fundamentals of SQL and working with data so that you can begin analyzing it for data science purposes. You will begin to ask the right questions and come up with good answers to deliver valuable insights for your organization. This course starts with the basics and assumes you do not have any knowledge or skills in SQL. It will build on that foundation and gradually have you write both simple and complex queries to help you select data from tables.  You'll start to work with different types of data like strings and numbers and discuss methods to filter and pare down your results. 

You will create new tables and be able to move data into them. You will learn common operators and how to combine the data. You will use case statements and concepts like data governance and profiling. You will discuss topics on data, and practice using real-world programming assignments. You will interpret the structure, meaning, and relationships in source data and use SQL as a professional to shape your data for targeted analysis purposes. 

Although we do not have any specific prerequisites or software requirements to take this course, a simple text editor is recommended for the final project. So what are you waiting for? This is your first step in landing a job in the best occupation in the US and soon the world!

可靈活調整截止日期

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

可分享的證書

完成後獲得證書

100% 在線

立即開始，按照自己的計劃學習。

第 1 門課程（共 4 門）

Learn SQL Basics for Data Science 專項課程

初級

完成時間大約為14 小時

英語（English）

對員工進行熱門技能培訓能否為您的公司帶來益處？

體驗 Coursera 企業版

您將學到的內容有

Identify a subset of data needed from a column or set of columns and write a SQL query to limit to those results.
Use SQL commands to filter, sort, and summarize data.
Create an analysis table from multiple queries using the UNION operator.
Manipulate strings, dates, & numeric data using functions to integrate data from different sources into fields with the correct format for analysis.

您將獲得的技能

Data Science
Data Analysis
Sqlite
SQL

可靈活調整截止日期

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

可分享的證書

完成後獲得證書

100% 在線

立即開始，按照自己的計劃學習。

第 1 門課程（共 4 門）

Learn SQL Basics for Data Science 專項課程

初級

完成時間大約為14 小時

英語（English）

對員工進行熱門技能培訓能否為您的公司帶來益處？

體驗 Coursera 企業版

授課教師

授課教師評分

4.66/5 （3,995 個評分）

Sadie St. Lawrence

Founder and CEO Women in Data (WID)

Continuing and Professional Education

492,541 個學生

3 門課程

提供方

加州大学戴维斯分校

了解頂級公司的員工如何掌握熱門技能

了解關於 Coursera for Business 的更多信息

授課大綱 - 您將從這門課程中學到什麼

內容評分91%（47,636 個評分）

週

週 1

完成時間為 4 小時

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.

完成時間為 4 小時

11 個視頻（總計 52 分鐘）, 2 個閱讀材料, 4 個測驗

11 個視頻

Course Introduction4分鐘

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!30分鐘

Practice Simple Select Queries30分鐘

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.

完成時間為 3 小時

9 個視頻（總計 49 分鐘）, 1 個閱讀材料, 3 個測驗

9 個視頻

Module Introduction1分鐘

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 Quiz30分鐘

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.

完成時間為 3 小時

10 個視頻（總計 56 分鐘）, 2 個閱讀材料, 3 個測驗

10 個視頻

Module Introduction1分鐘

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 Queries30分鐘

Module 3 Quiz30分鐘

Module 3 Coding Assignment45分鐘

週

週 4

完成時間為 4 小時

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.

完成時間為 4 小時

10 個視頻（總計 53 分鐘）, 3 個閱讀材料, 3 個測驗

10 個視頻

Module Introduction1分鐘

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

3788 條評論

5 stars
73.58%
4 stars
20.31%
3 stars
3.43%
2 stars
1.32%
1 star
1.34%

來自SQL FOR DATA SCIENCE的熱門評論

由 SS 提供2022年3月25日

This is a great introductory course, highlights the most inportant things in syntax and speeds up from simple queries to complex joins... the best thing about this course are the coding assignments.

由 MV 提供2020年7月19日

Please Included examples while the instructor is teaching in the video lectures. The instructor is very talented in teaching but due to lack of examples in the video it downgrades the overall course.

由 AV 提供2021年9月11日

This course provided the necessary knowledge to use SQL effectively in deriving insights from data stored in database management systems. The exercises and quizes helped reinforce lessons learned.

由 NC 提供2020年10月18日

I really liked the course, I learned too much. The explanation is clear, appropriate activities and very good traceability. I really enjoyed it, I will definitely apply what I learned in my career.

查看所有評論

關於 Learn SQL Basics for Data Science 專項課程

This Specialization is intended for a learner with no previous coding experience seeking to develop SQL query fluency. Through four progressively more difficult SQL projects with data science applications, you will cover topics such as SQL basics, data wrangling, SQL analysis, AB testing, distributed computing using Apache Spark, Delta Lake and more. These topics will prepare you to apply SQL creatively to analyze and explore data; demonstrate efficiency in writing queries; create data analysis datasets; conduct feature engineering, use SQL with other data analysis and machine learning toolsets; and use SQL with unstructured data sets.

常見問題

我什么时候能够访问课程视频和作业？
讲座和作业的访问权限取决于您的注册类型。如果您以旁听模式参加课程，则可以免费查看大多数课程资料。要访问评分作业并获得证书，您需要在旁听期间或之后购买证书体验。如果看不到旁听选项：
课程可能不提供旁听选项。您可以尝试免费试用，也可以申请助学金。
课程可能会改为提供'完整课程，没有证书'。通过此选项，您可以查看所有课程材料、提交所要求的作业，以及获得最终成绩。这也意味着您将无法购买证书体验。
我订阅此专项课程后会得到什么？
您注册课程后，将有权访问专项课程中的所有课程，并且会在完成课程后获得证书。您的电子课程证书将添加到您的成就页中，您可以通过该页打印您的课程证书或将其添加到您的领英档案中。如果您只想阅读和查看课程内容，可以免费旁听课程。
有助学金吗？
是的。如果您负担不起学习计划的注册费，则可以在选择学习计划时申请助学金或奖学金。如果您选择的学习计划提供助学金或奖学金，则您将在描述页面上看到一个申请链接。

還有其他問題嗎？請訪問學生幫助中心。

培養員工技能，推動業務成果

探索 Coursera for Business

SQL for Data Science

課程信息

您將學到的內容有

您將獲得的技能