Search Results for "sql sorting queries"

hello-sql is a beginner-friendly, Spanish-language course repository that teaches the fundamentals of SQL and relational databases through practical examples. It focuses mainly on MySQL for lessons due to its ubiquity in education and professional environments, while also introducing PostgreSQL to broaden learners’ exposure to modern database tooling. The materials emphasize real-world query writing, schema design basics, and the mental model behind SELECT, JOIN, GROUP BY, and subqueries....

refbase is a web-based bibliographic manager which can import and export references in various formats (including BibTeX, Endnote, MODS XML, and OpenOffice). It can make formatted lists of citations and offers powerful searching, rich metadata, and RSS.

...It introduces schema design, data types, and constraints before moving to CRUD operations, joins, subqueries, and aggregation. Transaction control, indexes, and execution plans are explained with real queries so readers can see how design choices affect speed and integrity. The repository also touches on user management, permissions, backups, and common operational tasks that arise in production. Throughout, the emphasis is on clear SQL examples and short explanations that can be tested immediately in a local instance. It serves both as a learning track for newcomers and as a handy reference for developers who need to refresh core MySQL skills.