• Completed Section 13. Understanding PostgreSQL Constraints on https://www.postgresqltutorial.com. Great to finally have deeper undestanding of setting constraints of table for database level data checking. Also, learnt a lot more about Foreign keys which i thought i understood. Did’nt realise you can configure your child table records to automatically cleanup if the related parent record is removed via the CASCADE option (so useful!).
• Started Section 14. PostgreSQL Data Types in Depth. I thought it might be too basic, but i’m still learning more of the intricacies of data types like Date and Timezone. really cool to see so many inbuilt functions to manipulate date and times to extrapoloate and skew data in all sorts of different ways.