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

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

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

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

Data Management and Database Design Part 1

Курс от Northeastern University
Уровень не указан≈ 20.4 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

In the Data Management and Database Design Part 1 course, you will gain an essential foundation in database theory and skills, exploring fundamental concepts and basic database structures. You will acquire valuable knowledge and skills in understanding, querying, and working with core database systems, with an emphasis on both relational and NoSQL database fundamentals.

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

Database DesignSQLNoSQLUnified Modeling LanguagePerformance TuningDatabase ManagementDatabase SystemsData ModelingDatabase TheoryRelational DatabasesData IntegrityDatabase DevelopmentDatabasesQuery LanguagesData ManipulationDatabase Management Systems

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

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

01General Database Purpose and Development History24 материалов

Getting Started

Course IntroductionЧтениеCourse IntroductionВидеоMeet Your FacultyВидеоData Management and Database Design Part 1 SyllabusЧтение

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

Simon W. Wang

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

Data Management and Database Design Part 1
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 20.4 ч

7 модулей

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

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

Часть программы вашего университета
Meet Your Fellow LearnersОбсуждение
Academic Integrity AttestationЧтение

Lesson 1: Database History

Database System HistoryВидеоThe Evolution of DatabasesЧтениеAssess Your Learning: Database HistoryЗадание

Lesson 2: Database Design Tools

Data CategoriesЧтениеData Types and UsesЧтениеData Models and Their Use CasesЧтениеToday's Database LandscapeЧтениеLucidchartЧтение

Lesson 3: Sharding vs. Replication

Sharding vs. Replication Чтение

Lesson 4: Relational Databases vs. NoSQL Databases

Relational Database vs. NoSQL DatabaseВидеоUnderstanding Relational DatabasesЧтениеAssess Your Learning: Relational Database vs. NoSQL DatabaseЗаданиеKey Takeaways: Relational Data ModelЧтениеWhat is NoSQL?ЧтениеComparing Relational Model and NoSQLЧтениеData Universal Framework ComparisonЧтение

Module 1 Wrap-Up

Case Study: Designing a Scalable Payment Processing SystemЧтениеModule 1 SummaryЧтение
02Entity–Relationship Modeling22 материалов

Lesson 1: Entity–Relationship Modeling

Database and Software Development Life CyclesЧтениеData ModelingВидеоAssess Your Learning: Data ModelingЗаданиеEntity-Relationship Diagram (ERD)ВидеоTypes of Keys and Data IntegrityЧтениеAssess Your Learning: Entity Relationship Diagrams (ERD)Задание

Lesson 2: Crow’s Foot Notation

Entity-Relationship ModelingЧтениеCrow’s Foot NotationЧтениеStrong Entity vs. Weak EntityЧтениеIdentifying vs. Non-Identifying RelationshipsЧтениеERD ExampleЧтениеAssess Your Learning: Crow’s Foot NotationЗадание

Lesson 3: Unified Modeling Language (UML) Notation

Unified Modeling Language (UML) NotationЧтениеMultiplicityЧтениеMission Statement and ObjectivesЧтениеModeling Comparison Between Relational and Document DatabasesЧтениеCreate ERD for Document DatabaseЧтениеPopular NoSQL DatabasesЧтение

Lesson 4: Enhanced Entity Relationship Modeling

Intro to Enhanced Entity-Relationship ModelingЧтениеEnhanced Entity-Relationship ModelingЧтениеAssess Your Learning: Enhanced Entity-Relationship ModelingЗадание

Module 2 Wrap-Up

Module 2 SummaryЧтение
03Conceptual and Logical Database Design24 материалов

Lesson 1: Database Development Life Cycle

Database Development LifecycleВидеоHow Does a Database Fit in the Overall Software Development Project?ВидеоStages of Database DesignЧтениеAssess Your Learning: Database Development Life CycleЗадание

Lesson 2: Database Design

Two Major Approaches to Database DesignЧтениеCASE ToolsЧтениеBest Practices for Database DesignЧтениеDocument Databases Design—Embedding vs. ReferencingЧтениеHow to Design and Implement a MongoDB DatabaseЧтениеDesign Comparison: Relational vs. NoSQL DatabasesЧтениеAssess Your Learning: Database and Software Development ProjectЗадание

Lesson 3: Normalization Process

NormalizationЧтениеAdvanced NormalizationЧтениеAttributesЧтение

Lesson 4: Normalization Concepts and Theories

Conceptual Database DesignЧтениеLogical Database Design for Relational ModelЧтение

Lesson 5: MongoDB Part 1

Getting Started with MongoDB Atlas Database ЧтениеMongoDB NormalizationЧтениеMongoDB Design–DenormalizationЧтениеCommon Ways to Query MongoDB DataЧтениеSyntax Rules for MongoDBЧтениеMongoDB Calculating Averages and TotalsЧтение

Module 3 Wrap-Up

Module 3 SummaryЧтение
04Database Constraints15 материалов

Lesson 1: Database Design Template

SQL: The Universal Data LanguageЧтениеAssess Your Learning: Introduction to SQLЗаданиеDatabase Design ExamplesЧтение

Lesson 2: Business Requirements and Rules

Key Tables of AdventureWorksЧтение

Lesson 3: Design Document

Document BasicsЧтениеDesigning and Modeling Document-Oriented DatabasesЧтение

Lesson 4: Introduction to SQL

SQL Server Management StudioЧтениеFront-End Tools for the Database EngineЧтениеDBeaverЧтениеEvolution of SQLЧтениеSQL Data DefinitionЧтениеProject Database Design DocumentВидеоAssess Your Learning: Project Database Design Document

Module 4 Wrap-Up

Module 4 SummaryЧтение
05SQL JOINs27 материалов

Lesson 1: Introduction to SQL Programming

Queries, SELECT, and JOINЧтениеInner, Outer, and Self JoinВидеоAssess Your Learning: Inner, Outer, and Self JoinЗаданиеHow to Learn About Our DataЧтениеHow to Get Started with SQL ProgrammingЧтение

Lesson 2: SQL Joins

SQL JOINsВидеоCommon Types of SQL JoinsЧтениеInner JoinsЧтениеLeft Outer JoinsЧтениеRight Outer JoinsЧтениеSelf JoinЧтениеUsing Self Joins with the Northwind DatabaseЧтениеClever Use of AliasesЧтениеClever Use of Aliases for JOINЧтениеUse SQL to Work with NoSQL Document Model DataЧтениеSQL JOINs for NoSQL Document Model DataЧтение

Lesson 3: SQL Programming Concepts

SQL Server Data TypesЧтениеSQL Identity PropertyЧтениеHow to Find Last Identity ValueЧтениеSimple Subquery vs. Correlated SubqueryЧтениеCommon Table Expression (CTE)ЧтениеGraph Processing–Recursive AllЧтение

Lesson 4: MongoDB Part 2

MongoDB ArchitectureЧтениеMongoDB ReplicationЧтение

Module 5 Wrap-Up

Module 5 SummaryЧтение
06Data Hierarchy16 материалов

Lesson 1: Data Hierarchy and SQL JOINs

Data Hierarchy and SQL JOINsВидеоData HierarchyВидеоAssess Your Learning: Data Hierarchy and SQL JOINsЗаданиеData Hierarchy and SQL JOINsЧтение

Lesson 2: Indexes and Indexing

Understanding IndexesЧтениеIndexing ConceptsЧтениеColumnstore Index BasicsЧтениеIndexing Best PracticesЧтениеCheck Your Knowledge: Indexing StrategiesЗадание

Lesson 3: SQL Programming Concepts

SQL INTERSECT and EXCEPT ConceptsЧтениеSQL INTERSECT and EXCEPT CommandsЧтениеAssess Your Learning: SQL INTERSECT and EXCEPT CommandsЗаданиеSQL Intersect and Except ExercisesЧтениеSQL UPDATE CommandЧтениеHow to Remove Data From SQL TableЧтение

Module 6 Wrap-Up

Module 6 SummaryЧтение
07SQL Ranking Functions and CASE24 материалов

Lesson 1: SQL Ranking Function

SQL RankingВидеоAssess Your Learning: SQL Ranking FunctionsЗаданиеHow to Best Work with SQL Ranking FunctionsЧтениеRANKЧтениеDENSE_RANKЧтениеROW_NUMBERЧтениеNTILEЧтениеSELECT TOP 1 WITH TIES vs. RANKЧтениеVideos on SQL FunctionsЧтениеDifferent Ways to Calculate MedianЧтениеHow to Remove Duplicates From a TableЧтениеReal-World Example Using SQL CASEЧтениеSample Report: Marketing Campaign PerformanceЧтение

Lesson 2: GROUP BY vs. PARTITION BY

GROUP BY vs. PARTITION BYВидеоAssess Your Learning: GROUP BY vs. PARTITION BYЗаданиеComparing GROUP BY and PARTITION BYЧтениеUse Case #1: Total Sales by TerritoryЧтениеUse Case #2: Most Expensive Order by TerritoryЧтениеUse Case #3: Top Performing TerritoryЧтение

Lesson 3: SQL Date Functions

Running Date ComponentsЧтениеCASE ExampleЧтение

Module 7 Wrap-Up

Module 7 SummaryЧтениеSaving Course MaterialЧтениеCongratulations! Чтение
Object Database NormalizationЧтение
Задание
Close Look at SQL SELECTЧтение
Data Aggregation and GROUP BYЧтение
GROUP BY WITH ROLLUP or CUBEЧтение