Building data-driven web apps with Pyramid and SQLAlchemy

Course Summary

One of the areas Python really shines is in building clean and powerful web applications. Once you know the language basics, this course will teach you everything you need to build data-driven, modern web applications in Python.

What's this course about and how is it different?

Full stack web development is exactly what you need to build true data-driven web applications in Python. Yet these courses can be confusing and overwhelming due to the many technologies involved (Python, SQL, CSS, etc).

We have taken great care to build a course that is just real enough to give you what you need without anything extra. We build a replica of a popular web application, Python's own packaging index over at pypi.org.

While building our replica PyPI, you will learn:

  • Learn about the different major Python web frameworks
  • Create a Pyramid-based website from scratch using the CLI and PyCharm
  • Work with dynamic HTML templates
  • Map URLs to view methods using routing
  • Make advanced use of routing to build a full custom CMS in 5 minutes
  • Take advantage of bootstrap to build well designed sites
  • Map data to and from Python using classes with SQLAlchemy
  • Learn how Alembic can help our database evolve as our models change
  • Accept user input with HTML forms
  • Add client and server-side validation
  • Overcome the special challenges of testing web apps (databases, frameworks, etc)
  • Deploy our web application to a fresh Linux machine (virtual, cloud-based)
  • Leverage our design patterns to convert our app to another data model (MongoDB edition)

View the full course outline

Who is this course for?

This course is for anyone who wants to create Python-based web applications using the Pyramid web framework. In fact, you'll learn a lot of web skills that will translate across frameworks as well.

We do assume that you have basic Python language skills and can read HTML and CSS. But most advanced uses of the language or CSS are explained in the course.

Follow along with your own version

Students get the most out of our courses when the work on projects closely related to the materials they are learning or even follow along by watching the videos and then recreating that code themselves chapter by chapter.

We have organized the source code included with the course to make following along starting from any chapter a breeze. In the screenshot below, you'll see two directories:

final/pypi_sqlalchemy
start/pypi_sqlalchemy

The start version is exactly what we started with on the videos for this chapter (chapter 9). If you want to follow along with chapter 9, just copy that somewhere and get started. Similarly, the final version is our final result exactly as it was on video. You can even diff the two directories to see the changes we made or against your work to see how we compare.

Here is the starter and final code from the SQLAlchemy database chapter.

Hands on exercises

Concepts backed by concise visuals

While exploring a topic interactively with demos and live code is very engaging, it can lose the forest for the trees. That's why when we hit a new topic, we stop and discuss it with concise and clear visuals.

Here's an example of concepts reviewing the basic idea of routing URLs to view methods and how Pyramid selects from the various URL routes given a single URL.

Example: Concepts backed by concise visuals

Who am I? Why should you take my course?

Who is Michael Kennedy?

My name is Michael, nice to meet you. ;) There are a couple of reasons I'm especially qualified to teach you Python.

1. I'm the host of the #1 podcast on Python called Talk Python To Me. On there I've interviewed many of the leaders and creators in the Python community. I bring that perspective to all the courses I create.

2. I've been a professional software trainer for over 10 years. I have taught literally thousands of professional developers in hundreds of courses throughout the world.

3. Students have loved my courses. Here are just a few of quotes from past students of mine.

"Michael is super knowledgeable, loves his craft, and he conveys it all well. I would highly recommend his training class anytime." - Robert F.
"Michael is simply an outstanding instructor." - Kevin R.
"Michael was an encyclopedia for the deep inner workings of Python. Very impressive." - Neal L.

Free office hours keep you from getting stuck

One of the challenges of self-paced online learning is getting stuck. It can be hard to get the help you need to get unstuck.

That's why at Talk Python Training, we offer live, online office hours. You drop in and join a group of fellow students to chat about your course progress and see solutions via screen sharing.

Just visit your account page to see the upcoming office hour schedule. Note: You must be enrolled in at least one course.

Is this course based on Python 3 or Python 2?

This course is based upon Python 3. With Python 2 going unsupported in 2020, we believe that it would be ill-advised to teach or learn Python 2.

The time to act is now

This data-driven web apps with Python and Pyramid course is just what you need to build that fast, custom web application that can help you create your next great idea or just solve a business problem by deploying it behind your firewall.

Course Outline: Chapters and Lectures

18:41
0:50
1:46
3:08
1:32
3:46
4:50
0:44
2:05
7:06
2:31
1:25
1:15
1:55
22:25
3:41
4:13
3:31
3:15
2:49
1:49
2:03
1:04
20:34
2:44
7:54
2:40
0:34
2:33
1:24
2:45
35:11
1:19
4:38
4:38
8:42
2:26
2:20
7:00
2:25
1:43
38:24
3:33
2:45
4:16
4:16
3:14
3:11
2:26
1:22
5:17
6:06
1:58
36:23
1:34
2:05
4:27
1:02
2:44
3:13
3:17
1:37
1:20
7:27
1:33
6:04
30:37
3:29
2:57
5:20
4:27
3:41
3:33
3:50
3:20
49:47
4:07
1:35
2:14
3:10
6:50
1:56
4:20
7:09
4:01
3:35
6:35
4:15
50:34
8:18
3:52
2:26
5:02
6:12
2:10
6:43
7:07
4:03
0:44
0:49
1:59
0:37
0:32
24:08
3:46
2:33
8:30
2:36
1:44
3:09
1:50
52:20
2:27
2:23
4:06
1:29
4:05
3:03
4:52
3:39
1:11
3:57
1:42
5:40
2:24
1:36
2:20
6:08
1:18
25:41
8:18
4:57
3:29
2:40
1:44
3:41
0:52
52:16
2:10
1:47
2:46
2:19
8:46
6:09
0:47
5:29
3:08
3:12
6:21
1:32
4:17
3:33
31:47
3:45
5:06
2:25
5:37
2:16
5:19
3:12
4:07
41:06
1:42
0:55
1:14
1:36
4:26
7:15
6:31
3:57
7:14
1:52
4:24
12:50
0:37
10:51
0:56
0:26
Buy the bundle, save 60% For your team

Questions? Send us an email: contact@talkpython.fm