Typing Hero App typingheroapp.com
Typing in SQL — Reserved Words and Quick Queries

Typing in SQL — Reserved Words and Quick Queries

· 2 min read · by Robin Érsek-Obádovics

SQL has unique typing demands: convention says keywords UPPERCASE (SELECT, FROM, WHERE), but identifiers in lowercase. This means heavy Shift usage. Add JOINs, subqueries, CTEs — and SQL becomes punctuation- and capitalization-rich.

SQL-specific characters

  • ***** wildcard (SELECT *)
  • ' string literals ('value')
  • ( ) grouping, function calls, subqueries
  • , column separators
  • ; statement terminator
  • = equality (or == in some dialects)
  • % wildcard in LIKE
  • . schema.table.column
  • " identifier quoting (some dialects)

Most-typed SQL patterns

Basic SELECT

SELECT column1, column2
FROM table_name
WHERE condition;

SELECT FROM WHERE rhythm.

JOIN patterns

SELECT t1.col, t2.col
FROM table1 t1
INNER JOIN table2 t2 ON t1.id = t2.t1_id
WHERE t1.status = 'active';

JOIN ON = is core SQL muscle memory.

Aggregations

SELECT COUNT(*), AVG(price), MAX(date)
FROM orders
GROUP BY customer_id
HAVING COUNT(*) > 10;

CTEs (Common Table Expressions)

WITH recent_orders AS (
    SELECT * FROM orders WHERE date > '2026-01-01'
)
SELECT * FROM recent_orders;

INSERT/UPDATE/DELETE

INSERT INTO table (col1, col2) VALUES ('a', 'b');
UPDATE table SET col1 = 'x' WHERE id = 1;
DELETE FROM table WHERE id = 1;

Uppercase keywords debate

Convention: SELECT FROM WHERE uppercase. Reality: most modern formatters do this for you.

If typing manually:

  • Use lowercase, let formatter capitalize
  • Or use snippets: sel → SELECT * FROM etc.

Or: train yourself uppercase manually (lots of Shift).

Speed tools for SQL

  • DBeaver — universal SQL IDE
  • DataGrip (JetBrains) — premium SQL IDE
  • SQL formatter — auto-capitalize keywords
  • Snippet packs for common queries
  • Auto-complete for column names

Snippets that save hours

  • sel → SELECT * FROM
  • selw → SELECT * FROM WHERE
  • join → INNER JOIN ON
  • cte → WITH name AS (SELECT * FROM )
  • upd → UPDATE SET WHERE

Realistic SQL typing speeds

  • 30 WPM: SQL is more think than type
  • 50-70 WPM: standard analyst/data engineer
  • 80+ WPM: senior data professional

SQL: query design >> typing speed. But friction-free flow helps thinking.

Common SQL typing pitfalls

  • ❌ Forgetting ; terminator
  • ❌ Mismatched parens in subqueries
  • ❌ Wrong quote type (" vs ')
  • ❌ Typos in column names (auto-complete helps)
  • ❌ Capitalization inconsistency (formatter helps)

Frequently Asked Questions

Are uppercase SQL keywords mandatory?

No — convention only. Most engines case-insensitive for keywords.

Will auto-complete know my schema?

If connected to live DB: yes. Otherwise: import schema definitions.

Best SQL IDE?

DBeaver (free, universal). DataGrip (paid, JetBrains). Either is excellent.

Should I learn keyboard shortcuts in my SQL tool?

Yes — F5 to run, Ctrl+Space for completion, format hotkey. Saves hours.

Best layout for SQL?

QWERTY. No special advantages from alternatives.

Will my SQL speed match my code speed?

Usually slower — SQL more think-time per character.

Build SQL typing flow

Typing Hero App — free, no signup. Get to 60 WPM baseline, then drill SQL-specific patterns with snippets.

For more: How to type code faster, Touch typing for programmers, Touch typing for data entry workers.