enochtangg/quick-SQL-cheatsheet
Quick SQL Cheatsheet
Ce projet est une antisèche de base de données relationnelle et un guide de référence SQL. Il fournit une collection d'exemples de syntaxe et de documentation de requêtes pour gérer des bases de données relationnelles en utilisant le langage de requête structuré (SQL).
L'outil est implémenté sous forme de site statique avec une documentation interrogeable côté client, permettant un filtrage immédiat du contenu technique via un index basé sur le navigateur.
La référence couvre la gestion de bases de données relationnelles, incluant la récupération de données, la gestion de schémas de base de données et la maintenance des enregistrements. Elle inclut également des conseils sur la manipulation de données relationnelles via des jointures de tables et la génération de rapports agrégés.
Features
- Table Data Retrieval - Acts as a primary reference for retrieving and filtering data from relational tables using SQL.
- Cheat Sheets - Provides a concise reference guide for common SQL syntax and technical database tasks.
- Table Schemas - Provides a reference for modifying table structures, such as adding or removing columns.
- Database Record Management - Covers the essential lifecycle operations for maintaining records within a database.
- Data Manipulation Language - Offers syntax examples for inserting, modifying, and removing records from database tables.
- Database Schema Managers - Guides users through the definition and modification of relational database structures.
- Table Definitions - Documents the SQL syntax required to create new tables with specific columns and data types.
- Database Views - Includes guidance on creating and managing virtual tables through database views.
- Group-By Aggregations - Provides a reference for calculating sums, averages, and counts using group-by aggregations.
- Reference Examples - Includes a comprehensive set of SQL query examples for data retrieval and table modification.
- Relational Database Management Systems - Serves as a comprehensive guide for managing relational database systems via SQL.
- Relational Join Engines - Explains how to combine data from multiple tables using standard relational join mechanisms.
- SQL Aggregate Functions - Documents the use of SQL aggregate functions to generate data summaries and reports.
- SQL Syntax References - Provides a detailed collection of SQL syntax examples for retrieving, filtering, and sorting data.
- Table Joining Operations - Provides syntax examples for combining data from multiple tables using various SQL join types.
- SQL Query Guides - Serves as a practical reference guide for writing and structuring SQL statements.
- Markdown-Based Content Authoring - Authors technical SQL documentation using version-controlled markdown files.
- Static Site Generation - Uses static site generation to pre-render markdown content into fast-loading HTML pages.
- Client-Side Indexing - Implements a browser-based index for rapid filtering and navigation of technical content.
- Technical Cheatsheets - Handy SQL reference guide.
- Curated Lists - Listed in the “Curated Lists” section of the The Book Of Secret Knowledge awesome list.
