Квизы: Changing Data & Database Design

Change data safely with INSERT, UPDATE, DELETE and transactions, protect it with constraints and keys, and design tables that stay fast and consistent with indexes and normalization.

Средний Квизов: 5 · вопросов: 50 около 29 минуты
0/5сдано Экзамен по разделу 20 вопросов вперемешку. За 80% - сертификат.
Теги:
1 INSERT, UPDATE & DELETE Лёгкий Add, change and remove rows with INSERT, UPDATE and DELETE, and avoid the classic missing-WHERE mistake. #dml#crud 10 вопр. · ~5 мин Не начат Начать
2 Constraints & Keys Средний Know what NOT NULL, UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY reject, and how SQLite, MySQL and PostgreSQL differ. #constraints#keys 10 вопр. · ~6 мин Не начат Начать
3 Transactions & ACID Средний Group changes with BEGIN, COMMIT, ROLLBACK and savepoints, and know what each ACID property promises. #transactions#acid 10 вопр. · ~6 мин Не начат Начать
4 Indexes Средний Learn what indexes speed up, what they cost and why some queries cannot use them. #indexes#performance 10 вопр. · ~6 мин Не начат Начать
5 Normalization (1NF, 2NF, 3NF) Средний Spot tables that break 1NF, 2NF or 3NF, the anomalies they cause and how to split them. #design#normalization 10 вопр. · ~6 мин Не начат Начать