Introduction to Python This lesson introduces students to the term “backend” and why we need it. They are introduced to basic syntax of the Python programming language while adding a leader board to a previous project, Treasure Hunt.
Sending Form Data One of the advantages while working with the backend is that multiple files can communicate with each other. In this class, students learn how to send data from a simple HTML form to a Python profile page. We use Python’s CGI module to implement this.
Introduction to Databases Database is a fundamental concept used to store user data on a server. All students get access to their individual database hosted on our server. Students are introduced to MySQL and learn about basic insert/retrieve queries in it.
Filtering Data The database provides us with an option to retrieve only a part of data from it. In this class, students learn how to filter by row and by column to get specific data. This class’s project imitates the behavior of the smart assistants like google assistant, Siri or Alexa.
Midterm Project Part I In these two classes, students are given a security problem in one of their previous projects. They fix this problem by saving the secure information in a database instead of writing directly in code.
Midterm Project Part II
Updating Data Existing data in a database can be modified by queries. Students get to know how to edit the existing data using an update query. They continue to work on their previous notepad project and add a database to it.
The Mysterious CRUD CRUD is an acronym for Create, Retrieve, Update and Delete. These are the standard operations we can perform on a database. Students have already implemented Create, Retrieve and Update query in MySQL. In this class, they complete all CRUD queries by learning the delete query.
Introduction to Hashing Hashing is a security concept widely used to protect user data from hackers. Every commercial app uses hashing in one form or another to encrypt user passwords. Students learn what goes on behind the scenes of encryption and hashing and how to implement them using Python.
Python Libraries Python has a wide range of libraries that can add exciting new features to the app. This lesson we introduce Python’s image manipulation library, Pillow, to students. They work on an avatar project and use Pillow to merge multiple images into one image.
Certification Project Part I In these two classes, students work on one of their previous project RemixTube (a YouTube clone). They add a playlist feature in the app. Each playlist will have a unique URL, which they can share with friends.