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.
To start this months' wrap up we have Gabriel posing the tough question - can a Data Scientists job be done by a Developer and an Analyst? Do we really need PhD qualified people to do a job that has been done for years already?
Let us know your thoughts in the comments.
Next up, Andrew from ExamPro shares a Dynamo guide on what you need to know for the AWS Certified Developer Associate Exam. Check it out for everything you need to know about data structures and best practices.
David wrote two posts this month all about why SQL is Beautiful (I have to agree). The first on using window functions for quick and easy analysis, the next on using functions to tidy up text.
Dates are tricky and there needs to be consistency to make sure your app doesn't break, and analysis is correct. Justin shows us how to make this work across different modern databases in this post from the Retool team.
SeattleDataGuy is back with a post on all things Data Engineering. Whether you're curious about Data Warehouses, Data Pipelines or DAGs this post covers them all.
SQL or NoSQL? Before you make the choice check out this post from Pankaj and learn when you would use one over the other.
Logs are not just for DBAs. Find out how to get started using the system tables to access transactional logs with this post from Evgeniy.
Our last post of the month is from Jill who adds to the informative posts on "SQL or NoSQL." This post gives a nice visual way to understand how the components of a SQL database fit together.
The software industry moves fast. But if you keep up, you can have an incredible career.