Python Interfacing with MySql

Python Interfacing with MySql, available at Free, has an average rating of 4.2, with 18 lectures, based on 56 reviews, and has 7384 subscribers.

Free Enroll Now

You will learn about How to install MySQL How to create database Python Interfacing with MySql This course is ideal for individuals who are Beginner Python Developers It is particularly useful for Beginner Python Developers.

Enroll now: Python Interfacing with MySql

Summary

Title: Python Interfacing with MySql

Price: Free

Average Rating: 4.2

Number of Lectures: 18

Number of Published Lectures: 15

Number of Curriculum Items: 18

Number of Published Curriculum Objects: 15

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

How to install MySQL

How to create database

Python Interfacing with MySql

Who Should Attend

Beginner Python Developers

Target Audiences

Beginner Python Developers

MySQL is one of the most popular database management systems (DBMSs) on the market today. It ranked second only to the Oracle DBMS in this year’s DB-Engines Ranking. As most software applications need to interact with data in some form, programming languages like Python provide tools for storing and accessing these data sources.

Using the techniques discussed in this course, you’ll be able to efficiently integrate a MySQL database with a Python application. You’ll develop a small MySQL database for a movie rating system and learn how to query it directly from your Python code.

By the end of this course, you’ll be able to:

Identify unique features of MySQL

Connect your application to a MySQL database

Query the database to fetch required data

Handle exceptions that occur while accessing the database

Use best practices while building database applications

To get the most out of this course, you should have a working knowledge of Python concepts like for loops, functions, exception handling, and installing Python packages using pip. You should also have a basic understanding of relational database management systems and SQL queries like SELECT, DROP, CREATE, and JOIN.

SQL stands for Structured Query Language and is a widely used programming language for managing relational databases. You may have heard of the different flavors of SQL-based DBMSs. The most popular ones include MySQL, PostgreSQL, SQLite, and SQL Server. All of these databases are compliant with the SQL standards but with varying degrees of compliance.

Being open source since its inception in 1995, MySQL quickly became a market leader among SQL solutions. MySQL is also a part of the Oracle ecosystem. While its core functionality is completely free, there are some paid add-ons as well. Currently, MySQL is

Course Curriculum

Lecture 1: Introduction

Chapter 1: What is Database?

Lecture 1: Introduction to databases

Chapter 2: Python for Database

Lecture 1: Database programming using python

Chapter 3: SQL connectors

Lecture 1: what are SQL coonectors

Lecture 2: Demo mysql installation

Chapter 4: MySQL Connector

Lecture 1: MySQL Connector

Lecture 2: Demo

Chapter 5: Establish Connection

Lecture 1: Establish Connection with MySQL

Chapter 6: Cursor Object

Lecture 1: MySQL Cursor Object

Chapter 7: Create Table

Lecture 1: Create Table

Chapter 8: Display Records of Table

Lecture 1: Display Records of Table

Chapter 9: Update Records of table

Lecture 1: Update Records of table

Lecture 2: Demo update records

Chapter 10: Delete records of table

Lecture 1: Delete records of table

Lecture 2: Demo delete records of table

Instructors

Mayur Sonar
Instructor

Rating Distribution

1 stars: 0 votes

2 stars: 6 votes

3 stars: 10 votes

4 stars: 18 votes

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