Udemyintermediatezh

看漫画学Python进阶实战7:Python访问MySQL

Learn Python with manga! Master MySQL database management & practical Python operations. 30 years experience. Hands-on skills.

5.0(5)
9students
1h 42m
Certificate
东升 关
东升 关技术专家,技术顾问,技术图书作家,金牌讲师

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.

$ whoami — the devs behind tutorialsearch.io

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.

5.0(81)
38m
beginner
5.0(10)
1h 46m
all

中國針灸學:初階【認識經絡與穴位】

by 駿緯視聽醫學器材股份有限公司 MEDITALENT ENTERPRISES LTD.

5.0(1)
5h 2m
all

中國針灸學-21.針刺補瀉

by 駿緯視聽醫學器材股份有限公司 MEDITALENT ENTERPRISES LTD.

5.0(2)
44m
all