|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/python-web-applications-with-google-sheets/
课程评论：没有评论
课程名称：构建基于 Google Sheets 的全栈 Python 网络应用 课程概述：欢迎来到学习全栈 Python Web 开发的最佳在线资源。本课程提供独特的学习体验，指导学员从零开始构建具有实际用途的真实应用程序。在课程结束时，您将部署一个通用的 Python 网络 API，该 API 能够与几乎无限数量的工作表连接。这个功能与许多提供 Google Sheets JSON API 的 SaaS 业务类似。 课程内容：您将学习如何从基础设置服务账户来启用 Sheets 和 Drive API，逐步实现创建和管理工作表、读取和写入数据、自动化常见任务以及使用认证保护路由等功能。课程分为四个深入的部分，涵盖从 Python 基础到创建和部署现代 API 及用户界面的内容。 在第一部分，您将： - 发掘 Google Sheets 作为灵活的云数据库替代品的强大功能 - 理解使用服务账户进行认证的细节 - 设置专业的开发环境 - 学习通过 Python 程序化地创建、读取、更新和删除 Google Sheets - 探索 API 开发者的秘密武器：发现文档 接下来，我们将深入 Python： - 使用 FastAPI 创建强大的 API - 设计优雅的面向对象抽象 - 实现行业标准的 JSON Web Tokens (JWT) 认证 - 精通不对称和动态数据的高级数据处理技术 - 构建完整的 CRUD API - 深入了解错误处理和安全最佳实践 - 学习将 API 从本地部署到全球的策略 接着，我们将转向用户界面（UI）设计和开发： - 启动 React 和 Next.js 的学习旅程 - 设计响应式现代 UI 使用 Tailwind CSS - 实现认证流程 - 从头开始设计电子商务店面 - 掌握复杂用户交互的状态管理 - 将用户界面部署到网络上 如果您是 Python 新手，不用担心！课程附录中包含完整的 Python 基础教学，帮助您快速掌握基础知识。 课程结束时，您将能够： - 创建一个面向生产环境的通用 API 与 Google Sheets 交互 - 精通从后端到中间件 API 再到用户界面的全栈开发 - 获得 Python、FastAPI、React 和 Next.js 的实际经验 - 开发并部署一个展示您新技能的项目 期待您的参与，让我们开始吧！
Welcome to the best resource online for learning full-stack Python web development with Google Sheets. This course offers a truly unique learning experience on Udemy. While there are hundreds of online Python courses to choose from, very few get you building real-world applications that have actual utility from the ground up. By the end of this course you will have deployed a universal Python web API that could connect to a virtually infinite number of workbooks. Functionally, this will be quite similar to several SaaS (software-as-a-service) businesses that you find on the web, services like SheetDB, SteinHQ, SheetBest, Sheety that offer JSON APIs on top of Google Sheets - obviously for $/month. In this course, you will develop a Python application that does just that! Except we will write every line of code together and in the end deploy the application to the web for free! We are going to do this step-by-step, starting with the very basics of setting up service accounts to enable the sheets and drive APIs, then moving on to the implementation of operations like creating and managing worksheets, reading, writing, and appending data, automating common tasks, managing updates, protecting our routes with authentication, and a lot more. The course features four in-depth sections that guide you from the basics of python all the way to creating and deploying fully functional modern APIs and user interfaces. In the first section you will:Uncover the power of Google Sheets as a flexible, cloud-based database alternativeUnderstand the details of authentication using service accountsSet up a professional development environment with virtual environmentsLearn to programmatically create, read, update, and delete Google Sheets through PythonExplore the secret weapon of API developers: the Discovery DocumentThen, we'll dive head-first into Python to:Craft a robust API using FastAPI, the most modern and lightweight Python web frameworkDesign elegant object-oriented abstractions for Google Sheets interactionsImplement industry-standard authentication with JSON Web Tokens (JWT)Master advanced data handling techniques for asymmetric and dynamic dataBuild a full CRUD (Create, Read, Update, Delete) API for Google SheetsDive deep into error handling and security best practicesLearn deployment strategies to take your API from local to globalFinally, we'll switch gears to user interface (UI) design and development. You will:Jumpstart your journey into the world of React and Next.jsDesign highly responsive, modern UIs with Tailwind CSSImplement authentication flows Design an e-commerce storefront from scratchMaster state management for complex user interactionsDeploy your user interface to the webAnd if you're new to python, don't worry! There is a full-length python primer included in the course that will get you up to speed in no time. This is included as an appendix to the course and covers all the basics of Python programming. It is designed to be a quick reference for those who are new to Python or need a refresher on the basics. By the end of this course, you will have: Built a production-ready universal API that interfaces with Google Sheets Mastered the full stack: from the backend to the middleware API to the user interface Gained real-world experience in Python, FastAPI, React, and Next.js Developed and deployed a portfolio-worthy project to showcase your new skillsI'm excited to have you on board. Let's get started!
