Fundamentals of MySQL And Using SQL with Python

In this two part course you will learn the fundamentals of MySQL and how to use SQL and Python together. You’ll understand how these two languages work together

We’ll start off exploring database fundamentals, as well as MySQL features. Students will learn the basics of MySQL that guide you through creating and maintaining a MySQL database of your own. We’ll explores the basic syntax, using SQL statements to insert, update, and delete data from your tables.

We’ll also cover creating a new database from scratch, as well as working with data types, operators, and string and mathematical functions. In addition, you will learn about the key differences between standard SQL and SQL as implemented by MySQL.

In part two of the course, Using SQL with Python, you’ll learn about connecting to a database, performing simple queries, and reading rows from a table. We’ll cover how to use prepared statements and cursors, how to build a wrapper class to streamline the SQL interface and support multiple different database engines, and how to build a CRUD class and a full–featured web application using what you’ve learned.

By the end of this course you’ll have a good understand of the fundamentals of MySQL and how to use SQL and Python together.