5 ms·
The creator posted this elsewhere in the comments: > it seemed like it was mostly intro stuff, or straight to DBA level This would have been perfect for someo
by testudovictoria 3y ago
The creator posted this elsewhere in the comments:
> it seemed like it was mostly intro stuff, or straight to DBA level
This would have been perfect for someone like me a few years ago. I went into my first job knowing how to make simple queries and simple joins. I changed jobs into a legacy system where there was an overwhelming amount of data sharded across few databases and several hundred schemas.
I didn't need to learn how to do simple joins or basic keywords like union and intersect that every tutorial talked about. I also didn't need a bunch of DBA knowledge like distribution strategies, replication, and HA techniques. I needed to learn how to leverage what was in the database to pull the exact data I needed more efficiently than what I was doing - windows, cursors, and good subqueries. I was the type of person being addressed.