Relational Databases

Birla Institute Of Technology And Science–Pilani (BITS–Pilani) via Coursera

Go to class Write review

Details

Go to class

Provider

Coursera
Pricing

Paid Course
Languages

English
Certificate

Paid Certificate Available
Duration & workload

2 days 9 hours 10 minutes
Sessions

On-Demand
Subtitles

English

Found in

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

Grab it

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.

Syllabus

Introduction to Database Management Systems

All Information Systems operate on data. Most of the systems depend on Database Management Systems, commonly referred as DBMS, to store the data and enable updates and retrievals. Modern DBMS have rich functionality to maintain and protect data during concurrent access from users. We look at expectations from DBMS to meet the needs of organizations. We will finally look at varieties of DBMS that are available.

Data Modeling

In this module, we discuss the basic concepts of conceptual database design. We understand anomalies in database operations. You will be introduced to the Entity–Relationship (ER) model, which is a popular high-level conceptual data model. We will discuss the diagrammatic notations used with the ER model, the ER model's constraints, and their use in the design of conceptual schemas for database applications. We also understand the basics of the Enhanced Entity–Relationship (EER) Model.

Relational Data Model

In this module, we discuss the basic concepts of Relational Model. We understand the Relational Model Terminologies. We discuss the characteristics of Relations and the Relational constraints. We also learn and understand the update Operations and the ways to deal with Constraint Violations. We learn the steps and process of mapping ER Constructs to relations.

Relational Algebra & Relational Calculus

In this module, we will learn formal query languages associated with the relational model. We will look at query operators in these languages and see how we can combine the operators to get the desired results.

Structured Query Language (SQL)

In this module, we will learn Structured Query Language(SQL), which is a standard-based language implemented by all relational databases to enable working with the structure and contents of the database . We will look at statements for defining schema, querying, and updating data in the database.

Relational Database Design and Normalization

In this module, we discuss the basic concepts of Functional dependencies and inference rules. We understand anomalies in database operations. We understand the need for normalization of relational schemas. We discuss the conditions for various Normal Forms- 2NF, 3NF, and BCNF. We explore the process of decomposition used to take a relation to higher normal forms. We learn how to check whether a decomposition is lossless or dependency-preserving.

Disk, File Storage and Hashing

In this module, you will understand important disk properties and how data is stored on the disk. You learn about the File storage schemes for storing data. You learn important static hashing and dynamic hashing schemes used for storing and fast retrieval of data from the database

Indexing

In this module, you will understand what is Indexing and its purpose in Databases. You will gain knowledge about the various categories of Indexing schemes like- Primary indexing, Secondary indexing and Multilevel indexing, and also learn how to design the same. You will understand and learn to design B+ tree indexing structures for Relational databases.

Transaction Processing and Concurrency Control

In this module, you learn about the Transaction model used in relational database systems which includes the need for a transaction, concept of schedule, serial and concurrent schedules, and serializability. You learn the need for concurrency control and the concept of locks-based concurrency control, deadlock and deadlock detection. You also learn about Timestamp-based protocols for concurrency control.

Database Recovery, Query Optimisation, and Database Security

In this module, first, you learn various schemes to recover from loss in the event of a crash, and restoring the databases with minimum impact. You learn more on log-based recovery techniques including checkpointing. Then, you understand the steps in SQL query processing and you are introduced to Query optimisation and Heuristics used. Next, you will get an introduction to Database security and important schemes used in securing databases from unauthorised access.