50 cards
This deck introduces the foundational concepts behind databases and SQL, starting with the basics of what a database is and how relational database management systems work. It then moves into core SQL topics like table structures, primary and foreign keys, common data types, and the DDL statements such as CREATE TABLE, ALTER TABLE, and DROP TABLE. You'll also explore important concepts like UNIQUE and CHECK constraints, which help keep your data accurate and reliable. Together, these cards build a solid mental model of how data is organized, defined, and manipulated.
It's a great fit if you're brand new to SQL, preparing for a technical interview, taking an introductory database course, or simply want a refresher on the terminology you keep running into at work. The questions are phrased in a clear, definition-style format, so even if you have no prior experience with databases, you can work through them at your own pace and build confidence as you go.
To get the most out of these flashcards, try reviewing a small batch of cards each day rather than cramming everything at once. Spaced repetition works especially well for vocabulary-heavy topics like database terminology, since the terms tend to build on one another. When you come across a concept that feels fuzzy, jot down a quick example in your own words; writing out how a primary key or a CHECK constraint works in plain language will help the definition stick far longer than simply memorizing it.