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

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

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

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

Relational Databases

Курс от Birla Institute of Technology & Science, Pilani
Средний≈ 57.2 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Master the art of relational databases with this comprehensive course, designed to equip you with essential skills for database modeling, design, and implementation. You’ll start with core concepts like Entity-Relationship (ER) modeling, progressing through relational algebra and foundational SQL commands for creating, manipulating, and querying databases. The course covers advanced topics, including normalization, storage, and indexing techniques, providing a solid understanding of Relational Database Management Systems (RDBMS). You'll delve into critical areas such as transaction processing, concurrency control, database recovery, query optimization, and database security. With a balance of theory and hands-on online practical sessions, you'll gain the confidence to implement relational databases for real-world applications. This course is ideal for anyone interested in database management, from software engineers to data scientists. By the end, you'll have the knowledge and skills to tackle challenging database assignments and excel in a dynamic field.

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

Relational DatabasesDatabase DesignSQLQuery LanguagesDatabase Management SystemsTransaction ProcessingDatabase ManagementData StorageDatabase DevelopmentInformation ArchitectureDatabase TheoryDatabasesSystem Design and ImplementationProblem SolvingData AnalysisDatabase Architecture and AdministrationData ManagementLogical ReasoningInformation TechnologyData Modeling

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

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

01Introduction to Database Management Systems28 материалов

Course Introduction

Course OverviewЧтениеMeet your Instructor - Prof. T. V. RaoВидеоMeet your Instructor - Prof. Preeti N. GВидеоMeet your Instructor - Prof. R. GururajВидео

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

BITS Pilani Instructors Group

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

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 57.2 ч

10 модулей

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

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

Why are Databases Needed?

Data for Information Systems ВидеоRecommended Reading: Data for Information SystemsЧтениеExample of a DatabaseВидеоRecommended Reading: Example of a DatabaseЧтениеWhy Take a Database Approach?ВидеоRecommended Reading: Why Take a Database Approach?ЧтениеWhy are Databases Needed?Задание

Capabilities Expected of a Database

Different Types of Users and Their NeedsВидеоRecommended Reading: Different Types of Users and Their NeedsЧтениеOrganisational Concerns with Data - 1ВидеоRecommended Reading: Organisational Concerns with Data - 1ЧтениеOrganisational Concerns with Data - 2ВидеоRecommended Reading: Organisational Concerns with Data - 2ЧтениеCapabilities Expected of a DatabaseЗадание

Varieties of Databases

History of Databases ВидеоRecommended Reading: History of Databases ЧтениеRelational DatabasesВидеоRecommended Reading: Relational DatabasesЧтениеNoSQL Databases ВидеоRecommended Reading: NoSQL Databases ЧтениеVarieties of DatabasesЗадание

Summary and Assessment

Let's Practice: Introduction to Database Management SystemsЗаданиеTest Yourself: Introduction to Database Management SystemsЗадание
02Data Modeling33 материалов

Overview of the Database Design Process and a Sample Database Application

Simplified Overview of the Database Design ProcessВидеоRecommended Reading: Simplified Overview of the Database Design ProcessЧтениеUnderstanding a Sample Database ApplicationВидеоRecommended Reading: Understanding a Sample Database ApplicationЧтениеOverview of the Database Design Process and a Sample Database ApplicationЗадание

Understanding Entity Types, Entity Sets, Attributes, and Keys

Entities and Attributes , Entity Types and Entity Sets ВидеоRecommended Reading: Entities and Attributes, Entity Types and Entity Sets ЧтениеKey Attributes of an Entity Type, Value Sets (Domains) of AttributesВидеоRecommended Reading: Key Attributes of an Entity Type, Value Sets (Domains) of AttributesЧтениеInitial Conceptual Design of the COMPANY DatabaseВидеоRecommended Reading: Initial Conceptual Design of the COMPANY DatabaseЧтениеUnderstanding Entity Types, Entity Sets, Attributes, and KeysЗадание

Relationship Types, Roles, and Structural Constraints and Weak Entity Type

Relationship Types, Relationship Degree, Role Names, and Recursive RelationshipsВидеоRecommended Reading: Relationship Types, Relationship Degree, Role Names, and Recursive RelationshipsЧтениеConstraints on Binary Relationship TypesВидеоRecommended Reading: Constraints on Binary Relationship TypesЧтениеAttributes of Relationship TypesВидеоRecommended Reading: Attributes of Relationship TypesЧтение

The Enhanced Entity–Relationship (EER) Model

Basic Concepts of Enhanced Entity–Relationship (EER) Model ВидеоRecommended Reading: Basic Concepts of Enhanced Entity–Relationship (EER) Model ЧтениеSubclasses, Superclasses, Specialisation, and GeneralisationВидеоRecommended Reading: Subclasses, Superclasses, Specialisation, and GeneralisationЧтениеConstraints on Specialisation and GeneralisationВидеоRecommended Reading: Constraints on Specialisation and GeneralisationЧтение

Summary and Assessment

Designing a University Database SystemDIALOGUELet's Practice: Data ModelingЗаданиеTest Yourself: Data ModelingЗадание
03Relational Data Model42 материалов

Relational Model Concepts

Relational Model Concepts and TerminologyВидеоRecommended Reading: Relational Model Concepts and TerminologyЧтениеDomains, Attributes, Tuples, and RelationsВидеоRecommended Reading: Domains, Attributes, Tuples, and RelationsЧтениеUnderstanding Relation Schema and Relation State with ExamplesВидеоRecommended Reading: Understanding Relation Schema and Relation State with ExamplesЧтениеRelational Model ConceptsЗадание

Characteristics of a Relation

Characteristics of a RelationВидеоRecommended Reading: Characteristics of a RelationЧтениеRelational Model NotationВидеоRecommended Reading: Relational Model NotationЧтениеCharacteristics of a RelationЗадание

Relational Model Constraints

Constraints on Databases and their CategoriesВидеоRecommended Reading: Constraints on Databases and their CategoriesЧтениеDomain and Key ConstraintsВидеоRecommended Reading: Domain and Key ConstraintsЧтениеEntity Integrity and Referential Integrity ConstraintsВидеоRecommended Reading: Entity Integrity and Referential Integrity ConstraintsЧтение

Update Operations and Dealing with Constraint Violations

Update Operations, and Dealing with Constraint ViolationsВидеоRecommended Reading: Update Operations, and Dealing with Constraint ViolationsЧтениеThe Insert OperationВидеоRecommended Reading: The Insert OperationЧтениеThe Delete OperationВидеоRecommended Reading: The Delete OperationЧтение

Steps to Map ER Constructs to Relations

ER-to-Relational Mapping Algorithm. Mapping of Regular and Weak Entity TypesВидеоRecommended Reading: ER-to-Relational Mapping Algorithm. Mapping of Regular and Weak Entity TypesЧтениеMapping of Binary 1:1 and 1:N Relationship TypesВидеоRecommended Reading: Mapping of Binary 1:N Relationship TypesЧтениеMapping of Binary M:N Relationship TypesВидеоRecommended Reading: Mapping of Binary M:N Relationship TypesЧтение

Summary and Assessment

Troubleshooting Constraint DIALOGUELet's Practice: Relational Data ModelЗаданиеTest Yourself: Relational Data ModelЗадание
04Relational Algebra & Relational Calculus33 материалов

Formal Query Languages

Introduction to Formal Query LanguagesВидеоRecommended Reading: Introduction to Formal Query LanguagesЧтениеOperations in Query Languages ВидеоRecommended Reading: Operations in Query LanguagesЧтениеFormal Query LanguagesЗадание

Relational Algebra - Unary & Set operations

SELECT and PROJECT OperationsВидеоRecommended Reading: SELECT and PROJECT OperationsЧтениеCombine Sequence of OperationsВидеоRecommended Reading: Combine Sequence of OperationsЧтениеUnion, Intersection, and Minus OperationsВидеоRecommended Reading: Union, Intersection, and Minus OperationsЧтениеCartesian Product OperationВидеоRecommended Reading: Cartesian Product OperationЧтениеRelational Algebra - Unary & Set operationsЗадание

Relational Algebra - Binary & Aggregate operations

Join OperationВидеоRecommended Reading: Join OperationЧтениеEquiJoin and Natural Join OperationsВидеоRecommended Reading: EquiJoin and Natural Join OperationsЧтениеOuter Join OperationВидеоRecommended Reading: Outer Join OperationЧтение

Relational Calculus

Tuple Relational CalculusВидеоRecommended Reading: Tuple Relational CalculusЧтениеDomain Relational CalculusВидеоRecommended Reading: Domain Relational CalculusЧтениеRelational CalculusЗадание

Summary and Assessment

Query Builder ProDIALOGUELet's Practice: Relational Algebra & Relational CalculusЗаданиеTest Yourself: Relational Algebra & Relational CalculusЗадание
05Structured Query Language (SQL)42 материалов

SQL Introduction

History of the SQLВидеоRecommended Reading: History of the SQLЧтениеOverview of SQL ВидеоRecommended Reading: Overview of SQL ЧтениеSQL IntroductionЗадание

Data Definition Language

DDL OverviewВидеоRecommended Reading: DDL OverviewЧтениеCREATE TABLE StatementВидеоRecommended Reading: CREATE TABLE StatementЧтениеDefining ConstraintsВидеоRecommended Reading: Defining ConstraintsЧтениеMaking Changes to SchemaВидеоRecommended Reading: Making Changes to SchemaЧтениеData Definition LanguageЗадание

SELECT Statement

SELECT Statement StructureВидеоRecommended Reading: SELECT Statement StructureЧтениеTuple Variable Usage, Alias and RenamingВидеоRecommended Reading: Tuple Variable Usage, Alias and RenamingЧтениеSet Operations on TableВидеоRecommended Reading: Set Operations on TableЧтение

SQL Modification Statements

INSERT StatementВидеоRecommended Reading: INSERT StatementЧтениеUPDATE StatementВидеоRecommended Reading: UPDATE StatementЧтениеDELETE StatementВидеоRecommended Reading: DELETE StatementЧтениеSQL Modification Statements

Advanced Queries in SQL

Nested QueriesВидеоRecommended Reading: Nested QueriesЧтениеEXISTS & UNIQUE ClausesВидеоRecommended Reading: EXISTS & UNIQUE ClausesЧтениеJoins in SQLВидеоRecommended Reading: Joins in SQLЧтениеAggregates in SQL

Summary and Assessment

SQL Analytics MasterDIALOGUELet's Practice: Structured Query Language (SQL)ЗаданиеTest Yourself: Structured Query Language (SQL)Задание
06Relational Database Design and Normalization24 материалов

Informal Design Guidelines, Update Anomalies, Functional Dependencies, and Inference Rules

Informal Design Guidelines and Update AnomaliesВидеоRecommended Reading: Informal Design Guidelines and Update AnomaliesЧтениеFunctional Dependencies and Inference RulesВидеоRecommended Reading: Functional Dependencies and Inference RulesЧтениеInformal Design Guidelines, Update Anomalies, Functional Dependencies, and Inference RulesЗадание

Introduction to Normalization, Normal Form(NF), Decomposition and Conditions for 1NF, 2NF, 3NF and BCNF

Introduction to Normalisation, Normal Forms, and Decomposition ProcessВидеоRecommended Reading: Introduction to Normalisation, Normal Forms, and Decomposition ProcessЧтение3NF and BCNFВидеоRecommended Reading: 3NF and BCNFЧтениеProblem Solving on NormalisationВидеоRecommended Reading: Problem Solving on NormalisationЧтениеIntroduction to Normalisation, Normal Form(NF), Decomposition and Conditions for 1NF, 2NF, 3NF and BCNFЗадание

Desirable Properties of a Decomposition, Lossless and Dependency Preserving Decomposition

Decomposition and Lossless Join Decomposition Part - 1ВидеоDecomposition and Lossless Join Decomposition Part -2ВидеоRecommended Reading: Decomposition and Lossless join decompositionЧтениеDependency Preserving Decomposition Part - 1ВидеоDependency Preserving Decomposition Part - 2ВидеоRecommended Reading: Dependency Preserving DecompositionЧтение

Summary and Assessment

Database Design MasterDIALOGUELet's Practice: Relational Database Design and NormalizationЗаданиеTest Yourself: Relational Database Design and NormalizationЗадание
07Disk, File Storage and Hashing24 материалов

Disk Properties and File Storage Schemes for Storing Data

Introduction to Data Storage MediaВидеоRecommended Reading: Introduction to Data Storage MediaЧтениеMagnetic Disk StorageВидеоRecommended Reading: Magnetic Disk StorageЧтениеDisk Access, Data Transfer, and RAID SystemsВидеоRecommended Reading: Disk Access, Data Transfer, and RAID SystemsЧтениеFile Organisation for Data StorageВидеоRecommended Reading: File Organisation for Data StorageЧтениеDisk Properties and File Storage Schemes for Storing DataЗадание

Hashing for Database Systems and Static Hashing

Introduction to HashingВидеоRecommended Reading: Introduction to HashingЧтениеStatic Hashing ВидеоRecommended Reading: Static Hashing ЧтениеHashing for Database Systems and Static HashingЗадание

Dynamic Hashing Schemes

Need for Dynamic Hashing and Extendible HashingВидеоRecommended Reading: Need for Dynamic Hashing and Extendible HashingЧтениеLinear HashingВидеоRecommended Reading: Linear HashingЧтениеProblem Solving on Disk Storage and Dynamic Hashing Part - 1ВидеоProblem Solving on Disk Storage and Dynamic Hashing Part - 2Видео

Summary and Assessment

Let's Practice: Disk, File Storage and HashingЗаданиеTest Yourself: Disk, File Storage and HashingЗадание
08Indexing27 материалов

Introduction to Indexing and Basic Concepts

Introduction to IndexingВидеоRecommended Reading: Introduction to IndexingЧтениеClassification of IndexingВидеоRecommended Reading: Classification of IndexingЧтениеIntroduction to Indexing and Basic ConceptsЗадание

Primary and Multilevel Indexing

Primary and Multilevel Indexing ConceptsВидеоRecommended Reading: Primary and Multilevel Indexing ConceptsЧтениеExamples for Primary and Multilevel IndexingВидеоRecommended Reading: Examples for Primary and Multilevel IndexingЧтениеPrimary and Multilevel IndexingЗадание

Clustering and Secondary Indexes

Clustering IndexВидеоRecommended Reading: Clustering IndexЧтениеSecondary IndexВидеоRecommended Reading: Secondary IndexЧтениеClustering and Secondary IndexesЗадание

B+ Tree Indexing

B+ Tree Indexing for DatabasesВидеоRecommended Reading: B+ Tree Indexing for DatabasesЧтениеExamples on B+ Tree IndexingВидеоRecommended Reading: Examples on B+ Tree IndexingЧтениеB+ Tree IndexingЗадание

Problem solving on Indexing

Problem Solving on Primary, Multilevel and Secondary IndexingВидеоRecommended Reading: Problem Solving on Primary, Multilevel and Secondary IndexingЧтениеProblem Solving on B+ Tree IndexingВидеоRecommended Reading: Problem Solving on B+ Tree IndexingЧтениеProblem Solving on IndexingЗадание

Summary and Assessment

Let's Practice: IndexingЗаданиеTest Yourself: IndexingЗадание
09Transaction Processing and Concurrency Control26 материалов

Transaction Model

Introduction to Transaction ModelВидеоRecommended Reading: Introduction to Transaction ModelЧтениеTransaction States and ACID PropertiesВидеоRecommended Reading: Transaction States and ACID PropertiesЧтениеTransaction ModelЗадание

Schedules of Transactions

Serial and Concurrent SchedulesВидеоRecommended Reading: Serial and Concurrent SchedulesЧтениеConflict SerialisabilityВидеоRecommended Reading: Conflict SerialisabilityЧтениеTest for Conflict Serialisability, Basics of and Recoverability and Cascading RollbackВидеоRecommended Reading: Test for Conflict Serialisability, Basics of and Recoverability and Cascading RollbackЧтениеSchedules of TransactionsЗадание

Concurrency Control

Need for Controlling ConcurrencyВидеоRecommended Reading: Need for Controlling ConcurrencyЧтениеLock-Based Concurrency Control ВидеоRecommended Reading: Lock-Based Concurrency Control Чтение DeadlocksВидеоRecommended Reading: DeadlocksЧтение

Summary and Assessment

Let's Practice: Transaction Processing and Concurrency ControlЗаданиеTest Yourself: Transaction Processing and Concurrency ControlЗадание
10Database Recovery, Query Optimisation, and Database Security29 материалов

Database Recovery

Introduction to Database Recovery and Log-based RecoveryВидеоRecommended Reading: Introduction to Database Recovery and Log-based RecoveryЧтениеDeferred and Immediate Modification TechniquesВидеоRecommended Reading: Deferred and Immediate Modification TechniquesЧтениеCheckpointing in Database Recovery ProcessВидеоRecommended Reading: Checkpointing in Database Recovery ProcessЧтениеDatabase RecoveryЗадание

SQL Query Execution and Optimization

Steps in SQL Query Execution ВидеоRecommended Reading: Steps in SQL Query Execution ЧтениеAlgorithms for Query ExecutionВидеоRecommended Reading: Algorithms for Query ExecutionЧтениеQuery Trees, Heuristic Optimisation and Cost ComponentsВидеоRecommended Reading: Query Trees, Heuristic Optimisation and Cost ComponentsЧтение

Database Security

Introduction to Database SecurityВидеоRecommended Reading: Introduction to Database SecurityЧтениеAccess Control MechanismsВидеоRecommended Reading: Access Control MechanismsЧтениеOther Important Concepts in Database SecurityВидеоRecommended Reading: Other Important Concepts in Database SecurityЧтение

Problem solving

Problem Solving on DB RecoveryВидеоRecommended Reading: Problem Solving on DB RecoveryЧтениеProblem Solving on Query OptimisationВидеоRecommended Reading: Problem Solving on Query OptimisationЧтениеProblem SolvingЗадание

Summary and Assessment

Let's Practice: Database Recovery, Query Optimisation, and Database SecurityЗаданиеTest Yourself: Database Recovery, Query Optimisation, and Database SecurityЗадание

Course Wrap-Up

Course SummaryЧтение
Weak Entity TypesВидео
Recommended Reading: Weak Entity TypesЧтение
Refining the ER Design for the COMPANY DatabaseВидео
Recommended Reading: Refining the ER Design for the COMPANY DatabaseЧтение
Relationship Types, Roles, and Structural Constraints and Weak Entity TypeЗадание
The Enhanced Entity–Relationship (EER) ModelЗадание
Relational Model ConstraintsЗадание
The Update OperationВидео
Recommended Reading: The Update OperationЧтение
Update Operations and Dealing with Constraint ViolationsЗадание
Mapping of Multivalued AttributesВидео
Recommended Reading: Mapping of Multivalued AttributesЧтение
Discussion and Summary of Mapping for ER Model ConstructsВидео
Recommended Reading: Discussion and Summary of Mapping for ER Model ConstructsЧтение
Steps to Map ER Constructs to RelationsЗадание
Division OperationВидео
Recommended Reading: Division OperationЧтение
Aggregate FunctionsВидео
Recommended Reading: Aggregate FunctionsЧтение
Relational Algebra - Binary & Aggregate OperationsЗадание
SELECT StatementЗадание
Задание
Видео
Recommended Reading: Aggregates in SQLЧтение
Views in SQLВидео
Recommended Reading: Views in SQLЧтение
Advanced Queries in SQLЗадание
Problem Solving on Decomposition PropertiesВидео
Recommended Reading: Problem Solving on Decomposition PropertiesЧтение
Desirable Properties of a Decomposition, Lossless and Dependency Preserving DecompositionЗадание
Recommended Reading: Problem Solving on Disk Storage and Dynamic HashingЧтение
Dynamic Hashing SchemesЗадание
Timestamp-Based Concurrency ControlВидео
Recommended Reading: Timestamp-Based Concurrency ControlЧтение
Problem Solving Part - 1Видео
Problem Solving Part - 2Видео
Recommended Reading: Problem Solving Чтение
Concurrency Control Задание
SQL Query Execution and OptimisationЗадание
Database Security Задание