To normalize data, we often store it in several tables within a given database. While querying those tables individually can provide answers to numerous questions around that data, more times than not, it leaves us ‘coming up short’ for the complete answer we need.
That poses the question of, how do you extract all this data from several tables that depend on one another to provide data-driven answers?
One tried and true method is to use a JOIN operation.
Database
Weekly Reading – For Week of 05/05/2018
Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…
- WAITING FOR POSTGRESQL 11 – FAST ALTER TABLE ADD COLUMN WITH A NON-NULL DEFAULT
- Capacity Planning for MySQL and MariaDB – Dimensioning Storage Size
- IDLE_IN_TRANSACTION_SESSION_TIMEOUT: TERMINATING IDLE TRANSACTIONS IN POSTGRESQL
- Raw SQL access for users with row-level-security
- 18:12
Mountpoints and the Single PostgreSQL Server - the ultimate postgres vs mysql blog post
- An Introduction to PostgreSQL Materialized Views
- Has the time finally come for PostgreSQL?
- Data engineers vs. data scientists
MySQL String Data Type Dive: CHAR and VARCHAR – Differences.
Data types… They are oh so important when designing your database tables. In this blog post, I look at two similar string data types: CHAR and VARCHAR. Chances are you will likely use one, the other, or both in MySQL. But what is the difference in them? I want to know myself. So let’s learn together…
Weekly Reading – Week of 4/28/2018
Feel free to read and share these open-source SQL articles and blog posts with all who would value a good read or two…
Easy mysqldump backups by example.
This blog post, will present three sample uses of the mysqldump backup utility. It will entail backing up: a database, a table, along with a table without data. This utility can easily be incorporated into shell scripts for those repetitive tasks you may need to execute on multiple occasions.