Create A Python Application To Connect To Multiple Databases

Create a Python App and Connect to and interact with Databases : PostgreSQL | MySQL |SQL Server | Oracle|SQLite

What you'll learn
Install and setup multiple database systems
Create virtual environments
Install database connector drivers for multiple database systems
Create Python Application GUI Frontend
Create database and table in multiple database systems
Create a class and methods in Python File
Import and use Python Modules
Create database connection configuration file
Interact with databases from Python Application GUI
Perform various database operations from Python App GUI
Requirements
Basic Knowledge of SQL
Basic knowledge of Python
Description
In this course you will   learn how to create a Python  application program  that will interact with the following database systems: SQL Server databasePostgreSQLMySQLOracleSQLitePython has  various modules that you can use to  interact with databases. We will install the various database connector module for each database system to enable us interact with the various  database systems from our Python application.We will setup the various database management systems and also create a new database and table that our Python application will interact with.We will create the Python application frontend using Tkinter which is a built in Python module used to create graphical user interfaces . From tkinter module we will import ttk module which is a themed widget library that contains various types of widgets like buttons,labels etc that we can use to build the graphical user interface for our Python application. We will also import other bits and pieces from the tkinter module that our Python application will use.Also we will create a database configuration file that twill be used to interact with the various database systems that we will  connect to from our Python application. We will perform various database operations on the databases we will create from out Python application GUI frontend.

Overview

Section 1: Creating the application user interface

Lecture 1 Introduction

Lecture 2 What is CRUD

Lecture 3 What we will create

Lecture 4 Application Design Sketch

Lecture 5 Install Python on Windows

Lecture 6 Install Python3 on Mac

Lecture 7 Install Atom Text Editor

Lecture 8 Create project directory and Python File

Lecture 9 Creating the GUI : Part 1

Lecture 10 Creating the GUI : Part 2

Lecture 11 Creating the GUI : Part 3

Lecture 12 Creating the GUI : Part 4

Lecture 13 Creating the GUI : Part 5

Lecture 14 Add comments to your code

Section 2: Setting Up Microsoft SQL Server Database

Lecture 15 Installing SQL Server 2017 Express

Lecture 16 The Source Code

Lecture 17 Create a new database and table

Lecture 18 Create a database configuration file

Lecture 19 Create a virtual environment and install pypyodbc

Lecture 20 Connect Python File to database

Lecture 21 Create a cursor object

Lecture 22 Create a class and methods

Lecture 23 Add more methods

Lecture 24 Create a function for selected rows

Lecture 25 Create more functions

Lecture 26 Activate button widgets

Lecture 27 Interacting with database from Python Application GUI - Part 1

Lecture 28 Interacting with database from Python Application GUI - Part 2

Section 3: Setting Up MySQL Database Server

Lecture 29 Installing MySQL

Lecture 30 MySQL Workbench

Lecture 31 Create a database and a table

Lecture 32 Create a configuration connection file

Lecture 33 Install Mysql -Connector in a virtual environment

Lecture 34 Modfify Python Application File to connect to Mysql Database

Lecture 35 Test connection to MySQL Database from Python App GUI

Lecture 36 Interacting with MySQL database from Python Application GUI - Part 1

Lecture 37 Interacting with MySQL database from Python Application GUI - Part 2

Lecture 38 The Source Code

Section 4: Setting Up PostgreSQL Database Server

Lecture 39 Installing PostgreSQL

Lecture 40 Create a database and a table

Lecture 41 Create a sequence for the id column

Lecture 42 Create a configuration connection file

Lecture 43 Install Pyscopg2 inside a virtual environment

Lecture 44 Modfify Python Application File to connect to PostgreSQL Database

Lecture 45 Test connection to PostgreSQL Database from Python App GUI

Lecture 46 Interacting with PostgreSQL database from Python Application GUI - Part 1

Lecture 47 Interacting with PostgreSQL database from Python Application GUI - Part 2

Lecture 48 The Source Code

Section 5: Setting Up Oracle Database Server

Lecture 49 Download and Install Oracle Database 18c Express Edition

Lecture 50 What is SQLPLUS

Lecture 51 Unlock sample HR Schema Account

Lecture 52 Install Oracle SQL Developer

Lecture 53 Create a new database table

Lecture 54 Connect Oracle developer to Oracle database

Lecture 55 Installing Oracle database driver in a virtual environment

Lecture 56 Modfify Python Application File to connect to Oracle Database

Lecture 57 Interacting with Oracle database from Python Application GUI

Lecture 58 The Source Code

Section 6: Setting Up SQLite3 Database

Lecture 59 Installing SQLite

Lecture 60 Modfify Python Application File to connect to SQLite3 Database

Lecture 61 Test connection to SQLite3 Database from Python App GUI

Lecture 62 Interacting with SQLite3 database from Python Application GUI

Lecture 63 SQLiteStudio

Lecture 64 DB Browser for SQLite

Lecture 65 Viewing SQlite3 Database Records

Lecture 66 The Source Code

Lecture 67 Thank You

Beginners to Python,Beginners to Programming