Technology
Databases & SQL
29 lessons · 169 glossary terms · 145 practice questions — Covers Foundations.
- Lessons
- Practice
- Vocabulary
Choose a unit
Foundations29 lessons
- What a Database Is
- Relational Databases
- Tables
- Rows: One Record at a Time
- Columns
- Data Types
- Primary Keys
- Foreign Keys
- Relationships
- One-to-One
- One-to-Many
- Many-to-Many
- Database Normalization
- SQL Basics
- SELECT
- WHERE: Filtering Rows
- ORDER BY
- LIMIT
- INSERT
- UPDATE: Changing Existing Rows
- DELETE: Removing Rows
- Aggregate Functions
- GROUP BY: Summaries per Group
- JOIN
- Subqueries
- Indexes
- Transactions: All-or-Nothing Operations
- Data Integrity
- Database Security
