Databases are used to store data in an accessible manner, it is so widespread that it is directly or indirectly used by most of the people without even realizing.

Databases are the crucial part of a website, banking system and even electronic devices. A Database Management System, essentially, is used to make handling of a Database easy.

This course will deal with various steps involved in designing and implementing a database. Structured Query Language (SQL) which is used to manage and retrieve data from databases will also be taught.

The aim of this course is to make you comfortable with the basics of Database Management Systems, while making you proficient in writing SQL statements and designing databases with the help of Entity-Relationship (ER) diagrams.

Batches

No batch is available

What you'll learn?

Introduction

Why is a database management system needed? Who are the users who access the database? 
 
All these basic questions will be answered in this section.
 
  • Introduction - Purpose of DBMS
  • View of Data
  • Database Language
  • Transaction Management
  • Storage Management
  • Database Users and Administrator
  • Database Views
  • Overall System structures
  • Different types of Database Systems

ER Model

To define the database at a conceptual level, we use ER model. You will learn how to design an ER diagram and the different concepts related to it.
 
  • Basic Concepts
  • Types of Attributes
  • Relationship Sets
  • Constraints
  • Keys
  • Weak Entity Sets
  • Extended ER Features
  • Constraints on Generalization
  • Aggregation
  • Ternary (Higher Order) Relationships
  • Mapping of ER Schema to Tables
  • Design Issues

Transaction

Learn how tasks are executed in a database, what happens if a failure occurs and the steps to avoid it.
 
  • Concept
  • State
  • Implementation of Atomicity and Durability
  • Concurrent Execution
  • Serializability
  • Testing for Serializability
  • Recoverability
  • Transaction Definition in SQL

Concurrency

Hundreds or maybe thousands of users access the database at a single time. Learn how a database 
handles concurrent access and the problems it faces.
 
  • Lock based Protocol
  • Timestamp based Protocol
  • Validation based Protocol
  • Deadlock Handling
  • Insert and Delete Operations
  • Concurrency in Index Structure

Recovery

In case of a failure of the system or any other mishappenings, there has to be a solid method to keep the data intact at all costs. You’ll learn more about it in this section.
 
  • Failure Classification
  • Recovery and Atomicity
  • Log Based Recovery
  • Shadow Paging

Normalization

Normalization is a technique of removing anomalies in the database. Learn more about why and how it is done in this section.
 
  • Need for Narmalization (Update Anomalies)
  • Non- Prime Attribute
  • Functional Dependency
  • Trival Functional Dependency
  • Full Functional Dependency
  • Normalization

SQL

Structured Query Language (SQL) is the language of the database, it is important to know this language so as to manage and retrieve data from any database efficiently.
 
  • Datatypes
  • Creating a Table
  • Inserting into a Table
  • Viewing into a Table
  • Creating a Table from a Table
  • Inserting into a Table from another Table
  • Delete
  • Update Operation
  • Modifying the structure of the table
  • Renaming Tables
  • Truncating Tables
  • Destroying tables
  • Constraints
  • DUAL Table
  • Aggregate Functions
  • Grouping data  from Tables
  • SUBQUERIES
  • JOINS
  • Views
  • PL/SQL

Additional Important Questions

  • Security and Authorization
  • Closure of a Set of Functional Dependencies
  • Armstrong's Axiom
  • Canonical Cover
  • Desiable Properties of Decomposition
  • Codd's Rule