# SQL (Part 1/2)

## Agenda
- Introduction to the query language SQL
- Extended Backus-Naur Form (EBNF)
- Data definition with SQL

## References

Sönke Cordts, Gerold Blakowski, Gerhard Brosius: Datenbanken für Wirtschaftsinformatiker: Nach dem aktuellen Standard SQL:2008, Auflage: 2011, Vieweg+Teubner Verlag, ISBN-13: 978-3834813824.

Avi Silberschatz, Henry F. Korth, S. Sudarshan: [Database System Concepts - 7th edition (db-book.com)](https://www.db-book.com/) McGraw-Hill, ISBN 9780078022159.

[sql.js demo: Online SQL interpreter (db-book.com)](https://www.db-book.com/university-lab-dir/sqljs.html)

[Online SQL Trainer](https://sql-academy.org/en/trainer?sort=byId)

[SQL Learning Game](http://www.sql-island.de/)

[MySQL Appliance VMDK (Virtual Machine Image)](https://www.turnkeylinux.org/mysql)

[Vorlesung "Datenmanagement mit SQL" (HPI, Prof. Dr. Felix Naumann](https://open.hpi.de/courses/sql)>

[sqlfmt: A SQL formatter for writing prettier SQL (cockroachlabs.com)](https://www.cockroachlabs.com/blog/sql-fmt-online-sql-formatter/?utm_campaign=nl-email&utm_source=mkto&utm_medium=email&utm_term=september-monthly-newsletter&utm_content=newsletter-2021-9&mkt_tok=MzUwLVFJTi04MjcAAAF_QUVud0lphe4Tmfj9DxdPSqV3GFbIJCsHkNvXM-nzGjalQdGt8RqKDxCzalgbYz_I3DPE-tH0RmyWKm26prO1awzY7tF9du-bdJPoW66P)

[Backus-Naur-Form](https://en.wikipedia.org/wiki/BNF)

[Extended Backus-Naur-Form](https://en.wikipedia.org/wiki/Extended_Backus%E2%80%93Naur_Form)

## Flashcards

[Structured Query Language SQL - AnkiWeb](https://ankiweb.net/shared/info/1980255676)