Advanced Python: Working with Databases

教程/Tutorials _432n 1评论 收藏

MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Advanced | Genre: eLearning | Language: English + .srt | Duration: 4h 51m | Size: 766 MB

To create functional and useful Python applications, you need a database. Databases allow you to store data from user sessions, track inventory, make recommendations, and more. However, Python is compatible with many options: SQLite, MySQL, and PostgreSQL, among others. Selecting the right database is a skill that advanced developers are expected to master. This course provides an excellent primer, comparing the different types of databases that can be connected through the Python Database API. Instructor Kathryn Hodge teaches the differences between SQLite, MySQL, and PostgreSQL and shows how to use the ORM tool SQLAlchemy to query a database. The final chapters put your knowledge to practical use in two hands-on projects: developing a full-stack application with Python, PostgreSQL, and Flask and creating a data analysis app with pandas and Jupyter Notebook. By the end, you should feel comfortable creating and using databases and be able to decide which Python database is right for you.

Topics include:
What is a database?
Relational vs. nonrelational databases
Creating a SQLite database
Editing records in SQLite
Creating a MySQL database
Encapsulating database operations
Creating a PostgreSQL database
Interacting with databases using SQLAlchemy
Creating a stored procedure
Developing full-stack apps with Python and Flask
Developing analysis apps with pandas and SQLAlchemy

Advanced Python: Working with Databases

Password/解压密码0daydown

Download rapidgator
https://rg.to/file/1b3298c57d6b995802276ea2f3c84f60/Advanced_Python__Working_with_Databases.rar.html

Download nitroflare
https://nitroflare.com/view/925CE56ADEBBC44/Advanced_Python__Working_with_Databases.rar

Download 百度网盘:抱歉,此资源仅限VIP下载,请先

您必须 登录 才能发表评论!

网友最新评论 (1)

  1. 为了开发能使用的Python应用,你需要一个数据库。数据库可以让你从用户的对话中存储数据,跟踪存货,做出推荐等。然而Python可以使用多种数据库: SQLite, MySQL和PostgreSQL等。选择正确的数据库是高级开发者需要掌握的技能。本教程为对比不同类型数据库提供了一个不错的导读,可以通过Python数据库API连接到这些数据库。讲师Kathryn Hodge会讲到数据库之间的区别,并演示如何使用ORM工具SQLAlchemy查询数据库。最后将会通过两个实践项目:开发一个全栈应用以及开发一个数据分析应用,综合运营你的Python知识。学习完本教程,你可以开发和使用数据库过程中决定合适的产品。 主要内容:何为数据库;关系型vs.非关系型数据库;创建一个SQLite数据库并编辑记录;创建一个MySQL数据库;封装数据库操作;创建一个PostgreSQL数据库;使用sqlaichemy与数据库交互;创建一个存储过程;使用Python和Flash开发全栈app;使用pandas和SQLAIchemy开发分析app。
    wilde(特殊组-翻译)5年前 (2020-10-12)