NoSQL Databases
NoSQL data modeling for query-first database schemas
NoSQL data modeling starts with application queries; use document boundaries, partition choices and index review to build a schema around real workflows.
database design
19 articles about database design — tutorials, explainers and interview questions, newest first.
Tag · 19 articles
Latest in database design
Python
Build a Real-World Python Inventory Management System
Dive into a practical real-world project by building an inventory management system using Python. From database design to frontend development and reporting, this comprehensive guide covers all aspects of creating a dynamic, feature-rich application.
System Design Interviews
Database Design & Management: Integrity, Tuning, Interviews
Explore the essentials of database design and management. From data modeling to performance optimization, this guide prepares candidates for interviews and provides insights for professionals looking to ensure data integrity.
Database Interviews
DB Interviews: Normalization vs Denormalization Trade-offs
Discover essential interview topics related to data normalization and denormalization. This guide explores definitions, normal forms, benefits, drawbacks, practical implementation, and trade-offs between these crucial concepts in database design.
Database Interviews
Data Modeling & Database Design: Efficient Normalized Schema
Explore the essentials of data modeling and database design in this comprehensive guide. Understand entities, relationships, normalization, denormalization, indexing, integrity constraints, tools, and best practices to design efficient and normalized database schemas.
Database Interviews
Query Optimization and Performance: Techniques for Enhancing Database Efficiency
Explore techniques for optimizing queries and improving database performance in this comprehensive guide. From understanding execution plans to leveraging indexes, efficient SQL writing, and hardware considerations, this article provides valuable insights for database professionals.
Relational Databases
Normalization Techniques: Reducing Data Redundancy & Ensuring Integrity in Relational Databases
Understand the process of normalization in relational databases. Learn about the different stages, including 1NF, 2NF, 3NF, BCNF, 4NF, and 5NF, to reduce data redundancy and ensure data integrity, resulting in a more robust and efficient database system.
Relational Databases
Database Design for Relational Systems: Efficient Schemas for Optimal Data Organization
Learn how to design efficient relational database schemas for optimal data organization. This comprehensive guide covers key concepts like normalization, entities, attributes, keys, and the steps in database design, from requirement analysis to physical implementation.
NoSQL Databases
Consistency Models in NoSQL: An Exploration of Impact on Data Integrity
This article explores the various consistency models in NoSQL databases, including strong consistency, eventual consistency, causal consistency, and tunable consistency. Understand how these models affect data integrity and the trade-offs involved in implementing them, with examples from popular NoSQL databases like Cassandra, MongoDB, and Riak.
Database Management
Database Administration Essentials: Core Tasks and Responsibilities of a DBA
Explore the essential tasks and responsibilities of a database administrator (DBA). This guide covers installation, design, performance monitoring, security, and more, providing a comprehensive understanding of the DBA role.
Database Management
Database Management Introduction: Principles and Practices
Explore the fundamental principles and best practices of effective database management. This comprehensive guide covers data integrity, security, consistency, types of DBMS, and more. Ideal for professionals and learners.
Database Design
Database Design Tools and Methodologies: A Comprehensive Guide to Streamlining the Database Design Process
Explore various database design tools and methodologies that aid in the creation of efficient and robust databases. Learn about ERD tools, UML tools, SQL development tools, and methodologies like top-down, bottom-up, agile, and waterfall approaches.