SQL for Data Science

This course is part of Learn SQL Basics for Data Science Specialization

Instructor: Sadie St. Lawrence

What you'll learn

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.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

14 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your subject-matter expertise

This course is part of the Learn SQL Basics for Data Science Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

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!

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.

What's included

11 videos3 readings4 assignments2 discussion prompts

11 videosTotal 51 minutes

Course Introduction4 minutesPreview module
Module Introduction1 minute
What is SQL Anyway?7 minutes
Data Models, Part 1: Thinking About Your Data5 minutes
Data Models, Part 2: The Evolution of Data Models3 minutes
Data Models, Part 3: Relational vs. Transactional Models5 minutes
Retrieving Data with a SELECT Statement4 minutes
Creating Tables7 minutes
Creating Temporary Tables4 minutes
Adding Comments to SQL5 minutes
Summary1 minute

3 readingsTotal 60 minutes

A Note from UC Davis10 minutes
SQL Overview15 minutes
Data Modeling and ER Diagrams35 minutes

4 assignmentsTotal 100 minutes

Module 1 Quiz30 minutes
Module 1 Coding Questions10 minutes
Let's Practice!30 minutes
Practice Simple Select Queries30 minutes

2 discussion promptsTotal 40 minutes

Your Goals For This Course10 minutes
Comparing NoSQL and SQL30 minutes

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.

What's included

9 videos1 reading3 assignments

9 videosTotal 49 minutes

Module Introduction1 minutePreview module
Basics of Filtering with SQL8 minutes
Advanced Filtering: IN, OR, and NOT7 minutes
Using Wildcards in SQL6 minutes
Sorting with ORDER BY4 minutes
Math Operations4 minutes
Aggregate Functions6 minutes
Grouping Data with SQL5 minutes
Putting it All Together3 minutes

1 readingTotal 25 minutes

SQL for Various Data Science Languages25 minutes

3 assignmentsTotal 105 minutes

Module 2 Quiz30 minutes
Module 2 Coding Assignment45 minutes
Module 2 Practice Quiz30 minutes

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.

What's included

10 videos2 readings3 assignments1 discussion prompt

10 videosTotal 58 minutes

Module Introduction1 minutePreview module
Using Subqueries6 minutes
Subquery Best Practices and Considerations8 minutes
Joining Tables: An Introduction5 minutes
Cartesian (Cross) Joins4 minutes
Inner Joins8 minutes
Aliases and Self Joins5 minutes
Advanced Joins: Left, Right, and Full Outer Joins7 minutes
Unions5 minutes
Summary5 minutes

2 readingsTotal 20 minutes

SQL and Python10 minutes
Union and Union All10 minutes

3 assignmentsTotal 105 minutes

Module 3 Quiz30 minutes
Module 3 Coding Assignment45 minutes
Practice Quiz - Writing Queries30 minutes

1 discussion promptTotal 20 minutes

What do you think you'll use?20 minutes

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.

What's included

11 videos3 readings4 assignments1 discussion prompt

11 videosTotal 55 minutes

Module Introduction1 minutePreview module
Working with Text Strings7 minutes
Working with Date and Time Strings5 minutes
Date and Time Strings Examples5 minutes
Case Statements7 minutes
Views6 minutes
Data Governance and Profiling5 minutes
Using SQL for Data Science, Part 15 minutes
Using SQL for Data Science, Part 26 minutes
USDA Acknowledgment Video2 minutes
Course Summary2 minutes

3 readingsTotal 61 minutes

Additional SQL Resources to Explore15 minutes
Final Project Instructions, Scripts, & Datasets45 minutes
USDA Acknowledgment1 minute

4 assignmentsTotal 155 minutes

Module 4 Quiz30 minutes
Module 4 Coding Questions35 minutes
Final Project45 minutes
Practice Final Project45 minutes

1 discussion promptTotal 15 minutes

How do you Plan on Using SQL in the Future?15 minutes

Instructor

Instructor ratings

4.7 (4,670 ratings)

Sadie St. Lawrence

University of California, Davis

4 Courses651,431 learners

Offered by

University of California, Davis

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

4.6

16,588 reviews

5 stars
73.68%
4 stars
19.91%
3 stars
3.47%
2 stars
1.43%
1 star
1.49%

Showing 3 of 16588

Reviewed on Oct 5, 2022

Amazing course for beginners! The entire course is well structured and has good hands-on assignments. SQL is extremely essential for Database management and fun learning so please do try this one out!

Reviewed on Nov 17, 2020

Well it was a short course, the assignments are a little bit repetitive (mostly in the last). The course reviews every 'practical' aspects of SQL, how to assemble the bricks while writing queries,...

Reviewed on Mar 25, 2022

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.

View more reviews