|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/using-sqlite3-databases-with-python/
课程评论：没有评论
课程名称：Python编程的SQLite数据库入门 课程概述：在现代编程中，数据库无处不在，而SQLite是目前最流行的数据库之一。作为一款免费和开源的数据库，SQLite非常适合小型项目、爱好项目以及测试和开发。Python则是当今最受欢迎和强大的编程语言之一，将这两者结合起来是一个强大的组合！ 在本课程中，你将学习如何使用SQLite与Python进行开发。课程内容涵盖数据库和表的创建、数据的插入和排序、报告的生成、特定数据的提取等。课程假设你已经具备基础的Python编程知识，但你不需要具备任何数据库或者SQLite的知识。 你将学习到的内容包括： - 数据库的基本概念 - Python的安装 - Git Bash终端的安装 - 如何在Python程序中使用SQLite - 如何连接到数据库 - 创建数据库和表的方法 - 向表中插入单条和多条记录 - 数据类型的理解 - 从表中选择数据 - 格式化结果的方法 - 使用WHERE、LIKE、AND和OR语句 - 更新记录、限制和排序结果 - 删除记录、删除（删除）表及备份等 课程结束时，我们将共同构建一个非常基本的应用程序，以巩固我们所学的内容。我会一步步引导你，如果在学习过程中有任何问题，我会随时解答。 如果你想理解SQLite数据库或在Python程序中使用它们，这门课程将非常适合你。我们将免费下载所有所需的工具，无需任何特殊的设备！期待在课程中见到你！——约翰·埃尔德
These days everything uses a database, and SQLite is one of the most popular databases out there. FREE and Open Source, SQLite is a great database for smaller projects, hobby projects, or testing and development.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 SQLite 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 SQLite to take the course.You'll learn...What Is A DatabaseHow To Install PythonHow To Install Git Bash TerminalHow To Use SQLite in a Python ProgramHow To Connect to Database in PythonHow 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 Your ResultsHow To Use The Where ClauseHow To Use The Like Clause and WildcardsHow To Use AND and ORHow To Update RecordsHow To Limit and Order ResultsHow To Delete RecordsHow To Delete (Drop) A Table And BackupsAnd More!At the end of the course we'll build a very basic app to help reinforce all the things we learning along the way.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 SQLite 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
