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
Introduction
- Embedding SQL everywhere with SQLite
- SQLite vs. other SQL engines
- How to use the exercise files
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
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
Going Further with SELECT
- Combining multiple tables with JOINs
- Basic functions
- Aggregate functions
- Window functions
- Queries of queries
- Transactions and isolation
Embedding SQLite
- Web browsers
- Programming languages
- Internet of Things
Conclusion
- Next steps