Python Interfacing with MySql

Python databses programming using MySQL
Rating: 3.7 out of 5 (14 ratings)
4,582 students
English
English [Auto]
How to install MySQL
How to create database
Python Interfacing with MySql

Requirements

  • Python Data Types, Control Structures, Loops, etc.
  • SQL Basics.

Description

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


Who this course is for:

  • Beginner Python Developers

Course content

11 sections15 lectures1h 16m total length
  • Introduction
    02:17

Instructor

Instructor
Mayur Sonar
  • 4.1 Instructor Rating
  • 21 Reviews
  • 4,866 Students
  • 2 Courses

I have nine years of experience in education, teaching computer technology class in India. During that time he also trained many instructional staff members in her district on how to use and integrate technology in the classroom. Mayur graduated from the University of Pune with a degree in Master in computer application.

My teaching philosophy is very simple students do not care how much you know, until they know how much you care. I show my caring by forming relationships with my students and trying to help them find their dreams and strengths so they can believe in themselves the way I believe in them. Either way they are the future and have unlimited value.