Introduction to SQLite

1h 16mBeginner2023-01-23

Authors

Brian Jepson

Programmer and Data Analyst

Course details

As a developer, you will encounter the SQLite database engine in a lot of places: as a storage engine for web browsers, in IoT, on mobile phones, for configuration and log storage, and many more use cases. In this course, programmer and data analyst Brian Jepson gives you all the information you need to get started using SQLite. Learn about SQLite setup and the command-line interface. Check out DB Browser and learn to use the SELECT statement. Explore ways to create, add, modify, and delete data, then deep dive into more uses of SELECT and other functions. Find out how to work with SQLite databases from a web application, pair it with programming languages, and embed it in phones and IoT devices. Get started with this very versatile engine!

Skills covered

SQLiteDatabase DevelopmentDatabase ManagementLearningOpen SourceSoftware Development

Concepts

0. Introduction

01 - Embedding SQL everywhere with SQLite
02 - SQLite vs. other SQL engines
03 - How to use the exercise files

1. SQLite Quick Start

04 - Starting SQLite
05 - The SQLite command-line interface
06 - DB Browser for SQLite
07 - Retrieving data with SELECT
08 - Filtering your SELECT with the WHERE clause
09 - Grouping your results

2. Creating and Modifying Data

10 - Creating a table with the CREATE TABLE statement
11 - Setting rules on your data
12 - Enforcing relationships between tables
13 - Adding data to a table
14 - Modifying an existing table
15 - Deleting data

3. Going Further with SELECT

16 - Combining multiple tables with JOINs
17 - Basic functions
18 - Aggregate functions
19 - Window functions
20 - Queries of queries
21 - Transactions and isolation

4. Embedding SQLite

22 - Web browsers
23 - Programming languages
24 - Internet of Things

Conclusion

25 - Next steps