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

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

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

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

Introduction to Relational Databases

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

О курсе

Database management systems are a crucial part of most large-scale industry and open-source systems. This course will introduce you to important concepts of database systems and design. We will learn what relational databases are, what they are used for, the theory underlying their design, and how to query and modify a database using the declarative SQL language. At the end of the course, you will be able to: - Describe what relational databases are, and how they are used. - Master the Relational Database Model. - Demonstrate proficiency in formal relational database theory. - Demonstrate comprehensive SQL skills. - Apply database knowledge to practical problems. Software Requirements: Jupyter Notebooks, SQL

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

Relational DatabasesSQLData ManipulationDatabase TheoryDatabase Management SystemsAuthorization (Computing)Database SystemsData IntegrityDatabasesDatabase ManagementQuery LanguagesDatabase SoftwareData ProcessingDatabase ApplicationPerformance TuningDatabase Design

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

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

01Module 1: Introduction to Relational Databases33 материалов

Course Welcome

Course OverviewВидеоInstructor WelcomeВидеоSyllabusЧтениеMeet and Greet DiscussionОбсуждение

Module 1 Introduction

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

Gerald Balekaki

Assistant Teaching Professor

Yousef Elmehdwi

Associate Teaching Professor of CS

Introduction to Relational Databases
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 71.9 ч

5 модулей

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

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

Часть программы вашего университета
Introduction to Relational DatabasesВидео

Lesson 1: Introduction to Relational Databases

Introduction to Relational DatabasesЧтениеIntroduction to Relational Databases - Part 1ВидеоIntroduction to Relational Databases - Part 2ВидеоIntroduction to Relational Databases - Part 3ВидеоIntroduction to Relational Databases - Part 4ВидеоIntroduction to Relational Databases - Part 5ВидеоIntroduction to Relational Databases - Part 6ВидеоSample Database SetupЛабораторнаяPractice Assessment Quiz 1.1Задание

Lesson 2: Relational DBMS

Relational DBMSЧтениеRelational DBMS - Part 1ВидеоRelational DBMS - Part 2 ВидеоRelational DBMS - Part 3ВидеоRelational DBMS - Part 4ВидеоTest Sample DatabaseЛабораторнаяPractice Assessment Quiz 1.2Задание

Lesson 3: Relational Data Model

The Relational ModelЧтениеKeysВидеоRelational Data Model - Part 1ВидеоRelational Data Model - Part 2ВидеоRelational Model Constraints - Part 1ВидеоRelational Model Constraints - Part 2ВидеоRelational Model Constraints - Part 3ВидеоRelational Model Constraints - Part 4ВидеоRelational Data Model Practice LabЛабораторнаяPractice Assessment Quiz 1.3Задание

Module 1 Summative Assessment

Module 1 Summative AssessmentЗадание

Module 1 Summary

Module 1 SummaryЧтение
02Module 2: Relational Algebra 19 материалов

Module 2 Introduction

Module 2 IntroductionВидео

Lesson 1: Basic RA operations

The Relational AlgebraЧтениеRelational Algebra - Part 1ВидеоRelational Algebra - Part 2ВидеоRelational Algebra - Part 3ВидеоRelational Algebra - Part 4ВидеоPractice Assessment Quiz 2.1Задание

Lesson 2: Advanced Relational Algebra Operations

Advanced Relational Algebra OperationsЧтениеSet Operations - Part 1ВидеоSet Operations - Part 2ВидеоSet Operations - Part 3ВидеоSet Operations - Part 4ВидеоPractice Assessment Quiz 2.2Задание

Lesson 3: Practicing Relational Algebra with Relax Tool

Relational Algebra Tool (RelaX)ЧтениеRelational Algebra - RelaX Tool - Part 1ВидеоRelational Algebra - RelaX Tool - Part 2 ВидеоRelational Algebra - RelaX Tool - Part 3Видео

Module 2 Summative Assessment

Module 2 Summative AssessmentЗадание

Module 2 Summary

Module 2 SummaryЧтение
03Module 3: Introduction to SQL (Foundations) 30 материалов

Module 3 Introduction

Module 3 IntroductionВидео

Lesson 1: SQL Overview, Categories, and Data Types

SQL Overview, Categories, and Data Type ЧтениеWhat is SQL?ВидеоSQL CategoriesВидеоSQL Data Types & Naming ConventionsВидео

Lesson 2: Data Definition Language (DDL)

Data Definition Language (DDL)ЧтениеCreating a Database and Tables ВидеоCreating Tables LabЛабораторнаяModifying Table Structure with ALTERВидеоAltering Tables LabЛабораторнаяManaging RelationshipsВидеоDropping Tables LabЛабораторнаяDDL - Removing Objects: TRUNCATE, and DROPВидеоStructured Query Language LabЛабораторная

Lesson 3: Data Manipulation Language (DML)

Data Manipulation Language (DML)ЧтениеRetrieve Data - The SELECT StatementВидеоSELECT queries 101 LabЛабораторнаяQueries with expressions LabЛабораторнаяFilter Data - Using the WHERE ClauseВидеоQueries with constraints (Pt. 1) LabЛабораторная

Module 3 Summative Assessment

Module 3 Practice AssessmentЗаданиеModule 3 Summative AssessmentЗадание

Module 3 Summary

Module 3 SummaryЧтение
04Module 4: Complex SQL33 материалов

Module 4 Introduction

Module 4 IntroductionВидео

Lesson 1: Joins and Relationships

Joins and RelationshipsЧтениеJoins and Relationships - INNER JOINВидеоSelect Queries with Joins LabЛабораторнаяJoins and Relationships - OUTER JOINВидеоSelect Queries with Outer Joins LabЛабораторнаяAvoiding the Cartesian Trap - CROSS JOIN vs Wrong JoinsВидеоSelect Queries with Nulls LabЛабораторнаяUsing SELF JOINs - Intra-table JoinsВидео

Lesson 2: Aggregations

AggregationsЧтениеAggregation Functions (10 min)ВидеоSelect Queries with Aggregates LabЛабораторнаяSelect Queries with Aggregates part 2 LabЛабораторнаяGROUP BY vs HAVING (7 min)Видео

Lesson 3: Set Operations

Set OperationsЧтениеSet Operations - Using UNION, UNION ALLВидеоSelect Queries with Joins LabЛабораторнаяSet Operations - Using INTERSECT, INTERSECT ALLВидеоSet Operations - Using EXCEPT, EXCEPT ALLВидео

Lesson 4: Subqueries, Sets, and Views

Subqueries, Sets, and ViewsЧтениеSubqueries and Set Memberships Operations (IN, NOT IN)ВидеоSelect Queries with Joins LabЛабораторнаяSet Comparison Operations (ANY, COME, ALL)ВидеоCorrelated Subqueries and EXISTS/NOT EXISTSВидеоCommon Table Expressions (CTEs)Видео

Lesson 5: Referential Integrity, Indexes, and Access Control

Referential Integrity, Indexes, and Access ControlЧтениеReferential Integrity - Maintaining Data ConsistencyВидеоIndexes - Making Data Retrieval FasterВидеоAccess Control - Database Security ManagementВидео

Module 4 Summative Assessment

Module 4 Practice AssessmentЗаданиеModule 4 Summative AssessmentЗадание

Module 4 Summary

Module 4 SummaryЧтение
05Summative Course Assessment1 материалов
Summative Course AssessmentЗадание
Queries with constraints (Pt. 2) LabЛабораторная
Add Data - The INSERT Statement Видео
Inserting Rows LabЛабораторная
Modify Data - The UPDATE Statement Видео
Updating Rows LabЛабораторная
Remove Data - The DELETE StatementВидео
Deleting Rows LabЛабораторная
Complex SQL - ViewsВидео