Learn databases with Brian Holt's Complete Intro to Databases v2 course - master PostgreSQL, MongoDB, Redis, Neo4J and more to advance your career and build better apps with proper data storage and retrieval techniques.

Introduction

Brian Holt's Complete Intro to Databases v2 setup guide covers installation options for MongoDB, PostgreSQL, Neo4j, Redis, and DuckDB using Docker, package managers, or direct downloads with specific version requirements and Node.js configuration.

Installation Notes

Learn database fundamentals with Brian Holt's Complete Intro to Databases v2 course, covering essential terminology, ACID principles, transactions, and different database types including SQL, NoSQL, and key-value stores.

Terminology

Welcome

Learn about SQL and relational databases in this Complete Intro to Databases course by Brian Holt. Explore PostgreSQL and more database management systems with practical comparisons and use cases.

Intro to SQL Database

Learn PostgreSQL fundamentals with Brian Holt's Complete Intro to Databases v2 - set up Docker containers, create databases and tables, and write your first SQL queries with step-by-step examples.

PostgreSQL

Learn essential SQL operations including SELECT, WHERE, UPDATE, and DELETE with PostgreSQL in Brian Holt's Complete Intro to Databases v2 course. Master database queries, filtering, sorting, and data manipulation with practical examples.

Querying Postgresql

Learn advanced PostgreSQL queries including foreign keys, JOINs, subqueries, and GROUP BY with Brian Holt's Complete Intro to Databases v2. Master relational database concepts through practical examples building a message board system.

Complex SQL Queries

Learn PostgreSQL's JSONB data type with Brian Holt in Complete Intro to Databases v2. Master storing and querying JSON objects in PostgreSQL using brackets, operators, and text extraction techniques for flexible schema-less data.

JSON in PostgreSQL

Learn database performance optimization with indexes in Brian Holt's Complete Intro to Databases v2. Master PostgreSQL indexing, EXPLAIN queries, compound indexes, unique constraints, and full-text search to make your database queries faster and more efficient.

Indexes in PostgreSQL

Learn to build a Node.js app with PostgreSQL in Brian Holt's Complete Intro to Databases course - includes Express setup, SQL queries, and critical SQL injection security practices.

Node.js App with PostgreSQL

Learn vector search and RAG (retrieval-augmented generation) with Postgres pgvector. Brian Holt demonstrates how to implement semantic search using embeddings from OpenAI or Ollama for database-powered AI applications with practical examples.

Vector Search

Learn about NoSQL and document-based databases like MongoDB in Brian Holt's Complete Intro to Databases v2. Discover when to choose unstructured data storage over relational databases and explore key advantages of document databases for JavaScript developers.

NoSQL

Learn MongoDB fundamentals in Brian Holt's Complete Intro to Databases v2 course - set up MongoDB with Docker, create databases and collections, and insert documents with practical examples.

MongoDB

Learn MongoDB querying techniques with Brian Holt's Complete Intro to Databases course - master findOne, find, query operators, logical operations, sorting, and projections for effective database retrieval.

Querying MongoDB

Learn MongoDB CRUD operations including insertOne, insertMany, updateOne, updateMany, upsert, deleteOne, deleteMany, and bulkWrite commands in Brian Holt's Complete Intro to Databases course.

Updating MongoDB

Learn MongoDB database indexing techniques with Brian Holt's Complete Intro to Databases v2 - create compound indexes, unique indexes, and text indexes for full-text search optimization.

Indexes in MongoDB

Learn MongoDB aggregation with pipelines and $bucket, $match, and $sort stages to analyze and group data efficiently from Brian Holt's Complete Intro to Databases course.

Aggregation

Learn how to build a Node.js application with MongoDB integration in Brian Holt's Complete Intro to Databases v2 course, featuring practical code examples for connecting Express server to MongoDB database with search functionality.

Write a Node.js App with MongoDB

Learn graph databases with Neo4j in Brian Holt's Complete Intro to Databases v2 course. Discover nodes, relationships, and properties for modeling complex data relationships like movies, actors, and directors in your applications.

Graph Databases

Learn how to set up and query Neo4j graph database using Docker and Cypher query language. Follow along as Brian Holt demonstrates creating nodes, relationships, and complex graph queries using movie/actor examples in this Complete Intro to Databases v2 tutorial.

Neo4j

Learn to use Neo4j's browser portal at localhost:7474 to run Cypher queries and visualize graph database relationships in Brian Holt's Complete Intro to Databases v2 course.

Neo4j Browser

Learn Neo4j graph database queries with practical examples including shortest path algorithms, relationship traversal, and solving the Six Degrees of Kevin Bacon problem using Cypher query language in Brian Holt's Complete Intro to Databases v2.

Complex Neo4j Queries

Learn how to optimize Neo4j database performance using indexes with Brian Holt's Complete Intro to Databases v2. This tutorial covers creating indexes on Node properties, using EXPLAIN to analyze query performance, and improving database query efficiency for graph databases.

Indexes in Neo4j

Learn to build a Node.js application with Neo4j graph database using Brian Holt's Complete Intro to Databases course - includes Express server, frontend interface, and parameterized queries for finding shortest paths between people.

Node.js App with Neo4j

Graph

Brian Holt explains key-value databases like Redis and Valkey in his Complete Intro to Databases v2 course, covering their use cases as caches, session storage, and analytics tools that complement primary databases like PostgreSQL and MongoDB.

Key Value Store

Learn Redis basics with Brian Holt in this Complete Intro to Databases v2 tutorial - master SET, GET, INCR, DECR commands and Redis key naming conventions using Docker setup.

Redis

Learn Redis NX/XX commands for conditional key setting and TTL (time to live) for automatic key expiration in Brian Holt's Complete Intro to Databases course. Master Redis caching strategies and avoid thundering herd problems.

Redis Command Options

Learn Redis data types in Brian Holt's Complete Intro to Databases v2 course - explore strings, lists, sets, sorted sets, and hashes with practical examples for storing and retrieving app data efficiently.

Redis Data Types

Learn advanced Redis features with Brian Holt including Lua scripting with EVAL, pub/sub messaging, transactions, and LRU cache configuration for database optimization and real-time applications.

More Redis Concepts

Learn to build a Redis Node.js application with Brian Holt's Complete Intro to Databases v2. Build a pageview counter and implement caching patterns using Express and Redis SDK for high-performance web apps.

Node.js App with Redis

Learn about columnar databases like DuckDB and Clickhouse for analytical workloads (OLAP) vs traditional row-based databases (OLTP) in Brian Holt's Complete Intro to Databases v2 course, covering ETL processes and data formats like Parquet and Iceberg.

Columnar

Learn DuckDB basics with Brian Holt in this Complete Intro to Databases tutorial - discover how this columnar OLAP database queries remote files, loads parquet data from S3, and performs fast analytical queries for data science and business intelligence.

DuckDB

Complete guide to choosing the right database for your project by Brian Holt. Learn database selection criteria including SQL, NoSQL, MongoDB, PostgreSQL considerations, paradigm matching, read/write patterns, caching strategies, and production deployment best practices.

Complete Intro to Databases v2

Complete Intro to Databases v2

How to store and retrieve data for apps and AI

Table of Contents

Welcome

SQL

NoSQL

Graph

Key Value Store

Columnar

Conclusion