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

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

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

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

Apply Advanced SQL Server Analytics and Programming

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

О курсе

By the end of this course, learners will be able to manage semi-structured data using JSON, model complex relationships with graph databases, and apply advanced analytics by integrating R and Python within SQL Server. Learners will gain the ability to query, modify, and analyze diverse data formats directly inside the database environment. This course is designed for database professionals and data practitioners who want to move beyond traditional relational querying and leverage advanced SQL Server capabilities. Through hands-on concepts, learners will understand how to store and manipulate JSON data, build and query graph databases for relationship-driven use cases, and execute R and Python scripts for analytics, data ingestion, and transformation. The course emphasizes practical application, enabling learners to process structured and unstructured data efficiently without moving data outside SQL Server. What makes this course unique is its unified approach to modern data handling within SQL Server—combining JSON, graph databases, R, and Python in a single advanced curriculum. By completing this course, learners will enhance their analytical skill set, improve data-driven decision-making, and be better prepared to handle real-world enterprise data challenges using SQL Server’s advanced features.

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

Data StructuresData ProcessingData Import/ExportScripting LanguagesDatabase DesignData-Driven Decision-MakingScripting

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

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

01JSON Data Management in SQL Server14 материалов

JSON Fundamentals

Introduction to JSONВидеоInserting Data in JSON tableВидеоJSON Using VariablesВидеоJSON Data Management in SQL ServerЗадание

Querying JSON Data

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

EDUCBA

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

Apply Advanced SQL Server Analytics and Programming
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 10.3 ч

4 модулей

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

Часть программы вашего университета
Select Queries in JSONВидео
Working on JSON TypeВидео
Inserting Data of Type JSONВидео
Querying JSON DataЗадание

Advanced JSON Queries and Updates

More on Select Queries on JSONВидеоAltering JSON DataВидеоAdvanced JSON Queries and UpdatesЗаданиеApplying JSON Functions to Real-World SQL Server DataDIALOGUEJSON Data Management in SQL ServerЗаданиеResolving JSON Query Issues in SQL ServerDIALOGUE
02Graph Databases with SQL Server12 материалов

Graph Database Basics

Introduction to Graph DatabasesВидеоCreating Node TableВидеоCreating Edge TableВидеоGraph Database BasicsЗадание

Modifying Graph Structures

Altering Edge TableВидеоExample on Creating Graph Database Part 1ВидеоExample on Creating Graph Database Part 2ВидеоModifying Graph StructuresЗадание

Graph Database End-to-End Examples

Example on Creating Graph Database Part 3ВидеоExample on Creating Graph Database Part 4ВидеоGraph Database End-to-End ExamplesЗаданиеGraph Databases with SQL ServerЗадание
03R Integration and Advanced Analytics in SQL Server12 материалов

Introduction to R with SQL Server

Introduction to R Using SQLВидеоExecuting R Scripts in SQL ServerВидеоExecuting R scripts for Importing CSV FileВидеоIntroduction to R with SQL ServerЗадание

Working with R Commands and Data Sources

Working on R CommandВидеоReading PDF FileВидеоDisplaying Data in SQL QueryВидеоWorking with R Commands and Data SourcesЗадание

Advanced Data Processing Using R Scripts

Writing Commands on R Command PromptВидеоWorking on Joins using R ScriptВидеоAdvanced Data Processing Using R ScriptsЗаданиеR Integration and Advanced Analytics in SQL ServerЗадание
04Python Programming Concepts for SQL Server10 материалов

Executing Python and Control Flow

Executing Python CommandsВидеоPython Comparison OperatorsВидеоIf and Else Statements in PythonВидеоExecuting Python and Control FlowЗадание

Python Operators and Data Structures

Arithmetic Operators in PythonВидеоVarious Comparison and Logical OperatorsВидеоTuples in PythonВидеоPython Operators and Data StructuresЗаданиеPython Programming Concepts for SQL ServerЗаданиеFixing a Broken JSON Pipeline in SQL ServerDIALOGUE