Coursera
Coursera Logo

University of California, Davis - SQL for Data Science Capstone Project 

  • Offered byCoursera

SQL for Data Science Capstone Project
 at 
Coursera 
Overview

Duration

35 hours

Start from

Start Now

Total fee

Free

Mode of learning

Online

Difficulty level

Intermediate

Official Website

Explore Free Course External Link Icon

Credential

Certificate

SQL for Data Science Capstone Project
 at 
Coursera 
Highlights

  • This Course Plus the Full Specialization.
  • Shareable Certificates.
  • Graded Programming Assignments.
Details Icon

SQL for Data Science Capstone Project
 at 
Coursera 
Course details

More about 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.
Read more

SQL for Data Science Capstone Project
 at 
Coursera 
Curriculum

Getting Started and Milestone 1: Project Proposal and Data Selection/Preparation

Course Introduction and Welcome

Milestone 1 Introduction

The Proposal Process

Import of Elon Musk Data

Initial Feature Exploration / Hypotheses

Entity Relationship Diagram (ERD) for Analysis

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

A Note from UC Davis

Choose Your Client/Dataset

Connecting to Mode Analytics

Welcome to Peer Review Assignments!

Milestone 2: Descriptive Stats & Understanding Your Data

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

Statistics Refresher (Optional)

Additional Resources

Milestone 3: Beyond Descriptive Stats (Dive Deeper/Go Broader)

Milestone 3 Introduction

TF-IDF for Word Frequency / Theme Analysis

Text Analysis of Elon Musk Tweets

Create a New Metric

Analyze Results

Milestone 4: Presenting Your Findings (Storytelling)

Milestone 4 Introduction

Sample Output / Presentation

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

Course Summary

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

SQL for Data Science Capstone Project
 at 
Coursera 
Admission Process

    Important Dates

    May 25, 2024
    Course Commencement Date

    Other courses offered by Coursera

    – / –
    3 months
    Beginner
    – / –
    20 hours
    Beginner
    – / –
    2 months
    Beginner
    – / –
    3 months
    Beginner
    View Other 6715 CoursesRight Arrow Icon

    SQL for Data Science Capstone Project
     at 
    Coursera 
    Students Ratings & Reviews

    5/5
    Verified Icon1 Rating
    A
    Abhishek Gangadhar Dolhare
    SQL for Data Science Capstone Project
    Offered by Coursera
    5
    Learning Experience: Wow amazing mind blowing
    Faculty: Wow amazing mind blowing Wow amazing mind blowing
    Course Support: Wow amazing mind blowing
    Reviewed on 27 Aug 2022Read More
    Thumbs Up IconThumbs Down Icon
    View 1 ReviewRight Arrow Icon
    qna

    SQL for Data Science Capstone Project
     at 
    Coursera 

    Student Forum

    chatAnything you would want to ask experts?
    Write here...