Python & MySQL Complete Course - Hamuuntire Academy

About Course

The Python & MySQL Complete Course is a step-by-step guide designed to take you from a complete beginner to an advanced developer capable of building powerful, data-driven applications.

Whether you’re just starting with Python or looking to enhance your backend development skills, this course will help you master the integration between Python and MySQL — one of the most widely used relational database systems in the world.

You’ll begin with the basics: learning what databases are, how MySQL works, and how to install and configure everything on your system. Then, you’ll learn how to use Python to connect to MySQL databases, create and manage tables, and perform essential CRUD operations (Create, Read, Update, Delete).

By the end of this course, you'll be able to:
Understand the fundamentals of MySQL databases
Connect Python applications to MySQL using mysql-connector-python
Perform CRUD operations (Create, Read, Update, Delete) with Python
Create and manage MySQL databases and tables using Python
Use SQL queries inside Python scripts
Build a mini-project that connects Python with MySQL
Prevent SQL injection and manage exceptions
Handle relational data and JOIN operations using Python
Work with user input and store data in a MySQL database

Course Content

Introduction to Python

Lesson 1 Introduction to python

13:55
Lesson 2 Setting Up the Python Environment

09:06
Lesson 3 Running your first Python program

09:50

Python Basics

Lesson 4 Variable, Datatype, Comment

21:25
Lesson 5 Input data from keyboard

07:21
Lesson 6 Operators

20:09
Lesson 7 Decision Control If, elif, else and nested if

22:33
Lesson 8 Conditional Operator Ternary Operator

04:57
Lesson 9 Loop for and while loop

12:12
Lesson 10 Nested loop

06:34
Lesson 11 Break and Continue Statements

04:36
Lesson 12 Functions

26:23
Lesson 13 Built in Function

07:26
Lesson 14 Data Structure (Lists, Tuples, Sets, Dictionaries)

33:28
Lesson 15 Data Structure with loop

05:02
Lesson 16 Exception Handling Try, Except, Finally

08:28
Lesson 17 Class and Object

08:32
Lesson 18 Constructor

10:13

Python GUI with Tkinter

Introduction to MySQL Database

lesson 1 MySQL Introduction, Downloading and Installing MSQL

19:33
lesson 2 MySQL Create Database and table

21:30
lesson 3 MySQL Constraints, Data Type

20:25
lesson 4 MySQL Inserting Data

22:23
lesson 5 MySQL Updating Data

04:44
lesson 6 MySQL Deleting Data

03:36
lesson 7 MySQL Drop ,Delete, Truncate

08:10
Lesson 8 MySQL Select Statement

13:44
Lesson 9 MySQL View Statement

04:43
Lesson 10 MySQL Filtering Rows with WHERE

15:38
Lesson 11 MySQL Aggregate Functions

26:04
Lesson 12 MySQL Alter Statement

16:30
Lesson 13 MySQL Joins

18:03
Lesson 14 MySQL Subqueries

13:51
Lesson 15 MySQL Common Methods

30:15
Lesson 16 MySQL Store Procedure

07:32
Lesson 17 MySQL Store Procedure with Insert, Update, Delete

30:11
Lesson 18 MySQL Function

07:26
Lesson 19 MySQL Student Balance

48:06
Lesson 20 MySQL Student Statement

34:24
Lesson 21 MySQL Trigger Insert

10:00
Lesson 22 MySQL Trigger Update and Delete

12:25
Lesson 23 MySQL Backup

04:48
Lesson 24 MySQL Normalization

39:29

CRUD Operations(Insert, Update, Delete & Search) with Python & MySQL

Login page with Database

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Introduction to Python

Lesson 1 Introduction to python

Lesson 2 Setting Up the Python Environment

Lesson 3 Running your first Python program

Python Basics

Lesson 4 Variable, Datatype, Comment

Lesson 5 Input data from keyboard

Lesson 6 Operators

Lesson 7 Decision Control If, elif, else and nested if

Lesson 8 Conditional Operator Ternary Operator

Lesson 9 Loop for and while loop

Lesson 10 Nested loop

Lesson 11 Break and Continue Statements

Lesson 12 Functions

Lesson 13 Built in Function

Lesson 14 Data Structure (Lists, Tuples, Sets, Dictionaries)

Lesson 15 Data Structure with loop

Lesson 16 Exception Handling Try, Except, Finally

Lesson 17 Class and Object

Lesson 18 Constructor

Python GUI with Tkinter

Lesson 1 Python GUI Introduction

Lesson 2 Python GUI Example 1

Lesson 3 User Information Form

Introduction to MySQL Database

lesson 1 MySQL Introduction, Downloading and Installing MSQL

lesson 2 MySQL Create Database and table

lesson 3 MySQL Constraints, Data Type

lesson 4 MySQL Inserting Data

lesson 5 MySQL Updating Data

lesson 6 MySQL Deleting Data

lesson 7 MySQL Drop ,Delete, Truncate

Lesson 8 MySQL Select Statement

Lesson 9 MySQL View Statement

Lesson 10 MySQL Filtering Rows with WHERE

Lesson 11 MySQL Aggregate Functions

Lesson 12 MySQL Alter Statement

Lesson 13 MySQL Joins

Lesson 14 MySQL Subqueries

Lesson 15 MySQL Common Methods

Lesson 16 MySQL Store Procedure

Lesson 17 MySQL Store Procedure with Insert, Update, Delete

Lesson 18 MySQL Function

Lesson 19 MySQL Student Balance

Lesson 20 MySQL Student Statement

Lesson 21 MySQL Trigger Insert

Lesson 22 MySQL Trigger Update and Delete

Lesson 23 MySQL Backup

Lesson 24 MySQL Normalization

CRUD Operations(Insert, Update, Delete & Search) with Python & MySQL

Login page with Database

Student Ratings & Reviews

Join Our Community