[Engineering Log] Why Not Index Everything?
An investigation into B-Trees, the library analogy, and why we don't index every column.
- #retrospective
- #backend
Tag: #backend
-
-
Understanding Data Modeling
Overview of conceptual, logical, and physical data models with examples and diagrams to guide database design from abstract ideas to implementation.
- #backend
-
Learning SQL: Constraints – Ensuring Data Integrity
Learn essential SQL constraints - NOT NULL, UNIQUE, CHECK, and DEFAULT - to enforce data integrity and maintain database accuracy with practical examples.
- #backend
-
Learning SQL: PRIMARY VS FOREGIN KEYS
Understand the difference between PRIMARY KEY and FOREIGN KEY in SQL, how they enforce data integrity, and link database tables with practical examples.
- #backend
-
Learning SQL: UNION and UNION ALL
Learn the difference between SQL UNION and UNION ALL—how to combine query results, remove duplicates, and optimize performance. Essential for data analysis! 🚀
- #backend
-
Learning SQL: Subqueries
Master SQL subqueries & operators (ANY, ALL, EXISTS) with clear examples. Learn nested queries for WHERE, FROM, SELECT clauses—boost your SQL skills today!
- #backend
-
Learning SQL: CASE
Learn how to use the SQL CASE statement for conditional logic in queries. Master categorization, custom labels, and conditional calculations with examples!
- #backend
-
Learning SQL: HAVING
Master the SQL HAVING clause to filter grouped data. Understand how to apply conditions to aggregated results with practical examples and use cases.
- #backend
-
Learning SQL: GROUP BY
Learn how to use the SQL GROUP BY clause to group and summarize data. Perfect for aggregating and analyzing datasets with clear examples and explanations.
- #backend
-
Learning SQL: CROSS JOIN
Learn SQL CROSS JOIN: Combine every row from two tables, create all possible combinations, and understand its use cases for data analysis.
- #backend
-
Learning SQL: FULL OUTER JOIN
Master SQL FULL OUTER JOIN: Combine data from two tables, retain all rows, handle NULL values, and optimize queries for better insights.
- #backend
-
Learning SQL: RIGHT JOIN
Learn how to use the RIGHT JOIN clause in SQL to combine tables, retain all data from the right table, and handle NULL values effectively with examples.
- #backend
-
Learning SQL: LEFT JOIN
Learn about SQL LEFT JOIN: combine data from two tables, return all rows from the left table, and fill unmatched rows with NULL values. Clear examples included!
- #backend
-
Learning SQL: INNER JOIN
Learn how to use the SQL JOIN command to combine data from multiple tables. Understand JOIN ON, JOIN USING, and NATURAL JOIN with examples and tips.
- #backend
-
Learning SQL: DELETE
Learn how to use the SQL DELETE clause to remove records from a table. Master its syntax, apply conditions, and handle constraints to manage data effectively.
- #backend
-
Learning SQL: UPDATE
Learn how to use the SQL UPDATE clause to modify existing data. Master its syntax, apply conditions, and ensure data integrity with constraints.
- #backend
-
Learning SQL: INSERT INTO
Learn the SQL INSERT INTO statement to add single or multiple rows to a table, insert into specific columns, and handle constraints for efficient data entry.
- #backend
-
Learning SQL: LIMIT and OFFSET
Learn how to use SQL's LIMIT and OFFSET clauses together to control query results, paginate data, and improve performance when working with large datasets.
- #backend
-
Learning SQL: ORDER BY
Learn how to use the SQL ORDER BY clause to sort query results by one or multiple columns in ascending or descending order with clear examples.
- #backend
-
Learning SQL: WHERE
Learn how to filter data using the SQL WHERE clause with operators like IN, LIKE, and more. Master combining conditions with AND and OR for efficient queries.
- #backend
-
Learning SQL: Column Alias
Learn how to use column aliases in SQL to simplify your query results, make calculations more readable, and improve clarity with easy-to-understand examples.
- #backend
-
Learning SQL: SELECT and SELECT DISTINCT
Learn how to use SQL's SELECT statement to retrieve data and filter out duplicates with DISTINCT with examples.
- #backend
-
Understanding Node.js Event Loop Efficiency
Understand how Node.js's event loop and non-blocking I/O efficiently manage concurrent tasks in a single-threaded environment for high-performance apps.
- #backend
-
Understanding NoSQL vs SQL Databases
Discover the contrasts between NoSQL and SQL databases: NoSQL for flexibility and scalability, SQL for relational integrity and transaction reliability.
- #backend
-
A Simple Guide to Set up and Deploy Node with TypeScript
Set up & deploy TypeScript Node.js app: Learn how to enable TypeScript, run locally 3 ways, & deploy the app with this guide.
- #backend
- #typescript