Building Full Stack Python Web Apps Backed By Google Sheets
Published 9/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.18 GB | Duration: 12h 1m
Develop and deploy a full-stack application using Python, Google Sheets, FastAPI, React, Next.js, and Tailwind CSS
What you'll learn
Build a universal Python JSON API that connects to a virtually infinite number of Google Sheets
Gain terrific, hands-on practice building and deploying full stack Python applications
Enable authentication with JSON Web Tokens (JWT) and protect routes and operations
Build and deploy a modern user interface with React, Next JS, and Tailwind CSS
Practice using Google Sheets as application databases for Python APIs
Explore the Google Sheets and Drive APIs from the ground up in Python
Requirements
A computer (Windows/Mac/Linux). That's all!
Some experience with python would be a plus, but is not required.
No prior experience with web development is required.
Description
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 that offer JSON APIs on top of Google Sheets - obviously for a price. 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, and a lot more. The course features four in-depth sections that guide you from the basics of python all the way to writing 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 PythonDiscover 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 Build a functional e-commerce storefront from scratchMaster state management for complex user interactionsDeploy your polished web application to the worldAnd 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 API that interfaces with Google Sheets Mastered the full stack: from database to API to 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!
Overview
Section 1: Python vs Worksheets
Lecture 1 Welcome!
Lecture 2 My Other Work
Section 2: Introduction To The Google Sheets API
Lecture 3 High-Level Concepts
Lecture 4 Credentials And Service Account
Lecture 5 Virtual Environment And Dependencies
Lecture 6 Setting Up The Sheets Service
Lecture 7 Inserting Values Into Existing Sheet
Lecture 8 Programmatically Creating New Sheets
Lecture 9 Managing Permissions Through The Drive API
Lecture 10 The Discovery Document
Section 3: Building The Python API Layer
Lecture 11 Section Resources + All The Code Files
Lecture 12 Setup And Dependencies
Lecture 13 Scaffolding The API
Lecture 14 Defining A Sheets Abstraction
Lecture 15 Service Account Credentials
Lecture 16 Injecting Dependencies In FastAPI
Lecture 17 Creating A New Sheet
Lecture 18 Permissioning A Specific User Or Anyone
Lecture 19 Pydantic Models
Lecture 20 Swagger UI API Documentation
Lecture 21 API Routers
Lecture 22 Rename Spreadsheet Operation
Lecture 23 Adding The Route Handler
Lecture 24 Deleting Spreadsheets
Lecture 25 Extra: Centralizing Exception Handling
Lecture 26 The Worksheets API Router
Lecture 27 Navigating Between Sheet Names And Ids
Lecture 28 Renaming A Worksheet
Lecture 29 Reading Worksheet Data And Returning JSON
Lecture 30 Writing Data To A Worksheet
Lecture 31 Handling Rows With Asymmetric Dimensions
Lecture 32 Appending Records With New Dimensions
Lecture 33 Handling Multiple New Columns Correctly
Lecture 34 Implementing Auto-Incrementing Ids
Lecture 35 Adding New Worksheets
Lecture 36 Clearing All Worksheet Content
Lecture 37 Deleting A Worksheet
Lecture 38 Introducing Environment Variables
Lecture 39 Creating Expirable JSON Web Tokens
Lecture 40 Implementing The /token Endpoint
Lecture 41 Adding Some Missing Dependencies
Lecture 42 Authentication And JWTs
Lecture 43 Defining An Auth Dependency
Lecture 44 Protecting Routes With Token-Based Authentication
Lecture 45 Finishing Touches
Lecture 46 Relaxing The CORS Policy
Lecture 47 Deployment Checklist
Lecture 48 Locking Dependencies And Config
Lecture 49 Git And .gitignore
Lecture 50 GitHub Remote Repository
Lecture 51 Deploying To The World Wide Web
Section 4: Creating User Interfaces With React And Next.js
Lecture 52 Section Resources + All The Code Files
Lecture 53 The Big Picture
Lecture 54 jаvascript, Node, React, And Next.js
Lecture 55 Setting Up A New Project
Lecture 56 Running The App
Lecture 57 Our First Component
Lecture 58 Controlling Components With jаvascript
Lecture 59 Styling Interfaces With Tailwind CSS
Lecture 60 Obtaining the JWT From The Backend
Lecture 61 Adding Interactivity To The Form
Lecture 62 Next.js Environment Variables
Lecture 63 Client-side Accessible Env Variables
Lecture 64 Conditionally Rendering On Successful Login
Lecture 65 Passing Down Props To Other Components
Lecture 66 Creating A New Workbook For Our Online Store
Lecture 67 Seeding Our Inventory
Lecture 68 Fetching Inventory Data Via The API
Lecture 69 Rendering Products
Lecture 70 Styling The Products Grid
Lecture 71 Defining A New ProductCard Component
Lecture 72 AddToCart Functionality
Lecture 73 Header With View Cart Button
Lecture 74 Opening And Closing The Cart
Lecture 75 Cart Container
Lecture 76 Displaying Items In The Cart
Lecture 77 Removing Items From The Cart
Lecture 78 Unique Cart Item Ids
Lecture 79 Calculating And Rendering TotalAmount
Lecture 80 Introducing A Checkout Button
Lecture 81 Creating The Orders Worksheet
Lecture 82 HandleCheckout From The UI
Lecture 83 Generating Unique Order Ids
Lecture 84 Updating Cart State On Order Checkout
Lecture 85 Persisting The Authentication Token
Lecture 86 Deploying The User Interface
Lecture 87 Deployed App
Lecture 88 Thank You!
Section 5: Appendix - Python Fundamentals
Lecture 89 A Quick Note + Section Resources
Lecture 90 Data Type
Lecture 91 Variables
Lecture 92 Arithmetic And Augmented Assignment Operators
Lecture 93 Ints And Floats
Lecture 94 Booleans And Comparison Operators
Lecture 95 Strings
Lecture 96 Methods
Lecture 97 Containers I: Lists
Lecture 98 Lists vs. Strings
Lecture 99 List Methods And Functions
Lecture 100 Containers II: Tuples
Lecture 101 Containers III: Sets
Lecture 102 Containers IV: Dictionaries
Lecture 103 Dictionary Keys And Values
Lecture 104 Membership Operators
Lecture 105 Controlling Flow: if, else, And elif
Lecture 106 Truth Value Of Non-booleans
Lecture 107 For Loops
Lecture 108 The range() Immutable Sequence
Lecture 109 While Loops
Lecture 110 Break And Continue
Lecture 111 Zipping Iterables
Lecture 112 List Comprehensions
Lecture 113 Defining Functions
Lecture 114 Function Arguments: Positional vs Keyword
Lecture 115 Lambdas
Lecture 116 Importing Modules
Enthusiastic beginners or developers looking to build full-stack Python applications backed by Google Sheets
https://ddownload.com/1x9jmwa1956o/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part1.rar
https://ddownload.com/vhw5w35t28d0/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part2.rar
https://ddownload.com/la9ebp990exe/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part3.rar
https://rapidgator.net/file/79f1bdcd0f866e2487e70153a591d13c/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part1.rar
https://rapidgator.net/file/dc2ac1898a37be81636a6b0307c33d00/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part2.rar
https://rapidgator.net/file/19dad596d9e00553faef4535ac4d9e72/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part3.rar
https://turbobit.net/hr2ai8nby0ba/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part1.rar.html
https://turbobit.net/yv178nrtdl6y/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part2.rar.html
https://turbobit.net/h7gxooymt2bg/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part3.rar.html
What you'll learn
Build a universal Python JSON API that connects to a virtually infinite number of Google Sheets
Gain terrific, hands-on practice building and deploying full stack Python applications
Enable authentication with JSON Web Tokens (JWT) and protect routes and operations
Build and deploy a modern user interface with React, Next JS, and Tailwind CSS
Practice using Google Sheets as application databases for Python APIs
Explore the Google Sheets and Drive APIs from the ground up in Python
Requirements
A computer (Windows/Mac/Linux). That's all!
Some experience with python would be a plus, but is not required.
No prior experience with web development is required.
Description
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 that offer JSON APIs on top of Google Sheets - obviously for a price. 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, and a lot more. The course features four in-depth sections that guide you from the basics of python all the way to writing 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 PythonDiscover 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 Build a functional e-commerce storefront from scratchMaster state management for complex user interactionsDeploy your polished web application to the worldAnd 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 API that interfaces with Google Sheets Mastered the full stack: from database to API to 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!
Overview
Section 1: Python vs Worksheets
Lecture 1 Welcome!
Lecture 2 My Other Work
Section 2: Introduction To The Google Sheets API
Lecture 3 High-Level Concepts
Lecture 4 Credentials And Service Account
Lecture 5 Virtual Environment And Dependencies
Lecture 6 Setting Up The Sheets Service
Lecture 7 Inserting Values Into Existing Sheet
Lecture 8 Programmatically Creating New Sheets
Lecture 9 Managing Permissions Through The Drive API
Lecture 10 The Discovery Document
Section 3: Building The Python API Layer
Lecture 11 Section Resources + All The Code Files
Lecture 12 Setup And Dependencies
Lecture 13 Scaffolding The API
Lecture 14 Defining A Sheets Abstraction
Lecture 15 Service Account Credentials
Lecture 16 Injecting Dependencies In FastAPI
Lecture 17 Creating A New Sheet
Lecture 18 Permissioning A Specific User Or Anyone
Lecture 19 Pydantic Models
Lecture 20 Swagger UI API Documentation
Lecture 21 API Routers
Lecture 22 Rename Spreadsheet Operation
Lecture 23 Adding The Route Handler
Lecture 24 Deleting Spreadsheets
Lecture 25 Extra: Centralizing Exception Handling
Lecture 26 The Worksheets API Router
Lecture 27 Navigating Between Sheet Names And Ids
Lecture 28 Renaming A Worksheet
Lecture 29 Reading Worksheet Data And Returning JSON
Lecture 30 Writing Data To A Worksheet
Lecture 31 Handling Rows With Asymmetric Dimensions
Lecture 32 Appending Records With New Dimensions
Lecture 33 Handling Multiple New Columns Correctly
Lecture 34 Implementing Auto-Incrementing Ids
Lecture 35 Adding New Worksheets
Lecture 36 Clearing All Worksheet Content
Lecture 37 Deleting A Worksheet
Lecture 38 Introducing Environment Variables
Lecture 39 Creating Expirable JSON Web Tokens
Lecture 40 Implementing The /token Endpoint
Lecture 41 Adding Some Missing Dependencies
Lecture 42 Authentication And JWTs
Lecture 43 Defining An Auth Dependency
Lecture 44 Protecting Routes With Token-Based Authentication
Lecture 45 Finishing Touches
Lecture 46 Relaxing The CORS Policy
Lecture 47 Deployment Checklist
Lecture 48 Locking Dependencies And Config
Lecture 49 Git And .gitignore
Lecture 50 GitHub Remote Repository
Lecture 51 Deploying To The World Wide Web
Section 4: Creating User Interfaces With React And Next.js
Lecture 52 Section Resources + All The Code Files
Lecture 53 The Big Picture
Lecture 54 jаvascript, Node, React, And Next.js
Lecture 55 Setting Up A New Project
Lecture 56 Running The App
Lecture 57 Our First Component
Lecture 58 Controlling Components With jаvascript
Lecture 59 Styling Interfaces With Tailwind CSS
Lecture 60 Obtaining the JWT From The Backend
Lecture 61 Adding Interactivity To The Form
Lecture 62 Next.js Environment Variables
Lecture 63 Client-side Accessible Env Variables
Lecture 64 Conditionally Rendering On Successful Login
Lecture 65 Passing Down Props To Other Components
Lecture 66 Creating A New Workbook For Our Online Store
Lecture 67 Seeding Our Inventory
Lecture 68 Fetching Inventory Data Via The API
Lecture 69 Rendering Products
Lecture 70 Styling The Products Grid
Lecture 71 Defining A New ProductCard Component
Lecture 72 AddToCart Functionality
Lecture 73 Header With View Cart Button
Lecture 74 Opening And Closing The Cart
Lecture 75 Cart Container
Lecture 76 Displaying Items In The Cart
Lecture 77 Removing Items From The Cart
Lecture 78 Unique Cart Item Ids
Lecture 79 Calculating And Rendering TotalAmount
Lecture 80 Introducing A Checkout Button
Lecture 81 Creating The Orders Worksheet
Lecture 82 HandleCheckout From The UI
Lecture 83 Generating Unique Order Ids
Lecture 84 Updating Cart State On Order Checkout
Lecture 85 Persisting The Authentication Token
Lecture 86 Deploying The User Interface
Lecture 87 Deployed App
Lecture 88 Thank You!
Section 5: Appendix - Python Fundamentals
Lecture 89 A Quick Note + Section Resources
Lecture 90 Data Type
Lecture 91 Variables
Lecture 92 Arithmetic And Augmented Assignment Operators
Lecture 93 Ints And Floats
Lecture 94 Booleans And Comparison Operators
Lecture 95 Strings
Lecture 96 Methods
Lecture 97 Containers I: Lists
Lecture 98 Lists vs. Strings
Lecture 99 List Methods And Functions
Lecture 100 Containers II: Tuples
Lecture 101 Containers III: Sets
Lecture 102 Containers IV: Dictionaries
Lecture 103 Dictionary Keys And Values
Lecture 104 Membership Operators
Lecture 105 Controlling Flow: if, else, And elif
Lecture 106 Truth Value Of Non-booleans
Lecture 107 For Loops
Lecture 108 The range() Immutable Sequence
Lecture 109 While Loops
Lecture 110 Break And Continue
Lecture 111 Zipping Iterables
Lecture 112 List Comprehensions
Lecture 113 Defining Functions
Lecture 114 Function Arguments: Positional vs Keyword
Lecture 115 Lambdas
Lecture 116 Importing Modules
Enthusiastic beginners or developers looking to build full-stack Python applications backed by Google Sheets
https://ddownload.com/1x9jmwa1956o/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part1.rar
https://ddownload.com/vhw5w35t28d0/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part2.rar
https://ddownload.com/la9ebp990exe/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part3.rar
https://rapidgator.net/file/79f1bdcd0f866e2487e70153a591d13c/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part1.rar
https://rapidgator.net/file/dc2ac1898a37be81636a6b0307c33d00/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part2.rar
https://rapidgator.net/file/19dad596d9e00553faef4535ac4d9e72/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part3.rar
https://turbobit.net/hr2ai8nby0ba/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part1.rar.html
https://turbobit.net/yv178nrtdl6y/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part2.rar.html
https://turbobit.net/h7gxooymt2bg/.Building.Full.Stack.Python.Web.Apps.Backed.By.Google.Sheets.part3.rar.html
We need your support!
Make a donation to help us stay online
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem
Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239
Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u
USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239
USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm