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

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

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

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

Real-World SQL Projects - 5 Hands-On Case Studies

Курс от Packt
Начальный≈ 8.4 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. Gain practical SQL expertise by working through real-world datasets and solving business-focused problems across multiple domains. This course helps you build strong analytical thinking, improve query-writing skills, and develop a portfolio of hands-on projects that demonstrate your ability to extract actionable insights from data. You’ll begin by setting up your SQL environment and learning how to approach project-based learning effectively. Then, you’ll dive into your first case study analyzing IPL team data, followed by T20 cricket matches, where you’ll progressively tackle increasingly complex queries and uncover meaningful patterns. As you advance, you’ll work with diverse datasets including flight operations, hospital records, and retail superstore sales. You’ll also learn essential data cleaning techniques and consistently apply structured exploration methods to answer real-world questions while publishing your work on GitHub. This course is ideal for aspiring data analysts, SQL beginners, and professionals looking to gain hands-on experience. Basic familiarity with databases is helpful but not required, making this a beginner-friendly yet practical learning experience. By the end of the course, you will be able to design and execute SQL queries, analyze diverse datasets, clean and transform data, and publish end-to-end data projects using GitHub.

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

SQLAnalytical SkillsData CleansingData AnalysisData ManipulationData WranglingData PreprocessingQuery LanguagesRelational DatabasesData ModelingAnalytical TestingExploratory Data AnalysisCase StudiesGitHubProblem Solving

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

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

01Introduction & Setup4 материалов

Introduction & Setup

Course IntroductionВидеоFull Course ResourceЧтениеHow to Approach This CourseВидеоEnvironment SetupВидео
02SQL Case Study 1 – IPL Teams Analysis7 материалов

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

Packt - Course Instructors

Преподаватель курса

Real-World SQL Projects - 5 Hands-On Case Studies
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 8.4 ч

7 модулей

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

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Испанский, Японский

Часть программы вашего университета

SQL Case Study 1 – IPL Teams Analysis

Import the Data in SQL ServerВидеоData Exploration (Q1 to Q3)ВидеоData Exploration (Q4 to Q6)ВидеоData Exploration (Q7 to Q10)ВидеоPublish Files to GitHubВидеоExploring IPL Player Data with SQL QueriesDIALOGUESQL Case Study 1 – IPL Teams Analysis - AssessmentЗадание
03SQL Case Study 2 – T20 Cricket Matches Analysis7 материалов

SQL Case Study 2 – T20 Cricket Matches Analysis

Import the Data in SQL ServerВидеоData Exploration (Q1 to Q3)ВидеоData Exploration (Q4 to Q6)ВидеоData Exploration (Q7 to Q10)ВидеоPublish Files to GitHubВидеоExploring and Analyzing T20I Cricket Data in SQLDIALOGUESQL Case Study 2 – T20 Cricket Matches Analysis - AssessmentЗадание
04SQL Case Study 3 – Flight Data Analysis7 материалов

SQL Case Study 3 – Flight Data Analysis

Import the Data in SQL ServerВидеоData Exploration (Q1 to Q3)ВидеоData Exploration (Q4 to Q6)ВидеоData Exploration (Q7 to Q10)ВидеоPublish Files to GitHubВидеоExploring SQL JOINs with a Flight Database Case StudyDIALOGUESQL Case Study 3 – Flight Data Analysis - AssessmentЗадание
05SQL Case Study 4 – Hospital Data Analysis8 материалов

SQL Case Study 4 – Hospital Data Analysis

Import the Data in SQL ServerВидеоData CleaningВидеоData Exploration (Q1 to Q3)ВидеоData Exploration (Q4 to Q6)ВидеоData Exploration (Q7 to Q10)ВидеоPublish Files to GitHubВидеоHospital Data Cleaning and Exploration with SQLDIALOGUESQL Case Study 4 – Hospital Data Analysis - AssessmentЗадание
06SQL Case Study 5 – Superstore Data Analysis7 материалов

SQL Case Study 5 – Superstore Data Analysis

Import the Data in SQL ServerВидеоData Exploration (Q1 to Q3)ВидеоData Exploration (Q4 to Q6)ВидеоData Exploration (Q7 to Q10)ВидеоPublish Files to GitHubВидеоExploring Superstore Sales Data with SQL Joins and AggregationsDIALOGUESQL Case Study 5 – Superstore Data Analysis - AssessmentЗадание
07Summary3 материалов

Summary

Course SummaryВидеоFull Course Practice AssessmentЗаданиеFull Course AssessmentЗадание