In this video course, you saw how to use MySQL Connector/Python to integrate a MySQL database with your Python application. You also saw some unique features of a MySQL database that differentiate it from other SQL databases.
Along the way, you learned some programming best practices that are worth considering when it comes to establishing a connection, creating tables, and inserting and updating records in a database application. You also developed a sample MySQL database for an online movie rating system and interacted with it directly from your Python application.
In this video course, you learned how to:
- Connect your Python app with a MySQL database
- Bring data from a MySQL database into Python for further analysis
- Execute SQL queries from your Python application
- Handle exceptions while accessing the database
- Prevent SQL injection attacks on your application
Phil M on Oct. 13, 2025
I took me several months to complete, but I learned about installing MySQL and MySQL WorkBench. This required a bit of extra studying and even some assistance from AI, which was another experience. I was able to learn and figure out how to script all the lessons as python scripts which achived matching results as the lesson’s videos. This expanded my Python and SQL knowledge in several different areas. I needed to reach out to these other resources to get the answers to move forward. I love Real Python but working through another tutorial to try and get an answer for just one question on how to make things work as I was trying to learn it – just was not the answer. There were several times I tried this approach with Real Python and each time I became more and more bogged down with additional learning that did not ever answer my question. Now I was left with a completing tutorial, or a partically completed or bookmarked tutorial and still no answers. Just as one tutorial in Real Python does not necessarily give me the answers to a problem in another tutorial, so it is also true that my mind has a hard time figuring out what it does not know. This describes the vortex of the downward spin to learning nothing. That is why slow learners like myself need to have multiple tools available to address these types of programming problems. If it wasn’t for computers and word processors (todays editors with linters) I would not even be try to program or even adding my comments to the decession. All-in-all, I am very grateful for the journey and very appreciative of all the hard work that I had to put in to complete this tutorial (MySQL Databases and Python) and thank you, too, Nataliya Portman for all your hard work! -Phil