- 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
Database Management System from scratch - Part 2
Quick Facts
particular | details | |||
---|---|---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
The technology that is being used to administer databases and this software is called a database management system. A database management system (DBMS) offers an interface to carry out several functions, including database design, data storage, data upgrading, table manufacturing, and database security and protection. Vignesh Sekar, a software engineer, and computer science instructor, designed the Database Management System from Scratch - Part 2 certification course, which is made available by Udemy.
Database Management System from scratch - Part 2 online classes are intended for individuals who are searching for a thorough learning program to enable them to get an understanding of the methods and strategies for managing databases utilizing database management systems. Database Management System from scratch - Part 2 online training includes 9 hours of video-based resources along with articles that cover topics like database normalization, database decomposition, relational algebra, JOIN operations and much more to clear the exams like GATE, ISRO, and PGEE.
The highlights
- Certificate of completion
- Self-paced course
- 9 hours of pre-recorded video content
- 1 article
- Learning resources
Program offerings
- Online course
- Learning resources
- 30-day money-back guarantee
- Unlimited access
- Accessible on mobile devices and tv
Course and certificate fees
Fees information
certificate availability
Yes
certificate providing authority
Udemy
Who it is for
What you will learn
After completing the Database Management System from scratch - Part 2 online certification, individuals will be introduced to the core functionalities of the database management systems for database management operations in the computer science field. Individuals will explore the techniques used in database normalization and decomposition. Individuals will become familiar with Boyce Codd Normal Form and its capabilities. Additionally, individuals will learn how to use relational algebra and JOIN operations.
The syllabus
Introduction to 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
Bonus : How to proceed further
- Bonus : How to proceed further