by JavierJG | Sep 11, 2024 | Articles
In this article, we will explore the main differences between relational and non-relational databases, their advantages and disadvantages, and in which situations it is more convenient to use one or the other. Databases are used in a wide range of applications, from...
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 5, 2024 | Articles
What are relational databases, and what are the best engines to use them? Databases are a way to store and organize information in a logical and orderly structure. There are different types of databases depending on the model they follow to represent the data and the...
by JavierJG | Sep 3, 2024 | Resources
This resource is designed to help you convert from an Entity-Relationship Model to a Relational Model, explaining each of the relationships. Each tab explains the transformation of each relationship: Bold: Key Bold and Underlined: Primary Key (fk): Foreign Key N:M...