Python Interfacing with MySql

Python databses programming using 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 sections • 15 lectures • 1h 16m total length