SQLite Databases | Python Programming: (Build App and API )

Course Curriculum

Chapter 1: SQLIte Database Server Setup

Lecture 1: Introduction

Lecture 2: What is SQLite

Lecture 3: Download and install SQLite

Lecture 4: What is SQLite Studio

Lecture 5: Attaching Sample Database

Lecture 6: Connecting to SQLite Database

Lecture 7: Database Concepts

Lecture 8: SQLite3 Tool

Lecture 9: Common SQLite3 Commands

Lecture 10: SQLite Dump Command

Chapter 2: SQLite Data Manipulation

Lecture 1: SQLite SELECT Statement

Lecture 2: Querying all columns in a table

Lecture 3: Querying specific columns in a table

Lecture 4: Sorting Data

Lecture 5: Removing duplicate records

Lecture 6: Filtering Records

Lecture 7: Identifying NULL Values

Lecture 8: SQLite Data Types

Chapter 3: Creating Database Objects

Lecture 1: SQLite Constraints

Lecture 2: SQLite Create Table Statements – Part 1

Lecture 3: SQLite Create Table Statements – Part 2

Lecture 4: SQLite INSERT INTO Table Statement

Lecture 5: SQLite UPDATE Statement

Lecture 6: SQLite DELETE Statement

Chapter 4: SQLite Operators

Lecture 1: SQLite BETWEEN Operator

Lecture 2: SQLite IN Operator

Lecture 3: SQLite LIKE Operator

Lecture 4: SQLite GLOB Operator

Chapter 5: Setting Up Python Programming Environment

Lecture 1: What is Python

Lecture 2: What is Jupyter Notebook

Lecture 3: Installing Jupyter Notebook Server

Lecture 4: Running Jupyter Server

Lecture 5: Notebook Dashboard

Lecture 6: Jupyter Notebook Interface

Lecture 7: Creating a new notebook

Chapter 6: Python Programming Fundamentals

Lecture 1: Expressions

Lecture 2: Statements

Lecture 3: Comments

Lecture 4: Data Types

Lecture 5: Casting Data Types

Lecture 6: Variables

Lecture 7: Python List

Lecture 8: Python Dictionary

Lecture 9: Python Operators

Lecture 10: Python Conditional Statements

Lecture 11: Python Loops

Lecture 12: Python Functions

Chapter 7: Build a Database App with SQLite and Python – The Setup

Lecture 1: Installing Python on Windows

Lecture 2: Installing Python on Macs

Lecture 3: Installing Python on Linux

Lecture 4: installing Text Editor

Lecture 5: Installing DB Browser for SQlite

Lecture 6: Create a database and table

Chapter 8: Building The Application Interface

Lecture 1: What we will create

Lecture 2: Application design sketch

Lecture 3: What is Tkinter

Lecture 4: Creating a logo image

Lecture 5: Creating a project directory

Lecture 6: Importing tkinterModule

Lecture 7: Creating a Python Class

Lecture 8: Adding Widgets : Part 1

Lecture 9: Adding Widgets : Part 2

Lecture 10: Adding Widgets : Part 3

Lecture 11: Adding Widgets : Part 4

Chapter 9: Connecting App to Database

Lecture 1: Setup database connectivity from Python

Lecture 2: Creating Functions : Part 1

Lecture 3: Creating Functions : Part 2

Lecture 4: Creating Functions : Part 3

Lecture 5: Setting a size for the application window

Lecture 6: Project Code

Chapter 10: Build an API with Python + Django + SQLite

Lecture 1: What is an API

Lecture 2: What is Django

Lecture 3: Create a virtual environment

Lecture 4: Install Django

Lecture 5: Install REST Framework

Lecture 6: Create Django Project

Lecture 7: Create Django App

Lecture 8: Register Applications

Lecture 9: Install Corsheaders

Lecture 10: SQLite Database Setup

Lecture 11: Applying Django Migrations

Lecture 12: Create a model

Lecture 13: Create and apply new migration

Lecture 14: Create a serializer class

Lecture 15: Start and stop development server

Lecture 16: Create a superuser account

Lecture 17: Create views: Part 1

Lecture 18: Create views: Part 2

Lecture 19: Map views to URLS

Lecture 20: Register Model