Database Management System from scratch - Part 2
4.6 (84 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
897 students enrolled

Database Management System from scratch - Part 2

Learn Database Management Systems from scratch as Database Management System forms the core of computer science
4.6 (84 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
897 students enrolled
Created by Vignesh Sekar
Last updated 1/2020
English
Current price: $103.99 Original price: $159.99 Discount: 35% off
15 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Expand all 67 lectures 09:11:47
+ Introduction to Decomposition
7 lectures 56:04
Rough Idea of Normalization
03:07
Lossless Decomposition
11:58
Lossless Decomposition Continued
09:40
Problem on Lossless Decomposition
04:32
Attribute Preserving Decomposition
02:26
Functional Dependency Preserving Decomposition
14:00
+ First Normal Form
2 lectures 11:03
First Normal Form Explained
08:51
Problem to illustrate First Normal Form
02:12
+ Second Normal Form
7 lectures 01:06:24
Second Normal Form Explained
09:07
Conversion of a relation to Second Normal Form
12:56
Problem 1
17:08
Problem 2
11:47
Problem 2 continued
10:28
Advantage of following Lossless Decomposition
02:43
Other Formal Definitions of Second Normal Form
02:15
+ Third Normal Form
5 lectures 36:11
Third Normal Form Explained
08:47
Another way of looking at third normal form
04:35
Problem 1
08:30
Problem 2
04:54
Problem 3
09:25
+ Boyce Codd Normal Form (BCNF)
11 lectures 01:32:33
BCNF Explained
07:10
Problem 1
08:55
Problem 2
14:20
Problem 3
14:18
Important Result
07:44
Problem 4
04:24
Problem 5
02:36
Problem 6
11:35
Problem 6 continued
03:25
Problem 7
09:04
Problem 8
09:02
+ Operations of Relational Algebra
9 lectures 58:45
Introduction to Relational Algebra
07:50
Selection Operation
09:38
More points on Selection
09:40
Projection Operation
04:42
More points on Projection
08:50
Rename Operation
03:03
Union Operation
06:20
Intersection Operation
03:15
Set Difference Operation
05:27
+ Joins
10 lectures 01:07:53
Cartesian Product
05:53
Join Operation
08:29
Important Points to note
03:04
Natural Join
07:52
Cartesian Product vs Join vs Natural Join
06:06
Quick Summary
00:51
Left Outer Join and Right Outer Join
13:28
Full Outer Join
02:25
Inner Join vs Left Outer Join vs Right Outer Join vs Full Outer Join
04:30
Minimum and Maximum number of tuples possible
15:15
+ Problems on Relational Algebra
11 lectures 02:07:47
Problem 1
14:23
Problem 2
15:58
Problem 3
06:20
Problem 4
16:50
Problem 4 explained with example
08:54
Problem 5
10:49
Problem 5 explained with example
07:08
Problem 6
15:33
Problem 7
08:04
Problem 8
10:02
Problem 9
13:46
+ How to proceed further
1 lecture 00:18
Discounts to my other courses
00:18