SECTION 03 · 9 NOTES · UPDATED 2026.09.10

DATABASES

NOTES 9

0101 MIN · 2025.11.11ACID PrinciplesSet of principles that ensure data integrity and consistency leveraging transactions.0210 MIN · 2026.09.10Analytics QueriesA CTE is a temporary named result set that exists only for the duration of a query.0301 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 0402 MIN · 2024.09.15JoinsIn DBMS, Joins are used to use the relation between the tables to create a combined result.0501 MIN · 2024.11.01MongoDBMongoDB working notes: collections, JSON vs BSON, and CRUD operations with their shell commands.0604 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.0701 MIN · 2025.11.11SQL Interview TipsQuick tips to keep in mind when solving SQL interview questions.0801 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.0902 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.