Python Syntax for SQL Developers

The Translation

SQL is declarative: you say WHAT you want. Python is imperative: you say HOW to do it.

Variables

# SQL: You store data in tables. Python: You store data in variables.

total_sales = 50000

customer_name = "John Doe"

is_premium = True

Lists (Like SQL Result Sets)

customers = ["Alice", "Bob", "Charlie"]

print(customers[0]) # Alice (0-indexed!)

Loops (Like Processing Each Row)

for customer in customers:

print(f"Hello, {customer}!")

Functions (Like Stored Procedures)

def calculate_tax(amount, rate=0.1):

return amount * rate

tax = calculate_tax(1000) # 100.0

*Day 103: Introduction to Pandas—The SQL of Python.*