SECTION 03 · 8 NOTES · UPDATED 2026.08.29

DATABASES

NOTES 8

0101 MIN · 2025.11.11ACID PrinciplesSet of principles that ensure data integrity and consistency leveraging transactions.0201 MIN · 2024.09.15ConstraintsConstraints are of 5 Types, these set rules for data integrity, reliability and compliance to standard requirements. - Valid value, data type or data in a range - Applied to one or more columns 0302 MIN · 2024.09.15JoinsIn DBMS, Joins are used to use the relation between the tables to create a combined result.0401 MIN · 2024.11.01MongoDBMongoDB working notes: collections, JSON vs BSON, and CRUD operations with their shell commands.0504 MIN · 2025.11.11Normalization and FormsNormalization is process of database design to make the data more organized, reduce redundancy, reduce inconsistency and ensure data integrity. Types of normalizations are levels of optimization on the database.0601 MIN · 2025.11.11SQL Interview TipsQuick tips to keep in mind when solving SQL interview questions.0701 MIN · 2024.09.16Types of RelationsThe three types of relationships between tables in a database: one to one, one to many, and many to many.0802 MIN · 2024.09.06How to Query Hierarchical Data in SQL: Self Joins, Recursive CTEs, Nested QueriesThree approaches to fetching hierarchical data from a self-referencing table: multiple merged queries, recursive CTEs, and nested queries.