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

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

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

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

SQL for Data Analytics

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

О курсе

SQL is one of the most essential skills for working with data, enabling professionals to store, manage, transform, and analyze information efficiently. This course provides a comprehensive foundation in SQL for data analytics, covering the techniques and tools used to extract meaningful insights from structured and semi-structured data. Throughout the course, learners will develop practical SQL skills for creating and managing databases, importing and manipulating data, and building analytical queries. By working with topics such as aggregations, window functions, advanced data types, and statistical analysis, participants will gain the ability to solve real-world business and analytics challenges using SQL. What sets this course apart is its balanced approach to both database management and advanced analytical techniques. Learners move beyond basic querying to explore performance optimization, JSON and array processing, inferential statistics, and a complete analytics case study that demonstrates SQL in practice. This course is ideal for aspiring data analysts, business analysts, data professionals, and technical practitioners who work with data. A basic understanding of data concepts and familiarity with computers is recommended, though prior SQL experience is not required.

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

Data WarehousingStar SchemaQuery LanguagesStatistical ProgrammingDatabase TheoryBusiness AnalyticsDatabase ManagementDatabasesDatabase DevelopmentData AnalysisDatabase DesignRelational DatabasesOperational DatabasesData Import/ExportSQLDatabase SystemsData ManipulationData ModelingAnalyticsPostgreSQL

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

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

01Introduction to Data Management Systems9 материалов

Building a Foundation: From Data Modeling to SQL in Action

OverviewВидеоIntroductionЧтениеData ModelingЧтениеUnderstanding Relational Databases and SQLЧтение

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

Packt - Course Instructors

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

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 10.6 ч

14 модулей

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

Часть программы вашего университета
NormalizationЧтение
Setting Up a PostgreSQL Relational DatabaseЧтение
Accessing and Understanding PostgreSQLЧтение
Import a Sample SQLDA DatabaseЧтение
Foundations of Data Management and SQLЗадание
02Creating Tables with Solid Structures7 материалов

Building Reliable SQL Tables: From Data Types to Constraints

OverviewВидеоIntroductionЧтениеCreating a Table from an Existing DatasetЧтениеLearning About Basic Data Types of SQLЧтениеDatetimeЧтениеColumn Constraints and Table ConstraintsЧтениеMastering Table Design and Data Handling in SQLЗадание
03Exchanging Data Using COPY5 материалов

Mastering Data Import and Export with PostgreSQL COPY

OverviewВидеоIntroductionЧтение\COPY in psqlЧтениеImporting Data into a PostgreSQL DatabaseЧтениеData Exchange and Management TechniquesЗадание
04Manipulating Data with Python5 материалов

Bridging Python and Databases: From Queries to DataFrames

OverviewВидеоIntroductionЧтениеManaging Data with PythonЧтениеReading and Writing to a Database with pandasЧтениеPython Data Manipulation and Database InteractionЗадание
05Presenting Data with SELECT7 материалов

Mastering Data Retrieval: Filtering and Sorting with SQL

OverviewВидеоIntroductionЧтениеORDER BY ClauseЧтениеFiltering Query ResultsЧтениеIN/NOT IN ClauseЧтениеReading data from the databaseЧтениеMastering Basic SQL Query ConstructsЗадание
06Transforming and Updating Data8 материалов

Mastering Data Updates, Transformations, and Automation in SQL

OverviewВидеоIntroductionЧтениеUpdating and Deleting DataЧтениеFunctions for Different Data TypesЧтениеData Manipulation Using FunctionsЧтениеCreating User-Defined FunctionsЧтениеTriggersЧтениеMastering Data Transformation and ManagementЗадание
07Defining Datasets from Existing Datasets8 материалов

Mastering Data Combination: Subqueries, Joins, and Set Operations

OverviewВидеоIntroductionЧтениеCommon Table ExpressionsЧтениеJoining TablesЧтениеOuter JoinsЧтениеFull Outer JoinsЧтениеRunning Set OperationsЧтениеMastering SQL Dataset ConstructionЗадание
08Aggregating Data with GROUP BY6 материалов

Mastering Data Summarization with SQL Aggregates

OverviewВидеоIntroductionЧтениеUsing Aggregate Functions to Analyze DataЧтениеCalculating the Cost by Product Type Using GROUP BYЧтениеApplying the HAVING ClauseЧтениеMastering Data Aggregation with GROUP BYЗадание
09Inter-Row Operation with Window Functions8 материалов

Mastering Window Functions for Dynamic Data Analysis

OverviewВидеоIntroductionЧтениеThe Basics of Window FunctionsЧтениеAnalyzing Customer Data Fill Rates over TimeЧтениеUsing Advanced Window DefinitionsЧтениеWindow FrameЧтениеTeam Lunch MotivationЧтениеExploring Window Functions in SQLЗадание
10Performant SQL6 материалов

Mastering Index Scans and Query Optimization in PostgreSQL

OverviewВидеоIntroductionЧтениеScanning the IndexЧтениеThe Hash IndexЧтениеEffective Index UseЧтениеMastering Efficient SQL Query ExecutionЗадание
11Processing JSON and Arrays7 материалов

Mastering JSON and Arrays for Advanced Data Handling

OverviewВидеоIntroductionЧтениеUsing JSONЧтениеAccessing Data from a JSON or JSONB FieldЧтениеCreating and Modifying Data in a JSONB FieldЧтениеUsing Arrays to Process Element CollectionsЧтениеExploring JSON and Array Operations in Database SystemsЗадание
12Advanced Data Types: Date, Text, and Geospatial7 материалов

Mastering Dates, Text, and Location Data for Real-World Analytics

OverviewВидеоIntroductionЧтениеTransforming DATE Data TypesЧтениеAnalytics with time-series dataЧтениеText ProcessingЧтениеLatitude and LongitudeЧтениеExploring Date, Text, and Geospatial Data in SQLЗадание
13Inferential Statistics Using SQL6 материалов

From Estimation to Prediction: Inferential Statistics in Action with SQL

OverviewВидеоIntroductionЧтениеEstimating: Point Estimates and Confidence IntervalsЧтениеAnalyzing Correlation and Performing RegressionЧтениеUnderstanding a Simple Linear Regression ExampleЧтениеInferential Statistics and SQLЗадание
14A Case Study for Analytics Using SQL8 материалов

From Raw Data to Insight: Building Analytics Workflows with SQL

OverviewВидеоIntroductionЧтениеUnderstanding Dimensional ModelsЧтениеApplying Data Analysis Using SQLЧтениеQuality Check for Raw DataЧтениеLoading Data into the Star SchemaЧтениеDelivery Data for AnalysisЧтениеData Warehousing and SQL Analytics FundamentalsЗадание