看漫画学Python进阶实战7:Python访问MySQL
Learn Python with manga! Master MySQL database management & practical Python operations. 30 years experience. Hands-on skills.
Course Content
看漫画学Python进阶实战7:Python访问MySQL is an intermediate-level Udemy course taught by 东升 关. It runs 1h 42m, is taught in Chinese, and includes a certificate of completion. Learners rate it 5.0 out of 5 from 5 reviews, with 9 students enrolled. It is a paid course, first published January 2025.
Learn MySQL and Python Database Interaction
This course provides a comprehensive introduction to MySQL database fundamentals and practical Python techniques for database management. You'll gain hands-on experience with database installation, configuration, and essential management commands.
What you'll learn:
- MySQL Fundamentals: Master the basics of MySQL, including installation and configuration.
- Database Management: Learn to manage your MySQL databases effectively using both command-line tools and graphical user interfaces (GUI).
- Python & MySQL Integration: Discover how to seamlessly integrate Python with MySQL.
- PyMySQL Library: Understand the installation and configuration of the PyMySQL library, a key tool for Python database interaction.
- CRUD Operations: Develop proficiency in performing CRUD (Create, Read, Update, Delete) operations on a sample student table. This includes:
- Creating Data: Learn to structure and add new data to your database.
- Reading Data: Master querying and retrieving data from the database.
- Updating Data: Understand how to modify existing data within the database.
- Deleting Data: Learn to remove unwanted data from your database.
- Data Manipulation Techniques: Gain a thorough understanding of how to efficiently manage and manipulate data within a MySQL database.
Course Content Breakdown:
- MySQL Installation: Step-by-step instructions for installing MySQL 8.
- MySQL Server Login: Learn to connect to your MySQL server using the command prompt.
- Essential Management Commands: Explore common MySQL commands for database administration.
- GUI Database Management: Utilize graphical tools for intuitive database management.
- Python MySQL Connection: Establish a connection to your MySQL database from Python using PyMySQL.
- Data Interaction Workflow: Understand the fundamental process of interacting with MySQL databases using Python.
- Hands-on Practice 1: CRUD on a Student Table:
- Creating a Student Table: Design and build a database table to store student information.
- Inserting Data: Populate the student table with sample data.
- Querying Data: Retrieve specific data from the table using SQL queries.
- Handling Multiple Results: Learn to process queries that return multiple rows of data.
- Hands-on Practice 2: Data Update and Deletion:
- Updating Data: Modify existing student records in the database.
- Deleting Data: Remove student records from the database.
Prerequisites:
This course is suitable for students with a basic understanding of programming concepts. It's designed to enhance your data storage and management skills, providing a solid foundation for future development projects.
Need a web app built? Hire the team behind TutorialSearch.io
We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.