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

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

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

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

Data Modeling and Applications

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

О курсе

This course introduces the student to the use of a database management system to provide the software and database necessary to upgrade a DBMS system. Database structures, applications, network, relational and hierarchical data models, applicate programs development, query systems, file security, and the role of the database administrator will be studied. A course fee may apply.

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

Database DesignSQLRelational DatabasesData SecurityDiagram DesignDatabase AdministrationData IntegrityDatabase ManagementData ModelingNetwork ModelData ManipulationDatabase Architecture and AdministrationData MaintenanceDatabase DevelopmentDatabase ApplicationDatabase SoftwareQuery LanguagesDatabase Management Systems

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

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

01Module 1: Why Use Databases22 материалов

Course Welcome

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

Module 1 Introduction

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

Marwan Omar

Associate Professor

Data Modeling and Applications
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 66.3 ч

9 модулей

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

Субтитры: Узбекский, Казахский

Часть программы вашего университета
Module 1 Introduction ReadingЧтение
Module 1 IntroductionВидео

Lesson 1: Components of a Database System

Components of a Database SystemЧтениеGetting Started with Databases - Part 1ВидеоGetting Started with Databases - Part 2ВидеоRelational DatabasesВидеоStructured Query LanguageВидеоSQL ExampleВидеоComponents of a Database System QuizЗадание

Lesson 2: Database Management Systems

Database Management SystemsЧтениеDatabase SystemsВидеоDatabase Management SystemВидеоDatabase Management Systems QuizЗадание

Lesson 3: Lists, Relational Database Management Systems, and SQL

Lists, Relational Database Management Systems, and SQLЧтениеEnterprise-Class Database SystemsВидеоLists, Relational Database Management Systems, and SQL QuizЗадание

Module 1 Summative Assessment

Module 1 Summative AssessmentЗадание

Module 1 Summary

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

Module 2 Introduction

Module 2 Introduction ReadingЧтениеModule 2 IntroductionВидео

Lesson 1: The Relational Model

The Relational ModelЧтениеEntitiesВидеоRelationsВидеоThe Relational Model QuizЗадание

Lesson 2: Importance of Keys

Importance of KeysЧтениеKeysВидеоSetting Up KeysВидеоImportance of Keys QuizЗадание

Lesson 3: Keys and Functional Dependencies

Keys and Functional DependenciesЧтениеSetting Up a Database in SQL Server - Part 1ВидеоSetting Up a Database in SQL Server - Part 2ВидеоSetting Up a Database in SQL Server - Part 3ВидеоSetting Up a Database in SQL Server - Part 4ВидеоKeys and Functional Dependencies QuizЗадание

Module 2 Summative Assessment

Module 2 Summative AssessmentЗадание

Module 2 Summary

Module 2 SummaryЧтение
03Module 3: Structured Query Language - Part 121 материалов

Module 3 Introduction

Module 3 Introduction ReadingЧтениеModule 3 IntroductionВидео

Lesson 1: Basic SQL Statements

Basic SQL StatementsЧтениеIntroduction to SQL - Part 1ВидеоIntroduction to SQL - Part 2ВидеоIntroduction to SQL - Part 3ВидеоIntroduction to SQL - Part 4ВидеоIntroduction to SQL - Part 5ВидеоBasic SQL Statements QuizЗадание

Lesson 2: Basic SQL Queries

Basic SQL QueriesЧтениеSQL Queries - Part 1ВидеоSQL Queries - Part 2ВидеоSQL Queries - Part 3ВидеоBasic SQL Queries QuizЗадание

Lesson 3: Working with Multiple Tables

Working with Multiple TablesЧтениеSQL Queries - Part 4ВидеоSQL Queries - Part 5ВидеоWorking with Multiple Tables QuizЗадание

Module 3 Summative Assessment

Module 3 Summative AssessmentЗадание

Module 3 Summary

Module 3 SummaryЧтениеInsights from an Industry Leader: Learn More About Our ProgramЧтение
04Module 4: Structured Query Language - Part 218 материалов

Module 4 Introduction

Module 4 Introduction ReadingЧтениеModule 4 IntroductionВидео

Lesson 1: SQL - Data Manipulation Language (DML)

SQL - Data Manipulation Language (DML)ЧтениеSQL - Data Manipulation Language (DML) - Part 1ВидеоSQL - Data Manipulation Language (DML) - Part 2ВидеоSQL - Data Manipulation Language (DML) QuizЗадание

Lesson 2: DML - Adding Data to a Table

DML - Adding Data to a TableЧтениеQuerying and Filtering Data - Exercises - Part 1ВидеоQuerying and Filtering Data - Exercises - Part 2ВидеоQuerying and Filtering Data - Exercises - Part 3ВидеоQuerying and Filtering Data - Exercises - Part 4ВидеоDML - Adding Data to a Table QuizЗадание

Lesson 3: DML - Updating and Deleting Data from a Table

DML - Updating and Deleting Data from a TableЧтениеJoin Statements - Part 1ВидеоJoin Statements - Part 2ВидеоDML - Updating and Deleting Data from a Table QuizЗадание

Module 4 Summative Assessment

Module 4 Summative AssessmentЗадание

Module 4 Summary

Module 4 SummaryЧтение
05Module 5: Structured Query Language - Part 319 материалов

Module 5 Introduction

Module 5 Introduction ReadingЧтениеModule 5 IntroductionВидео

Lesson 1: Working with Subqueries

Working with SubqueriesЧтениеWorking with Joints in MS-SQL - Part 1ВидеоWorking with Joints in MS-SQL - Part 2ВидеоWorking with Joints in MS-SQL - Part 3ВидеоWorking with Joints in MS-SQL - Part 4ВидеоWorking with Subqueries QuizЗадание

Lesson 2: Aggregate Functions

Aggregate FunctionsЧтениеDDLВидеоAggregate Functions QuizЗадание

Lesson 3: SQL JOINS

SQL JOINSЧтениеCreating Tables Using MS-SQL - Part 1ВидеоCreating Tables Using MS-SQL - Part 2ВидеоCreating Tables Using MS-SQL - Part 3ВидеоCreating Tables Using MS-SQL - Part 4ВидеоSQL JOINS QuizЗадание

Module 5 Summative Assessment

Module 5 Summative AssessmentЗадание

Module 5 Summary

Module 5 SummaryЧтение
06Module 6: Data Modeling and the E-R Model18 материалов

Module 6 Introduction

Module 6 Introduction ReadingЧтениеModule 6 IntroductionВидео

Lesson 1: Database Development Lifecycle

Database Development LifecycleЧтениеRequirements Analysis - Part 1ВидеоRequirements Analysis - Part 2ВидеоDatabase Development Lifecycle QuizЗадание

Lesson 2: Data Models

Data ModelsЧтениеER Data ModelВидеоBinary Relationships - Part 1ВидеоBinary Relationships - Part 2ВидеоData Models QuizЗадание

Lesson 3: Entity Relationship Diagrams 

Entity Relationship Diagrams ЧтениеCrow's Foot NotationВидеоWorking with ER Diagrams in SQL - Part 1ВидеоWorking with ER Diagrams in SQL - Part 2ВидеоEntity Relationship Diagrams QuizЗадание

Module 6 Summative Assessment

Module 6 Summative AssessmentЗадание

Module 6 Summary

Module 6 SummaryЧтение
07Module 7: Database Design22 материалов

Module 7 Introduction

Module 7 Introduction ReadingЧтениеModule 7 IntroductionВидео

Lesson 1: ER Models and the Relational Models

ER Models and the Relational ModelsЧтениеDatabase Design - Part 1ВидеоDatabase Design - Part 2ВидеоDatabase Design - Part 3ВидеоER Models and the Relational Models QuizЗадание

Lesson 2: Database Normalization

Database NormalizationЧтениеDatabase Normalization - Part 1ВидеоDatabase Normalization - Part 2ВидеоNormal Forms - Part 1ВидеоNormal Forms - Part 2ВидеоNormal Forms - Part 3ВидеоDatabase Normalization Quiz

Lesson 3: Representation of ER Diagrams and Relationships

Representation of ER Diagrams and RelationshipsЧтениеNormal Forms Examples - Part 1ВидеоNormal Forms Examples - Part 2ВидеоNormal Forms Examples - Part 3ВидеоNormal Forms DemonstrationВидеоRepresentation of ER Diagrams and Relationships QuizЗадание

Module 7 Summative Assessment

Module 7 Summative AssessmentЗадание

Module 7 Summary

Module 7 SummaryЧтение
08Module 8: Database Administration21 материалов

Module 8 Introduction

Module 8 Introduction ReadingЧтениеModule 8 IntroductionВидео

Lesson 1: Importance of Database Administration

Importance of Database AdministrationЧтениеAuthenticationВидеоAuthorizationВидеоSQL Server Login - Part 1ВидеоSQL Server Login - Part 2ВидеоImportance of Database Administration QuizЗадание

Lesson 2: Database Administration and Data Administration

Database Administration and Data AdministrationЧтениеDatabase AdministrationВидеоSQL Server RowsВидеоViewsВидеоViews ExerciseВидеоDatabase Administration and Data Administration QuizЗадание

Lesson 3: Database Security

Database SecurityЧтениеDatabase SecurityВидеоTriggers - Part 1ВидеоTriggers - Part 2ВидеоDatabase Security QuizЗадание

Module 8 Summative Assessment

Module 8 Summative AssessmentЗадание

Module 8 Summary

Module 8 SummaryЧтение
09Summative Course Assessment1 материалов

Summative Course Assessment

Summative Course AssessmentЗадание
Задание