Databases

Store and query data with SQL and Prisma, then meet two hosted backends, Supabase and Convex.

14 lessonsAbout 160 minutes

Lessons

1. 1What is a Database?Understanding databases, why they matter, and the different types available10 minQuiz
2. 2SQL BasicsLearn to write your first SQL queries to read data from a database14 minTerminal
3. 3Creating TablesLearn to define database tables with columns, data types, and constraints14 minMatching
4. 4Insert, Update, DeleteLearn to add, modify, and remove data in your database tables14 minTerminal
5. 5Filtering and SortingMaster WHERE clauses, ORDER BY, LIMIT, pattern matching, and logical operators to find exactly the data you need14 minTimeline
6. 6Relationships and JoinsLearn how tables connect through foreign keys and how to combine data from multiple tables using JOINs16 minDiagram
7. 7Prisma ORMUse Prisma to interact with your database using type-safe TypeScript instead of raw SQL16 minScenario
8. 8Database Best PracticesLearn essential practices for database performance, data integrity, security, and reliability14 minQuiz
9. Supabase
10. 9Supabase BasicsWhat a database is, what Supabase adds, and why real-time matters5 minMatching
11. 10Supabase in Your AppReading, writing and listening for changes in code, and Supabase vs Railway PostgreSQL6 minQuizScenario
12. 11Supabase Use Cases and PricingThe Supabase dashboard, common use cases and the free tier3 minMatching
13. Convex
14. 12Convex BasicsWhat Convex is, how its documents and functions work, and how it compares to Supabase10 minMatchingTimeline
15. 13Setting Up ConvexAdd Convex to a new Next.js app by following the official quickstart step by step12 minTerminal
16. 14Convex in Your AppAdd a schema, write mutations, and read and write tasks from a Next.js page12 minQuiz