This is a course like no other. This course takes you from zero to hero in 14 simple steps
I have broken down the basics of Software development , designed a simple database and build an application from scratch to the end. In this course , we are doing the following:
A discussion of what content you may want to store in a database of Covid-19 patients.
Create a database
Create a table
Create fields to hold different attributes of a patient e.g. Name, Date of Birth etc.
Create a form. This is the user interface where records can be captured. In this section, you will learn how to relate a database and the interface
Finally, we are handling the famous CRUD acronym
- Create
- Retrieve
- Update
- Delete
Create - This is inserting records into the database. A user captures information into a form and clicks on the save button. The INSERT commands sends that information to the database.
Retrieve - Once the data is stored. You will want to display it somewhere. SELECT command is responsible for the same.
Update - Sometimes, the data that is in the database needs to be changed or updated. UPDATE statement is used for that purpose.
Delete - The unwanted records have to be removed. DELETE command in this case is used.