📄️ Databases
A database is an organized system that allows saving, modifying, deleting, and querying large amounts of information quickly and securely.
📄️ Essential Concepts
To understand how relational databases work, it is fundamental to understand these concepts:
📄️ SQL DB Engines
An SQL database engine is the software that implements the necessary logic to save, query, update, and delete information using the SQL language.
📄️ Types of Relational DB
Relational databases store information in tables organized by rows (records) and columns (fields).
📄️ Uses and importance
Databases are fundamental to the operation of almost any modern computer system.
📄️ DBMS (Management System)
A Database Management System (DBMS or SGBD in Spanish) is the software that allows creating, managing, modifying, and querying a database.
📄️ Design a SQL DB with DBeaver
Guided practical activity: Design your first relational database in SQL with DBeaver
📄️ Best Practices
Properly designing a database from the beginning prevents errors, rework, and ensures long-term efficiency. This document explains how to name fields clearly and how to select the right data type for each one.
📄️ Schemas
What is a schema?
📄️ Data Types in NoSQL (MongoDB)
Technical document on data types in MongoDB, their internal structure, and recommended applications, with a practical focus for flexible modeling, efficient querying, and compatibility with distributed systems.
📄️ Data Types in SQL (MySQL)
This document details the main data types in SQL, organized by category, with examples and recommendations for use based on storage efficiency and purpose.