Tutors

The Diploma

PROGRAM OVERVIEW

Description

A database is an organized collection of data. A relational database, more restrictively, is a collection of schemas, tables, queries, reports, views, and other elements. Database designers typically organize the data to model aspects of reality in a way that supports processes requiring information. A database-management system (DBMS) is a computer-software application that interacts with end-users, other applications, and the database itself to capture and analyze data. A general-purpose DBMS allows the definition, creation, querying, update, and administration of databases. A database is not generally portable across different DBMSs, but different DBMSs can interoperate by using standards.


What will you learn?

ER‐model, Relational model: relational algebra, tuple calculus, SQL, Integrity constraints, normal forms. File organization, indexing (e.g., B and B+ trees), Transactions and concurrency control, Recovery System-Failure, Classification-Storage, Structure-Recovery & Atomicity log-based recovery, etc.


Prerequisites

1. Basic understanding of programming languages like C++, Java 


2. Basic knowledge of SQL (Structured Query Language) then you're good to go with any Databases.

 

CURRICULUM

  Introduction to DBMS

  • Introduction to DBMS
  • Types of Databases

  ER‐Model-Relationships

  • Entity - Relationships
  • Types of Relationships
  • Degree of Relationship
  • Relational Models

  ER-Model-Module-1

  • Er - Modeling
  • Participation Constraints
  • Cardinality Ratio
  • Attributes

  ER-Model-Module-2

  • Er - Diagrams
  • Keys
  • Foreign Key-Lecture 01
  • Foreign Key-Lecture 02

  Functional Dependencies-Module-1

  • Functional Dependency
  • Armstrong Inference Rule
  • Closure of Functional Dependency

  Functional Dependencies-Module-2

  • Applications of Closure
  • Canonical Cover Of F.D- Lecture 01
  • Canonical Cover Of F.D- Lecture 02

  Normalization

  • Normalizations
  • Normal Forms
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

  Schema Refinement-Normalization

  • Essential Properties of Decomposition-Lecture 01
  • Essential Properties of Decomposition-Lecture 02

  Boyce Codd Normal Form

  • Boyce Codd Normal Form