Skip to content

IT

1. Tables, rows and keys

Initializing search

Home
Start
Books

IT

Home
Start
Books
Books
- Databases
  Databases
  - SQL
    
    SQL
    
    SQL interview fast track
    
    SQL cheat sheet
    
    The sample database: a small shop
    
    1. Tables, rows and keys
    
    2. SELECT, WHERE, ORDER BY, LIMIT
    
    3. The order a query really runs in
    
    4. Expressions: CASE, numbers, dates, CAST
    
    5. Text functions and pattern matching
    
    6. NULL and three-valued logic
    
    7. Aggregation: GROUP BY and HAVING
    
    8. Joins: inner, left, right, full, cross
    
    9. Self, semi and anti joins
    
    10. Subqueries
    
    11. CTEs and recursive CTEs
    
    12. UNION, INTERSECT, EXCEPT
    
    13. Window functions: ranking
    
    14. Window functions: LAG, LEAD and running totals
    
    15. Classic interview patterns
    
    16. Dates and time series
    
    17. INSERT, UPDATE, DELETE, MERGE
    
    18. CREATE TABLE, types, constraints
    
    19. Data modelling
    
    20. Transactions and isolation
    
    21. Views and materialized views
    
    22. Duplicates and incremental loads
    
    23. Data quality checks
    
    24. JSON and arrays
    
    25. Indexes and EXPLAIN
    
    26. Making slow queries fast
    
    27. GROUPING SETS, ROLLUP, CUBE, LATERAL
    
    28. chapter 28
    
    29. Safe SQL
    
    30. Practice set A
    
    31. Practice set B
    
    32. Mock tests
    
    Glossary

1. Tables, rows and keys¶

Being written

This chapter is being written and will be here soon (November 2026).

The sample database: a small shop

2. SELECT, WHERE, ORDER BY, LIMIT

Part of Mars – your new home

Made with Material for MkDocs