SQLite for Beginners: ALTER TABLE — ADD COLUMN, RENAME & More | Episode 12

Tables evolve! In this episode, you learn ALTER TABLE to add new columns, rename columns, and rename tables — all without recreating anything. We start with a student grades table and progressively modify it: add an email column, rename subject to course, and rename the table to enrollments. Student code: https://github.com/GoCelesteAI/learn-sqlite-in-neovim/tree/main/episode12 Every keystroke is shown on screen with 3-second pauses so you can follow along at your own pace. What You'll Learn: - ALTER TABLE ADD COLUMN to add new columns - New columns start as NULL for existing rows - ALTER TABLE RENAME COLUMN to change column names - ALTER TABLE RENAME TO to change the table name - Using .tables to verify table names - Running SQL files with :!sqlite3 :memory: Timestamps: 0:00 - Introduction 0:12 - Preview: What We Cover 0:44 - Creating alter_table.sql 1:50 - CREATE TABLE students (4 columns) 2:56 - INSERT — four students 4:01 - SELECT * — four columns, four rows 4:34 - ALTER TABLE ADD COLUMN email 5:13 - UPDATE to populate emails 6:41 - ALTER TABLE RENAME COLUMN subject to course 7:24 - ALTER TABLE RENAME TO enrollments 8:22 - .tables — confirm new name 8:52 - Recap: 3 Key Takeaways 9:27 - End Screen Key Takeaways: 1. ADD COLUMN adds a new column — existing rows get NULL for the new column 2. RENAME COLUMN changes a column name — the data stays the same 3. RENAME TO changes the table name — all queries must use the new name This is Episode 12 of the Learn SQLite in Neovim series — 32 episodes from beginner to advanced. Taught by CelesteAI. Like & subscribe for more tutorials! #sqlite #sql #neovim #programming #tutorial #beginners #learnsql #database #altertable #addcolumn #rename #sqlitetutorial #coding Tags