Complete Guide

Complete Database Tutorial

Every application needs a database. This guide covers all 117 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

117

Topics

Beginner

Intermediate

Advanced

Jump to section

SQL Basics (16)SQL Advanced (16)NoSQL (15)Database Design (16)ORM (7)MySQL & PostgreSQL (13)PL/SQL (27)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 UPDATE Statement: Syntax, Examples and Best Practices 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 Single Table Inheritance: When to Use It and When to Avoid It Intermediate

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 SQL Server Management Studio (SSMS): Installation and Features Beginner

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 How to Read and Understand the Oracle Error Stack (ORA-XXXX + ORA-06512) Intermediate Best Practices for Exception Handling in Oracle PL/SQL Advanced ORA-01403: No Data Found – Causes, Fixes & Prevention Beginner ORA-01422: Exact Fetch Returned More Than Requested Number of Rows Beginner ORA-06550: PL/SQL Compilation Error – The Complete Guide Beginner ORA-00942: Table or View Does Not Exist – Full Troubleshooting Beginner ORA-01017: Invalid Username/Password – Common Causes & Solutions Beginner ORA-12154: TNS: Could Not Resolve the Connect Identifier Beginner Oracle Error ORA-01858: A Non-Numeric Character Was Found Intermediate ORA-20001 to ORA-20999: User-Defined Errors and ORA-06512 Intermediate Complete List of Common Oracle Errors That Cause ORA-06512 Intermediate How to Use RAISE_APPLICATION_ERROR Properly in Oracle Intermediate Using PRAGMA EXCEPTION_INIT to Map Oracle Errors Intermediate SQL Developer Debugging Tutorial – Catch ORA-06512 Faster Intermediate Debugging PL/SQL with DBMS_OUTPUT, Exceptions & SQL Developer Intermediate Oracle PL/SQL Performance Tuning to Prevent ORA-06512 Timeouts Advanced Oracle 19c vs 21c vs 23ai: Changes in Error Handling & PL/SQL Advanced Migrating Oracle PL/SQL to PostgreSQL – Common Errors Advanced

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

Also Explore

System Design 78 tutorials → CS Fundamentals 73 tutorials → Python 135 tutorials → DevOps 144 tutorials →

Start from the beginning

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

Browse Database Tutorials →