MySQL Database Connectivity using Python

MySQL Database Connectivity using Python, available at Free, has an average rating of 3.7, with 14 lectures, based on 66 reviews, and has 6567 subscribers.

You will learn about Know python statements required to connect with MySQL database for an application This course is ideal for individuals who are Beginner for Python developer and Database Application developer or Beginner for Python application developer It is particularly useful for Beginner for Python developer and Database Application developer or Beginner for Python application developer.

Enroll now: MySQL Database Connectivity using Python

Summary

Title: MySQL Database Connectivity using Python

Price: Free

Average Rating: 3.7

Number of Lectures: 14

Number of Published Lectures: 14

Number of Curriculum Items: 14

Number of Published Curriculum Objects: 14

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

Beginner for Python developer and Database Application developer

Beginner for Python application developer

Target Audiences

Beginner for Python developer and Database Application developer

Beginner for Python application developer

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

Course Curriculum

Chapter 1: Introduction of Course MySQL Database Connectivity using Python

Lecture 1: Introduction to MySQL Database Connectivity

Chapter 2: What is relational database and MySQL demo using command prompt

Lecture 1: What is relational database and MySQL commands

Lecture 2: Demonstration of MySQL using Command prompt

Chapter 3: Python IDEs and Jupyter notebook demo

Lecture 1: Python IDEs

Lecture 2: Demonstration of Jupyter Notebook

Chapter 4: Connector Module and methods in Python

Lecture 1: Connect Module in Python

Lecture 2: Demonstration of connection testing

Chapter 5: Create Database and Create Table

Lecture 1: Create Database and table using Python code

Lecture 2: Demonstration of creating database and table using python code

Chapter 6: Insert values in database and display values from database

Lecture 1: Insert values in database and display values from database

Lecture 2: Demonstration of insert values in the table and display values of table

Chapter 7: Alter and Update table

Lecture 1: Alter, Update and delete

Lecture 2: Demonstration of alter update and delete

Chapter 8: Simple Menu driven Simple application

Lecture 1: Simple Menu driven application in Python

Instructors

Seema Gondhalekar
Instructor for Udemy online courses for IT

Rating Distribution

1 stars: 6 votes

2 stars: 1 votes

3 stars: 11 votes

4 stars: 21 votes

5 stars: 27 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!