Paul SerbanSoftware Engineer
  • PORTFOLIO
  • BLOG

#Query Optimization

Posts

  • Relational Databases Explained: What, How, When, and WhyA practical guide to the relational model, SQL fundamentals, and the engineering decisions behind choosing a relational database

    Learn the core concepts of relational databases-tables, keys, normalization, ACID, and indexing-with practical SQL and code examples for engineers.

    • #Database Design
    • #Software Architecture
    • #SQL
    • #ACID
    • #Database Normalization
  • SQL Fundamentals: A Hands-On Guide to the Basics Every Developer NeedsFrom SELECT statements to joins and transactions - a practical, no-fluff introduction to relational databases for engineers who want to actually understand what's happening under the hood

    Learn SQL fundamentals through practical examples: queries, joins, indexes, transactions, and normalization - a hands-on guide built for developers who want real understanding.

    • #Database Engineering
    • #Back-end Development
    • #SQL
    • #Relational Databases
    • #Query Optimization
  • SQL Patterns, Anti-Patterns, and Pitfalls: A Practical Guide for EngineersHow to write SQL that scales, stays correct, and doesn't quietly rot your database

    A practical guide to SQL design patterns, common anti-patterns, and performance pitfalls, with concrete examples for engineers who work with relational databases daily.

    • #Database Engineering
    • #Software Architecture
    • #SQL
    • #Query Optimization
    • #Database Indexing
View all posts
  • LinkedInLinkedIn
  • GitHubGitHub
  • HackerRankHackerRank
  • LeetCodeLeetCode
  • EmailEmail
  • Portfolio
  • My Projects
  • Coursework
  • Blog
  • Posts
  • Snippets
  • Book Notes
  • Cookie Settings
  • Cookie Policy
2026 © Paul Serban. All rights reserved.www.paulserban.eu | Sitemap