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

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

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

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

The Structured Query Language (SQL)

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

О курсе

In this course you will learn all about the Structured Query Language ("SQL".) We will review the origins of the language and its conceptual foundations. But primarily, we will focus on learning all the standard SQL commands, their syntax, and how to use these commands to conduct analysis of the data within a relational database. Our scope includes not only the SELECT statement for retrieving data and creating analytical reports, but also includes the DDL ("Data Definition Language") and DML ("Data Manipulation Language") commands necessary to create and maintain database objects. The Structured Query Language (SQL) can be taken for academic credit as part of CU Boulder’s Master of Science in Data Science (MS-DS) degree offered on the Coursera platform. The MS-DS is an interdisciplinary degree that brings together faculty from CU Boulder’s departments of Applied Mathematics, Computer Science, Information Science, and others. With performance-based admissions and no application process, the MS-DS is ideal for individuals with a broad range of undergraduate education and/or professional experience in computer science, information science, mathematics, and statistics. Learn more about the MS-DS program at https://www.coursera.org/degrees/master-of-science-data-science-boulder.

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

SQLQuery LanguagesDatabase AdministrationRelational DatabasesData AccessData IntegrityDatabase ApplicationData ModelingData AnalysisDatabase DesignDatabase DevelopmentData ManipulationDatabase SystemsDatabase TheoryData ScienceDatabase Management

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

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

01Introduction to SQL - Structured Query Language14 материалов

Welcome to The Structured Query Language (SQL)

Course Updates and Accessibility SupportЧтениеEarn Academic Credit for your Work!ЧтениеCourse SupportЧтениеOverview of Course, Intro to InstructorВидео

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

Alan Paradise

Teaching Professor

The Structured Query Language (SQL)
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 27.1 ч

6 модулей

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

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

Часть программы вашего университета
Introduce Yourself!Обсуждение

The Origins of SQL

The Origins of SQLВидеоOld, but Widely UsedЗаданиеModule 1Обсуждение

The Relational Algebra

The Relational AlgebraВидеоUnderstanding Relational Algebra TermsЗадание

ANSI Standard SQL

The SQL Standard Видео

Preparing SQL for Execution

What Happens When I Execute a Query?ВидеоSQL Query Execution TermsЗадание

Module 1 Resources

Lecture SlidesЧтение
02The Basic SELECT Statement18 материалов

Our Lab Environment

Our Coursera Lab EnvironmentВидеоpgAdmin Lab EnvironmentЛабораторная

The Basic SELECT Statement

The Basic SELECT ClauseВидеоLab 1: Coding Your First SELECT StatementsЧтениеUnlock Lab 1 Solutions ЗаданиеLab 1: Solutions Чтение

The WHERE Clause - Selecting a Subset of Rows

The WHERE Clause and ConditionsВидеоLab 2: Adding Conditions Using the WHERE ClauseЧтениеUnlock Lab 2 Solutions ЗаданиеLab 2: SolutionsЧтение

Managing your answer set

The ORDER BY and DISTINCTВидео Adjusting Your OutputЗадание

DATES and NULLS

How Does SQL Handle DATES and NULLSВидеоLab 3: Date Functions and NullsЧтениеUnlock Lab 3 Solutions ЗаданиеLab 3: Solutions ЧтениеModule 2Обсуждение

Assessments

The Basic SELECT StatementЗадание
03Group Functions, SubTotals, and Subqueries13 материалов

The Five GROUP Functions

The Five GROUP Functions ВидеоUsing the Group FunctionsЗадание

Creating Totals and Subtotals with the GROUP BY

Creating Totals and SubtotalsВидеоUnderstanding the RULESЗаданиеLab 4: Using the GROUP BYЧтениеUnlock Lab 4 Solutions ЗаданиеLab 4: SolutionsЧтение

Using Sub Queries

SubQueries - Three Different FormsВидеоDifferentiating Types of SubqueriesЗаданиеLab 5: Practice Using SubqueriesЧтениеUnlock Lab 5 Solutions ЗаданиеLab 5: Solutions Чтение

Assessments

Group Functions and SubQueriesЗадание
04Getting Data from Multiple Tables14 материалов

The INNER JOIN

JOIN SyntaxВидеоUnderstanding JOINsЗаданиеLab 6: Inner JOINSЧтениеUnlock Lab 6 Solutions ЗаданиеLab 6: Solutions Чтение

Joining More than Two Tables

Three-Way JOINВидео

The Cartesian Product

The Cartesian Product - an Easy ErrorВидеоJOIN Conditions Задание

The OUTER JOIN

When an OUTER JOIN is NeededВидеоModule 4ОбсуждениеLab 7: Outer JOINSЧтениеUnlock Lab 7 Solutions ЗаданиеLab 7: SolutionsЧтение

Assessments

JoinsЗадание
05DDL and DML15 материалов

Creating Tables with the CREATE Statement

CREATE Statement - Data TypesВидеоUnderstanding Data TypesЗаданиеLab 8: Creating TablesЧтениеUnlock Lab 8 Solutions ЗаданиеLab 8: Solutions Чтение

Understanding CONSTRAINTS

Database ConstraintsВидео

Modifying Database Objects with the ALTER Statement

Making Changes with the ALTERВидеоLab 9: Modifying Tables and Columns with ALTERЧтениеUnlock Lab 9 Solutions ЗаданиеLab 9: Solutions Чтение

INSERT, UPDATE, DELETE, DROP

Adding, Changing, Deleting DataВидеоLab 10: Practicing DMLЧтениеUnlock Lab 10 Solutions ЗаданиеLab 10: Solutions Чтение

Assessments

DDL and DMLЗадание
06Advanced SQL Commands18 материалов

VIEWs

Creating and Using VIEWsВидеоLab 11: Using a VIEWЧтениеUnlock Lab 11 Solutions ЗаданиеLab 11: Solutions Чтение

CASE

The CASE StatementВидеоLab 12: Conditionals with the CASE OperatorЧтениеUnlock Lab 12 Solutions ЗаданиеLab 12: Solutions Чтение

UNION

Joining Answer Sets with the UNIONВидео

Identity

Creating Unique Keys with IDENTITYВидео

Final Assessment

Some Advanced SQLЗаданиеFinal LabЧтениеUnlock Final Lab Solutions ЗаданиеFinal Lab: SolutionsЧтениеFinal Comprehensive SQL ReflectionВзаимная проверка

Summary and Wrap-Up

Module 6ОбсуждениеWrap-UpВидеоLinks from Wrap-Up VideoЧтение