Browse Library

Learning Python Flask and SQL Alchemy ORM

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

Instructed by Jack Chan

5 days left at this price!
  • Buy Single Course $25 $85 71% off
    $25
    It Includes:
    Get access to this course only.
    Access to all marketplace courses
    Lifetime Course Access
    Play & Pause Videos
    High Quality Recorded Lectures
    Learn Online from Mobile/PC/Tablet
    Download Course for Offline Viewing
    Inlcudes Real Projects
    Free Instructor Support
  • Go Premium & Save
    Get access to all courses starting at $19/mo
    It Includes:
    Get Monthly Unlimited Access (1 user)
    Access to all marketplace courses
    Play & Pause Videos
    High Quality Recorded Lectures
    Learn Online from Mobile/PC/Tablet
    Download Course for Offline Viewing
    Inlcudes Real Projects
    Certificate of Completion
    Free Instructor Support
  • Monthly $15/Per user (min 5 users) ($14/user/mo)
    Buy
    Buy
    $15
    It Includes:
    All Personal plan features +
    Best for small teams or Business
    Unlimited access for team
    Admin Dashboard & Analytics
    Basic reporting
    User Management
    Custom Branding Options
  • Yearly $169/Per user (min 5 users) ($14/user/mo)
    Buy
    Buy
    $169
    It Includes:
    All Personal plan features +
    Best for small teams or Business
    Unlimited access for team
    Admin Dashboard & Analytics
    Basic reporting
    User Management
    Custom Branding Options
  • Learn how to use Flask to develop a web application
  • Learn SQLAlchemy to handle database interaction
  • Learn how to use a professional Python IDE, PyCharm, to develop the whole project
  • Understand the interaction between frontend and backend system
  • Use Jinja2 template to render a dynamic UI
  • Learn how to use and customize the Jinja filter
  • Read and sort database data using SQLAlchemy

The best way to demonstrate your programming skill is to build a web application. A web application can be run by any computer or mobile device. With nowaday technology, a web application can run as fast as native application. In this course, we will show you how you can kick start your first web application, using Python Flask framework as the frontend and SQL Alchemy ORM to interactive with the backend database.

Programming is one of the very important skills that people value a lot in this era. Not only it can help you get a well-paid software engineer job, but it can also train your brain to think in a logically manner. We are sure you agree with that but you are not sure where and how to start. 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 how to create your first python web application step by step. You may become the next Jeff Bazos or Mark Zuckerburg!

 

Why is this course for me?

If you want to learn about Python, this course is for you! Python is simple yet powerful. It is widely used by tech giants like Google, Youtube, Dropbox etc.

If you want to build a web application from Scratch, this course is for you! This course guild you how to build a workable web application from scratch. Unlike other learning materials that you can find in the internet, this course is complete and well organized.

If you want to learn it in an effective and fun way, this course is for you. This course is full of practical material, you will go back with a workable web application. This give you all the techniques and confidence to create your own web application in the future.

 

What exactly will you learn?

This course has a goal, which is to show you how you can build real life full stack web application using python.

Unlike other programming courses which spent a lot of time on covering the syntax and logic, this course focus on the practical usage of the language. We assume you have basic understanding about the programming language (Python), we then teach you how you can build this simple lucky draw web application from scratch.

This course will show you how to use SQLAlchemy to interact with the backend database (SQLLite). We will cover a series of database operations include creat, read, update, delete records. You will be able to combine the frontend UI design with the backend data handling logic. Since we are showing you how to build the online web application step by step, you will see us using the free professional Python IDE PyCharm. Your takeaway after this course is a workable web application with a beautiful UI.

We are trying to keep the course short and straight forward, so you can pick up the necessary skill to kick start your first web application in a few hours.

You can also take this chance to revise important programming concept in Python.

 

What is Python?

Python is a simple, intuitive, yet powerful programming language. It is an high-level programming language invented back in 1991. It is a go-to language for beginners because it is so easy and expressive. You can often express concepts with very few lines of code. That's why we choose Python as the programming language for this course!

However, don't have a misunderstanding that Python is only for beginner. It is used in many areas including data analysis, finance, scientific research, artificial intelligence etc. Python is a very powerful programming language and is well supported the community. There are lots of useful packages like Numpy, Scipy etc. It is a programming language that supports multiple programming paradigms like procedural, functional, object-oriented etc. 

In a nutshell, if you can only learn one programming language, Python is your choice! And if you are a beginner and you want to grab the basics before taking this course, we recommend you to enroll our python beginner course - Learn Python in a Day. You can find the course under our profile.

 

What is Flask?

Flask is a micro web framework written in Python. It is classified as a microframework because it does not require particular tools or libraries. It supports extensions that can add application features and making the web applications built on Flask more powerful. Extensions are updated far more regularly than the core Flask program. In this course, we will cover Flask as well as other necessary extensions that are required to build this production grade party web platform. Flask is commonly used with MongoDB (which we will cover in this course as well), allowing 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 and which is more than good enough for this course. It is a powerful IDE that can significantly improve the development efficiency by providing project management, syntax highlight, syntax suggestion and version control.

 

Who are the instructors?

Jack comes from a software engineering background. He has built sophisticated systems for top tier investment banks. You can understand more about the instructor in their Learnfly profile. 

Instructor: Jack Chan
Course Designer: Raymond Chung

 

Sign up for our course today, and let's kick start your first web application together!

  • A computer that can access internet
  • All the software used in this course are downloadable for free
  • Basic HTML, CSS and Python knowledge
  • Students who want to learn Python, a powerful yet simple programming language
  • Students who want to build a web application, and share his idea to the world
  • Students who want to build a webpage that interact with the backend data
  • Students who want to learn SQLAlchemy, and how it interact with the database
  • Students who want to become a full stack web developer
View More...

Section 1 : Learning Resources

  • Lecture 1 :
  • Getting the tools and additional learning resources needed Preview

Section 2 : Environment Setup

  • Lecture 1 :
  • Python Installation
  • Lecture 2 :
  • PyCharm Setup
  • Lecture 3 :
  • Installing Flask

Section 3 : Creating the Frontend

  • Lecture 1 :
  • Jinja2 Template
  • Lecture 2 :
  • Create a New Restaurant
  • Lecture 3 :
  • Getting Data from Input Form

Section 4 : Database Operations

  • Lecture 1 :
  • SQLite DB & SQLAlchemy
  • Lecture 2 :
  • Models and DB Operations
  • Lecture 3 :
  • Reading Database Data
  • Lecture 4 :
  • Updating Database Data
  • Lecture 5 :
  • Deleting Database Data

Section 5 : Implementing the Core Functions of the Web Application

  • Lecture 1 :
  • Jinja 2 Filter
  • Lecture 2 :
  • The Random Function
  • Lecture 3 :
  • Creating the Histories Model
  • Lecture 4 :
  • Displaying All the History Records
  • Lecture 5 :
  • Sorting the Top 5 Most Visited Restaurants

Section 6 : Final Touch Up

  • Lecture 1 :
  • Auto Delete the Obsolete History Records
  • Lecture 2 :
  • Showing the Current Page in Navigation Bar

Section 7 : Download the Source Code Here

  • Lecture 1 :
  • Where to download source code through git repository
  • Lecture 2 :
  • Complete Source Code Download
  • How do i access the course after purchase?

    Once you purchase a course (Single course or Subscription), you will be able to access the courses instantly online by logging into your account. Use the user name & password that you created while signing up. Once logged in, you can go to the "My Courses" section to access your course.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certification after completing the course?

    Yes. Once you succesfully complete any course on Learnfly marketplace, you get a certiifcate of course completion emailed to you within 24 hours with your name & the Learnfly badge. You can definately brag about it & share it on your social media or with friends as one of your achievement. Click here to view the sample certificate Click Here
  • For how long can i access my course after the purchase?

    If you buy a single course, that course is accessible to you for a lifetime. If you go for a premium subcription, you can access all the courses on Learnfly marketplace till your subscription is Active.
  • Whats the difference between Single Course Purchase & Go Premium option?

    With Single Course Purchase, you only get an access of one single course. Whereas, with premium monhtly or annual subscription, you can access all the existing or new courses on learnfly marketplace. You can decide what option suits you the best and accordingly you can make your purchase.
  • Is there any free trial?

    Currently, we don't have any free trial but it may be available in near future.
  • What is the refund policy?

    We would hate you to leave us. However, if you are not satisfied, you can ask for a full refund within 30 days & we will be happy to assist you further.

Jack Chan,

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.
View More...
google-tensorflow-hands-on-with-python-latest

Google TensorFlow Hands on with Pyt...

By : UNP United Network of Professionals

Lecture 51

create-your-own-programming-language-from-scratch

Create your OWN Programming Languag...

By : Harshit Srivastava

Lecture 6

learn-elixir-programming-from-zero-to-hero

Learn ELIXIR programming from Zero ...

By : Pranjal Srivastava

Lecture 35

getting-started-with-coding

Getting started with coding

By : Devansh Varshney

Lecture 27

superb-python-course-become-certified-python-developer

Superb Python Course - Become Certi...

By : Paul Carlo Tordecilla

Lecture 91

c-from-the-beginning

C# from the beginning

By : Igor Evdokimov

Lecture 31

Sign up and start learning
By signing up, you agree to our Terms of Use and Privacy Policy
Forget Password