Category
Course Content
video recordings
0/17
Recording – Course Introduction | Indentation | Variables
02:08:15
Recording – Python DataTypes | Numbers | Booleans
46:22
Recording – String Processing part 1 | Get inputs from users
01:32:43
Recording – Type Casting | String Processing | Assignment Operators
58:12
Recording – Collections in Python
00:00
Recording – Python Sets and Dictionaries
02:36:26
Recording – Program-flow in Python programming
00:00
Recording – Python Functions
00:00
Recording – Python Modules
00:00
Recording – Object Oriented Programming in Python
00:00
Recording – Exception Handling in Python
00:00
Recording – Python Pandas
02:43:33
Recording – File Handling in Python
00:00
Data Visualisation
00:00
Unit Testing, Email Sending and Database management
00:00
Consume APIs using Python
02:01:32
Regular Expression – Regex
02:48:14
Introduction to Python Programming Language
0/2
Introduction to Python Programming Language
00:00
Getting Started with Python
00:00
Python Indentation, Comments and Variables
0/2
Python Indentation and Comments
00:00
Python Variables
00:00
Python Data Types
0/5
Python Data Types
00:00
Numerics (mathematical relevance)
00:00
Booleans (checking for truth)
00:00
String (sequences of characters)
00:00
Type Casting
00:00
Inputs , operators
0/2
Inputs from users
00:00
Python Operators
00:00
Collections in Python
0/7
Introduction to Python Collections
00:00
Python Lists
00:00
Python Tuples
00:00
Python Sets
00:00
Dictionaries
00:00
The `collections` module in Python
00:00
Exercises
00:00
Program Flow
0/5
Introduction to program flow
00:00
if … else
00:00
for loop
00:00
`while` loop
00:00
`break`, `continue`, and `exit`
00:00
Python Functions
0/2
Python Functions
00:00
In-built Functions in Python Programming
00:00
Python Modules
0/4
Modules vs. Functions in Python programming
00:00
Python Modules
00:00
Python Datetime (as an example of a Python module)
00:00
User-defined modules
00:00
Object Oriented Programming in Python
0/1
Object Oriented Programming in Python
00:00
File Handling in Python
0/1
File Handling in Python Programming
00:00
Exception Handling in Python
0/1
Exception Handling in Python
00:00
Python Pandas
0/9
Intro to Python Pandas
00:00
Data input in Pandas
00:00
Series in Pandas
00:00
Dataframe
00:00
Data manipulations using pandas
00:00
Data cleaning
00:00
Data Analysis
00:00
Data Output using Pandas
00:00
Data Visualisation
00:00
Data Visualisation using Python
0/8
Data Visualisation Introduction
00:00
Matplotlib Library for data visualisation
00:00
Line Graph
00:00
Scatter plots
00:00
Subplot
00:00
Bar Graph
00:00
Histograms
00:00
Pie Charts
00:00
Sending emails with Python
0/1
Email sending template
00:00
Unit test in python programming
0/1
unit test in python programming
00:00
Using Databse with Python programming
0/16
Database with Python
00:00
Python SQLite – introduction
00:00
Python SQLite – Connecting to Database
00:00
SQLite Datatypes and its Corresponding Python Types
00:00
Python SQLite – Cursor Object
00:00
Python SQLite – Create Table
00:00
Python SQLite – Insert Data
00:00
Python SQLite – Select Data from Table
00:00
Python SQLite – WHERE Clause
00:00
Python SQLite – ORDER BY Clause
00:00
Python SQLite – LIMIT Clause
00:00
Python SQLite – Update Data
00:00
Python SQLite – Update Specific Column
00:00
Python SQLite – JOIN Clause
00:00
Python SQLite – DROP Table
00:00
Python SQLite – Deleting Data in Table
00:00
Regular Expressions using Python
0/6
Regular expressions
00:00
Metacharacters in regular expressions
00:00
Regex – special Sequences
00:00
Regex – sets
00:00
The `finditer()` function
00:00
Regex – split function
00:00
Consuming APIs in Python
0/4
Introduction to APIs
00:00
Getting Started
00:00
Authenticating to Access Python APIs
00:00
Consuming Google Books API with Python: Practical Examples
00:00
Python Technical Interview Assignments – with solutions
Sharpen your Python skills with these programming challenges. Go through the solutions and then try to attempt them on your own.
0/24
Capital indexes
00:00
Middle letter
00:00
Online status
00:00
Randomness
00:00
Type check
00:00
Double letters
00:00
Adding and removing dots
00:00
Counting syllables
00:00
Anagrams
00:00
Flatten a list
00:00
Min-maxing
00:00
Divisible by 3
00:00
Tic tac toe input
00:00
Palindrome
00:00
Up and down
00:00
Consecutive zeros
00:00
All equal
00:00
Boolean and
00:00
Writing short code
00:00
Custom zip
00:00
Solution validation
00:00
List xor
00:00
Counting parameters
00:00
Thousands separator
00:00
Python programming (zero to advance!!!)
About Lesson

Python SQLite

Python SQLite3 module is used to integrate the SQLite database with Python. It provides a standardized Python DBI API 2.0 and offers a straightforward and simple-to-use interface for interacting with SQLite databases. SQLite is a lightweight, serverless, self-contained, and transactional SQL database engine. The Python SQLite3 module comes bundled with Python starting from version 2.5x, so there’s no need to install it separately.

Introduction

1. Introduction to SQLite in Python: SQLite is a C library that provides a lightweight disk-based database. It doesn’t require a separate server process and allows access to the database using a nonstandard variant of the SQL query language. In Python, SQLite is commonly used for lightweight database applications or for prototyping.

2. Python SQLite – Connecting to Database: To connect to an SQLite database from Python, you need to use the `sqlite3` module, which provides a simple way to establish a connection to the database file. You can specify the database file path when creating the connection object.

3. SQLite Datatypes and its Corresponding Python Types: SQLite has a dynamic type system, which means you can store any value in any column, regardless of the declared datatype. However, SQLite uses the following datatypes to specify the storage class for each value: NULL, INTEGER, REAL, TEXT, and BLOB. Python’s corresponding types for these datatypes are `None`, `int`, `float`, `str`, and `bytes`, respectively.

Python SQLite Queries

1. Python SQLite – Cursor Object: The cursor object in Python SQLite is used to execute SQL queries against the database. It allows you to perform database operations such as executing SQL statements, fetching data from the result sets, and managing transactions.

2. Python SQLite – Create Table: To create a new table in an SQLite database using Python, you need to execute a CREATE TABLE statement using the cursor object. You can specify the table name, column names, and data types for each column in the CREATE TABLE statement.

3. Python SQLite – Insert Data: After creating a table, you can insert data into it using the INSERT INTO statement. You need to specify the table name and column values for each row that you want to insert into the table.

4. Python SQLite – Select Data from Table: To retrieve data from a table in an SQLite database, you can use the SELECT statement. You can specify the columns you want to retrieve and apply conditions using the WHERE clause to filter the rows.

5. Python SQLite – WHERE Clause: The WHERE clause in the SELECT statement allows you to filter rows based on specified conditions. You can use comparison operators such as =, <, >, <=, >=, !=, and logical operators such as AND, OR, and NOT in the WHERE clause.

6. Python SQLite – ORDER BY Clause: The ORDER BY clause in the SELECT statement allows you to sort the result set based on one or more columns. You can specify the column name and the sort order (ASC for ascending or DESC for descending) in the ORDER BY clause.

7. Python SQLite – LIMIT Clause: The LIMIT clause in the SELECT statement allows you to limit the number of rows returned by the query. You can specify the maximum number of rows to return after the LIMIT keyword.

8. Python SQLite – JOIN Clause: The JOIN clause in the SELECT statement allows you to combine rows from two or more tables based on a related column between them. You can specify the type of join (INNER, LEFT OUTER, RIGHT OUTER, or FULL OUTER) and the join condition in the JOIN clause.

9. Python SQLite – Deleting Data in Table: To delete data from a table in an SQLite database, you can use the DELETE statement. You need to specify the table name and apply conditions using the WHERE clause to filter the rows to be deleted.

10. Python SQLite – DROP Table: To drop (delete) an existing table from an SQLite database, you can use the DROP TABLE statement. You need to specify the table name after the DROP TABLE keywords.

11. Python SQLite – Update Data: To update existing data in a table in an SQLite database, you can use the UPDATE statement. You need to specify the table name, column names, and new values for the columns to be updated, as well as apply conditions using the WHERE clause to filter the rows to be updated.

12. Python SQLite – Update Specific Column: You can update specific columns in a table by specifying the column names and new values in the UPDATE statement. This allows you to modify only the desired columns without affecting other columns in the table.

These are the basic operations you can perform with Python SQLite to interact with SQLite databases and manipulate data. It’s essential to understand these concepts to effectively work with SQLite databases in Python applications.

Join the conversation
Previous
Next