Generate an HTML table from an SQL query

Sometimes it’s useful to be able to generate an HTML table based on the data produced by a query. I’ve worked with clients who have needed this done as part of an internal automated notification…

DB News – 2020 Week 6

The first edition. Thanks for reading. 1. NULL Values in SQL Queries Handling NULL values in SQL is tricky to say the least. An interesting tour of ternary logic. 2. pg_ctl Tips and Tricks pg_ctl…

Interactive SQL Practice Exercises

The following list of sites give users the chance to practice writing SQL through a series of progressive exercises. These are the sites I’ve found through initial research, but is not necessarily an exhaustive list.…

SQL Sandboxes

The SQL sandboxes listed here are a great way to practice your SQL skills and practice querying against a live database. The interactivity is the killer feature. The sits listed here present guided exercises along…