Tag: SQL

All the articles with the tag "SQL".

• What Is Database Connection Pooling and Why It Matters

  24 Apr, 2026

  By Pratik Bhuite | 34 min read

  Series: Database Fundamentals

  Learn what database connection pooling is, how it works under the hood, and why it is essential for building performant, scalable backend applications.

  • Database
  • SQL
  • Beginner Guide

• How ORMs Work Internally: A Simple Explanation

  23 Apr, 2026

  By Pratik Bhuite | 35 min read

  Series: Database Fundamentals

  Learn how Object-Relational Mappers work under the hood - from query building and identity maps to lazy loading and the N+1 problem.

  • Database
  • SQL
  • ORM

• What Is a Database Transaction? Step-by-Step Guide

  22 Apr, 2026

  By Pratik Bhuite | 24 min read

  Series: Database Fundamentals

  Learn what a database transaction is, how BEGIN, COMMIT, and ROLLBACK work, and when to use savepoints with clear SQL examples.

  • Database
  • SQL
  • Beginner Guide

• ACID Properties Explained: Atomicity, Consistency, Isolation, and Durability

  18 Apr, 2026

  By Pratik Bhuite | 21 min read

  Series: Database Fundamentals

  Learn what ACID properties mean in databases. Understand atomicity, consistency, isolation, and durability with simple examples and real-world use cases.

  • Database
  • SQL
  • Beginner Guide

• Database Normalization Explained: 1NF, 2NF, and 3NF with Examples

  17 Apr, 2026

  By Pratik Bhuite | 16 min read

  Series: Database Fundamentals

  Learn database normalization step by step. Understand 1NF, 2NF, and 3NF with clear table examples and how each normal form reduces redundancy.

  • Database
  • SQL
  • Database Design

• Basic SQL Queries Every Developer Must Know

  13 Apr, 2026

  By Pratik Bhuite | 20 min read

  Series: Database Fundamentals

  Learn the essential SQL queries every developer needs: SELECT, WHERE, JOIN, GROUP BY, INSERT, UPDATE, and DELETE with real examples.

  • Database
  • SQL
  • Beginner Guide

• What Are Database Indexes? How They Improve Performance

  8 Apr, 2026

  By Pratik Bhuite | 12 min read

  Series: Database Fundamentals

  Learn what database indexes are, how they speed up SQL queries, and when to use single, composite, and covering indexes to improve performance.

  • Database
  • SQL
  • Performance

• Primary Key vs Foreign Key Explained with Examples

  7 Apr, 2026

  By Pratik Bhuite | 12 min read

  Series: Database Fundamentals

  Primary key vs foreign key explained with SQL examples, core differences, and best practices to design reliable relational database schemas.

  • Database
  • SQL
  • Relational Database

• SQL vs NoSQL: Complete Guide to Differences, Use Cases, and Examples

  4 Apr, 2026

  By Pratik Bhuite | 12 min read

  Series: Database Fundamentals

  Learn the key differences between SQL and NoSQL databases, their use cases, advantages, and when to choose each for your projects with practical examples.

  • Database
  • SQL
  • NoSQL

• Relational Databases Explained: Tables, Rows, and Keys

  3 Apr, 2026

  By Pratik Bhuite | 18 min read

  Series: Database Fundamentals

  Learn relational databases: tables, rows, columns, and keys - with practical SQL examples and clear explanations for beginners.

  • Database
  • SQL
  • Relational Database