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

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

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

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

SQL Foundations

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

О курсе

Learn the fundamentals of SQL with Microsoft SQL Server in this introductory course. You'll learn to write basic and intermediate queries to extract and analyze data while understanding relational database concepts. Through hands-on exercises with SQL Server Management Studio, you'll practice filtering data with WHERE clauses, sorting results with ORDER BY, and transforming data with built-in functions. This course also introduces you to database schemas, tables, and views, providing a foundation for understanding data structure. Additionally, you'll explore how generative AI tools can assist with SQL query development, reflecting modern workplace practices. By completing this course, you'll build confidence writing T-SQL queries and be prepared for more advanced data manipulation techniques.

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

SQLRelational DatabasesGitHub CopilotDatabase ManagementData TransformationTransact-SQLData AnalysisMicrosoft SQL ServersQuery LanguagesDatabase Management SystemsDatabase DesignDatabasesData ManipulationGenerative AI

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

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

01Module 1: Introduction to SQL and Course Overview17 материалов

Lesson 1: Welcome to the Course

Welcome to SQL with Microsoft SQL Server CertificateВидеоWelcome to SQL FoundationsВидеоCourse Structure and Learning OutcomesЧтениеSet Your Learning GoalsDIALOGUE

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

Microsoft

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

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 25 ч

4 модулей

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

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

Часть программы вашего университета
Course Accessibility InformationЧтение

Lesson 2: Introduction to Databases

The Power of DataВидеоIntroduction to DatabasesЧтениеHow Data is Organized in the Chinook DatabaseВидеоExamine Tables in a Sample DatabaseЛабораторнаяExploring Table StructuresЗаданиеReflect on the Importance of DatabasesDIALOGUE

Lesson 3: Exploring Tables and Their Structures

The Power of SQLВидеоWhat is SQL?ЧтениеWorking with SQL Queries Using PseudocodeВидеоDiscuss How SQL Can Benefit Your FieldDIALOGUEQuery a Database using PseudocodeЛабораторнаяUnderstanding SQL Basics for Interacting with DataЗадание
02Module 2: Retrieve Data from a Database with SQL Queries25 материалов

Lesson 1: Constructing Basic SQL Queries

The Power of SQL QueriesВидеоSQL SELECT Statements ЧтениеWriting and Executing Simple QueriesВидеоRetrieve Data from a Database Using SELECTЛабораторнаяSQL Syntax and Query ConstructionЗаданиеDiscuss Your First Query-Writing ExperienceDIALOGUE

Lesson 2: Filtering Querying Results

Real-world Scenarios for Data FilteringВидеоUsing Comparison and Logical Operators with the WHERE ClauseЧтениеDemonstration of Filtering Data with the WHERE ClauseВидеоPractice Filtering Data in a Sample DatabaseЛабораторнаяFiltering in SQLЗаданиеReflect on the Challenges of Data FilteringDIALOGUE

Lesson 3: Retrieving Data from Multiple Tables

The Power of Combining DataВидеоUnderstanding JOINS in SQLЧтениеDemo on Writing Basic JOIN QueriesВидеоPractice Writing JOIN QueriesЛабораторнаяUnderstanding Basic JOINsЗаданиеShare Your Experience with JOINsDIALOGUE

Lesson 4: Sorting and Organizing Data

The Importance of Data OrganizationВидеоSorting Query Results with ORDER BYЧтениеSorting Demo in SQLВидеоDiscuss the Importance of Sorting DataDIALOGUESort Data in a Real-world DatasetЛабораторнаяSorting Functions in SQLЗадание
03Module 3: Data Transformations with Aliases and Filtering18 материалов

Lesson 1: Using SQL Functions for Data Transformations

Transforming Data for AnalysisВидеоCommon SQL Functions for Data TransformationЧтениеDemo on Using SQL Functions for TransformationsВидеоApply SQL Functions to Transform DataЛабораторнаяUnderstanding Data Transformation in SQLЗаданиеReflect on Real-World Data Transformation NeedsDIALOGUE

Lesson 2: Applying Aliases in SQL Queries

Simplifying Queries with AliasesВидеоSQL Aliases Usage and BenefitsЧтениеDemo on Using Aliases in QueriesВидеоSimplify Complex Queries Using AliasesЛабораторнаяUsing Aliases in SQLЗаданиеDiscuss Scenarios Where Aliases Improve ClarityDIALOGUE

Lesson 3: Combining Transformations, Filtering, and Aliases

Creating Powerful and Efficient QueriesВидеоCrafting Combined Queries for Better ResultsЧтениеCase Study on Combined Query StrategiesВидеоEvaluate Your Query Optimization StrategiesDIALOGUECombine and Optimize Queries in PracticeЛабораторнаяCombining Transformations and AliasesЗадание
04Module 4: Data Encapsulation and Exploring AI20 материалов

Lesson 1: Utilizing Views for Data Presentation

Views for Better Data InsightsВидеоOverview of SQL ViewsЧтениеCreating and Using ViewsВидеоUse Views in PracticeЛабораторнаяUnderstanding and Creating ViewsЗаданиеReflect on the Role of Views in Simplifying DataDIALOGUE

Lesson 2: Modifying and Dropping Views in SQL Server

Updating and Removing ViewsЧтениеUpdating and Removing ViewsВидеоModifying and Dropping Views in a PracticeЛабораторнаяUnderstanding Modifying and Dropping ViewsЗаданиеReflect on Modifying and Dropping ViewsDIALOGUE

Lesson 3: Using Generative AI to Assist in Working with SQL

Exploring AI in SQLВидеоHow to Use GitHub Copilot to Create SQL QueriesЧтениеAccessing GitHub Copilot by MicrosoftЛабораторнаяDemo on Using GitHub Copilot for SQLВидеоDiscuss the Future of AI in Database ManagementDIALOGUEImplement AI-assisted SQL QueriesЛабораторная

Lesson 4: Course Wrap-Up

Wrap-UpВидеоWrapping Up and Looking AheadЧтение
Writing SQL Queries to Retrieve and Filter Data DIALOGUE
Understanding and Applying AI in SQLЗадание