Advanced Python: Working With Multiple Databases

Build and connect Python Application to multiple databases

What you'll learn

Establishing database connections in Python.

Performing CRUD operations (Create, Read, Update, Delete) on database records.

Executing SQL queries using Python's database APIs.

Working with different database management systems such as MySQL, PostgreSQL, SQLite, SQL Server

Building a Python Application

Connecting Python Application to multiple databases

Creating databases and tables

Requirements

Basic knowledge of Python advised

Basic knowledge of database concepts advised

Basic knowledge of SQL advised

Description

In today's data-driven world, businesses rely on multiple relational databases to store and manage their valuable information. Python, being a powerful and versatile programming language, offers a wide range of tools and libraries that enable seamless integration and interaction with these databases. In this advanced Python course, you will explore the intricacies of working with multiple relational databases and learn how to harness Python's capabilities to manipulate, query, and manage data effectively across different database systems.When creating Python programs, you'll likely want to populate data in an application automatically, or save data between user sessions. Databases help you to do this. They provide an organized structure so you can easily access, store, and manage large amounts of data. In this course, we'll look at how to use databases in Python 3, we'll create databases in SQLite, MySQL, SQL Server, Postgres. Then we'll experiment with those databases using special Python modules that implement the Python database API.By the end of this course, you will have gained the expertise to confidently work with multiple relational databases using Python, enabling you to seamlessly integrate, manage, and manipulate data across different database systems. Whether you are a data engineer, database administrator, or Python developer, this advanced course will equip you with the skills and knowledge to tackle complex database challenges and drive impactful solutions in your organization. Join us on this exciting journey to master the art of advanced Python - working with multiple relational databases.

Overview

Section 1: Introduction and Python Setup

Lecture 1 Introduction

Lecture 2 What is a database

Lecture 3 Python Database API

Lecture 4 Install Python on Windows

Lecture 5 Install Python on Macs

Lecture 6 Note on text editors

Lecture 7 Installing Visual Studio Code

Lecture 8 Create project directory and Python file

Section 2: Build an application with Python

Lecture 9 What we will create

Lecture 10 The application design sketch

Lecture 11 Creating the application GUI - Part 1

Lecture 12 Creating the application GUI - Part 2

Lecture 13 Creating the application GUI - Part 3

Lecture 14 Creating the application GUI - Part 4

Lecture 15 Creating the application GUI - Part 5

Section 3: Python and Microsoft SQL Server Database Interaction

Lecture 16 Download SQL Server

Lecture 17 Install SQL Server

Lecture 18 Install SQL Server Management Studio - SSMS

Lecture 19 Connect SSMS to SQL Server

Lecture 20 Create a new database and table

Lecture 21 Create a database configuration file

Lecture 22 Install Python SQL Server Connector

Lecture 23 Connect Python file to SQL Server Database

Lecture 24 Create a cursor object

Lecture 25 Create a class and methods

Lecture 26 Add more methods

Lecture 27 Create a function for selected rows

Lecture 28 Create more functions

Lecture 29 Activate button widgets

Lecture 30 Python and SQL Server Database Interaction: Part 1

Lecture 31 Python and SQL Server Database Interaction: Part 2

Section 4: Python and MySQL Database Interaction

Lecture 32 Installing MySQL

Lecture 33 Install MySQL on Mac

Lecture 34 MySQL Workbench

Lecture 35 Create a database and table

Lecture 36 Create a database configuration file

Lecture 37 Install Python MySQL Connector

Lecture 38 Python MySQL Connection Configuration

Lecture 39 Testing Python and MySQL Database Connection

Lecture 40 Python and MySQL Database Interaction: Part 1

Lecture 41 Python and MySQL Database Interaction: Part 2

Section 5: Python and PostgreSQL Database Interaction

Lecture 42 Install PostgreSQL

Lecture 43 Connect to PostgreSQL with PgAdmin

Lecture 44 Create a database and table

Lecture 45 Create a sequence

Lecture 46 Database configuration file

Lecture 47 Install Python PostgreSQL Database Connector

Lecture 48 Modify app to connect to PostgreSQL

Lecture 49 Testing the connection to PostgreSQL

Lecture 50 Python and PostgreSQL Database Interaction - Part 1

Lecture 51 Python and PostgreSQL Database Interaction - Part 2

Section 6: Python and SQLite Database Interaction

Lecture 52 Installing SQLite

Lecture 53 Modify Python App to connect to SQLite

Lecture 54 Test connection to SQLite Database

Lecture 55 Python and SQLite Interaction

Lecture 56 SQLite Studio

Lecture 57 DB Browser for SQLite

Lecture 58 Viewing database records

Beginner Python Developers,Beginner Data Analyst