Database Management System from scratch - Part 1

Last updated 2/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 10.21 GB | Duration: 11h 52m

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

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 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
Have a PC with internet connection
Even ZERO knowledge in Database Management Systems is fine - I'll teach you everything you need to know

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.

Overview
Section 1: Introduction

Lecture 1 Important Tip

Lecture 2 Introduction

Lecture 3 Data model and its types

Section 2: Basics of ER model

Lecture 4 Entity, Relationship and Attribute Explained

Lecture 5 Database Designer's perspective

Lecture 6 ER Model and Relational Model - Advantages and Disadvantages

Lecture 7 Basic Idea of Attributes of relationship

Lecture 8 Simple vs Composite Attributes, Single valued vs Multi-valued Attributes

Lecture 9 Stored vs Derived Attributes

Lecture 10 Complex Attributes

Section 3: Relationship - Terminologies and Types

Lecture 11 Degree of a relationship and Cardinality Ratio

Lecture 12 Cardinality Ratio Explained with example

Lecture 13 Types of Participation - Total vs Partial Participation

Lecture 14 Example to illustrate Total and Partial Participation

Lecture 15 More Examples on Maximum and Minimum Cardinality

Lecture 16 Types of Relationships

Lecture 17 Recursive Relationship

Lecture 18 Example on finding the type of relationship

Section 4: Relational Model

Lecture 19 Tuple, Field, Domain and Entity vs Entity types

Lecture 20 How Relational Model is derived from Discrete Math

Lecture 21 Degree of a relation, state of a relation, Intention vs Extension

Lecture 22 Important Rules in Relational Model

Section 5: Constraints of Relational Model

Lecture 23 Types of Constraints, Domain Constraints Explained

Lecture 24 Key Constraints - Intro

Section 6: Keys, Super Keys, Candidate Keys, Primary Keys

Lecture 25 Super Key Explained with example

Lecture 26 More Points on Super Key

Lecture 27 Key Explained with example

Lecture 28 Example to illustrate the difference between Key and Super Key

Lecture 29 Super Key vs Key vs Candidate Key vs Primary Key

Lecture 30 Finding the number of Super Keys

Lecture 31 Finding the number of Super Keys - 2

Lecture 32 Finding the number of Super Keys - 3

Section 7: Constraints of Relational Model Revisited

Lecture 33 Key Constraints

Lecture 34 Entity Integrity Constraints

Lecture 35 Foreign Key Explained with example

Lecture 36 Example on Foreign Key

Lecture 37 Difference between Foreign Key and Primary Key

Lecture 38 Referential Integrity Constraints

Lecture 39 Constraints violated by Insertion

Lecture 40 Constraints violated by Deletion

Lecture 41 Constraints violated by Updation and Viewing

Lecture 42 Steps taken by DBMS in case of constraint violation

Lecture 43 Problem on ON-DELETE CASCADE

Lecture 44 Problem on Referential Integrity Constraint

Section 8: More on Finding the Number of Super Keys

Lecture 45 Problem 1 on finding the number of Super Keys

Lecture 46 Finding Number of Super Keys using Venn Diagram 1

Lecture 47 Finding Number of Super Keys using Venn Diagram 2

Lecture 48 Important Observation

Lecture 49 Finding Number of Super Keys using Venn Diagram 3

Lecture 50 Finding Number of Super Keys using Venn Diagram 4

Section 9: Conversion of ER Model to Relational Model

Lecture 51 Conversion of Entities, Attributes, Prime Attribute and Composite Attributes

Lecture 52 Conversion of one-to-many relationship

Lecture 53 Example for conversion of one-to-many relationship

Lecture 54 Conversion of One-to-one relationship

Lecture 55 Conversion of Many-to-many relationship

Lecture 56 A good approach to follow but not a rule

Lecture 57 Problem on Multivalued attributes

Lecture 58 Problem on finding minimum number of tables needed for conversion

Lecture 59 Problem on finding maximum number of tables needed for conversion

Lecture 60 Special Case : One-to-one relationship with total participation on both sides

Lecture 61 Lecture 60 continued

Lecture 62 Weak vs Strong Entity - Differences

Lecture 63 Example to illustrate Weak Entity and their conversion to Relational model

Lecture 64 N-ary relationships

Lecture 65 Identifying Relationships

Lecture 66 Important Notations Revisit

Lecture 67 Problem 1

Lecture 68 Attributes to relationship : one to many relationship

Lecture 69 Attributes to relationship : one-to-one relationship

Lecture 70 Attributes to relationship : many-to-many relationship

Lecture 71 Problem

Section 10: Functional Dependencies

Lecture 72 Introduction to Functional Dependencies

Lecture 73 Examples on Functional Dependency

Lecture 74 Important Point to note

Lecture 75 More Examples on Functional Dependency

Lecture 76 Trivial Functional Dependency

Lecture 77 Non Trivial Functional Dependency

Lecture 78 Semi Trivial Functional Dependency

Lecture 79 Important Point to Note

Lecture 80 Closure set of an attribute 1

Lecture 81 Closure set of an attribute 2

Lecture 82 Closure set of an attribute 3

Lecture 83 Example on finding Closure Set

Lecture 84 Applications of Closure operation

Section 11: Finding the Keys using Closure Operation

Lecture 85 Problem 1 on finding keys using Closure Operation

Lecture 86 Problem 2 on finding keys using Closure Operation

Lecture 87 Problem 3 on finding keys using Closure Operation

Lecture 88 Problem 4 on finding keys using Closure Operation

Lecture 89 Problem 4 on finding keys using Closure Operation - continued

Lecture 90 Problem 5 on finding keys using Closure Operation

Lecture 91 Problem 6 on finding keys using Closure Operation

Lecture 92 Problem 7 on finding keys using Closure Operation

Lecture 93 Problem 8 on finding keys using Closure Operation

Lecture 94 Problem 9 on finding keys using Closure Operation

Lecture 95 Problem 1 on finding keys of sub relation

Lecture 96 Problem 2 on finding keys of sub relation

Lecture 97 Problem 3 on finding keys of sub relation

Lecture 98 Problem

Section 12: Equivalence and Minimization of FD sets using Closure

Lecture 99 Checking Equivalence of FD'S - 1

Lecture 100 Checking Equivalence of FD'S - 2

Lecture 101 Checking Equivalence of FD'S - 3

Lecture 102 Checking Equivalence of FD'S - 4

Lecture 103 Minimization of Functional Dependency Set - 1

Lecture 104 Minimization of Functional Dependency Set - 2

Section 13: Bonus Section : How to proceed further

Lecture 105 Bonus : How to proceed further

Anybody who needs to learn Database Management System from scratch,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

Buy Premium Account From My Download Links & Get Fastest Speed.