Code24Lab
Menu
Courses Categories Guides Pricing Log in Sign up

psql and Your First PostgreSQL Query

Lesson 1 of 22Lab

All lessons
  1. psql and Your First PostgreSQL QueryLabFree
  2. Data Types and How Much Space They TakeLab Locked
  3. serial, Identity Columns and SequencesLab Locked
  4. text, varchar(n) and String FunctionsLab Locked
  5. numeric(p,s): Exact Decimals and OverflowLab Locked
  6. Integer Division, % and :: CastsLab Locked
  7. date: Days, Differences and IntervalsLab Locked
  8. timestamp, EXTRACT and Half-Open RangesLab Locked
  9. CREATE TABLE with NOT NULL, CHECK and DEFAULTLab Locked
  10. INSERT: Multi-Row VALUES, DEFAULT and RETURNINGLab Locked
  11. UPDATE: Change Rows SafelyLab Locked
  12. DELETE, Foreign Keys and ON DELETE CASCADELab Locked
  13. WHERE with IN, BETWEEN, AND and ORLab Locked
  14. ORDER BY, NULLS LAST, LIMIT and OFFSETLab Locked
  15. LIKE, ILIKE and Concatenation with ||Lab Locked
  16. NULL, COALESCE and AggregatesLab Locked
  17. GROUP BY, HAVING and the FILTER ClauseLab Locked
  18. boolean and CASE ExpressionsLab Locked
  19. generate_series: Numbers and Dates on DemandLab Locked
  20. Calendars with generate_series and LEFT JOINLab Locked
  21. Transactions: BEGIN, COMMIT, ROLLBACK and SAVEPOINTLab Locked
  22. Final Project: The March ReportLab Locked

You are not signed in — the lab works, but your progress is not saved. Sign up

Lesson 1 of 22 is free. Unlock all 22 hands-on labs, the final exam and your certificate.

Buy course — €9.90
Loading the lab…
Next lesson →