SQL and Database Wrapup 2020 (3 Part Series)
At the end of each month, I'll be showcasing some of the great posts, projects and insights from the data community.
First up ronsoak challenges Data Analysts who can SQL to make the move to Python. Check out the article for more tips, an excellent video and some top notch gifs.
Next, Trevor introduces SQL User Defined Functions (UDFs) in Redshift. If you've ever been curious about what they can do for you and how the differ from Scalar Functions this article is for you.
Thamaraiselvam then gives us a thoughtful introduction to replication and load balancing. Read more for how you can increase performance on your next project.
Next Bryan shows us that optimising and profiling queries isn't just for DBAs. These skills are becoming more and more useful for Developers so check it out to learn how to get started.
Keeping with the architecture theme, Matthew from the Heroku team writes about scaling up, scaling out and sharding of databases.
The Heroku team have been busy this month, this time James writes about caching with Redis and PostgreSQL. Check it out to find out what you should be caching and how it speeds things up.
Next, vbilopav returns to the wrap up with a post about Stored Procedures and what they can do for you. Check out this balanced post for more.
Last on the wrap up is Adi and a long read on Data Technology and the story so far in our journey from Database to Data Warehouse to Data Lake.
The software industry moves fast. But if you keep up, you can have an incredible career.