|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/using-mysql-databases-with-python/
课程评论：没有评论
课程名称：使用MySQL数据库与Python 课程概述：在当今时代，几乎所有的事物都依赖数据库，而MySQL是最受欢迎的数据库之一。作为一个免费且开源的数据库，MySQL非常适合满足各种需求。同样，Python是当前最流行且强大的编程语言之一。将两者结合在一起是一种强大的组合！在本课程中，您将学习如何使用Python进行MySQL的基本操作，包括创建数据库和表格、添加数据、排序数据、生成报告、提取特定数据等。 这门课程假设您已经具备基础的Python编程知识，但对数据库或MySQL没有任何了解也完全没问题。您将学习到以下内容： - 什么是数据库 - 如何安装Python - 如何安装Git Bash终端 - 如何下载MySQL - 如何安装MySQL及Workbench - 如何安装MySQL连接器 - 如何在Python中连接数据库 - 如何探索MySQL Workbench - 如何创建数据库 - 如何创建表格 - 如何向表格中插入一条记录 - 如何向表格中插入多条记录 - 数据类型的理解 - 如何从表格中选择数据 - 如何格式化结果 - 如何使用Where子句 - 如何使用Like子句和通配符 - 如何使用AND和OR - 如何更新记录 - 如何限制和排序结果 - 如何删除记录 - 如何删除（删除）表格及备份 - 还有更多内容！ 在整个学习过程中，我将一次一步带您完成此过程。如果您在过程中有任何问题，我会随时为您解答。 如果您一直想了解数据库或在Python程序中使用数据库，那么这门课程非常适合您。我们将免费下载课程所需的所有内容，您无需任何特殊工具！期待与您在课程中见面！- John Elder
These days everything uses a database, and MySQL is one of the most popular databases out there. FREE and Open Source, Mysql is a great database for just about all your needs.Likewise, Python is one of the most popular and powerful programming languages today. Pairing the two together is a powerful combination!In this course you'll learn the basics of using MySQL with Python. You'll learn how to create databases and tables, add data, sort data, create reports, pull specific data, and more.For this courses I'll assume you already have a basic knowledge of Python programming, but you don't need to know anything at all about databases or MySQL to take the course.You'll learn...What Is A DatabaseHow To Install PythonHow To Install Git Bash TerminalHow To Download MySQLHow To Install MySQL and WorkbenchHow To Install MySQL ConnectorHow To Connect to Database in PythonHow To Explore The MySQL WorkbenchHow To Create A DatabaseHow To Create A TableHow To Insert One Record Into TableHow To Insert Many Records Into TableUnderstanding Data TypesHow To Select Data From TableHow To Format Our ResultsHow To Use The Where ClauseHow To Use The Like Clause and WildcardsHow To Use AND and ORHow To Updating RecordsHow To Limit and Order ResultsHow To Delete RecordsHow To Delete (Drop) A Table And BackupsAnd More!I'll walk you through all of this and more, step by step. If you have any question along the way, I'm here to answer them.If you've ever wanted to understand databases or use them in your Python programs, this is the course for you.We'll download everything you need for this course for free, you don't need any special tools!I'll see you on the inside!-John Elder
