Database Clinic: SQLite

Get started using the versatile SQLite database engine.

Introduction

• Embedding SQL everywhere with SQLite
• SQLite vs. other SQL engines
• How to use the exercise files

1. SQLite Quick Start

• 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

2. Creating and Modifying Data

• 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

3. Going Further with SELECT

• Combining multiple tables with JOINs
• Basic functions
• Aggregate functions
• Window functions
• Queries of queries
• Transactions and isolation

4. Embedding SQLite

• Web browsers
• Programming languages
• Internet of Things

Conclusion

• Next steps