ASCI Logo
ASCI.Academy
LearnPracticeCompeteCareer
Sign InGet Started

Search ASCI Academy

Universal search across Courses, Lessons, Skills, Projects, Challenges, Competitions, Jobs, Internships, and Users

sql

Curriculum Index

Current LevelInitiate
0/ 500 XP
Gravit Certificate:
100% Required
  • SQL Introduction & Querying with SELECT and WHERE
  • Database Mutations: INSERT, UPDATE & DELETE
•
1
2
3
4
5
6
7
8
9
10
Relational Queries & CRUD•Lesson 2

INSERT, UPDATE & DELETE

Modifying database tables requires precision. INSERT INTO appends new rows. UPDATE alters existing column values—always accompanied by a WHERE clause to avoid accidentally modifying every row in the entire table! DELETE removes rows matching criteria.

> **Key Takeaway:** Use INSERT INTO to create records, UPDATE to modify existing rows, and DELETE to remove data.
Python 3.11
•
Interactive Challenge
+50 XP
Challenge Objective

Use INSERT INTO to create records, UPDATE to modify existing rows, and DELETE to remove data.

solution.py
UTF-84 SpacesAuto-saved
cpython3.11:~/workspace
CPython 3.11.8 (WASM)
$python3 -u solution.py
Click "Compile & Run" (or press Ctrl + Enter) to compile AST, verify bytecode, and execute the solution.