This content originally appeared on DEV Community and was authored by Helen Anderson
Hi! I'm Helen, one of #SQL and #database tag moderators.
Each month I'll be taking a trip down memory lane and showcasing some classic data posts. Some of these might be your 'go-to' resources already, others may offer some new insight or ideas.
Let's jump into the posts!
First up Adi writes about the building blocks that open a whole new world of workload management, various types of files, log systems, and architectures specifically designed to handle scale.
This classic post from jen dives into PostgreSQL and what you can do with the SELECT clause. Check out the post and the comments for more.
Next up is a post from Wendy and a post tackling outer joins with useful examples and images to make them easier to understand.
This classic post from Matt discusses what deadlocks are, how to interpret deadlock graphs, and some options for handling deadlocks.
Our last post is from Jill and covers the differences between relational and non-relational databases. Check out the post for more on how to plan your next data project.
That's all for this month! For more from the Data Community check out the #sql, #postgres, #mysql, and #database tags, and follow @TheDatabaseDev on Twitter.
This content originally appeared on DEV Community and was authored by Helen Anderson
Helen Anderson | Sciencx (2021-06-07T10:27:34+00:00) Five classic SQL & database posts – June 2021. Retrieved from https://www.scien.cx/2021/06/07/five-classic-sql-database-posts-june-2021/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.