Database Management System : The Complete Masterclass (53 hours course)
Current Status
Not Enrolled
Price
Closed
Get Started

Course Content

Introduction
Basics of ER model
Relationship - Terminologies and Types
Relational Model
Constraints of Relational Model
Keys, Super Keys, Candidate Keys, Primary Keys
Constraints of Relational Model Revisited
More on Finding the Number of Super Keys
Conversion of ER Model to Relational Model
Functional Dependencies
Finding the Keys using Closure Operation
Equivalence and Minimization of FD sets using Closure
Introduction to Decomposition
Problems on Lossless, Attribute Preserving and FD Preserving Decomposition
First Normal Form
Second Normal Form
Third Normal Form
Boyce Codd Normal Form (BCNF)
Operations of Relational Algebra
Joins
Problems on Relational Algebra
Introduction
Table Creation
Constraints in SQL
Referential Trigger Actions
Data Retrieval using SELECT-FROM-WHERE
Aliasing in SQL
DISTINCT and ALL in SQL
Difference between Distinct and All
Pattern Matching in SQL
Concatenation , Between and Order By in SQL
Dealing with NULL values in SQL
1 of 2

FLASH SALE : Get 15% off by using coupon SAVE15SPECIALOFFER . This will expire at 17/october/2021-11:59 PM IST

X