Complete Guide

Complete Database Tutorial

Every application needs a database. This guide covers all 96 database tutorials on TheCodeForge — SQL fundamentals, NoSQL, database design, query optimisation and more.

Learning Roadmap

Beginner → Write SQL queries, understand tables, joins and filtering

Intermediate → Design schemas, work with indexes, transactions and NoSQL

Advanced → Optimise queries, handle replication, sharding and ORMs

Topics

Beginner

Intermediate

Advanced

Jump to section

SQL Basics (15)SQL Advanced (16)NoSQL (15)Database Design (15)ORM (7)MySQL & PostgreSQL (12)PL/SQL (9)Cassandra (4)Neo4j (3)

SQL Basics

Introduction to SQL Beginner SQL CREATE TABLE and Data Types Beginner SQL INSERT UPDATE DELETE Beginner SQL SELECT Statement Beginner SQL WHERE Clause and Filtering Beginner SQL ORDER BY and LIMIT Beginner SQL JOINs Explained Intermediate SQL GROUP BY and HAVING Intermediate SQL Aggregate Functions Beginner SQL Subqueries Intermediate SQL UNION and INTERSECT Intermediate SQL NULL Handling Beginner SQL CASE Statement Intermediate SQL Date and Time Functions Intermediate SQL String Functions Beginner

SQL Advanced

SQL Indexes Intermediate SQL Views Intermediate SQL Stored Procedures Advanced SQL Triggers Advanced SQL Transactions and ACID Advanced SQL Window Functions Advanced SQL CTEs — Common Table Expressions Advanced SQL Query Optimisation Advanced SQL EXPLAIN and Execution Plans Advanced Full-Text Search in SQL Advanced Database Cursors Advanced Partitioning Tables in SQL Advanced Materialized Views Advanced Recursive SQL Queries Advanced Database Locking Mechanisms Advanced Multi-version Concurrency Control Advanced

NoSQL

Introduction to NoSQL Databases Intermediate MongoDB Basics Intermediate MongoDB CRUD Operations Intermediate MongoDB Aggregation Pipeline Advanced MongoDB Indexing Advanced Redis Basics Intermediate Redis Data Structures Intermediate Cassandra Basics Advanced SQL vs NoSQL — When to Use Which Intermediate Firebase Realtime Database Basics Intermediate DynamoDB Basics Intermediate Elasticsearch Basics Advanced Neo4j Graph Database Basics Advanced Apache Kafka Basics Advanced Apache HBase Basics Advanced

Database Design

Database Normalization Intermediate 1NF 2NF 3NF Explained Intermediate ER Diagrams Beginner Primary Key and Foreign Key Beginner Database Relationships Intermediate Database Sharding Advanced Database Replication Advanced CAP Theorem and Databases Advanced Partitioning in Databases Advanced Database Connection Pooling Intermediate Composite Keys in Databases Intermediate Denormalisation in Databases Advanced Event Sourcing with Databases Advanced CQRS with Databases Advanced Polyglot Persistence Advanced

ORM

What is an ORM Beginner Hibernate ORM Basics Intermediate JPA — Java Persistence API Intermediate Sequelize ORM for Node.js Intermediate Prisma ORM Basics Intermediate TypeORM Basics Intermediate ActiveRecord vs DataMapper Pattern Advanced

MySQL & PostgreSQL

MySQL vs PostgreSQL Beginner MySQL Installation and Setup Beginner PostgreSQL Installation and Setup Beginner MySQL Stored Functions Intermediate PostgreSQL JSON Support Advanced Database Backup and Restore Intermediate MySQL Performance Tuning Advanced PostgreSQL Extensions Advanced PostgreSQL Triggers Advanced MySQL Replication Setup Advanced Database Monitoring Tools Intermediate Read Replicas in PostgreSQL Advanced

PL/SQL

Introduction to PL/SQL Beginner PL/SQL Variables, Constants and Data Types Beginner PL/SQL Control Structures — IF, LOOP, WHILE Beginner PL/SQL Cursors Explained Intermediate PL/SQL Stored Procedures and Functions Intermediate PL/SQL Triggers Explained Intermediate PL/SQL Exception Handling Intermediate PL/SQL Packages Explained Advanced ORA-06512: What It Means and How to Fix It Intermediate

Cassandra

Introduction to Apache Cassandra Beginner Cassandra Data Model and Keyspaces Beginner CQL — Cassandra Query Language Basics Beginner Cassandra vs MongoDB — When to Use Which Intermediate

Neo4j

Introduction to Graph Databases and Neo4j Beginner Cypher Query Language Basics Beginner Neo4j Use Cases — When to Use a Graph Database Intermediate

Start from the beginning

Every tutorial starts with a plain-English analogy — then real code, then interview questions.

Browse Database Tutorials →