Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Job-ready SQL and database skills
·
Module 7
Data Manipulation and Definition
1
DDL for Table Management
Create, alter, and drop tables using Data Definition Language (DDL).
2
Designing Tables: Columns, Data Types, and Constraints
Define table columns with appropriate data types and constraints (e.g., `NOT NULL`, `UNIQUE`).
3
Inserting Data with `INSERT` Statements
Insert single and multiple rows into a table using `INSERT` statements.
4
Updating Records with the `UPDATE` Statement
Update existing records that match a condition using the `UPDATE` statement.
5
Deleting Records with WHERE
Delete records from a table using the `DELETE` statement with a `WHERE` clause.
6
Copying and Transforming Data with INSERT SELECT
Use `INSERT` with a `SELECT` statement to copy and transform data between tables.
Previous module
Organizing Queries with CTEs
Next module
Database Design and Normalization