Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Python Flask and SQLAlchemy ORM

person icon Jack Chan

4

Python Flask and SQLAlchemy ORM

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

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Jack Chan

category icon Development,Data Science and AI ML,Python

Lectures -22

Resources -1

Duration -1.5 hours

4

price-loader

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.

Goals

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.

Prerequisites

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

Curriculum

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
Tutorialspoint
Creating the Frontend
3 Lectures
Tutorialspoint
Database Operations
5 Lectures
Tutorialspoint
Implementing the Core Functions of the Web Application
5 Lectures
Tutorialspoint
Final Touch Up
2 Lectures
Tutorialspoint
Download the Source Code Here
2 Lectures
Tutorialspoint

Instructor Details

Jack Chan

Jack Chan

Educator / Software Engineer / Business Analyst in iBank

Hi, I'm Jack. I have 10+ years of experience in the finance IT industry, have worked in top tier global investment banks like Morgan Stanley, Merrill Lynch, HSBC and BNP Paribas.

I started programming since I was 10. Since then, I felt in love with software engineering and went on to purse my degree in Information Engineering in university. I was an active participant in world wide programming contests. I had also go aboard to Singapore to work with the local professors to analyze gene data in a bioinformatic project. I learnt a great deal form that in my young age.

I have then been working in the finance IT industry for 10+ years. I worked with different top tier investment banks and has used my skill to build numerous robust systems for them. I have built systems that analyze millions of transactions and positions to spot suspicious movement. I have leveraged the powerful analytical Python libraries to perform data analysis and performance optimization for trading system that works in microsecond level. I have profound knowledge on the modern software development life cycle which use automated testing, continuous integration and agile methodology. I learnt different programming languages, including Java, C#, C++, Php, Python etc. But among them, I found python the most expressive and powerful, it is one of the best programing languages he will recommend to people.

If you like my work, you are welcome to contact me through my website, Facebook, linked-in etc.

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

Feedbacks

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

1800-202-0515