Get started using the versatile SQLite database engine.
Overview
Syllabus
Introduction
- Embedding SQL everywhere with SQLite
- SQLite vs. other SQL engines
- How to use the exercise files
- Starting SQLite
- The SQLite command-line interface
- DB Browser for SQLite
- Retrieving data with SELECT
- Filtering your SELECT with the WHERE clause
- Grouping your results
- Creating a table with the CREATE TABLE statement
- Setting rules on your data
- Enforcing relationships between tables
- Adding data to a table
- Modifying an existing table
- Deleting data
- Combining multiple tables with JOINs
- Basic functions
- Aggregate functions
- Window functions
- Queries of queries
- Transactions and isolation
- Web browsers
- Programming languages
- Internet of Things
- Next steps
Taught by
Mark Niemann-Ross
