#sql

1d ago · 5 min read · How modern database architecture, optimization, and scalability principles improve performance, reliability, and long-term software maintainability. Introduction Databases are one of the most critica

Join discussion

ARAbdul Rahmanblog.abdulrdeveloper.me

0

Chai aur SQL — A Beginner's Journey into Databases

1d ago · 10 min read · SQL stands for Structured Query Language. It is the language we use to talk to relational databases like MySQL, PostgreSQL, and SQLite. What is a Server and Where Does the Database Live? Most beginner

Join discussion

GSGustavo Sanchezgustavosanchez.hashnode.dev

0

My learning path to software engineer

2d ago · 6 min read · Since the COVID-19 pandemic, I've become interested in software engineering. Even though I'm an electronics and telecommunications engineer, 20 years ago I had no real experience with software technol

Join discussion

YPYejun Parkyejunpark3.hashnode.dev

0

Database Normalization: A Complete Guide to Eliminating Anomalies and Designing Clean Schemas

2d ago · 14 min read · Have you ever updated a customer's email address in one table, only to find that their old address still appears somewhere else in your system? Or tried to add a new product to a database, only to rea

Join discussion

TKTomas Kucharzykkuchatom.hashnode.dev

0

New SQLCL 26.1 feature - DIFF command

4d ago · 4 min read · It has already been some time since I started using SQLcl project, and in my opinion it is a very good tool for CI/CD. I like that I can just export, stage, and deploy in a few simple steps. The new S

Join discussion

CLConstantin Lungudatawise.dev

0

pre_ and post_operations in Dataform

4d ago · 1 min read · Here's a useful Dataform concept: pre_operations and post_operations. As the name implies, these represent a set of actions that run before and after the main operation (table, view, or SQL operations

Join discussion

MMarymaryjonah.hashnode.dev

0

Let's have a summer sale ☀️🏖️😎🌴

4d ago · 2 min read · In about a month's time, the summer begins and by now, most companies are already out with good deals on their products. Unfortunately, my fictional company was dealing with other issues, so they are

Join discussion

YPYejun Parkyejunpark3.hashnode.dev

0

How Databases Find Your Data in Milliseconds: A Deep Dive into Indexing and B-Trees

4d ago · 15 min read · Have you ever wondered how a database with tens of millions of records can return your query result in under a millisecond? The answer is indexing — one of the most elegant and practical ideas in comp

Join discussion

IEItdaksh Educationitdaksh.hashnode.dev

0

Step-by-Step Roadmap to Become a Python Developer from Scratch in 2026

6d ago · 23 min read · Step-by-Step Roadmap to Become a Python Developer from Scratch in 2026 The complete roadmap to become a job-ready Python developer from absolute zero is a 6 to 7 month journey divided into seven seque

Join discussion

VDVishnu Dthedatatrench.hashnode.dev

0

OLTP vs OLAP: The Difference Every Data Engineer Should Know

May 15 · 10 min read · Every data pipeline you build starts at an OLTP system and ends at an OLAP system. If you don't understand the difference, you'll design the wrong thing. This post is the foundation. If you've read th

Join discussion

Tag feed

Tag feed

#sql

Trending tags this week

Building Scalable Database Systems for Modern Applications