Database Track

Database Tutorials

SQL, NoSQL, database design, indexing, transactions and query optimisation.

117
Topics
31
Beginner
45
Intermediate
41
Advanced
📋 Complete Database Guide — all 117 topics →
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