Database Technologies

What is SQL? A beginner's guide to SQL queries

SQL explained: how tables, rows and columns hold data, and how SELECT, WHERE, ORDER BY, INSERT, UPDATE and DELETE read and change it in PostgreSQL and MySQL.

  • 6 min read
  • 5 questions
  • +35 XP
Transcript

SQL, explained by cats. Kitty runs a tuna shop. She needs to remember things. Orders. Customers. Prices. So Kitty uses a database. The database stores data in tables. Rows. Columns. Neatly organized. Each row is one order. Each column is a detail.

To talk to the database, Kitty uses SQL. When Kitty wants answers, she asks questions in SQL. “Show me all tuna orders; “Only today’s orders “Sort BY price; SQL also tells the database to: Insert data. Update data. Delete data.

Databases like Postgres, MySQL, and SQL Server all understand SQL. SQL is strict. Clear. And Reliable. That’s SQL. the language Kitty uses to talk to her database and always find her tuna.