by JavierJG | Oct 3, 2026 | Entity-Relationship Models, Tutorials
The entity-relationship model (ER model) is the most widely used way of drawing the data in a problem before turning it into a database. Peter Chen proposed it in 1976 and it is still the first step in almost any database design: before thinking about tables or SQL,...
by JavierJG | Sep 16, 2024 | Tutorials
SQL views are stored queries that can be reused to simplify access to complex data, enhance security, and structure data more efficiently. They are ideal for cases where we need to reuse complex queries without rewriting them repeatedly. In this tutorial, you will...
by JavierJG | Sep 8, 2024 | Tutorials
Managing tables is a fundamental skill in any relational database. With SQL, you can efficiently create, modify, and manipulate tables to store and organize data. In this guide, you’ll learn step by step how to create tables in SQL, add primary and foreign keys,...
by JavierJG | Sep 1, 2024 | Tutorials
Relational database design is a fundamental process for organizing and structuring data in a way that supports efficient retrieval and management. Although it may seem challenging, especially for beginners, this process is crucial for storing and managing information...
