SQL for Data Science Capstone Project

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

Instructor: Don Noxon

Access provided by Google

38,920 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

4.2

(232 reviews)

Intermediate level

Some related experience required

35 hours to complete

3 weeks at 11 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

4.2

(232 reviews)

Intermediate level

Some related experience required

35 hours to complete

3 weeks at 11 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Develop a project proposal and select your data
Perform descriptive statistics as part of your exploratory analysis
Develop metrics and perform advanced techniques in SQL
Present your findings and make recommendations

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English

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

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

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

Data science is a dynamic and growing career field that demands knowledge and skills-based in SQL to be successful. This course is designed to provide you with a solid foundation in applying SQL skills to analyze data and solve real business problems.

Whether you have successfully completed the other courses in the Learn SQL Basics for Data Science Specialization or are taking just this course, this project is your chance to apply the knowledge and skills you have acquired to practice important SQL querying and solve problems with data. You will participate in your own personal or professional journey to create a portfolio-worthy piece from start to finish. You will choose a dataset and develop a project proposal. You will explore your data and perform some initial statistics you have learned through this specialization. You will uncover analytics for qualitative data and consider new metrics that make sense from the patterns that surface in your analysis. You will put all of your work together in the form of a presentation where you will tell the story of your findings. Along the way, you will receive feedback through the peer-review process. This community of fellow learners will provide additional input to help you refine your approach to data analysis with SQL and present your findings to clients and management.

In this first milestone, you will select your client and import your dataset. You will begin to explore your data to understand it and make assumptions about your data. You will draft a project proposal to act as a guide as you explore your data and prove or disprove your hypotheses.

What's included

12 videos4 readings1 peer review2 discussion prompts

12 videosTotal 48 minutes

Course Introduction and Welcome3 minutesPreview module
Milestone 1 Introduction1 minute
The Proposal Process3 minutes
Import of Elon Musk Data5 minutes
Initial Feature Exploration / Hypotheses8 minutes
Entity Relationship Diagram (ERD) for Analysis2 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
SQL in Notebooks3 minutes
Import Data2 minutes
Introduction of Data of Unknown Quality1 minute

4 readingsTotal 70 minutes

A Note from UC Davis10 minutes
Choose Your Client/Dataset30 minutes
Connecting to Mode Analytics20 minutes
Welcome to Peer Review Assignments!10 minutes

1 peer reviewTotal 420 minutes

Milestone 1: Project Proposal and Data Selection/Preparation420 minutes

2 discussion promptsTotal 20 minutes

Your Learning Goals10 minutes
Questions For Your Peers10 minutes

In this milestone, you will start to execute your project proposal. You will start looking at your data and perform initial statistic models to explore your data and determine what you have available to you.

What's included

7 videos1 reading1 peer review1 discussion prompt

7 videosTotal 38 minutes

Milestone 2 Introduction1 minutePreview module
Importance of Understanding Your Data2 minutes
Foundational Stats in SQL/Sheets9 minutes
Pandas Teach on Stats5 minutes
Visualization with raw graphics.io6 minutes
Impact of Findings on Hypotheses5 minutes
Statistics Refresher (Optional)8 minutes

1 readingTotal 20 minutes

Additional Resources20 minutes

1 peer reviewTotal 420 minutes

Milestone 2: Descriptive Stats420 minutes

1 discussion promptTotal 10 minutes

Questions For Your Peers10 minutes

In this milestone, you will go beyond the descriptive statistics you completed in the last milestone. This milestone is really about diving deeper to analyze your data, beyond descriptive stats. Maybe you need to analyze qualitative data or textual data to get a full picture.

What's included

5 videos1 peer review1 discussion prompt

In this milestone, you will present your findings. You will identify your audience and create a presentation tailored to them. You will be able to tell the story of analyses and make recommendations.