Understanding Databases

Introduction

Databases are the backbone of any software application. They are used to store, retrieve, and manipulate data. There are many types of databases, but the most common ones are Relational Databases and NoSQL Databases. Relational Databases are based on the relational model of data, and NoSQL databases are based on non-relational models of data.

Quickly spin up databases

1. The rise of docker has made Installation and testing Databases very easy. You can use this article as a reference. Please check the docker hub page of the database software for the latest comments.

The underlying stuff

1. A good playlist on Database Engineering Concepts
2. Carnegie Mellon University’s Databases Courses Part 1 and Part 2
3. Mode Analytics SQL Tutorial

Book

I haven’t read many Books on Databases, But one of the books I have read and found very useful is the Database System Concepts by Sudarshan et.al. I read the 6th edition years ago. This helps in deep diving into the databases and the foundational principles behind them.

---