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.