Monthly Subscription Starting at AED 99 + VAT

SQL for Data Science Capstone Project
  • Level Professional
  • Duration 35 hours
  • Course by University of California, Davis
  • Offered by

About

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.

Modules

Getting Started!

    • 1 Videos
    • 1 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Your Learning Goals

1 Videos

  • Course Introduction and Welcome

1 Readings

  • A Note from UC Davis

Milestone 1: Project Proposal and Data Selection/Preparation

    • 5 Videos
    • 1 Readings
Show info about module content

5 Videos

  • Milestone 1 Introduction
  • The Proposal Process
  • Import of Elon Musk Data
  • Initial Feature Exploration / Hypotheses
  • Entity Relationship Diagram (ERD) for Analysis

1 Readings

  • Choose Your Client/Dataset

Resources

    • 6 Videos
    • 1 Readings
Show info about module content

6 Videos

  • Data Models, Part 1: Thinking About Your Data
  • Data Models, Part 2: The Evolution of Data Models
  • Data Models, Part 3: Relational vs. Transactional Models
  • SQL in Notebooks
  • Import Data
  • Introduction of Data of Unknown Quality

1 Readings

  • Connecting to Mode Analytics

Milestone 1 Assignment

    • 1 Readings
    • 1 Discussion
    • 1 PeerReview
Show info about module content

1 Peer Review

  • Milestone 1: Project Proposal and Data Selection/Preparation

1 Discussions

  • Questions For Your Peers

1 Readings

  • Welcome to Peer Review Assignments!

Milestone 2: Descriptive Stats & Understanding Your Data

    • 6 Videos
Show info about module content

6 Videos

  • Milestone 2 Introduction
  • Importance of Understanding Your Data
  • Foundational Stats in SQL/Sheets
  • Pandas Teach on Stats
  • Visualization with raw graphics.io
  • Impact of Findings on Hypotheses

Resources

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Statistics Refresher (Optional)

1 Readings

  • Additional Resources

Milestone 2 Assignment

    • 1 Discussion
    • 1 PeerReview
Show info about module content

1 Peer Review

  • Milestone 2: Descriptive Stats

1 Discussions

  • Questions For Your Peers

Milestone 3: Beyond Descriptive Stats

    • 3 Videos
Show info about module content

3 Videos

  • Milestone 3 Introduction
  • TF-IDF for Word Frequency / Theme Analysis
  • Text Analysis of Elon Musk Tweets

Resources

    • 2 Videos
Show info about module content

2 Videos

  • Create a New Metric
  • Analyze Results

Milestone 3 Assignment

    • 1 Discussion
    • 1 PeerReview
Show info about module content

1 Peer Review

  • Milestone 3: Beyond Descriptive Stats

1 Discussions

  • Questions For Your Peers

Milestone 4: Presenting Your Findings (Storytelling)

    • 2 Videos
Show info about module content

2 Videos

  • Milestone 4 Introduction
  • Sample Output / Presentation

Resources

    • 9 Videos
    • 7 Readings
Show info about module content

9 Videos

  • Module Introduction
  • Working with Text Strings
  • Working with Date and Time Strings
  • Date and Time Strings Examples
  • Case Statements
  • Views
  • Data Governance and Profiling
  • Using SQL for Data Science, Part 1
  • Using SQL for Data Science, Part 2

7 Readings

  • Resources on the Who, What, Why, and How
  • Resources on Audience
  • Dashboard and Storytelling with Data
  • Finding the Story
  • Prioritizing, Optimizing and Designing the Data Story
  • Tell the Story of Your Data
  • Additional SQL Resources to Explore

Milestone 4 Assignment

    • 1 Discussion
    • 1 PeerReview
Show info about module content

1 Peer Review

  • Milestone 4: Presenting Your Findings (Storytelling)

1 Discussions

  • Questions For Your Peers

Summary

    • 1 Videos
    • 1 Discussion
Show info about module content

1 Discussions

  • Reflections

1 Videos

  • Course Summary

Auto Summary

Embark on a comprehensive journey to hone your data science skills with the **SQL for Data Science Capstone Project**. This course is meticulously designed for those seeking to deepen their expertise in SQL within the burgeoning field of Data Science & AI. Guided by Coursera, this professional-level course empowers you to tackle real-world business problems using SQL. Throughout the project, you'll apply your SQL knowledge to analyze data, developing a significant, portfolio-worthy project from start to finish. Ideal for those who have completed the Learn SQL Basics for Data Science Specialization, or even newcomers with SQL experience, the course offers a practical, hands-on approach to mastering SQL querying. You'll begin by selecting a dataset and creating a project proposal, followed by an in-depth data exploration and statistical analysis. As you uncover insightful analytics, you'll devise new metrics based on emerging patterns. The culmination of your hard work will be a compelling presentation of your findings, enhanced by peer feedback to refine your analytical skills and presentation prowess. With a duration of 2100 minutes, this course is available under the Starter subscription plan, making it accessible for professionals eager to elevate their data analysis capabilities. Join a community of like-minded learners and advance your career by mastering SQL for Data Science.

Don Noxon
Instructor

Don Noxon