Learn the fundamentals of SQLite and database management in this comprehensive 22-minute tutorial. Explore the basics of SQLite3, its applications in web development, and essential database operations. Master dot commands, file execution, Data Definition Language (DDL), and Data Manipulation Language (DML). Discover how to select, update, and delete data efficiently. Dive into advanced concepts like foreign keys and creating joins to enhance your database skills. Perfect for beginners looking to gain practical knowledge in SQL and database management.
Overview
Syllabus
- What + why SQLite3
- What about Websites
- Getting Started
- Dot Commands
- Execute a File
- DDL
- DML
- Selecting Data
- Update
- Deleting Data
- Foreign Keys
- Creating a Join
Taught by
Caleb Curry
