SQLite course

SQLite is a software library that implements a self-sufficient, serverless, zero configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. SQLite source code is not subject to copyright restrictions.

This tutorial will show you how to use SQLite programming, and let you get started quickly.

Now start learning SQLite!

Who is suitable to read this tutorial?

This tutorial helps beginners understand the basic knowledge and advanced concepts related to SQLite database engine.

What you need to know before reading this tutorial:

Before starting to use the various examples provided in this tutorial for practice, you need to know what a database is, especially RDBMS, and what a computer programming language is.

Compile/execute SQLite program

If you want to compile/execute SQL programs through SQLite DBMS, but you do not have relevant settings, you can access SQLite Online IDE 。 You can experience real programming experience on high-end servers by simply clicking. This is a completely free online tool.

SQLite Function Reference Manual

This tutorial provides reference manuals for all important built-in SQLite functions.

SQLite Common Functions

SQLite Useful Resources

This tutorial lists SQLite database websites and books.

SQLite Useful Websites

  • SQLite Home Page -The official website of SQLite provides the latest installation version of SQLite, the latest SQLite information and the complete SQLite tutorial.

  • PHP SQLite3 -The website provides full details of PHP support for SQLite 3 databases.

  • SQLite JDBC Driver: -SQLite JDBC, developed by Taro L. Saito, is a library for accessing and creating SQLite database files in Java.

  • DBD-SQLite-0.31 -The SQLite Perl driver driver is used with the Perl DBI module.

  • DBI-1.625 -The Perl DBI module provides a common interface for any database, including SQLite.

  • SQLite Python -The sqlite3 python module was written by Gerhard Haring. It provides a SQL interface compatible with the DB-API 2.0 specification.