Web Development with Python Tutorial – Flask & Dynamic Database-Driven Web Apps

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.

Notes & references links:

⭐️ 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

--

[jovianhq]

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 @freecodecamp and Beau for hosting us! 🙏🏼

[parrobo]

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.

[ggggggg]

what a tutorial, started from zero, by the end got almost everything, on my way of building personal projects with obtained skills and knowledge!!

[nambativepeter]

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

[SreevathsaBV]

This is gold! The flow was absolutely flawless and understood without having to rewind and watch. Great stuff! 👌

[Matty]

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!!

[swastiksharma]

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!

[mariumbegum]

The fact that this is available is fantastic!

[banabasejiofor]

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

[SatyaMedidi]

This is Awesome. Please continue with the next steps!! This Content is GOLD!!

[johngodoy]

First, I'd like to say this is one of the most fluid and well explained coruses i've ever taken

[princekhunt]

This is a very good tutorial. You will learn flask, how to deploy on render and hosting.

[de-frag]

This was absolutely amazing, built a fully packaged website with dynamic data and email linked, basically everything

[caiozendron]

If you had trouble converting to dict at around 2h:54m, apparently Legacy.Row is out of date. This worked for me:

with engine.connect() as conn:
result = conn.execute(text("select * from jobs"))
result_all = result.all()
first_result = result_all[0]
column_names = result.keys()
first_result_dict = dict(zip(column_names, first_result))
print(first_result_dict)

[ajaykuchhadiya]

I usually don't comment on videos but this one is super helpful. cheers to you man, This was flawless

[pukhrajkumawat]

If you don't get proper dictionary @3: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()

[Pier_Py]

sir, you are the best. Just started with web development and i literally understood everything without any problem. thank you very much

[mathewtuwei]

The best web development tutorial so far!
easy to Follow and understand.

[penujahansith]

The course is really cool. the best tutorial for flask for beginners

[rajuljha]

By far the best tutorial I have seen, explaining the end to end workflow and resolving errors on the go.
Thank you so much FreeCodeCamp and Aakash!!