Introduction to SQL
Databases are ubiquitous in software and system design. SQL is foundational for understanding how to interact with relational databases.
Free and open source25 chapters497 stars on GitHub
What is inside
- 01Databases
- 02MySQL
- 03Tables
- 04Basic Syntax
- 05SELECT
- 06WHERE
- 07Sorting with ORDER and GROUP BY
- 08INSERT
- 09UPDATE
- 10DELETE
- 11JOIN
- 12SQL | DDL, DQL, DML, DCL and TCL Commands
- 13SQL Sub Queries
- 14SQL - UNIONS CLAUSE
- 15Relational Keys- Keys in a Relational Database
- 16Logical Operator Keywords
- 17HAVING Clause
- 18Essential MySQL Functions
- 19Triggers In SQL
- 20Transaction Control Language
- 21Data Control Language
- 22The MySQL dump command
- 23Learn Materialize by running streaming SQL on your nginx logs
- 24Conclusion
- 25SQL Injection — A Beginner's Understanding
Linked chapters are also posts on this site.
- Difference between scaling horizontally and vertically for databases?
- How to show all tables in PostgreSQL?
- How to flatten JSON array in SQL using jsonb_array_elements?
- How to use 'IF' in 'SELECT' SQL statements?
- How to join MySQL and Postgres in a live materialized view
- What is the difference between DATETIME and TIMESTAMP data type in MySQL?