Free Database Programming Tutorial – MySQL Database Connectivity using Python
Learn how to connect MySQL database with Python in this course. You will gain knowledge of Python statements required for connectivity and create simple applications. Prerequisites include MySQL and Python basics. Tools used are XAMPP server and Anaconda Navigator with Jupyter Notebook. Topics covered include relational databases, MySQL connector module, connect method, cursor object, and executing SQL queries in Python. Suitable for beginner Python and database application developers.
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
Who this course is for:
- Beginner for Python developer and Database Application developer
- Beginner for Python application developer
User Reviews
Be the first to review “Free Database Programming Tutorial – MySQL Database Connectivity using Python”
You must be logged in to post a review.
There are no reviews yet.