SQL & Database Monthly Wrap Up - June 2019

Hi! I'm Helen, one of your friendly mods looking after the #sql and #database tags.

At the end of each month, I'll be showcasing some of the great posts, projects and insights from the data community.

We started the month with Frank showing us how to migrate databases using migration tools in combination with version-controlled scripts and automated deployments.

Testing Your Database Migrations With Flyway and Testcontainers

Frank Rosner Jun 7 5 min read

#kotlin #database #testing #sql

Ryan showed us how easy it is to set up a Postgres database on Digital Oceans managed servers. If you're looking for a tutorial on how to get going quickly check out this post.

Getting Started with PostgreSQL

Ryan Doyle Jun 14 5 min read

#sql #tutorial #beginners #webdev

Arjun presented a quick tutorial on getting up and running with Amazon Athena to query data directly from S3 using a SQL client.

Connect to Amazon Athena with a SQL client

Arjun Rao Jun 9 2 min read

#aws #sql #data #database

Milhan is studying at Flatiron School and has been learning about the types of databases available. In this post, we see the advantages and disadvantages of SQLite and Postgres.

How To Select a Relational Database Management System

milandhar Jun 3 5 min read

#sql #sqlite #postgres #beginners

Lucas is back with Everything you need to know about NoSQL databases to follow up the excellent article from earlier this year on SQL databases.

Everything you need to know about NoSQL databases

Lucas Olivera Jun 4 16 min read

#beginners #database #nosql

Mark continues the AWS DevOps Pro Certification series and shows the different engines AWS supports, the documentation to get started and CLI features to provision a table, store an item, and perform a query.

AWS DevOps Pro Certification Blog Post Series: Databases

Mark Sta Ana Jun 14 7 min read

#aws #database #rds #dynamodb

Arik introduces us to Graph DBs by comparing records and tables to vertexes and nodes, then answering questions on performance, storage and writing efficient queries. If you've been curious about Graph DBs this is a great place to start.

Making your relational database a little more graphy

Arik Jun 21 5 min read

#graph #sql #relational

If you're learning about Aggregate Functions or need a refresher, this post covers what you'll need to get started with COUNT, DISTINCT and GROUP BY

SQL 201: All About Aggregate Functions

Helen Anderson Jun 17 4 min read

#sql #data #database #beginners

That wraps up the review for this month. If you'd like to see more check out the #sql and #database tags or follow The Database Dev on Twitter.