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:
Sample Database Creation
Create a Table
Inserting Data into a table
Selecting Data from a table
Selecting Data Using Where Clause
Order By Clause
Update Data in a table
Module in-built Functions
Importing data from CSV file
Exporting data into CSV file
Exception handling with example
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.