Build a Database driven Application with Python and MySQL

Build a Database driven Application with Python and MySQL, available at $44.99, has an average rating of 4.5, with 24 lectures, based on 56 reviews, and has 4949 subscribers.

You will learn about Installing Python Installing MySQL Database Server Creating a new database Creating a new table Create graphical user interface for the application Create and activate a virtual environment Install MySQL Database Connector Creating a database configuration file Connecting and interacting with MySQL Database from Python Create a class with methods Create stand alone functions Connect widgets to functions Interact with ListBox Perform CRUD Operations This course is ideal for individuals who are Beginners to building database driven applications. It is particularly useful for Beginners to building database driven applications.

Enroll now: Build a Database driven Application with Python and MySQL

Summary

Title: Build a Database driven Application with Python and MySQL

Price: $44.99

Average Rating: 4.5

Number of Lectures: 24

Number of Published Lectures: 24

Number of Curriculum Items: 24

Number of Published Curriculum Objects: 24

Original Price: $59.99

Quality Status: approved

Status: Live

What You Will Learn

Installing Python

Installing MySQL Database Server

Creating a new database

Creating a new table

Create graphical user interface for the application

Create and activate a virtual environment

Install MySQL Database Connector

Creating a database configuration file

Connecting and interacting with MySQL Database from Python

Create a class with methods

Create stand alone functions

Connect widgets to functions

Interact with ListBox

Perform CRUD Operations

Who Should Attend

Beginners to building database driven applications.

Target Audiences

Beginners to building database driven applications.

In this course you  learn how to interface a Python  application program with a MySQL Server Database. Python has  various modules that you can use to  interact with databases. We will install CX_ORACLE connector module to enable us interact with MySQL Server database from our Python application.

We will be installing Python and MySQL database server  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 MySQL Server database from our Python application. We will also be creating a class with methods and also stand alone functions for our application.

When the application is complete we will be able to perform CRUD operations on the MySQL database from our Python application.

Course Curriculum

Chapter 1: Setting Up Python Environment

Lecture 1: Introduction

Lecture 2: Install Python on Windows

Lecture 3: Install Atom text editor

Lecture 4: What is CRUD

Lecture 5: What we will create

Chapter 2: Creating Application Interface

Lecture 1: Application Design Sketch

Lecture 2: Creating a project directory and Python file

Lecture 3: Creating the application GUI interface – Part 1

Lecture 4: Creating the application GUI interface – Part 2

Lecture 5: Creating the application GUI interface – Part 3

Lecture 6: Creating the application GUI interface – Part 4

Lecture 7: Creating the application GUI interface – Part 5

Chapter 3: Setting Up MySQL Database Server

Lecture 1: Installing MySQL Database Server

Lecture 2: Creating a database and a table

Lecture 3: Create and activate virtual environment

Lecture 4: Install MySQL Connector

Lecture 5: Creating a configuration connection file

Chapter 4: Interacting with MySQL Database From Python

Lecture 1: Creating a class with methods

Lecture 2: Creating Functions

Lecture 3: Activating button widgets

Lecture 4: Testing Connection to database from Python

Lecture 5: Interacting with MySQL from Python – Part 1

Lecture 6: Interacting with MySQL from Python – Part 2

Lecture 7: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 1 votes

2 stars: 0 votes

3 stars: 10 votes

4 stars: 22 votes

5 stars: 23 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!