Data science is a dynamic and growing field requiring SQL skills for success. This course provides a solid foundation in applying SQL to analyze data and solve real business problems. Learn to develop a project proposal, perform descriptive statistics, and present findings, all while receiving feedback from a community of fellow learners.
Certificate Available ✔
Get Started / More Info
The SQL for Data Science Capstone Project consists of four modules covering project proposal and data selection, descriptive statistics, advanced SQL techniques, and presenting findings through storytelling.
The first module, "Getting Started and Milestone 1: Project Proposal and Data Selection/Preparation," introduces the course and guides learners through developing a project proposal, selecting data, and exploring data models. You will also connect to Mode Analytics and engage in peer review assignments.
The second module, "Milestone 2: Descriptive Stats & Understanding Your Data," delves into the importance of understanding data, foundational statistics in SQL, and visualization techniques. Learners will gain insights into the impact of findings on initial hypotheses and engage in peer feedback.
The third module, "Milestone 3: Beyond Descriptive Stats (Dive Deeper/Go Broader)," focuses on advanced techniques such as TF-IDF for word frequency analysis, text analysis of tweets, and creating new metrics for analysis. Learners will analyze results and participate in peer discussions.
The final module, "Milestone 4: Presenting Your Findings (Storytelling)," covers storytelling with data, working with text and date strings, utilizing SQL for data science, and resources for designing a compelling data story. Learners will prioritize and optimize their data story and engage in reflections and peer feedback.
Applied Data Science with R equips learners with the essential skills to work with data in R, from data manipulation and analysis to creating visualizations and...
SAS Visual Business Analytics course equips learners with skills in data exploration, interactive reporting, and dashboard design using SAS Visual Analytics and...
Data Analysis with SQL: Inform a Business Decision
Introduction to Data Analytics for Business is a comprehensive course that provides a strong foundation in data analytics practices, from the information lifecycle...