Learn SQLite, a lightweight, self-contained, and serverless SQL database engine. This learning path offers comprehensive SQLite courses designed for beginners and embedded application developers. It provides a structured roadmap to master SQL queries, data modeling, and local database management. Through a series of hands-on, non-video SQLite courses and practical exercises in an interactive SQL playground, learners gain real-world experience in building and querying embedded databases.
Create a new SQLite database file.
Establish a connection to a SQLite database.
Build a new table in a SQLite database.
Define a primary key in a SQLite table.
Insert one row of data into a SQLite table.
Insert multiple rows into a SQLite table.
Retrieve all rows from a SQLite table.
Filter SQLite query results using a WHERE clause.
Sort SQLite query results with ORDER BY.
Update one row in a SQLite table.
Delete one row from a SQLite table.
Add a new column to an existing SQLite table.
Create an index on a SQLite table column.
Drop an index from a SQLite table.
Create a simple view in a SQLite database.
Drop a view from a SQLite database.
Start a new transaction in SQLite.
Commit changes in a SQLite transaction.
Roll back changes in a SQLite transaction.
Verify if a table exists in a SQLite database.
Retrieve the version of the SQLite engine.
Close the connection to a SQLite database.