First Move (11~18) - Code, Learn, Build
🧭 Career CompassDashboardProgress
Loading...
First Move (11~18) - Code, Learn, Build

Structured, level-based technology learning paths from foundational exploration to industry mastery.

Learning Domains

  • Python Programming (Active)
  • Computer Science Core
  • Web Development
  • AI & Machine Learning

Platform Architecture

  • Level-Based Progression
  • Decoupled Content Schema
  • Modular Code Execution Engine
  • Curated Official Resources

© 2026 First Move (11~18) • CODE • LEARN • BUILD. Built with Next.js App Router.

Readability & Accessibility First

← SQL & Database Management Systems|Level 1: Relational Database Fundamentals & SQL Queries

1. Relational Architecture, Primary Keys & SQL Syntax

Lesson 1 of 6
Saved Locally (Guest)
Progress
0%

Relational Architecture, Primary Keys & SQL Syntax

Create database tables, enforce integrity constraints (PRIMARY KEY, UNIQUE, NOT NULL), and perform SELECT, WHERE, ORDER BY, and LIMIT operations.

Learning Objectives & The Relational Model

### Learning Objectives - Master relational database fundamentals (tables, rows, columns, schemas). - Enforce entity integrity with `PRIMARY KEY` and `FOREIGN KEY` constraints. - Categorize SQL statements into DDL (`CREATE`, `ALTER`, `DROP`) and DML (`SELECT`, `INSERT`, `UPDATE`, `DELETE`). - Filter records dynamically using `WHERE`, `LIKE`, `IN`, and `BETWEEN` operators. --- ### The Relational Database Architecture Relational Database Management Systems (RDBMS) store structured records in two-dimensional tables consisting of rows (tuples) and columns (attributes). Data relationships are linked using **Foreign Keys**, preventing orphan records and guaranteeing referential integrity.
💻 Ready to test your knowledge with code?
Solve the hands-on coding exercise in the interactive code editor.