Database Tutorials

Browser engines, DOM and CSSOM processing, critical rendering paths, and tips for improving web performance.

All Database Tutorials

Fundamentals

Database Basics: A Beginner Guide to Data Storage

Learn the fundamentals of databases, including tables, rows, columns, and how data is stored, organized, and managed in applications.

View Tutorial

Relational Database Design: Principles and Best Practices

Learn how to design relational databases with proper structure, relationships, and constraints for efficient data management.

View Tutorial

SQL

SQL Basics: A Beginner Guide to Database Queries

Learn the fundamentals of SQL including SELECT, INSERT, UPDATE, DELETE, and how to query and manage data in relational databases.

View Tutorial

Advanced SQL: Joins, Subqueries, and Window Functions

Master advanced SQL concepts including different types of joins, correlated subqueries, and window functions for complex data analysis.

View Tutorial

Performance

SQL Query Optimization: Writing Efficient Database Queries

Learn how to write efficient SQL queries, avoid common performance pitfalls, and use EXPLAIN to analyze query execution plans.

View Tutorial

Database Indexing: How It Works and Why It Matters

Learn what database indexing is, how indexes improve query performance, and how to use them effectively to speed up data retrieval.

View Tutorial

Types of Database Indexes: B-Tree, Hash, Bitmap, and Full-Text

Learn about different index types including B-Tree, Hash, Bitmap, and Full-Text indexes, and when to use each for optimal query performance.

View Tutorial

Database Caching: How It Works and Why It Matters

Learn what database caching is, how it reduces database load, and how caching strategies improve application performance and scalability.

View Tutorial

Query Execution Plan: Understanding How Databases Run Queries

Learn how to read and analyze query execution plans to identify performance bottlenecks and optimize slow queries.

View Tutorial

Database Partitioning: Splitting Large Tables for Performance

Learn what database partitioning is, how it splits large tables into smaller manageable pieces, and how it improves query performance and maintenance.

View Tutorial

Database Performance Tuning: A Complete Guide

Learn how to optimize database performance through indexing, query optimization, configuration tuning, and architecture improvements.

View Tutorial

Design

Database Normalization: What It Is and Why It Matters

Learn what database normalization is, how it reduces data redundancy, and how normal forms like 1NF, 2NF, and 3NF improve database design.

View Tutorial

Database Denormalization: When and How to Use It

Learn what denormalization is, when to use it for performance optimization, and the trade-offs between normalization and denormalization.

View Tutorial

Data Modeling: Designing Database Structures

Learn what data modeling is, how to design database structures, and how entities, attributes, and relationships organize data for applications.

View Tutorial

Entity Relationship Diagram (ERD): Visual Database Design

Learn how to create and read Entity Relationship Diagrams to visually represent database structures, entities, attributes, and relationships.

View Tutorial

Primary Key and Foreign Key: Understanding Database Keys

Learn what primary keys and foreign keys are, how they uniquely identify records, and how they create relationships between tables.

View Tutorial

Architecture

Database Replication: Master-Slave and Multi-Master

Learn what database replication is, how master-slave and multi-master replication work, and how they improve availability and read scalability.

View Tutorial

Database Sharding: Horizontal Scaling for Large Databases

Learn what database sharding is, how it distributes data across multiple servers, and how it enables horizontal scaling for massive datasets.

View Tutorial

ACID

Database Transactions: ACID Properties

Learn what database transactions are, the ACID properties (Atomicity, Consistency, Isolation, Durability), and how they ensure data integrity.

View Tutorial

Database Isolation Levels: Read Uncommitted, Read Committed, Repeatable Read, Serializable

Learn about database isolation levels, the concurrency problems they prevent (dirty reads, non-repeatable reads, phantom reads), and how to choose the right level.

View Tutorial

Concurrency

Database Deadlock: Causes, Detection, and Prevention

Learn what database deadlocks are, how they occur, and how to detect and prevent them in high-concurrency applications.

View Tutorial

Database Locking: Row-Level, Table-Level, and Page-Level Locks

Learn about different types of database locks, how they control concurrent access, and how to choose the appropriate lock granularity.

View Tutorial

NoSQL

NoSQL Databases: Types, Use Cases, and When to Use Them

Learn about NoSQL databases, their types (document, key-value, column-family, graph), and when to choose them over relational databases.

View Tutorial

MongoDB Basics: Document Database Fundamentals

Learn the fundamentals of MongoDB, including collections, documents, queries, indexing, and aggregation pipelines.

View Tutorial

Redis Basics: In-Memory Data Store

Learn the fundamentals of Redis, including strings, hashes, lists, sets, sorted sets, and common use cases like caching and session storage.

View Tutorial

Administration

Database Backup and Recovery: Strategies for Data Protection

Learn about database backup strategies, recovery models, point-in-time recovery, and best practices for protecting against data loss.

View Tutorial

Database Migration: Schema Changes Without Downtime

Learn how to manage database schema changes, perform zero-downtime migrations, and use migration tools like Flyway and Liquibase.

View Tutorial

Database Monitoring: Metrics, Alerts, and Performance Tuning

Learn how to monitor database health, track key metrics like query latency, connection count, and cache hit ratio, and set up alerts for anomalies.

View Tutorial

Database Security: Authentication, Authorization, and Encryption

Learn how to secure databases with strong authentication, role-based access control, data encryption at rest and in transit, and audit logging.

View Tutorial

ORM

Database ORM: What It Is and How It Works

Learn what an ORM (Object Relational Mapping) is, how it simplifies database interaction, and how developers use it to work with databases using code instead of SQL.

View Tutorial

ORM Performance: N+1 Problem, Lazy Loading, and Eager Loading

Learn about common ORM performance issues like the N+1 query problem, and how to solve them using lazy loading, eager loading, and batch fetching.

View Tutorial

Analytics

Data Warehousing: Concepts, Architecture, and Best Practices

Learn what data warehousing is, how it differs from operational databases, and how to design star schemas and ETL pipelines for analytics.

View Tutorial