Welcome to the Complete Intro to Databases! Brian goes over what you need to know to get started.

Introduction

Brian gives you notes on how you can install the various databases you will be using in this course.

Installation Notes

Brian discusses what databases are, what the various type we will cover, and get you in the mindset of storing data.

Terminology

Welcome

Brian introduces the first style of database in the course, NoSQL. He goes over what the term means and leads into the example NoSQL you are going to work with, MongoDB.

Nosql

MongoDB is a document-based NoSQL database that allows developers to write unstructured data to be queried later. Brian goes into what this means for a developer and when you might want to use it

MongoDB

After inserting documents into MongoDB, you are going to want to be able to query those documents. Brian shows you how in this section to write find queries for MongoDB.

Querying Mongodb

Brian shows you how to update and delete the documents that have been inserted into the database.

Updating Mongodb

When querying against MongoDB, query performance can be very important. Brian shows you how to think about indexing a MongoDB database to improve performance and capabilities.

Indexes in Mongodb

Aggregation

Brian shows you a quick project to demonstrate how to translate these command line concepts into code with a Node.js app to query our pets database

Write a Node.js App with MongoDB

While developers don't necessarily need to know how to run a database cluster in production, it can be important to know how and why databases are being run the way they are. Brian gives a brief treatise on the various features of MongoDB's operations aspects.

MongoDB Ops

The most common databases today are relational databases. Brian goes over the landscape of current SQL-based relational databases and some of their features.

Intro to SQL Database

PostgreSQL is a relational database that lets developers write amazing apps. Brian goes over how to get PostgreSQL started on your computer and help you write your first query.

PostgreSQL

SQL is a very flexible and expressive way to describe what data you want out of a database. In this section Brian talks about the various ways to read from and modify a database using SQL.

Querying Postgresql

Brian dives into how to compound queries, joins, unions, group bys, and other ways to get obtain powerful results with the expressiveness of SQL

Complex Sql Queries

One of PostgreSQL's super powers is that it's able to store and query JSON

JSON in PostgreSQL

Indexes are critical to a well functional relational database. Brian quickly explains how to investigate query performance and how to create an index to solve that problem.

Indexes in Postgresql

To help transfer learnings from the command line to code, Brian shows you how to quickly write an app for our message board tables using Node.js

Node.js App with PostgreSQL

Brian gives a quick overview of a powerful tool to use with PostgreSQL, Hasura. Hasura is a service you will put in your cluster so you can query your PostgreSQL database with GraphQL.

Hasura

While it is not important for a developer to know how to precisely manage a database cluster in production, a developer does need to know a bit how about how it is done so they can plan accordingly when they write their code.

PostgreSQL Ops

Graph databases are great when you need to define relations between objects that can have complex webs of relations especially for things like social networks.

Graph Databases

Neo4j

An amazing tool that Neo4j provides dev is a built in browser that allows you run queries and visualize your graph

Neo4j Browser

Complex Neo4j Queries

Query performance in a graph database is just as important as it is in any database. Brian teaches you to profile Neo4j queries and how to tune them for performance with indexes.

Indexes in Neo4j

Time to put some of that graph magic into practice! Put together with Brian an app to find the smallest path between two people in a graph.

Node.js App with Neo4j

Brian talks for a second about what things to consider with Neo4j running in production.

Neo4j Ops

Graph

Key Value Store

Redis

Useful when using Redis is the ability to define when documents get deleted with TTLs and when a query will fail with NX and XX.

Redis Command Options

Redis has a few different data types. Brian goes over when and where you would use each of them.

Redis Data Types

This course only covers some of Redis's core capabilties but there a few more use cases a developer should know about Redis.

More Redis Concepts

Take the learnings from how to use Redis as a key-value store and cache from the command line to code! Brian whips up two examples of how and why you'd want to use Redis with Node.js.

Node.js App with Redis

Learn a few things about running Redis and how you as a coder can maximize your effectiveness with Redis.

Redis Ops

Brian wraps up the course and says his parting, wise words.

Complete Intro to Databases v2

Complete Intro to Databases v2

How to store and retrieve data for apps and AI

Table of Contents

Welcome

Nosql

Sql

Graph

Key Value Store

Conclusion