MySQL Database Connectivity using Python

MySQL Database Connectivity using Python

4.05 (62 reviews)
Udemy
platform
English
language
IT Certification
category
6,396
students
1.5 hours
content
May 2021
last update
FREE
regular price

What you will learn

Know python statements required to connect with MySQL database for an application

Description

MySQL Database Connectivity using Python course is designed for developer who are working on Database Projects where the concept of front end and back end is used many times for developing an application.

Outcomes of the course are

Participants will be able to

●Know python statements required to connect with MySQL database

●Create simple application of python - database connectivity

Prerequisite : MySQL basics, Python basics

In this course Concept explanation video will be followed by hands on session /demonstration of all the concept of MySQL Database Connectivity using Python

.Tools used for this course are XAMPP server having MySQL database creation facility and Anaconda Navigator with Jupyeter Notebook for python code demonstration. Both tools/softwares are Free and Open source and Popular also

Contents are

In First and Second Section we cover for prerequisite, that is demonstration of MySQL with its tool and Python basics with Jupyeter Notebook and other tools which are available

●What is Relational database?

In this session participants will get information about Relational database and SQL queries

●MySQL connector module

In this session participants will get information about MySQL connector module required for connectivity

●connect method and cursor object

In this session participants will get information about connect method of MySQL connector module and cursor object for execution queries

●Code in Python to

a)Create Database

a)Create table

b)Insert Values

c)Display values

d)Alter table

e)Update/Delete rows

These sections are for explaining and demonstrating all SQL queries which can be executed in Python code. That is concept of front end and back end.

●Create simple application of python - database connectivity


Content

Introduction of Course MySQL Database Connectivity using Python

Introduction to MySQL Database Connectivity

What is relational database and MySQL demo using command prompt

What is relational database and MySQL commands
Demonstration of MySQL using Command prompt

Python IDEs and Jupyter notebook demo

Python IDEs
Demonstration of Jupyter Notebook

Connector Module and methods in Python

Connect Module in Python
Demonstration of connection testing

Create Database and Create Table

Create Database and table using Python code
Demonstration of creating database and table using python code

Insert values in database and display values from database

Insert values in database and display values from database
Demonstration of insert values in the table and display values of table

Alter and Update table

Alter, Update and delete
Demonstration of alter update and delete

Simple Menu driven Simple application

Simple Menu driven application in Python

Screenshots

MySQL Database Connectivity using Python - Screenshot_01MySQL Database Connectivity using Python - Screenshot_02MySQL Database Connectivity using Python - Screenshot_03MySQL Database Connectivity using Python - Screenshot_04

Reviews

Fulvio
May 18, 2023
Basic course with foundamentals. Audio is poor and subtitles seem automatically generated, so, the most difficult part is to follow the audio/text
Brian
January 22, 2023
Could not get past the mysql -u root command fairly early in the course, so came to an abrupt halt...
Hitesh
September 20, 2022
It's a great experience to learn this course. It is an amazing course Easy to understand and simple to learn
Dante
May 16, 2021
I like so much this course, it was usefull for my projects, I would like to include image manangement system as well.

Charts

Price

MySQL Database Connectivity using Python - Price chart

Rating

MySQL Database Connectivity using Python - Ratings chart

Enrollment distribution

MySQL Database Connectivity using Python - Distribution chart

Related Topics

3990818
udemy ID
4/18/2021
course created date
5/9/2021
course indexed date
Bot
course submited by