Database Management System from scratch - Part 2

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

4.47 (2909 reviews)
Udemy
platform
English
language
Other
category
instructor
9,294
students
9 hours
content
Feb 2023
last update
$84.99
regular price

What you will 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

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.

Content

Introduction to Decomposition

Closure of Functional Dependency Set
Rough Idea of Normalization
Lossless Decomposition
Lossless Decomposition Continued
Problem on Lossless Decomposition
Attribute Preserving Decomposition
Functional Dependency Preserving Decomposition

Problems on Lossless, Attribute Preserving and FD Preserving Decomposition

Problem 1
Problem 2
Problem 3
Problem 4

First Normal Form

First Normal Form Explained
Problem to illustrate First Normal Form

Second Normal Form

Second Normal Form Explained
Conversion of a relation to Second Normal Form
Problem 1
Problem 2
Problem 2 continued
Advantage of following Lossless Decomposition
Other Formal Definitions of Second Normal Form

Third Normal Form

Third Normal Form Explained
Another way of looking at third normal form
Problem 1
Problem 2
Problem 3

Boyce Codd Normal Form (BCNF)

BCNF Explained
Problem 1
Problem 2
Problem 3
Important Result
Problem 4
Problem 5
Problem 6
Problem 6 continued
Problem 7
Problem 8

Operations of Relational Algebra

Introduction to Relational Algebra
Selection Operation
More points on Selection
Projection Operation
More points on Projection
Rename Operation
Union Operation
Intersection Operation
Set Difference Operation

Joins

Cartesian Product
Join Operation
Important Points to note
Natural Join
Cartesian Product vs Join vs Natural Join
Quick Summary
Left Outer Join and Right Outer Join
Full Outer Join
Inner Join vs Left Outer Join vs Right Outer Join vs Full Outer Join
Minimum and Maximum number of tuples possible

Problems on Relational Algebra

Problem 1
Problem 2
Problem 3
Problem 4
Problem 4 explained with example
Problem 5
Problem 5 explained with example
Problem 6
Problem 7
Problem 8
Problem 9

How to proceed further

Discounts to my other courses

Screenshots

Database Management System from scratch - Part 2 - Screenshot_01Database Management System from scratch - Part 2 - Screenshot_02Database Management System from scratch - Part 2 - Screenshot_03Database Management System from scratch - Part 2 - Screenshot_04

Reviews

Murari
August 19, 2023
none of my doubts are clarified by the teacher .But the lectures seem to be very good . Hope that the teacher clarifies my doubts sent as soon as possible .
Nguyen
August 2, 2023
Same with part1, instructor is repeating many things. The knowledge is already new, and take time to understand, and he just has to make it more boring. If I have trouble sleeping at night, I can watch a few videos and pass out. Should have used slides, easier to follow, and take screenshot.
Aldrin
September 22, 2022
Explanations are very clear and easy to follow. Every penny is worth it for this lesson. This has helped me in my studies and is very ideal for beginners like me.
Pritam
September 1, 2022
very poor presentations on topics. gate smashers (a YouTube channel) have better videos on DBMS, even thoroughly and well organized.
In
November 12, 2021
Repetition of the same thing can be good but he is repeating the same thing as an explanation of a concept. Example being, "This is a that because this is that" In text, it might sound like not a big deal but "This is that" can be minutes of explanation only to be hit by round two of the same thing to explain his thought process. The moment he says "because", my head is expecting a deeper explanation, but in the end its just the same thing repeated. It gets really confusing. If you want students to understand by repetition, they will do it on their own by rewatching the video. Moving onto the next thought is good if you think explained it well enough the first time. His understanding and lectures is good, but it feels like there's redundancies that could be easily fixed by reviewing his own videos and creating a script. In a way, "it could be better."
Rishabh
June 23, 2021
I haven't found such a good course of DBMS anywhere on Google. Thanks Vijay, you are awesome and so is your course. It covers mostly every topic in detail.
Mohit
June 1, 2021
Nice course...I have finished both part1 and now part2 in one week's time...Excellent teaching by Vignesh Sir...Keep up the good work...I request you to design one course on designing complex relational data models...in which you take examples of data models from different industries.
Siddarth
February 22, 2021
The course explains the concept very nicely in an easy to understand manner. Moreover, this course is perfect for any students who want to study the subject along with their university syllabus
Chevano
November 13, 2020
Too basic. Everything covered in this course could have been found on youtube. The practice questions done on relational algebra is too simple. Expected quality content but got average content.
Mehul
September 2, 2020
Vignesh Sir is a very good teacher. He explains each and every concept really well and repeats them also so that we can fully internalise and remember them. I would highly recommend everyone to purchase this course.
Moamen
April 2, 2020
Excellent course I received a high grade in the Database Systems course because A wise lecturer !! highly recommend
Srinivas
March 12, 2019
DBMS had always been a scariest topic for me in college. I could not find satisfaction with my professors who were teaching DBMS until I met Vignesh Sir. Sir had enormous patience explaining the DBMS concepts, till they stay with you forever. Now I feel DBMS is easy and fun. My best wishes are with Vignesh Sekar Sir. Thank you sir!!
Tsai
December 16, 2018
explains really clearly! however, are there courses about normalizing the relation for a given table?
Bryan
October 7, 2018
Took part 1 which was very good. This, part 2 is a continuation. For my studies and preparation for the midterm this set of videos and the previous set have been very helpful. Nice repetitive examples help to drill into head the concepts as well as how to actually perform the action.
Arun
October 4, 2018
Awesome course! Expecting indexing topic in the next part. The way he has explained the concepts with patience deserves respect! Thanks!

Charts

Price

Database Management System from scratch - Part 2 - Price chart

Rating

Database Management System from scratch - Part 2 - Ratings chart

Enrollment distribution

Database Management System from scratch - Part 2 - Distribution chart

Related Topics

1877032
udemy ID
8/26/2018
course created date
11/21/2019
course indexed date
Bot
course submited by