Database Management System

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 these topics in 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

* Should have a PC with internet connection
* Should have watched part 1 course of Database Management System

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
  • 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

10 sections • 67 lectures

Closure of Functional Dependency Set Preview 10:21

Rough Idea of Normalization Preview 03:07

Lossless Decomposition Preview 11:58

Lossless Decomposition Continued Preview 09:40

Problem on Lossless Decomposition Preview 04:32

Attribute Preserving Decomposition Preview 02:26

Functional Dependency Preserving Decomposition Preview 14:00

First Normal Form Explained Preview 08:51

Problem to illustrate First Normal Form Preview 02:12

Second Normal Form Explained Preview 09:07

Conversion of a relation to Second Normal Form Preview 12:56

Problem 1 Preview 17:08

Problem 2 Preview 11:47

Problem 2 continued Preview 10:28

Advantage of following Lossless Decomposition Preview 02:43

Other Formal Definitions of Second Normal Form Preview 02:15

Third Normal Form Explained Preview 08:47

Another way of looking at third normal form Preview 04:35

Problem 1 Preview 08:30

Problem 2 Preview 04:54

Problem 3 Preview 09:25

Introduction to Relational Algebra Preview 07:50

Selection Operation Preview 09:38

More points on Selection Preview 09:40

Projection Operation Preview 04:42

More points on Projection Preview 08:50

Rename Operation Preview 03:03

Union Operation Preview 06:20

Intersection Operation Preview 03:15

Set Difference Operation Preview 05:27

Cartesian Product Preview 05:53

Join Operation Preview 08:29

Important Points to note Preview 03:04

Natural Join Preview 07:52

Cartesian Product vs Join vs Natural Join Preview 06:06

Quick Summary Preview 00:51

Left Outer Join and Right Outer Join Preview 13:28

Full Outer Join Preview 02:25

Inner Join vs Left Outer Join vs Right Outer Join vs Full Outer Join Preview 04:30

Minimum and Maximum number of tuples possible Preview 15:15

Problem 1 Preview 14:23

Problem 2 Preview 15:58

Problem 3 Preview 06:20

Problem 4 Preview 16:50

Problem 4 explained with example Preview 08:54

Problem 5 Preview 10:49

Problem 5 explained with example Preview 07:08

Problem 6 Preview 15:33

Problem 7 Preview 08:04

Problem 8 Preview 10:02

Problem 9 Preview 13:46