Five classic SQL & Database posts - February 2021

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!

Our first classic post is from Lucas who has written a complete guide to relational databases. This excellent resource covers everything from keys to queries and sorting to security.

Lucas has been writing on Dev since 2018 and has covered NoSQL databases as well. Check out both posts for a complete guide to database technology.

Everything you need to know about (Relational) Databases

Lucas Olivera Jan 17 '19 16 min read

#beginners #database #sql

Next, we have Seattle Data Guy and some excellent insight on creating a great dashboard. If you read data posts here on Dev regularly you've probably seen Ben's brilliant posts on data engineering, pipelines, and the future of technology.

Tips on Designing a Million Dollar Dashboard

SeattleDataGuy Aug 29 '19 7 min read

#ui #star #sql #career

Our next post is from Lisa and an introduction to Elasticsearch. This was published in Septemeber 2020 but quickly became the go-to guide for Elasticsearch. Check out more of Lisa's posts for beginner-friendly guides.

Beginner's guide to Elasticsearch

Lisa Sep 20 '20 16 min read

#datascience #beginners #database #node

Next we have Abdisalan with a post on pagination. Abdisalan has also written about BigQuery, MongoDB, and tackling SQL interview questions with plenty of tips for developers using data.

1 SQL Query You Should Stop Using

Abdisalan Jun 16 '20 3 min read

#sql #database #performance

To wrap up the list we have Margo from the HarperDB team. This post tackles the intricacies of database types and what to consider when working on your next project.

Margo and the HarperDB team have written a huge collection of posts covering all business intelligence, data lakes, database storage, and more. Give them a follow for more on the world of data!

Database Architectures & Use Cases - Explained

Margo McCabe Jun 30 '20 7 min read

#database #architecture #webdev #beginners

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.