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 |
Credential | Certificate |
SQL for Data Science Capstone Project at Coursera Highlights
- This Course Plus the Full Specialization.
- Shareable Certificates.
- Graded Programming Assignments.
SQL for Data Science Capstone Project at Coursera Course details
- 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.
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
Other courses offered by Coursera
SQL for Data Science Capstone Project at Coursera Students Ratings & Reviews
- 4-51