#May Motivation Use code MAY10 for extra 10% off

Python Flask and SQLAlchemy ORM

person icon Jack Chan


Python Flask and SQLAlchemy ORM

Build your first web application 'Lucky Draw' with Python, Flask & SQLAlchemy

updated on icon Updated on May, 2024

language icon Language - English

person icon Jack Chan

English [CC]

category icon Development,Data Science and AI ML,Python

Lectures -22

Resources -1

Duration -1.5 hours



30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

This course teaches you how to build real-world full-stack web applications with Python. Unlike other programming courses that focus on syntax and logic, this course focuses on practical application.

You may already know some basics about programming, which is good, but you may think that is another level to build a useful application by yourself. Don't worry, in this course, we will guide you on how to create your first Python web application step by step.

Python Flask And SQLAlchemy ORM Overview

We'll start by assuming you have a basic understanding of Python. We'll then show you how to build a simple web application for a lucky draw using SQLAlchemy to communicate with an SQLite backend database.

You'll learn how to perform basic database operations, such as creating, reading, updating, and deleting records. You'll also learn how to combine frontend user interface design with backend data processing algorithms.

We'll walk you through the process of creating the web application step-by-step using the free, premium Python IDE PyCharm. By the end of the course, you'll have built a functional web application with a stunning user interface that can be run on any computer or mobile device.

Why Learn Web Development?

Programming is one of the most in-demand skills in today's world. It can not only help you land a high-paying job as a software engineer, but it can also teach you how to think logically and rationally.

Even if you're a beginner, this course will teach you everything you need to know to build your first web application from scratch using the Python Flask framework for the front end and the SQL Alchemy ORM to interface with the database in the backend.

What is Flask?

Flask is a lightweight Python web framework that is easy to learn and use. It is classified as a microframework because it does not have any dependencies beyond the Python standard library. It supports extensions that can add features to Flask applications, making them more powerful. Extensions are updated more frequently than the core Flask framework.

In this course, we will cover Flask as well as other necessary extensions that are required to build a production-grade party web platform. Flask is commonly used with MongoDB (which we will also cover in this course), which gives it more control over databases and history.

What is PyCharm?

PyCharm is a professional Python IDE (Integrated Development Environment) developed by JetBrains. It has a free community edition that is more than sufficient for this course. PyCharm is a powerful IDE that can significantly improve development efficiency by providing features such as project management, syntax highlighting, syntax suggestions, and version control.


What will you learn in this course:

  • Master the fundamentals of Python, a powerful yet simple programming language.

  • Learn how to use Flask to develop a web application.

  • Learn SQLAlchemy to handle database interaction.

  • Use the Jinja2 template to render a dynamic UI.

  • Learn how to use and customize the Jinja filter.

  • Understand the interaction between frontend and backend systems.

  • Read and sort database data using SQLAlchemy.

  • Develop the skills necessary to build complete web applications, including the user interface, database, and server-side logic.

  • Learn how to use a professional Python IDE, PyCharm, to develop the whole project.

  • Be able to share your web application with the world by deploying it to a cloud hosting platform.


What are the prerequisites for this course?

  • A computer that can access the internet.

  • All the software used in this course is downloadable for free.

  • Basic HTML, CSS, and Python knowledge.

Python Flask and SQLAlchemy ORM


Check out the detailed breakdown of what’s inside the course

Learning Resources
1 Lectures
  • play icon Getting the tools and Additional Learning Resources Needed 01:24 01:24
Environment Setup
3 Lectures
Creating the Frontend
3 Lectures
Database Operations
5 Lectures
Implementing the Core Functions of the Web Application
5 Lectures
Final Touch Up
2 Lectures
Download the Source Code Here
2 Lectures

Instructor Details

Jack Chan

Jack Chan

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best


Michael Hoover

Michael Hoover


This feedback is not course related, but rather about the video player. It would be nice if it would save my volume settings. Every time I go to a new lesson my ears suffer lol.

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us