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

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

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

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

Applied Data Science with SQL, R, and Python

Курс от John Wiley & Sons
Средний≈ 11.3 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

This course equips learners with practical skills in data science using SQL, R, and Python, emphasizing their role in analyzing and interpreting complex datasets. Participants develop the ability to manage, manipulate, and visualize data to support data-driven decisions. Learners progress from foundational SQL concepts to advanced query design, joining, and optimization techniques. They then explore R for statistical analysis and visualization, followed by Python for data processing and creating advanced visualizations with Matplotlib. The course combines theory with hands-on, example-driven lessons, making programming and data analysis accessible. Learners gain applied experience that strengthens their confidence and competence in real-world data science tasks. Data analysts, aspiring data scientists, and professionals seeking practical skills in SQL, R, and Python will benefit from this course. Basic familiarity with computers is helpful but not required. This course is part three of a three-course Specialization designed to provide a comprehensive learning pathway in this subject area. While it delivers standalone value and practical skills, learners seeking a more integrated and in-depth progression may benefit from completing the full Specialization. From Data Analytics & Visualization All-in-One For Dummies Copyright © 2024 by John Wiley & Sons, Inc., Hoboken, New Jersey Used by arrangement with John Wiley & Sons, Inc.

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

MatplotlibPlot (Graphics)Database ManagementData VisualizationR ProgrammingDatabase DesignStatistical MethodsRelational DatabasesGgplot2Database SystemsData AnalysisPython ProgrammingDatabase TheoryR (Software)DatabasesStatistical ProgrammingPower BIData ScienceSQLQuery Languages

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

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

01SQL Foundations6 материалов

Demystifying Relational Databases: From Theory to SQL Practice

OverviewВидеоIntroductionЧтениеFunctional DependenciesЧтениеViewsЧтение

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

Wiley Skills Network

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

Applied Data Science with SQL, R, and Python
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 11.3 ч

15 модулей

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

Часть программы вашего университета
CatalogsЧтение
SQL Foundations and Database TheoryЗадание
02Drilling Down to the SQL Nitty-Gritty12 материалов

Mastering SQL Foundations: Data Types, Constraints, and Integration

OverviewВидеоIntroductionЧтениеEmbedded SQLЧтениеUsing Reserved Words CorrectlyЧтениеBIGINTЧтениеCharacter stringsЧтениеDatetimesЧтениеXML typeЧтениеREF typesЧтениеHandling Null ValuesЧтениеTable constraintsЧтениеMastering SQL Data Types and ConstraintsЗадание
03Values, Variables, Functions, and Expressions8 материалов

Mastering SQL Data Manipulation and Expression Building

OverviewВидеоIntroductionЧтениеWorking with FunctionsЧтениеDissecting data with value functionsЧтениеUsing ExpressionsЧтениеConditional value expressionsЧтениеConverting data types with a CAST expressionЧтениеSQL Fundamentals and Data ManipulationЗадание
04SELECT Statements and Modifying Clauses6 материалов

Mastering Data Retrieval and Aggregation in SQL

OverviewВидеоIntroductionЧтениеWHERE clausesЧтениеANY CAN BE AMBIGUOUSЧтениеGROUP BY clausesЧтениеMastering SQL Query ConstructionЗадание
05Tuning Queries6 материалов

Mastering SQL Performance: Strategies for Efficient Query Execution

OverviewВидеоIntroductionЧтениеTemporary TablesЧтениеThe ORDER BY ClauseЧтениеThe HAVING ClauseЧтениеMastering Efficient Query DesignЗадание
06Complex Query Design10 материалов

Mastering Advanced SQL: Subqueries, Joins, and Query Optimization

OverviewВидеоIntroductionЧтениеSubqueries that return a single valueЧтениеQuantified subqueries return a single valueЧтениеCorrelated subqueriesЧтениеUsing Subqueries in INSERT, DELETE, and UPDATE StatementsЧтениеTuning Considerations for Statements Containing Nested QueriesЧтениеTuning Correlated SubqueriesЧтениеUNIONЧтениеMastering Complex SQL Query ConstructsЗадание
07Joining Data Together in SQL6 материалов

Mastering SQL Joins: Techniques for Combining Tables

OverviewВидеоIntroductionЧтениеEqui-joinЧтениеColumn-name joinЧтениеON versus WHEREЧтениеMastering SQL Data Relationships and Database DesignЗадание
08Using Open Source R for Data Science7 материалов

Mastering R: From Functions to Statistical Analysis in Data Science

OverviewВидеоIntroductionЧтениеDelving into Functions and OperatorsЧтениеIterating in RЧтениеObserving How Objects WorkЧтениеSorting Out R's Popular Statistical Analysis PackagesЧтениеExploring R for Data ScienceЗадание
09R: What It Does and How It Does It10 материалов

Getting Started with R: Foundations of Data Analysis and Probability

OverviewВидеоIntroductionЧтениеA little probabilityЧтениеNull and alternative hypothesesЧтениеGetting RЧтениеA Session with RЧтениеR FunctionsЧтениеR StructuresЧтениеData framesЧтениеExploring R Fundamentals and Statistical PrinciplesЗадание
10Getting Graphical7 материалов

Visualizing Data Patterns with R: From Box Plots to Scatter Plots

OverviewВидеоIntroductionЧтениеOf boxes and whiskersЧтениеBar plotsЧтениеBar plots revisitedЧтениеScatter plotsЧтениеExploring Graphical Data RepresentationЗадание
11Kicking It Up a Notch to ggplot26 материалов

Mastering Data Visualization with ggplot2: From Bars to Scatter Plots

OverviewВидеоIntroductionЧтениеBar PlotsЧтениеBar Plots Re-revisitedЧтениеScatter PlotsЧтениеExploring Advanced Data Visualization with ggplot2Задание
12Discovering the Match Between Data Science and Python6 материалов

From Data to Insights: Python’s Power in the Data Science Pipeline

OverviewВидеоIntroductionЧтениеUnderstanding Python's Role in Data ScienceЧтениеLearning to Use Python FastЧтениеUnderstanding the need for indentationЧтениеPython and Data Science FundamentalsЗадание
13Using Python for Data Science and Visualization8 материалов

From Python Basics to Powerful Data Visualizations

OverviewВидеоIntroductionЧтениеSorting Out the Various Python Data TypesЧтениеPutting Loops to Good Use in PythonЧтениеKeeping Cool with ClassesЧтениеChecking Out Some Useful Python LibrariesЧтениеBonding with MatPlotLib for data visualizationЧтениеPython Data Science FundamentalsЗадание
14Getting a Crash Course in Matplotlib6 материалов

Mastering Visual Storytelling with Matplotlib

OverviewВидеоIntroductionЧтениеSetting the Axis, Ticks, and GridsЧтениеDefining the Line AppearanceЧтениеUsing Labels, Annotations, and LegendsЧтениеMatplotlib EssentialsЗадание
15Visualizing the Data8 материалов

Bringing Data to Life: Mastering Visualization Techniques with Matplotlib

OverviewВидеоIntroductionЧтениеShowing distributions using histogramsЧтениеCreating Advanced ScatterplotsЧтениеPlotting Time SeriesЧтениеPlotting Geographical DataЧтениеVisualizing GraphsЧтениеData Visualization FundamentalsЗадание