Database plays a key role in maintaining information and provide app required data when we call an api or can store information when saved.

It’s a general scenario we see mostly but creating a database is not so rocket science as it might appear for the novice follow this tutorial carefully and within no time you will be a pro in dealing with databases as well as api management.

This tutorial will not only help you learn MYSQL, PHP but it boosts your confidence, how ? by letting you learn from basics adding interesting video tutorials which can be understood through out the world.

So why late lets get through today’s topic

 

 

CRUD Operations

Basically the mostly performed operations and more most important topic for a beginner to know regarding the database tutorial.

C -> Create

R-> Read

U-> Update

D-> Delete

 

Create

For creating a database and tables inside the database we use this operation.And to clarify one point a database can have more than one table.

 

Read

For reading values from database we use this operation and also we can pass a key value to fetch the particular data and process.You can clearly see this in the tutorial playlist provided.

 

Update

For updating the current values in the database we use this operation.Similar to read operation we can pass a key value to update particular row.

 

Delete / Drop

This operation is used for deleting a row from table, or entire table or even sometimes dropping a database.So its risky operation if not used correctly.We can pass a parameter key to delete the selected row / table/ database.

 

Delete:

 

Drop:

 

For more information and complete details visit the video tutorial below

 

Show Buttons
Hide Buttons
Read previous post:
Android Kotlin Tutorials on Variables

Close