Manipulation
Learn how to use SQL to access, create, and update data stored in a database.
StartKey Concepts
Review core concepts you need to learn to master this subject
Column Constraints
CREATE TABLE
Statment
INSERT
Statement
ALTER TABLE
Statement
DELETE
Statement
UPDATE
Statement
Column Constraints
Column Constraints
CREATE TABLE student (
id INTEGER PRIMARY KEY,
name TEXT UNIQUE,
grade INTEGER NOT NULL,
age INTEGER DEFAULT 10
);
Column constraints are the rules applied to the values of individual columns:
PRIMARY KEY
constraint can be used to uniquely identify the row.UNIQUE
columns have a different value for every row.NOT NULL
columns must have a value.DEFAULT
assigns a default value for the column when no value is specified.
There can be only one PRIMARY KEY
column per table and multiple UNIQUE
columns.
Manipulation
Lesson 1 of 1
What you'll create
Portfolio projects that showcase your new skills
How you'll master it
Stress-test your knowledge with quizzes that help commit syntax to memory