- Introduction
What you'll learn
- How to install MySQL
- How to create database
- Python Interfacing with MySql
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
Other Courses
Virtual Machine full localhost LAMP stack setup in minutes
Guide to creating a virtual machine in under 5 minutes, WordPress localhost setup in minutes
Spreadsheets for Business PART 1
Learn how and why spreadsheets can be an amazing tool for your business!
10 Steps to Stop Living Someone Else's Dream:
Make your own dreams a reality by developing the same mindset as the most successful people in history, starting today.
Visualization 101: Recorded Live Tele-series Class
Listen in on a pre-recorded visualization class. Learn what visualization is and how to use it.
Introduction to Logic (Geometry Unit 2)
the first unit for High School Geometry (for students)
How and Where to Find Good Shopping Deals Online
Shop better, shop smarter, and save money. This course focuses on sites, tools, and techniques to a more frugal life!
About the instructors
- 3.98 Calificación
- 8205 Estudiantes
- 2 Cursos
Mayur Sonar
Instructor
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.
Student feedback
Course Rating
Reviews
It is boost my intellect the more
Muy buen curso, para fundamental el uso de Python y MYSQL.
good
nice