NRNathan Robinsoninblog.robinhart.me·May 11, 2024 · 4 min readIntroduction to PostgreSQL Aggregate FunctionsAggregation is a really helpful tool in the SQL arsenal, and it enables us to ask slightly more sophisticated questions of our data than we would be able to otherwise. This is a slightly more advanced topic, so be sure to brush up on basic SQL syntax...00
NRNathan Robinsoninblog.robinhart.me·Apr 27, 2024 · 3 min readBeginners guide to modifying data in PostgreSQLThere are three primary modification operations we can perform in SQL, create, update, and delete. In this blog post, we'll cover examples and explanations of each. We'll be using the following data model for the examples. Inserting Data Here's an e...00