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

4.50 (169 reviews)
Udemy
platform
English
language
Databases
category
3,741
students
6 hours
content
Jun 2021
last update
$74.99
regular price

What you will 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

Description

In this course you will   learn how to create a Python  application program  that will interact with the following database systems:

  • SQL Server database

  • PostgreSQL

  • MySQL

  • Oracle

  • SQLite

Python 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.

Content

Creating the application user interface

Introduction
What is CRUD
What we will create
Application Design Sketch
Install Python on Windows
Install Python3 on Mac
Install Atom Text Editor
Create project directory and Python File
Creating the GUI : Part 1
Creating the GUI : Part 2
Creating the GUI : Part 3
Creating the GUI : Part 4
Creating the GUI : Part 5
Add comments to your code

Setting Up Microsoft SQL Server Database

Installing SQL Server 2017 Express
The Source Code
Create a new database and table
Create a database configuration file
Create a virtual environment and install pypyodbc
Connect Python File to database
Create a cursor object
Create a class and methods
Add more methods
Create a function for selected rows
Create more functions
Activate button widgets
Interacting with database from Python Application GUI - Part 1
Interacting with database from Python Application GUI - Part 2

Setting Up MySQL Database Server

Installing MySQL
MySQL Workbench
Create a database and a table
Create a configuration connection file
Install Mysql -Connector in a virtual environment
Modfify Python Application File to connect to Mysql Database
Test connection to MySQL Database from Python App GUI
Interacting with MySQL database from Python Application GUI - Part 1
Interacting with MySQL database from Python Application GUI - Part 2
The Source Code

Setting Up PostgreSQL Database Server

Installing PostgreSQL
Create a database and a table
Create a sequence for the id column
Create a configuration connection file
Install Pyscopg2 inside a virtual environment
Modfify Python Application File to connect to PostgreSQL Database
Test connection to PostgreSQL Database from Python App GUI
Interacting with PostgreSQL database from Python Application GUI - Part 1
Interacting with PostgreSQL database from Python Application GUI - Part 2
The Source Code

Setting Up Oracle Database Server

Download and Install Oracle Database 18c Express Edition
What is SQLPLUS
Unlock sample HR Schema Account
Install Oracle SQL Developer
Create a new database table
Connect Oracle developer to Oracle database
Installing Oracle database driver in a virtual environment
Modfify Python Application File to connect to Oracle Database
Interacting with Oracle database from Python Application GUI
The Source Code

Setting Up SQLite3 Database

Installing SQLite
Modfify Python Application File to connect to SQLite3 Database
Test connection to SQLite3 Database from Python App GUI
Interacting with SQLite3 database from Python Application GUI
SQLiteStudio
DB Browser for SQLite
Viewing SQlite3 Database Records
The Source Code

Screenshots

Create a Python Application to connect to multiple databases - Screenshot_01Create a Python Application to connect to multiple databases - Screenshot_02Create a Python Application to connect to multiple databases - Screenshot_03Create a Python Application to connect to multiple databases - Screenshot_04

Reviews

Nurlybek
July 11, 2023
I found the course to be highly engaging and informative. The instructor's clear and deliberate speaking style ensured that everyone could easily follow along. The content was incredibly useful, and I feel confident in my ability to create my own app for our business purposes. Thank you for providing such a valuable learning experience!
Joe
March 17, 2023
speakers cadence is flat and his voice is monotone. he needs to vary the way he is speaking to be less like he was reading off of a script.
Kannan
November 22, 2022
Nice course, I can clearly understand how the python code interacts with multiple databases. Need some update in SQL servers installation process.
Noam
September 18, 2022
Fantastic! Although I am an intermediate python coder, the lectures were complex enough to generate my interest and teach me new skills but also at the right pace so that I could easily catch on and learn fast
Toren
July 22, 2021
The content of the course is spot on for my learning initiative. I can appreciate that it covers the main development applications currently being used and gives a clear understanding on how to interact with the applications.
SADIQ
April 15, 2021
As a database person, looking for python knowledge to implement in on going project,This course was the right choice as it fulfilled my requirement in simple and short duration with 5 different variety of databases, Thank you so much
Vladyslav
June 4, 2020
The course gives practical skills to create simple GUI application and practical basic knowledge of 5 different sql databases and how connect them to python application. It was very useful for me.

Charts

Price

Create a Python Application to connect to multiple databases - Price chart

Rating

Create a Python Application to connect to multiple databases - Ratings chart

Enrollment distribution

Create a Python Application to connect to multiple databases - Distribution chart

Related Topics

2581436
udemy ID
9/28/2019
course created date
10/30/2019
course indexed date
Bot
course submited by