Web App DevelopmentCornell

Certificate Program

In this course, you will write programs to automate repetitive tasks within basic data sets. You will explore how to sort and order simple text using list structures within the Python programming language. By breaking down scripts and texts into smaller parts, you will discover how to accomplish larger tasks by tackling each individual piece. You will then practice automating these basic functions into fundamental building blocks that can be reused as you enhance and expand your coding vocabulary. By the end of this course, you will have built your own playable game that you can continue to iterate and improve as your programming knowledge grows.

You are required to have completed the following course or have equivalent experience before taking this course:

• How to Write Programs That Make Choices With Control Flow

Databases power things that we rely on every day of our lives, from displaying restaurant menus to processing payments to tracking likes and comments. These tasks require you to work with much more data than you may be used to, as real-life data sets can be extremely large and cumbersome. Using a database to organize your data allows you to work with it systematically and at scale.

This course provides you with the foundational knowledge for integrating databases into your programs and using them to read, write, store, and process data. You will cover the basics of working with files and complex data structures. You will explore important data formats like JSON and CSV, discover how to write database queries that extract information of interest from a database, and get an introduction to the SQL database programming language. With these new tools, you will be able to work with huge amounts of data that would otherwise be tedious and time consuming to process manually.

You are required to have completed the following courses or have equivalent experience before taking this course:

• How to Write Programs That Make Choices With Control Flow
• How to Write Functions to Automate Repetitive Tasks

In this course, you will begin to work with web services and applications that allow you to complete certain tasks online. As part of your coursework, you will write a program that connects and pulls data from the web. Expanding upon this, you will then scale your data collection to get large amounts of data in the form of a database, and you will use the data you collect to create your own web service. You will be introduced to a web framework called Flask that utilizes prepackaged HTML templates to allow you to systematically set up and operate your web service, enabling others to interact with your content.

The following course is required to be completed before taking this course:

• How to Write Programs That Work With Databases

Additionally, you are required to have completed the following courses or have equivalent experience:

• How to Write Programs That Make Choices With Control Flow
• How to Write Functions to Automate Repetitive Tasks

With the introduction of three more programming languages in this course, you will create interactive web applications that let users do things in their browsers, such as upload photos or play simple games. Using HTML, you can create the basic framework of a website, write CSS to decorate and style the site, and then see how JavaScript can be used to add engaging interactive elements. You will also get a chance to automate the HTML writing by using the Flask framework to more easily produce web page structures, allowing you to connect your apps to a database to generate bulk HTML content programmatically.

The following courses are required to be completed before taking this course:

• How to Write Programs That Work With Databases
• How to Develop Web Interfaces With Online Protocols

Additionally, you are required to have completed the following courses or have equivalent experience:

• How to Write Programs That Make Choices With Control Flow
• How to Write Functions to Automate Repetitive Tasks