SQLite is an open source, serverless, zero-configuration, self-contained, stand alone, transaction relational database engine designed to be embedded into an application. Python by default will have the SQlite3 module installed in it, we need not to install this module separately. This course help you to start with using SQLite3 module in Python. To use sqlite3 module in Python Programming, you must first create a connection object that represents the database and then optionally you can create a cursor object, which will help you in executing all the SQL statements.

Once you complete this tutorial, you will get basics of SQLite3 module.

Concepts covered in this course:

Overview

Sample Database Creation

Create a Table

Inserting Data into a table

Selecting Data from a table

Selecting Data Using Where Clause

Order By Clause

LIMIT option

Deleting Rows

Update Data in a table

Alter table

LIKE Operator

Distinct Operator

Module in-built Functions

rowid

lastrowid

Importing data from CSV file

Exporting data into CSV file

Exception handling with example

Function creation

I will explain all the basic concepts using SQLite3 module in Python Programming with examples.

I will also provide document for each concept for your reference.

After completing this course, you will be in a position to understand SQLite3 concepts and start writing your own scripts in Python Programming for your requirements.