Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Python Interfacing with MySql

via Udemy

Overview

Python databses programming using MySQL

What you'll learn:
  • How to install MySQL
  • How to create database
  • Python Interfacing with MySql

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


Taught by

Mayur Sonar

Reviews

4.5 rating at Udemy based on 38 ratings

Start your review of Python Interfacing with MySql

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.