Name		Name	Last commit message	Last commit date
Latest commit History 66 Commits
.idea		.idea
Complete SQL in one shot		Complete SQL in one shot
Lec- 1 Data and Information		Lec- 1 Data and Information
Lec- 10 3 tier Architecture		Lec- 10 3 tier Architecture
Lec- 11 Data model		Lec- 11 Data model
Lec- 12 Data Independence		Lec- 12 Data Independence
Lec- 13 Essential components of table		Lec- 13 Essential components of table
Lec- 14 View in DBMS		Lec- 14 View in DBMS
Lec- 15 keys and its types		Lec- 15 keys and its types
Lec- 16 Referential integrity		Lec- 16 Referential integrity
Lec- 17 Insert \| Update \| Delete from Refrenced table		Lec- 17 Insert \| Update \| Delete from Refrenced table
Lec- 18 Insert \| Update \| Delete from Refrencing table		Lec- 18 Insert \| Update \| Delete from Refrencing table
Lec- 19 Integrity Constraints in DBMS		Lec- 19 Integrity Constraints in DBMS
Lec- 2 Database & file System		Lec- 2 Database & file System
Lec- 20 Super key		Lec- 20 Super key
Lec- 21 ER model in DBMS		Lec- 21 ER model in DBMS
Lec- 22 Entity & Its types \| ER model		Lec- 22 Entity & Its types \| ER model
Lec- 23 Attribute & its types \| ER model		Lec- 23 Attribute & its types \| ER model
Lec- 24 Relationship, Degree and Cardinality \| ER Model		Lec- 24 Relationship, Degree and Cardinality \| ER Model
Lec- 25 1-1 relationship		Lec- 25 1-1 relationship
Lec- 26 1-N relationship		Lec- 26 1-N relationship
Lec- 27 N-1 relationship		Lec- 27 N-1 relationship
Lec- 28 N-N relationship		Lec- 28 N-N relationship
Lec- 29 Participation Constraint		Lec- 29 Participation Constraint
Lec- 3 DBMS & Applications		Lec- 3 DBMS & Applications
Lec- 30 Extended ER features		Lec- 30 Extended ER features
Lec- 31 Specialization		Lec- 31 Specialization
Lec- 32 Generalization		Lec- 32 Generalization
Lec- 33 Aggregation		Lec- 33 Aggregation
Lec- 34 Steps to draw an ER model		Lec- 34 Steps to draw an ER model
Lec- 35 ER Model of instagram		Lec- 35 ER Model of instagram
Lec- 36 Relational Model		Lec- 36 Relational Model
Lec- 37 ER model to Relational Model		Lec- 37 ER model to Relational Model
Lec- 38 Complete SQL series		Lec- 38 Complete SQL series
Lec- 39 Intension & Extension in DBMS		Lec- 39 Intension & Extension in DBMS
Lec- 4 One shot revision		Lec- 4 One shot revision
Lec- 40 What is RDBMS		Lec- 40 What is RDBMS
Lec- 41 Normalisation		Lec- 41 Normalisation
Lec- 42 Denormalisation		Lec- 42 Denormalisation
Lec- 43 Functional Dependency		Lec- 43 Functional Dependency
Lec- 44 Attribute Closure		Lec- 44 Attribute Closure
Lec- 45 Finding super key using attribute closure		Lec- 45 Finding super key using attribute closure
Lec- 46 Finding candidate key using attribute closure		Lec- 46 Finding candidate key using attribute closure
Lec- 47 First Normal Form		Lec- 47 First Normal Form
Lec- 48 Second Normal Form		Lec- 48 Second Normal Form
Lec- 49 Third Normal Form		Lec- 49 Third Normal Form
Lec- 5 Types of Databases		Lec- 5 Types of Databases
Lec- 50 BCNF		Lec- 50 BCNF
Lec- 51 Lossy and Lossless decomposition		Lec- 51 Lossy and Lossless decomposition
Lec- 52 Dependency preserving decomposition		Lec- 52 Dependency preserving decomposition
Lec- 53 Fourth Normal Form		Lec- 53 Fourth Normal Form
Lec- 54 Fifth Normal Form		Lec- 54 Fifth Normal Form
Lec- 55 Highest Normal Form		Lec- 55 Highest Normal Form
Lec- 56 Normalise a table		Lec- 56 Normalise a table
Lec- 57 Equivalence of FD		Lec- 57 Equivalence of FD
Lec- 58 Minimal cover in FD		Lec- 58 Minimal cover in FD
Lec- 59 Transaction and Concurrency control		Lec- 59 Transaction and Concurrency control
Lec- 6 Need, Advantages & Disavantages of dbms		Lec- 6 Need, Advantages & Disavantages of dbms
Lec- 60 ACID properties		Lec- 60 ACID properties
Lec- 61 Isolation and its level		Lec- 61 Isolation and its level
Lec- 62 Schedule and its types		Lec- 62 Schedule and its types
Lec- 63 Concurrent VS Parallel Schedule		Lec- 63 Concurrent VS Parallel Schedule
Lec- 64 Serializability and its types		Lec- 64 Serializability and its types
Lec- 65 Conflict-Serializability		Lec- 65 Conflict-Serializability
Lec- 66 View-Serializability		Lec- 66 View-Serializability
Lec- 67 Why do we need Concurrency Control mechanisms		Lec- 67 Why do we need Concurrency Control mechanisms
Lec- 68 Concurrency control mechanisms		Lec- 68 Concurrency control mechanisms
Lec- 69 Database Recovery management		Lec- 69 Database Recovery management
Lec- 7 DataAbstraction & Different levels		Lec- 7 DataAbstraction & Different levels
Lec- 70 Techniques for optimizing SQL queries and File organization		Lec- 70 Techniques for optimizing SQL queries and File organization
Lec- 71 Indexing and its types		Lec- 71 Indexing and its types
Lec- 72 B and B+ trees		Lec- 72 B and B+ trees
Lec- 73 Difference between B and B+ trees		Lec- 73 Difference between B and B+ trees
Lec- 74 Scaling in Databases		Lec- 74 Scaling in Databases
Lec- 75 Role based access control		Lec- 75 Role based access control
Lec- 76 Encryption		Lec- 76 Encryption
Lec- 77 Data masking techniques		Lec- 77 Data masking techniques
Lec- 8 Schema & Instance in DBMS		Lec- 8 Schema & Instance in DBMS
Lec- 9 DBMS Architecture		Lec- 9 DBMS Architecture
Syllabus		Syllabus
Top SQL Interview questions-part2		Top SQL Interview questions-part2
Top SQL Interview questions		Top SQL Interview questions
LICENSE		LICENSE
README.md		README.md

Repository files navigation

Dbms_Series

Hi all, In this repo you can find all the notes of the on-going DBMS Series on my

Youtube channel : https://youtube.com/@RitiKumari

Playlist link (DBMS Series) : https://www.youtube.com/playlist?list=PLrL_PSQ6q062cD0vPMGYW_AIpNg6T0_Fq

Notes are attached above "keep learning, keep growing" :)

You can also connect me here 👇

Linkedin : https://www.linkedin.com/in/riti2409 Telegram : https://telegram.me/ritikumari Instagram : https://www.instagram.com/ritikumariupadhyay24/ Twitter : https://x.com/riti2409

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

Dbms_Series

About

Releases

Packages

License

riti2409/Dbms_Series

Folders and files

Latest commit

History

Repository files navigation

Dbms_Series

About

Resources

License

Stars

Watchers

Forks

Releases

Packages 0

Packages