← All blog series

SQLite with Neovim (Beginner)

Learn SQLite hands-on inside Neovim — CREATE TABLE, INSERT, SELECT, WHERE, AND/OR/NOT, ORDER BY, LIMIT/OFFSET, data types and typeof(). 12 beginner-friendly episodes.

12 posts

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

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

Celest Kim•Video•Quiz available
1
SQLite for Beginners: INSERT INTO, Multi-Row Inserts & NULL Values | Episode 2

SQLite for Beginners: INSERT INTO, Multi-Row Inserts & NULL Values | Episode 2

Celest Kim•Video•Quiz available
2
Learn SQLite in Neovim: Selecting Columns — Pick Only What You Need | Episode 3

Learn SQLite in Neovim: Selecting Columns — Pick Only What You Need | Episode 3

Celest Kim•Video•Quiz available
3
Learn SQLite in Neovim: Data Types — INTEGER, REAL, TEXT & typeof() | Episode 4

Learn SQLite in Neovim: Data Types — INTEGER, REAL, TEXT & typeof() | Episode 4

Celest Kim•Video•Quiz available
4
Learn SQLite in Neovim: WHERE Clause — Filter Your Data | Episode 5

Learn SQLite in Neovim: WHERE Clause — Filter Your Data | Episode 5

Celest Kim•Video•Quiz available
5
Learn SQLite in Neovim: Multi-Condition Filters with AND, OR, NOT | Episode 6

Learn SQLite in Neovim: Multi-Condition Filters with AND, OR, NOT | Episode 6

Celest Kim•Video•Quiz available
6
SQLite for Beginners: ORDER BY, ASC, DESC & Multi-Column Sorting | Episode 7

SQLite for Beginners: ORDER BY, ASC, DESC & Multi-Column Sorting | Episode 7

Celest Kim•Video•Quiz available
7
SQLite for Beginners: LIMIT, OFFSET & Pagination Explained | Episode 8

SQLite for Beginners: LIMIT, OFFSET & Pagination Explained | Episode 8

Celest Kim•Video•Quiz available
8
Learn SQLite in Neovim: LIKE & Pattern Matching — Wildcards % and _ | Episode 9

Learn SQLite in Neovim: LIKE & Pattern Matching — Wildcards % and _ | Episode 9

Celest Kim•Video•Quiz available
9
SQLite for Beginners: UPDATE SET WHERE & the Danger of No WHERE | Episode 10

SQLite for Beginners: UPDATE SET WHERE & the Danger of No WHERE | Episode 10

Celest Kim•Video•Quiz available
10
SQLite for Beginners: DELETE FROM WHERE & DROP TABLE Explained | Episode 11

SQLite for Beginners: DELETE FROM WHERE & DROP TABLE Explained | Episode 11

Celest Kim•Video•Quiz available
11
SQLite for Beginners: ALTER TABLE — ADD COLUMN, RENAME & More | Episode 12

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

Celest Kim•Video•Quiz available