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

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

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

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

Data Analysis Using SQL

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

О курсе

In this comprehensive course, you will embark on a transformative journey to master the art of analyzing data through SQL. SQL is a powerful tool used for managing and manipulating data in relational databases. Throughout this course, you will acquire the essential skills to efficiently extract relevant data from databases, empowering you to navigate through vast amounts of information with ease. With a focus on practical application, you will delve into the world of data analysis, discovering how to derive meaningful insights from large datasets housed within complex relational databases. By the end of this course, you will Gain skills to create and modify databases, equipping you with the ability to solve real-world business problems. Learn to filter and clean datasets, ensuring the accuracy and reliability of your analysis. Whether you aspire to be a data analyst, a business intelligence professional, or a decision-maker relying on data-driven insights, this course will provide you with the necessary tools and knowledge to succeed.

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

SQLData ManipulationData AnalysisDatabase DesignQuery LanguagesDatabasesDatabase ManagementCase StudiesRelational DatabasesMySQL WorkbenchData Cleansing

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

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

01Introduction to Data Analysis using SQL15 материалов

Are your spreadsheets too slow?

Gateway to the CourseВидеоSyllabus - Data Analysis using SQLЧтение

Introduction to Data Analysis using SQL

Database and Why Relational Database?Видео

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

Analytics Vidhya

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

Data Analysis Using SQL
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 17.7 ч

5 модулей

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

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

Часть программы вашего университета
Ungraded Quiz: Check your UnderstandingЗадание
History of Databases and Introduction to NoSQL DatabaseЧтение
Choosing the Right RDBMSВидео
Installation of the Software (Windows, Linux, and Mac)Чтение
Introduction to the UI of MySQLВидео
Case Study - FoodHunter || Import DataВидео
Optional: Mysql Ungraded LabЛабораторная
Writing Your First Code to Explore ORDERS Table - Part 1Видео
Writing Your First Code to Explore ORDERS Table - Part 2Видео
Mastering Your SQL Foundation: From Data Retrieval to Analysis ReadinessDIALOGUE
Graded Assignment Задание
Code Glossary - Week 1Чтение
02Data Analysis with SQL on a Single Table10 материалов

Data Analysis with SQL on a Single Table

Understanding the Monthly SalesВидеоAnalyzing the Trend In Sales for FoodHunterВидеоVarious Factors Affecting Revenue - Hypothesis GenerationВидеоFactors Affecting RevenueОбсуждениеDid Discounts Have Any Impact on SalesВидеоDid Day Have Any Impact on SalesВидеоMysql Ungraded LabЛабораторнаяUngraded Assignment - Check Your UnderstandingЗаданиеEnd of Week Graded Assignment ЗаданиеCode Glossary - Week 2 Чтение
03Advanced functions on Single Tables in SQL11 материалов

Advanced functions on Single Tables in SQL

Understand Percentage Change in Sales Over MonthsВидеоUnderstanding Window FunctionsВидеоUngraded - Check Your UnderstandingЗаданиеCompare Month-On-Month Change in RevenueВидеоInsights Based on Delivery TimeВидеоMidweek Practice Question - Analysing the Food Habits of Customers Based on Meal of the DayЧтениеMidweek Practice Question - SolutionЧтениеInsights based on Average Delivery TimeОбсуждениеOptional: Mysql Ungraded LabЛабораторнаяGraded Assignment: Analysing the Food Habits of Customers Based on Meal Of The DayЗаданиеCode Glossary - Week 3Чтение
04Analyzing Multiple Tables in SQL8 материалов

Analysing Food Preferences and Food Items

A Sneak Peek into the ModuleВидеоCombine Information from Different Tables Using JoinsВидеоJoins in SQL - Additional ReadingЧтениеAnalysing the Food Preferences of CustomersВидеоFinding Restaurants With No Items Ordered!ВидеоOptional: Mysql Ungraded LabЛабораторнаяEnd of week Graded Assignment - Managing Multiple Tables using SQL ЗаданиеCode Glossary - Week 4Чтение
05CRUD Operations in SQL14 материалов

CRUD operations in SQL

Complete Recall and A Gist of the ModuleВидеоConverting Raw Data into a Structured Relational DatasetВидеоImporting Data using the Table Import WizardВидеоUnderstanding Percentage Change in Competitor Revenue vs FoodHunter RevenueВидеоHow to Remove Data from TablesЧтениеUngraded Quiz: Check your Understanding ЗаданиеCode Glossary - Week 5 Lesson 1Чтение

Global Problem Statement

Introduction to the Global Problem StatementВидеоBasic Querying of DataВидеоProduct Based Analysis of SalesВидеоImpact of Campaign on Sales of ProductsВидеоMySQL Ungraded LabЛабораторнаяEnd of Week AssessmentЗадание
Code Glossary - Week 5 Lesson 2Чтение