Skip to main content
SITE-API
Curriculum

Phase 4

Data Persistence and SQL

Carry your intuition for array operations over to databases, SQL, and transactions. Covers standalone SQL as well as connecting repositories to API contracts.

Topics
10
topic groups
Ready
120
implemented tasks
Total
120
planned tasks

Topic 4-1

SELECT basics

Covers SELECT, WHERE, ORDER BY, LIMIT, and NULL.

Implemented
14
Passed
0
Planned
14
Environment
SQLite-like mock DB / TypeScript
Goal
A DB-backed memo API

Required Tasks

Exercises

  1. 01Return only public columns in the memo listAuto grading / FeedbackSign in
  2. 02Fetch a single memo by its IDAuto grading / FeedbackSign in
  3. 03Exclude archived memos from the resultsAuto grading / FeedbackSign in
  4. 04Return the list ordered by most recently updatedAuto grading / FeedbackSign in
  5. 05Fetch only the latest 5 recordsAuto grading / FeedbackSign in
  6. 06Fetch only incomplete tasksAuto grading / FeedbackSign in
  7. 07Return a NULL description as an empty stringAuto grading / FeedbackSign in
  8. 08Fetch only the count of public memosAuto grading / FeedbackSign in
  9. 09Fetch only memos created todayAuto grading / FeedbackSign in
  10. 10Return prioritized tasks in priority orderAuto grading / FeedbackSign in
  11. 11Fix a broken SELECT clauseAuto grading / FeedbackSign in
  12. 12Exclude deleted records while returning an empty array for zero resultsAuto grading / FeedbackSign in
  13. 13Clarify the difference in SELECT columns between detail and list retrievalAuto grading / FeedbackSign in
  14. 14Apply the basic SELECT contract to the memo APIAuto grading / FeedbackSign in