Everything about SQL

🧭 Start here: a 6-step reading path

1. Read the overview: SQLA 5-minute orientation
2. Skim a recent paper: RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQLInfluential work since 2022
3. Pick up a classic book: SQL for DummiesThe most-reprinted book on the subject
4. Read the landmark paper: Scalable SQL and NoSQL data storesCited 930 times
5. Go sideways: Null (SQL)A closely related topic
6. Go sideways: SQL:1999A closely related topic

🏆 Landmark papers (most cited)

• Scalable SQL and NoSQL data stores

  Rick Cattell · 2011 · ACM SIGMOD Record · 930 citations

• Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation

  Dawei Gao, Haibin Wang, Yaliang Li · 2024 · Proceedings of the VLDB Endowment · 338 citations

• SQL databases v. NoSQL databases

  Michael Stonebraker · 2010 · Communications of the ACM · 311 citations

• On optimizing an SQL-like nested query

  Won Kim · 1982 · ACM Transactions on Database Systems · 277 citations

• A critique of ANSI SQL isolation levels

  Hal Berenson, Phil Bernstein, Jim Gray · 1995 · ACM SIGMOD Record · 274 citations

• Spatial SQL: a query and presentation language

  M.J. Egenhofer · 1994 · IEEE Transactions on Knowledge and Data Engineering · 246 citations

• Towards practical differential privacy for SQL queries

  Noah Johnson, Joseph P. Near, Dawn Song · 2018 · Proceedings of the VLDB Endowment · 206 citations

• A survey on deep learning approaches for text-to-SQL

  George Katsogiannis-Meimarakis, Georgia Koutrika · 2023 · The VLDB Journal · 190 citations

🆕 Influential since 2022

• RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQL

  Haoyang Li, Jing Zhang, Cuiping Li · 2023 · Proceedings of the AAAI Conference on Artificial Intelligence · 188 citations

• CodeS: Towards Building Open-source Language Models for Text-to-SQL

  Haoyang Li, Jing Zhang, Hanbing Liu · 2024 · Proceedings of the ACM on Management of Data · 143 citations

• SQL and NoSQL Database Software Architecture Performance Analysis and Assessments—A Systematic Literature Review

  Wisal Khan, Teerath Kumar, Cheng Zhang · 2023 · Big Data and Cognitive Computing · 135 citations

• Detection of SQL Injection Attack Using Machine Learning Techniques: A Systematic Literature Review

  Maha Alghawazi, Daniyal Alghazzawi, Suaad Alarifi · 2022 · Journal of Cybersecurity and Privacy · 106 citations

• The Dawn of Natural Language to SQL: Are We Fully Ready?

  Boyan Li, Yuyu Luo, Chengliang Chai · 2024 · Proceedings of the VLDB Endowment · 98 citations

📚 Books worth reading

• SQL for DummiesAllen G. Taylor, Reinhard Engel · 1993
• SQL in a NutshellKevin E. Kline, Kevin Kline · 2000
• Oracle PL/SQL LanguageSteven Feuerstein · 1999
• Oracle PL/SQL ProgrammingSteven Feuerstein · 1995
• SQLJonathan Gennick, Alice Zhao · 2004
• SQL all-in-one for dummiesAllen G. Taylor · 2011
• High Performance MySQLJeremy D. Zawodny, Derek J. Balling · 2004
• Joe Celko's SQL for SmartiesJoe Celko · 1995

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…