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

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

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

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

Intro to Data Analytics, SQL, and EDA Using Python

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

О курсе

The ability to understand and work with data has become increasingly important in today's world, where data is ubiquitous and valuable. This course covers a range of topics, including what data is and its different types, what big data looks like, and how companies are using it. It also explores the fields of data analysis and data science and how the two come together. To help form the field of data analytics, we'll look at the entire data analytics process and how it works, from defining the analytics problem to interpreting and presenting the results. We'll also look at some case studies, which are presented to illustrate the application of data analytics in real-world scenarios.

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

SQLPandas (Python Package)Exploratory Data AnalysisData Visualization SoftwareData AnalysisRelational DatabasesMatplotlibData ScienceSeabornData VisualizationAnalyticsQuery LanguagesData StorageData LiteracyData ManagementData StoreData Storage TechnologiesDatabase ManagementBig DataBusiness Analytics

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

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

01Module 1: Introduction to Data & Data Analytics and Defining the Problem17 материалов

Welcome!

How To Use Data - Specialization IntroВидеоIntro to Data Analytics, SQL, and EDA Using Python - Course IntroВидеоAbout The InstructorВидео

Lesson 1: Intro to Data

Module 1 ResourcesЧтение

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

Brandon Krakowsky

Lecturer

Intro to Data Analytics, SQL, and EDA Using Python
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 16.8 ч

3 модулей

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

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

Часть программы вашего университета
Module 1 Intro: Data & Data Analytics, Defining the ProblemВидео
Intro to Data & Data AnalyticsВидео
Programming Languages and Tools Used in This CourseЧтение
Learning Check - Intro to DataЗадание

Lesson 2: Intro to Data Science and Data Analysis

Intro to Data Science and Data Analysis Видео

Lesson 3: Intro to Data Analytics

Intro to Data AnalyticsВидеоHearst Case Study: Data Analytics ProcessВидео

Lesson 4: Defining the Analytics Problem

Defining the Analytics ProblemВидеоFelix Case Study: Defining the problemВидеоLearning Check - Intro to Data Analysis, Data Science, and Data AnalyticsЗадание

Weekly Assignment

💻 Codio Demo - SQL 💻ВидеоAssignment 1 - Retention Rate IncreaseЗаданиеOpt-in to Penn Engineering Online CommunicationsЧтение
02Module 2: Introduction to Data Wrangling and SQL36 материалов

Lesson 1: Intro to Data Storage and Access

Module 2 ResourcesЧтениеModule 2 Intro: Intro to Data Wrangling using SQLВидеоWays to Store DataЧтение

Lesson 2: Intro to SQL

Intro to SQLВидео

Lesson 3: Overview of Relational Databases

Overview of Relational DatabasesВидеоGetting Started With DBeaverЧтение

Lesson 4: Selecting and Querying Data

💻 Coding demo: Connecting to SQLite Database in DBeaver 💻ВидеоIntro to Selecting and Querying DataВидеоExecuting SQL with Keyboard ShortcutsЧтение💻 Coding demo: Basic SELECT Statements 💻ВидеоCommon Comparison OperatorsВидео💻 Coding demo: Filtering Records and Sorting Data 💻Видео

Lesson 5: Joining Data

Joining DataВидеоRIGHT JOINЧтениеPrimary Keys and Foreign Keys for Tables in Example2 DatabaseВидео💻 Coding Demo: INNER JOIN and LEFT JOIN 💻ВидеоPractice Assignment: Basics of Joining DataВнешний инструмент

Lesson 6: Single-Row Functions and Group Functions

Single-Row FunctionsВидеоSingle-Row Function SyntaxЧтение💻 Coding Demo: Single-Row Functions 💻ВидеоGroup FunctionsВидеоAdditional Group Function SyntaxЧтение💻 Coding Demo: Group Functions💻Видео

Lesson 7: Creating, Updating, and Deleting Data

Creating DataВидеоUpdating and Deleting DataЧтение💻 Coding Demo: CREATE Table and INSERT INTO 💻ВидеоLearning Check - MySQLЗадание

Lesson 8: Importing, Exporting, and Formatting Data

Importing and Exporting Data Видео💻 Coding Demo: Loading Data in SQLite 💻ВидеоFormatting DataВидео💻 Coding Demo: Formatting Data 💻Видео

Weekly Assignment

Assignment 2 - Creating, Updating, and Deleting DataВнешний инструмент
03Module 3: Exploratory Data Analysis (EDA) Using Python35 материалов

Lesson 1: Loading, Inspecting, & Querying Data

Module 3 ResourcesЧтениеModule 3 Intro: Overview of Exploratory Data Analysis (EDA) ВидеоLoading, Inspecting, and Querying DataВидеоReading: More About the Pandas ModuleЧтение💻 Coding Demo: Loading and Inspecting Data 💻Видео💻 Coding Demo: Querying Data 💻ВидеоOpt-in to Penn Engineering Online CommunicationsЧтение💻Codio Demo - Jupyter Notebook💻ВидеоPractice Assignment: Restaurant Data with Consumer RatingsВнешний инструмент

Lesson 2: Casting and Cleaning Data

💻 Coding Demo: Casting Data 💻ВидеоDifferent Ways of Casting DataЧтение💻 Coding Demo: Cleaning Data 💻ВидеоCleaning Data & Dealing With Missing ValuesЧтение

Lesson 3: Joining and Filtering Data

Joining & Filtering DataВидео💻 Coding Demo: Joining Data 💻Видео💻 Coding Demo: Filtering Data 💻ВидеоIntro to Computations Видео💻 Coding Demo: Data Computations 💻ВидеоLearning Check - Loading, Inspecting, & Querying DataЗадание

Lesson 4: Updating and Creating Data

Updating & Creating DataВидео💻 Coding Demo: Updating and Creating data 💻Видео

Lesson 5: Summarizing Data

Summarizing DataВидео💻 Coding Demo: Summarizing Data 💻ВидеоPivot Tables – aggfunc()ЧтениеPractice Assignment - Summarizing DataВнешний инструмент

Lesson 6: Visualizing Data

Visualizing DataВидеоAbout Jupyter Notebook “Magic Functions”Чтение💻 Coding Demo: Visualizing Data - Histograms 💻Видео💻 Coding Demo: Visualizing Data - Scatterplots 💻Видео💻 Coding Demo: Visualizing Data - Heatmaps 💻Видео💻 Coding Demo: Visualizing Data - Barplots 💻Видео

Weekly Assignment

Assignment 3 - Visualizing DataВнешний инструмент

Self-Evaluation

Self-EvaluationЗадание
Tables in Example2 Database - video for completing the assignmentsВидео
Learning Check - Relational DatabasesЗадание
Practice Assignment: Selecting and Filtering RecordsВнешний инструмент
Practice Assignment: Single Row and Group FunctionsВнешний инструмент
Practice Assignment - Joining & Filtering DataВнешний инструмент
Learning Check - Joining and Filtering DataЗадание