Interactive Data Curriculum
Learning about tables and queries can get boring but what if it’s taught in the context of real-world programming?
Data is like a fuel to tech industry but learning about databases often mean dealing with mundane tables and boring queries. We believe that happens if you teach databases without the context of its application in programming. In this course, we teach interaction with databases while building interesting projects in each lesson. This way we not only keep the student’s interest but we also help them integrate their database knowledge with their programming knowledge. An integration that one would expect from every real-world programmer.
- Data is Everywhere (Project: Movie Database)
We make students see for themselves that data is in fact, everywhere. Whenever they like on Facebook, comment on Instagram or search on Youtube, they generate, update and receive data. Having inspired about its importance, we show them how to do the same data interactions that they see everywhere in a database of their own.
- Let’s create Data (Project: Shopping Database)
Students start by learning how to import database functionalities in python. They learn how to connect to a new database or use an existing one, and by the end of this class, students use SQL queries to create a fun shopping database. They insert different types of data and multiple sets of values in a table that they build from scratch.
- Let’s filter Data (Project: Shopping Database Filtered)
We interact with gigabytes of data every day, and the main advantage of using a modern database management system is the power to filter and handpick data relevant to a single user. That’s what makes the internet exciting and personal. In this lesson, students master the use of logical operators, relational operators and “where” keyword to filter data from the shopping database they created in previous class.
- Let’s change Data (Project: To Do List)
Data mirrors the world in digital form, and the world is not static. It keeps on changing every day, so data needs to keep up too, a.k.a it needs to be updated. In this lesson, while building a database driven To Do List; students learn how to update single or multiple rows of data based on certain conditions. They also learn about primary keys, auto-incrementing fields and more that helps in their project goals.
- C.R.U.D. Tales (Games Scoreboard)
We introduce students to the most common technical term used in the database world called “CRUD” which stands for Create, Retrieve, Update and Delete. Students apply these four concepts via python methods and functions while learning about what goes behind the scoreboard they see every time they play or watch a game.
- Mid-Term Project Part I
- Mid-Term Project Part II
The midterm project focuses entirely on revising what students have mastered in the previous lessons and integrating that knowledge as one single python project called notebook (a digital note-taking app). They begin with importing database functionality in python to create a new database and move on to create a new table and insert values in it. Once the connection to the database has been set up, they use AJAX to apply all the fundamental operations on the database including constraints and conditions used for filtering data.
- Let’s aggregate data (Chinook.db – working with real-world data)
Until this class students have been working with toy databases of a small size. It has been great for learning, but it’s time to work with a real database. Chinook.db is a database that has data about thousands of music tracks and dealing with such huge databases requires an entirely different set of tools. Students learn the concepts of data aggregation, Count, Max, Min, Avg, Limit and much more while having fun with a repository of musical knowledge that’s at their disposal.
- Let’s filter data-II: (Chinook.db – working with real-world data continued)
Showing data in a meaningful way is an art in itself. In this lesson, students analyze the use of the || (OR) operator, “AS” keyword and “NULL” keyword to make their output more presentable and meaningful. They learn to use “AND” keyword and CASE statements to filter and label columns the way they want.
- Let’s join data (University Database Project)
Joins are one of the most advanced features of database management systems. With inner and outer joins, students pull data from multiple tables at once using complex statements and join them to be shown as one meaningful presentation of data. Being able to make proper joins is the key skill of professional database administration. It’s like earning a black belt in interacting with databases.
- Final Project Part I
- Final Project Part II
It’s time to integrate all these fantastic concepts that students have learned about data and databases into one single project. In this project, students transform their knowledge from the past 12 weeks into one practical piece of code that they can show off to prove that they now have mastery over data interactions.