К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
SQL for Data Science Capstone Project · LearnSpace
Назад в каталог
courseraАнализ данных

SQL for Data Science Capstone Project

Курс от University of California, Davis
Средний≈ 35 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

Data SciencePeer ReviewData ModelingExploratory Data AnalysisText MiningData Import/ExportPresentationsBusiness MetricsDatabase DesignBusiness AnalyticsTarget AudienceSQLAnalytical SkillsData StorytellingData AnalysisStatistical AnalysisDescriptive StatisticsPerformance MetricDescriptive AnalyticsData Presentation

Программа курса

4 модулей · 57 учебных материалов

01Getting Started and Milestone 1: Project Proposal and Data Selection/Preparation19 материалов

Getting Started!

A Note from UC DavisЧтениеCourse Introduction and WelcomeВидеоYour Learning GoalsОбсуждение

Milestone 1: Project Proposal and Data Selection/Preparation

Учитесь у экспертов

Don Noxon

Research Data Scientist for Deep Insights AI at Intel

SQL for Data Science Capstone Project
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 35 ч

4 модулей

Язык: Английский

Субтитры: Арабский, Французский, Бенгальский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Вьетнамский, Нидерландский, Корейский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Дари, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
Milestone 1 IntroductionВидео
The Proposal ProcessВидео
Choose Your Client/DatasetЧтение
Import of Elon Musk DataВидео
Initial Feature Exploration / HypothesesВидео
Entity Relationship Diagram (ERD) for AnalysisВидео

Resources

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ВидеоConnecting to Mode AnalyticsЧтение

Milestone 1 Assignment

Welcome to Peer Review Assignments!ЧтениеMilestone 1: Project Proposal and Data Selection/PreparationВзаимная проверкаQuestions For Your PeersОбсуждение
02Milestone 2: Descriptive Stats & Understanding Your Data10 материалов

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Видео

Resources

Statistics Refresher (Optional)ВидеоAdditional ResourcesЧтение

Milestone 2 Assignment

Milestone 2: Descriptive StatsВзаимная проверкаQuestions For Your PeersОбсуждение
03Milestone 3: Beyond Descriptive Stats (Dive Deeper/Go Broader)7 материалов

Milestone 3: Beyond Descriptive Stats

Milestone 3 IntroductionВидеоTF-IDF for Word Frequency / Theme AnalysisВидеоText Analysis of Elon Musk TweetsВидео

Resources

Create a New MetricВидеоAnalyze ResultsВидео

Milestone 3 Assignment

Milestone 3: Beyond Descriptive StatsВзаимная проверкаQuestions For Your PeersОбсуждение
04Milestone 4: Presenting Your Findings (Storytelling)21 материалов

Milestone 4: Presenting Your Findings (Storytelling)

Milestone 4 IntroductionВидеоSample Output / PresentationВидео

Resources

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Чтение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ВидеоAdditional SQL Resources to ExploreЧтение

Milestone 4 Assignment

Milestone 4: Presenting Your Findings (Storytelling)Взаимная проверка

Summary

Course SummaryВидеоReflectionsОбсуждение