IIRF Online > Development > Database Design & Development > Database Management Systems (DBMS) > Database Management System from scratch - Part 2
Database Management System from scratch - Part 2 by Udemy
Learn Database Management Systems from scratch as Database Management System forms the core of computer science
Course Highlights
- 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
Skills you will learn!
Curriculum
7 Topics
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
4 Topics
Problem 1
Problem 2
Problem 3
Problem 4
2 Topics
First Normal Form Explained
Problem to illustrate First Normal Form
7 Topics
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
5 Topics
Third Normal Form Explained
Another way of looking at third normal form
Problem 1
Problem 2
Problem 3
11 Topics
BCNF Explained
Problem 1
Problem 2
Problem 3
Important Result
Problem 4
Problem 5
Problem 6
Problem 6 continued
Problem 7
Problem 8
9 Topics
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
10 Topics
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
11 Topics
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
1 Topic
Bonus : How to proceed further
Database Management System from scratch - Part 2
Related Database Management Systems (DBMS) Courses
.webp)
.webp)
Thank You!
Your review has been submitted successfully.