Learn how to develop Dynamic Database-Driven Web Apps with Python, Flask, and MySQL. This course is broken up into two parts. In part one, you will learn how to build and deploy a site using the Flask Python web framework. In part two, you will connect the Flask application from the first part to a cloud MySQL database and learn how to deploy a production-ready database-driven web application. ✏️ Aakash N S created this course. 🔗 Submit your project & earn a certificate: https://jovian.com/learn/web-development-with-python-and-flask 🔗 Check out Jovian’s YouTube channel: https://youtube.com/@jovianhq Notes & references links: 🔗 Part 1: https://jovian.com/aakashns/web-development-with-python 🔗 Part 2: https://jovian.com/aakashns/database-driven-web-applications ❤️ Try interactive Python courses we love, right in your browser: https://scrimba.com/freeCodeCamp-Python (Made possible by a grant from our friends at Scrimba) ⭐️ Contents ⭐️ Part 1 ⌨️ (0:00:00) Introduction ⌨️ (0:02:07) 1.1 Project Setup & Flask Basics ⌨️ (0:22:25) 1.2 Building Web Pages using HTML ⌨️ (0:40:57) 1.3 Styling with CSS & Bootstrap ⌨️ (1:08:25) 1.4 Dynamic Data using Templates ⌨️ (1:27:22) 1.5 Deploying to the Cloud with Render ⌨️ (1:42:39) 1.6 Functional and Aesthetic Improvements ⌨️ (1:58:44) 1.7 Summary & Future Work Part 2 ⌨️ (2:04:19) Database-Driven Web Applications ⌨️ (2:07:24) 2.1 Project Setup & Deployment ⌨️ (2:21:44) 2.2 Cloud MySQL Database Setup ⌨️ (2:36:20) 2.3 DB Connection with SQLAlchemy ⌨️ (2:56:22) 2.4 Display DB Data on Web Page ⌨️ (3:20:04) 2.5 Dynamic Database-Driven Pages ⌨️ (3:49:23) 2.6 HTML Form for Applications ⌨️ (4:15:37) 2.7 Saving Applications to DB ⌨️ (4:26:23) 2.8 Summary & Future Work ⌨️ (4:37:50) Conclusion 🎉 Thanks to our Champion and Sponsor supporters: 👾 Nattira Maneerat 👾 Heather Wcislo 👾 Serhiy Kalinets 👾 Erdeniz Unvan 👾 Justin Hual 👾 Agustín Kussrow 👾 Otis Morgan -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news
ADVERTISEMENT
We hope you enjoy this tutorial, and we look forward to seeing what you'll build! If you'd like to get your project reviewed by our team & earn a certificate, register here for free: /learn/web-development-with-python-and-flask If you have any questions or face issues, please post them in the comments and we'll help you out. Do check out our YouTube channel as well, where we're posting new tutorials every week. Thanks and Beau for hosting us! 🙏🏼
This is gold! The flow was absolutely flawless and understood without having to rewind and watch. Great stuff! 👌
You are a super teacher. I wish we could teach students in the University in such granularity and functionality. There is no point dumping boring theories onto students' brain about www, HTTP, etc. Tutorials like this puts everything into context. Well done and thank you so much for making and sharing these contents.
why waste time understanding replit, when you can do it in vscode anyway
For those facing issue related to the TypeError while appending the row in the result_dict at 2:56:00 can use result_dicts.append(row._mapping), i was also facing this issue wasted around 2 Hrs to figure it out!
what a tutorial, started from zero, by the end got almost everything, on my way of building personal projects with obtained skills and knowledge!!
For those experiencing some issues around 3:29, this worked for me def load_job_from_db(id): with engine.connect() as conn: result = conn.execute( text(f"SELECT * FROM jobs WHERE id={id}") ) rows = [] for row in result.all(): rows.append(row._mapping) if len(rows) == 0: return None else: return row
If you don't get proper dictionary :26:50 here is the function that worked for me: def load_job_from_db(id): with engine.connect() as conn: result = conn.execute(text("SELECT * FROM jobs WHERE id = :val"),{'val': id}) row = result.fetchone() return row._asdict()
First, I'd like to say this is one of the most fluid and well explained coruses i've ever taken
Aakash has been a very big blessing to my career. I had an interview and somehow passing Algorithms through code challenges was difficult. But the moment i lay hold of Aakash tutorial on Data structures and algorithms. After going through the course this time i went into the test and came out successful. Thank you Co-founder of Jovian Aakash
This was absolutely amazing, built a fully packaged website with dynamic data and email linked, basically everything
at 2:55:20 if you are stuck with dict( ) conversion, try using ._asdict() method Apparently it will be like first_result_dict = result_all[0]._asdict()
Absolutely love this course.. Thank you 🙂
This tutorial is just awesome!! Bro please make one similar video which will include HTML,CSS, Java Script, Angular & Database in that. Mainly I would like to understand how javascript Anular and DB work together.
4:21:16 if anyone's facing issues where the data is not being inserted into the database, even though there's no errors in your code, then write conn.commit() after the conn.execute() command.
Man, I am from Brazil. I have just seen 43 min until now, but I would like to send this text: This is the best, simple Flask I have seen!! Thank you for your time!!
Always keep it up! You're doing great! 👍👍👍👍👍
Thank you Aakash and freeCodeCamp for taking the time to create and share this video it was a great walk through for flask and mysql in the cloud!!
Thank you for this, so well-explained and comprehensive!
I gained more knowledge from you than I did from my entire college web development course. Thank you, sir.