Database Management Systems

  1. Home
  2. Database-management
  3. Database Management Systems

Tags: Database Management

Learn Database Management Systems from scratch as Database Management System forms the core of computer science

Last updated 2022-01-10 | 4.6

- You will become very familiar with the core concepts of Database Management Systems
- You will be able to challenge the interviewer on questions related to Database Management Systems
- You will view Computer Science in a different dimension

What you'll learn

You will become very familiar with the core concepts of Database Management Systems
You will be able to challenge the interviewer on questions related to Database Management Systems
You will view Computer Science in a different dimension
You will be able to answer all questions of exams like GATE
PGEE
ISRO
You will be able to get a top grade in your Database Management Systems course in your Bachelor's degree
Understand how Database Management Systems work

* Requirements

* Have a PC with internet connection
* Even ZERO knowledge in Database Management Systems is fine - I'll teach you everything you need to know

Description

Welcome to the course Database Management system from scratch !!!

Mastering the concepts of Database Management System is very important to get started with Computer Science because Database Management System is the program which is responsible for the ease with which we are able to fetch the data from the database and that is the backbone of internet today. The concepts which we are going to study is going to give a very good understanding of Database Management System and by the end of it you will be able to answer any interview question on Database Management System.

Without using Database Management Systems ,it is extremely difficult to communicate with the data in the server. Every server today has Database Management System installed in it. Through this course you will not only master the basics of Database Management Systems but also get ready for venturing into advanced concepts of Database Management Systems.

In this course ,every concept of Database Management System is taught in an easy-to-understand manner such that anybody without any prerequisites will be able to master the concepts of Database Management System in the easiest way.

Come and join me, I assure you that you will have the best learning experience of not just Database Management Systems but also the core of Computer Science in a different dimension.

Who this course is for:

  • Anybody who needs to learn Database Management System from scratch
  • Anybody who wants to pursue a career in Computer Science
  • Anybody who has Database Management System in the Bachelor's degree
  • Anybody who is preparing for interview in product based companies
  • If you are preparing for exams like GATE , PGEE , BITS HD , ISRO ,..etc
  • If you are a Computer Science Engineer

Course content

13 sections • 105 lectures

Introduction 3 lectures

Important Tip Preview 00:30

Introduction Preview 10:18

Data model and its types Preview 03:54

Basics of ER model 7 lectures

Entity, Relationship and Attribute Explained Preview 11:16

Database Designer's perspective Preview 04:13

ER Model and Relational Model - Advantages and Disadvantages Preview 02:00

Basic Idea of Attributes of relationship Preview 01:57

Simple vs Composite Attributes, Single valued vs Multi-valued Attributes Preview 11:17

Stored vs Derived Attributes Preview 04:13

Complex Attributes Preview 02:23

Relationship - Terminologies and Types 8 lectures

Degree of a relationship and Cardinality Ratio Preview 11:15

Cardinality Ratio Explained with example Preview 05:53

Types of Participation - Total vs Partial Participation Preview 09:12

Example to illustrate Total and Partial Participation Preview 05:09

More Examples on Maximum and Minimum Cardinality Preview 08:06

Types of Relationships Preview 02:35

Recursive Relationship Preview 09:09

Example on finding the type of relationship Preview 01:19

Relational Model 4 lectures

Tuple, Field, Domain and Entity vs Entity types Preview 07:34

How Relational Model is derived from Discrete Math Preview 12:36

Degree of a relation, state of a relation, Intention vs Extension Preview 03:37

Important Rules in Relational Model Preview 07:29

Constraints of Relational Model 2 lectures

Types of Constraints, Domain Constraints Explained Preview 09:55

Key Constraints - Intro Preview 02:06

Keys, Super Keys, Candidate Keys, Primary Keys 8 lectures

Super Key Explained with example Preview 14:50

More Points on Super Key Preview 09:13

Key Explained with example Preview 12:28

Example to illustrate the difference between Key and Super Key Preview 06:06

Super Key vs Key vs Candidate Key vs Primary Key Preview 09:08

Finding the number of Super Keys Preview 09:17

Finding the number of Super Keys - 2 Preview 03:06

Finding the number of Super Keys - 3 Preview 02:47

Constraints of Relational Model Revisited 12 lectures

Key Constraints Preview 08:12

Entity Integrity Constraints Preview 03:30

Foreign Key Explained with example Preview 10:29

Example on Foreign Key Preview 06:13

Difference between Foreign Key and Primary Key Preview 08:11

Referential Integrity Constraints Preview 01:19

Constraints violated by Insertion Preview 11:44

Constraints violated by Deletion Preview 04:57

Constraints violated by Updation and Viewing Preview 04:59

Steps taken by DBMS in case of constraint violation Preview 13:00

Problem on ON-DELETE CASCADE Preview 05:06

Problem on Referential Integrity Constraint Preview 05:53

More on Finding the Number of Super Keys 6 lectures

Problem 1 on finding the number of Super Keys Preview 04:34

Finding Number of Super Keys using Venn Diagram 1 Preview 12:14

Finding Number of Super Keys using Venn Diagram 2 Preview 13:15

Important Observation Preview 03:02

Finding Number of Super Keys using Venn Diagram 3 Preview 04:56

Finding Number of Super Keys using Venn Diagram 4 Preview 03:39

Conversion of ER Model to Relational Model 21 lectures

Conversion of Entities, Attributes, Prime Attribute and Composite Attributes Preview 04:26

Conversion of one-to-many relationship Preview 14:05

Example for conversion of one-to-many relationship Preview 12:22

Conversion of One-to-one relationship Preview 07:19

Conversion of Many-to-many relationship Preview 09:32

A good approach to follow but not a rule Preview 11:10

Problem on Multivalued attributes Preview 06:45

Problem on finding minimum number of tables needed for conversion Preview 05:57

Problem on finding maximum number of tables needed for conversion Preview 03:23

Special Case : One-to-one relationship with total participation on both sides Preview 11:21

Lecture 60 continued Preview 05:36

Weak vs Strong Entity - Differences Preview 02:54

Example to illustrate Weak Entity and their conversion to Relational model Preview 12:38

N-ary relationships Preview 04:51

Identifying Relationships Preview 02:34

Important Notations Revisit Preview 01:15

Problem 1 Preview 03:52

Attributes to relationship : one to many relationship Preview 11:49

Attributes to relationship : one-to-one relationship Preview 03:17

Attributes to relationship : many-to-many relationship Preview 04:20

Problem Preview 03:41

Functional Dependencies 13 lectures

Introduction to Functional Dependencies Preview 04:21

Examples on Functional Dependency Preview 07:21

Important Point to note Preview 03:16

More Examples on Functional Dependency Preview 02:58

Trivial Functional Dependency Preview 06:06

Non Trivial Functional Dependency Preview 04:07

Semi Trivial Functional Dependency Preview 02:16

Important Point to Note Preview 15:01

Closure set of an attribute 1 Preview 15:06

Closure set of an attribute 2 Preview 03:56

Closure set of an attribute 3 Preview 06:09

Example on finding Closure Set Preview 06:17

Applications of Closure operation Preview 02:05

Finding the Keys using Closure Operation 14 lectures

Problem 1 on finding keys using Closure Operation Preview 10:52

Problem 2 on finding keys using Closure Operation Preview 03:46

Problem 3 on finding keys using Closure Operation Preview 15:36

Problem 4 on finding keys using Closure Operation Preview 10:27

Problem 4 on finding keys using Closure Operation - continued Preview 15:25

Problem 5 on finding keys using Closure Operation Preview 06:46

Problem 6 on finding keys using Closure Operation Preview 02:36

Problem 7 on finding keys using Closure Operation Preview 03:12

Problem 8 on finding keys using Closure Operation Preview 02:15

Problem 9 on finding keys using Closure Operation Preview 12:40

Problem 1 on finding keys of sub relation Preview 10:01

Problem 2 on finding keys of sub relation Preview 07:46

Problem 3 on finding keys of sub relation Preview 03:33

Problem Preview 04:33

Equivalence and Minimization of FD sets using Closure 6 lectures

Checking Equivalence of FD'S - 1 Preview 08:24

Checking Equivalence of FD'S - 2 Preview 02:13

Checking Equivalence of FD'S - 3 Preview 04:32

Checking Equivalence of FD'S - 4 Preview 02:35

Minimization of Functional Dependency Set - 1 Preview 14:12

Minimization of Functional Dependency Set - 2 Preview 08:13

Bonus Section 1 lectures

Bonus : How to proceed further Preview 00:23