In the previous chapter, we have discussed basic operations that can be performed on MariaDB such as creating databases and tables, adding data, modifying data, deleting data, and retrieving the data. We have also worked with the basic techniques of sorting and filtering data in order to work with the targeted and specific datasets. In this chapter, we will work with the following advanced concepts:
Let's begin by making a few changes to the existing
students table. We will be adding two columns to the
students table that would store a student's username and password. This database will be used to support
Student Portal that we will ...