Create A Python Application To Connect To Multiple Databases

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

Homepage

https://www.udemy.com/course/create-a-python-application-to-connect-to-multiple-databases/