# SQL (Part 2/2)

## Agenda
- Relational Algebra with SQL
- Projection
- Selection
- Union
- Data Manipulation with SQL
- Insert
- Update
- Delete
- Select
- Aggregate functions
- Subqueries (Nested queries)
- Joins (Equijoins, Natural Joins, Inner & Outer Joins)
- Modern 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/)

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

[Modernes SQL: mehr als relational](https://modern-sql.com/de)

[Modern SQL: Three-Valued Logic (3VL) — Purpose, Benefits and Special Cases (modern-sql.com)](https://modern-sql.com/concept/three-valued-logic)

## Flashcards

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