SQLite is a lightweight, self-contained, serverless, zero-configuration, transactional SQL database engine. This Skill Tree offers a comprehensive learning path for mastering SQLite. It's perfect for beginners and embedded application developers, presenting a structured roadmap to understand SQL queries, data modeling, and local database management. Through hands-on, non-video courses and practical exercises in an interactive SQL playground, you'll 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.