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.
- Basic SQL
- Some basic PostgreSQL commands and syntax.
- Postgres Datatypes
- App that sows verious PostgreSQL data types.
- Joins and Unions
- Demo of SQL joins and unions.
- Arrays
- Demo that shows a working example of the SQL ARRAY datatype.
- PostgreSQL Info
- Functions that return basic infomration about your database..
- Cascading Deletion
- Demo that shows working examples of linked tables and cascading deletions.
- Aggregation
- Demo of JSON and array aggregation functions.
- PGLite DBA
- A PostgreSQL server in your browser.