APIs and Databases

In the first lesson of this course, students create a page that tracks the position of the international space station in real-time while learning the concept of an API. They make API requests to fetch the longitude and latitude of the space station. In addition, they also get a count of total astronauts currently in the outer sky.

In this lesson, students learn the difference between a browser and third-party APIs. They witness how they have been using a browser API for a long time. They reveal the webcam stream into a video tag using the in-built browser APIs and add filters on it using CSS. The magical part about this app is that the video tag is placed in such a way, that it looks like your face is on a poster!

In this lesson, students send data to APIs along with the request using data parameters. It filters the API response to exactly what’s needed, instead of getting all the responses. While learning how to do this they build a quiz app using the Open Trivia database API. 

In this lesson, students explore a way to send a request to an API from Python. They are introduced to the requests module of Python. By the end of this class, they create sleek ASCII text. They get a different ASCII font every time on page load using the random module.

In this lesson, students start with the concept of data and how it is everywhere. They look behind the scenes at how data is stored in a database. Students learn how to interact with a database using SQL. They explore a database with some data about movies. They retrieve, sort, and insert new data into the existing table.

In this lesson, students learn how to create a database. They also learn about different data types and the query to create a new table. By the end of this lesson, they are able to save user details like first name, last name, and age in the database. To make it more exciting, they use a random user API to generate a dummy date for as many users as they want.

In this lesson, students work in a school database. They learn how to filter the data by column and row. They use the where condition to filter the data by row. Also, students learn about logical operators And, Or to add multiple conditions in a where statement. In addition to that, they update the grades of students depending upon their marks using an update query.

In this lesson, students analyze the database structure of the CodeWizardsHQ platform. They start with a simplified version of the database that saves the student names with a course and instructor. While working on it, they come across a problem where they have to update the data, but there’s no unique value to identify it. To fix that, they learn about the primary key and auto-increment properties to generate a unique id for each student.

In this lesson, students learn about the CRUD concept. It is an acronym for Create, Retrieve, Update, and Delete. These are the four basic operations that we perform on the data. With this lesson, students complete all four concepts by learning about the delete query. As a bonus, they also learn how to delete an entire table from the database.

In this lesson, students work with a sample database with thousands of music tracks and more. They learn how to show a large amount of data in blocks instead of all at once. In addition to that, we introduce data grouping functions to them. They use the count and sum function to generate some interesting facts about the database.

In this lesson, the students begin part 1 of the final project by continuing with their Online Gym app from a previous course that can have real users. The project is divided into two parts: handling users’ data and handling tasks’ data. Students focus on the user’s part and implement signup and login.

In the final lesson of this course, students complete what they started in the previous lesson. Students complete the signup functionality in the previous lesson. They work on integrating it with the timer app. They work on the login functionality and the ability to save the complete tracking in the database. As a bonus, they add a button to clear all previous tracking.