Getting Started with SQL pt.5

In this video we look at limit, offset, order by, before expanding the database structure to reflect a more true to life web store, then taking a brief look at transactions

Links:

- DDL and DML: Stack Overflow: https://stackoverflow.com/questions/2578194/what-are-ddl-and-dml
- Download DBeaver: DBeaver: https://dbeaver.io/download/
- Use SQLite in a browser: SQLite Online: https://sqliteonline.com/
- SQLite Docs: SQLite: https://sqlite.org/doclist.html
- SQLite Foreign Keys: SQLite: https://sqlite.org/foreignkeys.html
- SQLite Dates/Times: SQLite: https://sqlite.org/lang_datefunc.html
- Joins as Venn diagrams: Stack Overflow: https://stackoverflow.com/questions/13997365/sql-joins-as-venn-diagram
- SQLite Aggregations: SQLite: https://sqlite.org/lang_aggfunc.html
- SQLite Transactions: SQLite: https://www.sqlite.org/lang_transaction.html

Hopefully you found something useful in this video - Drop any questions in the comments below!

Видео Getting Started with SQL pt.5 канала The Island Dev