SQL
I started developing with SQL back in 1995 with Mini SQL.
I upgraded to MySQL in '98 and
started using PostgreSQL in 2021 which is what I mainly use now.
- A SQL Timeline
- A list of major developments with SQL.
- PGLite DBA
- A PostgreSQL server in your browser.
- PostgreSQL Info
- Functions that return basic information about your database.
- Basic SQL
- Some basic PostgreSQL commands and syntax.
- Postgres Datatypes
- App that shows various PostgreSQL data types.
- Strings
- Various string functions.
- Dates and Times
- Many functions that make and use dates and times.
- Subqueries
- Queries within queries.
- Arrays
- Demo that shows a working example of the SQL ARRAY datatype.
- Series
- Demo of the GENERATE_SERIES function.
- Joins and Unions
- Demo of SQL joins and unions.
- Cascading Deletion
- Demo that shows working examples of linked tables and cascading deletions.
- Aggregation Functions
- Demo of arithmetic aggregation functions.
- Array Aggregation
- Demo of JSON and array aggregation functions.