SQLite for Beginners: CREATE TABLE, INSERT & SELECT in Neovim | Episode 1

Start learning SQL from scratch — right inside Neovim! In this first episode, we create a contacts table, insert rows, and query data with SELECT. SQLite is a lightweight database engine used in mobile apps, browsers, IoT devices, and millions of applications worldwide. No server needed — it runs right on your machine. In this series, we learn SQL while coding in Neovim — building both skills at once. Every keystroke is shown on screen with 3-second pauses so you can follow along at your own pace. What You'll Learn: - Creating a .sql file in Neovim - .mode column and .headers on for readable output - CREATE TABLE to define columns with types (INTEGER, TEXT) - PRIMARY KEY for automatic row IDs - INSERT INTO to add rows with text values in single quotes - SELECT * FROM to query all rows and columns - Running SQL files with :!sqlite3 Timestamps: 0:00 - Introduction 0:12 - What is SQLite? (Preview) 0:44 - Creating intro.sql 0:54 - File header comments 1:14 - .mode column and .headers on 1:51 - CREATE TABLE contacts 2:38 - First run — table created silently 3:16 - INSERT INTO — adding three contacts 4:26 - SELECT * FROM contacts 5:00 - Final run — three rows displayed 5:36 - Recap: 3 Key Takeaways 6:06 - End Screen Key Takeaways: 1. CREATE TABLE defines your table structure with column names and types 2. INSERT INTO adds rows — text values go in single quotes 3. SELECT * FROM shows all data — the most common SQL query This is Episode 1 of the Learn SQLite in Neovim series — 32 episodes from beginner to advanced, covering tables, queries, filtering, joins, aggregation, transactions, and more. Taught by CelesteAI. Like & subscribe for more tutorials! #sqlite #sql #neovim #programming #tutorial #beginners #learnsql #database #neovimtutorial #coding #sqlitetutorial #createtable #insertinto #select #sqlbasics