Data Manipulation
Table of contents
Introduction
When faced with several data from a database, it may seem not to make sense, till the data is manipulated. This means that data manipulation is imply presenting data in a way that is organized, easily read and information extracted comfortably from the source.transactionss we can apply various techniques that can be grouped into functions, transactions and locking.
Meaning and Uses of Functions
Functions are codes that are put in to get results or outcomes and it could be string functions, number functions or date function.
The string functions deal with ‘text data’, number functions operate data types while date function operates on date data.
Transactions are applied to a database, here we have two categories, the committed, where an action is applied to the data and a committed where the transaction is undone from the data base. This transaction removes the error of a partial operations, allowing a data analyst to carry out function and return them where needed.
Locking just like the name is simply locking a table to prevent it from being altered by anyone, this way you can share your database with your team without having to worry about the table being distorted.
Conclusion
It is advised that you study these various manipulations and apply them to your database while carrying out certain projects.
Have any contributions on learning more on this? Please use the comment section.