Everything about SQL

🧭 Start here: a 6-step reading path

1. Read the overview: SQLA 5-minute orientation
2. Skim a recent paper: A Comprehensive Review of Federated Learning Architectures for Insider Threat Detection in Distributed SQL-Based Enterprise EnvironmentsInfluential work since 2022
3. Pick up a classic book: HBaseThe most-reprinted book on the subject
4. Read the landmark paper: GenAp: a distributed SQL interface for genomic dataCited 11 times
5. Go sideways: Null (SQL)A closely related topic
6. Go sideways: SQL:1999A closely related topic

🏆 Landmark papers (most cited)

• GenAp: a distributed SQL interface for genomic data

  Christos Kozanitis, David A. Patterson · 2016 · BMC Bioinformatics · 11 citations

• CorrectMR: Authentication of Distributed SQL Execution on MapReduce

  Bo Zhang, Boxiang Dong, Hui Wang · 2019 · IEEE Transactions on Knowledge and Data Engineering · 8 citations

• A distributed scientific data archive using the Web, XML and SQL/MED

  Mark Papiani, Jasmin L. Wason, Alistair N. Dunlop · 1999 · ACM SIGMOD Record · 8 citations

• Building the distributed geographic SQL workflow in the Grid environment

  Zhou Huang, Yu Fang, Bin Chen · 2011 · International Journal of Geographical Information Science · 5 citations

• Performance Optimization in Distributed SQL Environments : A Comprehensive Analysis of Presto Query Engine

  Santhosh Gourishetti · 2024 · International Journal of Scientific Research in Computer Science, Engineering and Information Technology · 2 citations

• Design and Implementation of HSQL: A SQL-like language for Data Analysis in Distributed Systems

  Anurag Singh Bhadauria, Atreya Bain, Jyoti Shetty · 2021 · International Journal of Advanced Computer Science and Applications · 2 citations

• PSpec-SQL: Enabling Fine-Grained Control for Distributed Data Analytics

  Chen Luo, Fei He, Fei Peng · 2021 · IEEE Transactions on Dependable and Secure Computing · 1 citations

• EXECUTION OF SQL-LIKE QUERIES IN DISTRIBUTED HETEROGENEOUS SYSTEMS BASED ON APACHE HADOOP

  А.Д. Данилов, М.О. Саввин, А.Е. Карачевцев · 2024 · ВЕСТНИК ВОРОНЕЖСКОГО ГОСУДАРСТВЕННОГО ТЕХНИЧЕСКОГО УНИВЕРСИТЕТА · 1 citations

🆕 Influential since 2022

• A Comprehensive Review of Federated Learning Architectures for Insider Threat Detection in Distributed SQL-Based Enterprise Environments

  Onuh Matthew Ijiga, Nonso Okika, Semirat Abidemi Balogun · 2025 · International Journal of Innovative Science and Research Technology · 2 citations

• AN ANALYSIS OF APACHE SPARK AND GPU PERFORMANCES ON DATABASE SQL QUERIES FOR DISTRIBUTED NETWORKS

  Mehmet Turan, Emin Tenekeci, Kemal Güner · 2024 · Adıyaman Üniversitesi Mühendislik Bilimleri Dergisi · 1 citations

• Improving SQL Join Algorithms for Distributed Systems: A Case Study of Compute Express Link-Based Multihost Shared Memory

  JaeYung Jun, HyunWoong Ahn, Joohee Lee · 2025 · IEEE Micro · 1 citations

• dsJSON: A Distributed SQL JSON Processor

  Majid Saeedan, Ahmed Eldawy, Zhijia Zhao · 2023 · Proceedings of the ACM on Management of Data · 0 citations

• Methods For Optimizing PL/SQL Queries in Distributed Banking Databases

  Sr IT Developer, First Horizon Bank, Memphis, TN, USA, Rushikesh Anantrao Deshpande · 2025 · The American Journal of Applied Sciences · 0 citations

📚 Books worth reading

• HBaseLars George · 2011
• Advanced Data ManagementLena Wiese · 2015
• Microsoft SQL Server 2012 with HadoopDebarchan Sarkar · 2013
• 10 projects you can do with Microsoft SQL Server 7Karen L Watterson, Karen Watterson · 1999
• Oracle distributed systemsCharles Dye · 1999
• 📕Windows Azure Mobile ServicesJohnson, Bruce · 2013
• Official Sybase SQL anywhereDerek Ball, Ian Richmond · 1997
• Pro SQL Server 2005 Replication (Definitive Guide)Sujoy Paul · 2006

Ranked by number of editions on Open Library, a rough measure of how lasting a book is.

🔗 Related topics

• Null (SQL) In the SQL database query language, null or NULL is a special marker used to indicate that a data value does not exist in the database. Introduced by the…
• SQL:1999 SQL:1999 (also called SQL 3) was the fourth revision of the SQL database query language. It introduced many new features, many of which required clarifications…
• XML database An XML database is a data persistence software system that allows data to be specified, and stored, in XML format. This data can be queried, transformed…
• Relational database A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A Relational Database Management System…
• SQL:2011 SQL:2011 or ISO/IEC 9075:2011 (under the general title "Information technology – Database languages – SQL") is the seventh revision of the ISO (1987) and…
• Comparison of relational database management systems The following tables compare general and technical information for a number of relational database management systems. Please see the individual products'…
• List of SQL reserved words This list includes SQL reserved words – aka SQL reserved keywords, as the SQL:2023 specifies and some RDBMSs have added. A dash (—) means that the keyword…
• SQL syntax The syntax of the SQL programming language is defined and maintained by ISO/IEC SC 32 as part of ISO/IEC 9075. This standard is not freely available. Despite…