campuslands-dev-sql

This is a structured collection of SQL exercises, written in Spanish, aimed at students learning how to design and work with relational databases. The exercises walk through the full cycle: analyzing what a database needs to store, identifying the tables and relationships, writing the SQL to build those tables, inserting sample data, and then querying it back out. It is a teaching repository rather than a finished application.

The folder layout keeps things tidy. Each exercise lives under an ejercicios/ directory with its own instructions and a template folder containing separate files for table definitions, data inserts, and query scripts. Students copy that template into a resoluciones/ folder, fill in the SQL, and submit their work through Git. The database engine used is SQLite, which runs locally without needing a server.

The repository enforces a branching discipline that mirrors real team workflows. There are two protected branches: main for stable, approved work, and dev as the base for all new work. Students create a fresh branch for each exercise, make small focused commits, and merge back into dev. A pre-commit hook blocks accidental direct commits to the protected branches. Instructors decide when changes are promoted from dev to main.

The tooling needed is minimal: Git, SQLite 3, and optionally a diagram tool such as Draw.io or Mermaid for drawing entity-relationship diagrams when exercises require them. File naming follows simple conventions: lowercase with hyphens for folders, .sql extension for all SQL files, and solutions must run cleanly on an empty database from scratch.

The README is in Spanish, so readers who do not speak Spanish will need a translation for the exercise instructions, though the folder structure and SQL files themselves are language-independent.