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

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

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

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

SQL Problem Solving

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

О курсе

SQL for Problem Solving is designed for learners who already understand the basics of SQL and are ready to apply their skills to real-world data problems. In this hands-on course, you’ll move beyond textbook queries to tackle the challenges data analysts face every day. From diagnosing data quality issues to building rolling metrics and interpreting event data, this course gives you the toolkit to write powerful, efficient SQL queries across different dialects and complex datasets. You’ll learn: - Problem-solving strategies used by data professionals - Techniques for debugging, improving data quality, and building complex queries - How to work with modern data environments, from event logs to denormalized schemas - How to communicate business-relevant insights through SQL-based analysis Whether you're preparing for a data job interview, building dashboards for stakeholders, or leveling up your data chops, this course empowers you with the skills to make SQL your go-to tool for data analysis and problem-solving.

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

SQLData PresentationData AnalysisBusiness MetricsJSONData VisualizationData QualityData ManipulationQuery LanguagesData CleansingData ValidationBusiness ReportingForecastingComplex Problem SolvingPredictive Analytics

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

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

01Getting Started, SQL Review, and SQL Problem Solving Techniques32 материалов

Getting Started

Course IntroductionВидеоCourse Navigation and Safety StatementЧтениеThinking Like a Data Problem SolverDIALOGUE

Review Prerequisites

Prerequisites IntroductionВидео

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

Katrina Glaeser Poole

Senior Data Scientist at OpenSpace.ai

SQL Problem Solving
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 11.5 ч

4 модулей

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

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

Часть программы вашего университета
Set-UpВидео
Course DatasetЧтение
Various Set-Up VariationsВидео
Dataset Intro + Entity Diagram + Join ReviewВидео
Review: Entity DiagramsЗадание
Review SQL Clauses & FunctionsВидео
Solution: SQL Clauses & Functions - Part 1Видео
Solution: SQL Clauses & Functions - Part 2Видео
Review: Clauses and FunctionsЗадание
Review Joins, Subtables and CTESВидео
Solution: Review Joins, Subtables and CTES - Part 1Видео
Solution: Review Joins, Subtables and CTES - Part 2Видео
Review: Joins and SubtablesЗадание
Review by Troubleshooting ErrorsВидео
Solution: Troubleshooting ErrorsВидео
Review: Troubleshooting ErrorsЗадание
Spreadsheets vs. SQLВидео
Review: Spreadsheets vs. SQLЗадание

SQL Problem Solving Techniques

Introduction to SQL Problem Solving TechniquesВидеоQuick Tricks to Check Data QualityВидеоCoalesce to Improve Data QualityВидеоPivot and Roll-Up Data - Part 1ВидеоPivot and Roll-Up Data - Part 2ВидеоUsing a Backbone Table for StructureВидеоUse CTEs and Subqueries to Reduce ComplexityВидеоCan You Do Loops in SQL? - Part 1ВидеоCan You Do Loops in SQL? - Part 2Видео

Module 1 Review

SQL Problem Solving Techniques QuizЗадание
02The Modern Data Environment18 материалов

The Modern Data Environment

Introduction to the Modern Data EnvironmentВидеоWhere Does the Data Come From Anyway? - Part 1ВидеоWhere Does the Data Come From Anyway? - Part 2ВидеоNavigating the Modern Data EnvironmentDIALOGUEProduction Databases + SQL Dialects + HistoryВидеоSolution: Exploring the Events Table - Part 1ВидеоSolution: Exploring the Events Table - Part 2ВидеоAll About Event Data - Part 1ВидеоAll About Event Data - Part 2ВидеоEventsОбсуждениеDeep Dive - How to Use Field History TableВидеоSolution: Evaluate AI Generated Code - Part 1ВидеоSolution: Evaluate AI Generated Code - Part 2ВидеоData Pipelines - Part 1ВидеоData Pipelines - Part 2ВидеоSQL Style GuideВидеоReminders Of Where To Be SkepticalВидео

Module 2 Review

The Modern Data Environment QuizЗадание
03Using Data to Drive Business Decisions26 материалов

Business Focused Case Studies

Introduction to Business Focused Case StudiesВидеоApplications of SQL Data AnalysisВидеоNormalized vs. Denormalized DataВидеоUsing Data to Drive Business DecisionsDIALOGUEDenormalized Line Items Table - Part 1ВидеоDenormalized Line Items Table - Part 2ВидеоBONUS: Keyboard ShortcutsВидеоNormalized & Denormalized DataОбсуждениеWhat Makes a Good Executive Metric?ВидеоDefining Good MetricsВидеоItem_View MetricВидеоReporting Basics - Part 1ВидеоReporting Basics - Part 1 ExampleВидеоReporting Basics - Part 2ВидеоReporting Basics - Part 3ВидеоReporting Basics - Part 3 ExampleВидеоFunnels and How They Extend to Retention - Part 1ВидеоFunnels and How They Extend to Retention - Part 2ВидеоDeep Dive: Retention & LTVВидеоRetention Example: Period Over Period (PoP)ВидеоAB TestingВидеоExample of AB TestingВидеоGoing Beyond SQLВидеоExploratory Analysis & Case StudiesВидеоBusiness Focused Case Studies QuizЗадание

Apply Your Learning

From Question to Insight — The SQL Problem-Solving MindsetЗадание
04From Query to Insight - Solving Real Problems with SQL28 материалов

Data Science in the Wild

Introduction to Data Science in the WildВидеоTriage a Business QuestionВидеоScenario: Sloppy Question ClinicВидеоExample: Descriptive Statistics for DesignВидеоAnother Example: Which Segment is the Biggest?ВидеоInvestigating a DropВидеоMix ShiftВидеоProblem Solving: Getting Un-StuckВидеоTest As You GoВидеоCollaborative Filtering RecommenderВидеоItem Recommender: Start Coding - Part 1ВидеоItem Recommender: Start Coding - Part 2ВидеоData PreparationВидеоCreate Data to Feed a ForecastВидеоFrom Query to InsightDIALOGUEJust For Fun: How to Forecast in PythonВидеоDefine a Metric: ActivationВидеоFunnel Skill - Part 1ВидеоFunnel Skill - Part 2ВидеоFunnel Skill - Part 3ВидеоVisualization ClinicВидеоRemove DistractionsВидеоData Science in the Wild QuizЗадание

Interview Preparation

Interview Mindset and ToolsВидеоInterview Question BankЧтениеSQL Interview Simulation: Communicating Data InsightsDIALOGUE

Module 4 Review

From Data to Decision: Analyzing Insights with SQLЗадание

Course Summary

Course SummaryВидео