[#013]Data Manipulation
The process of adjusting data, make it organized and easier to read
Hey friend, it’s Me again! 🤗 Welcome to Hack a craft — a weekly email around tips that will help you hack a craft and a navigating framework.
Thanks for the feedback given, we encourage you to always share your thoughts and suggestion about our newsletter with us. I’m sorry this is coming late.
This newsletter is behind our usual schedule and I am so sorry for that. Here is a curated resource for a beginner starting his/her way into web engineering and software engineering.
The information you read when you visit a website has been organized and arranged in a manner that appears to your craving for information. You may have heard that information in its raw state is known as Data. Data is changing the way businesses carry out their day-to-day activity. Business decision-making to day-to-day communication, everything is dependent on data. And none of this is possible without transforming raw data into useful information.
Data manipulation is the process of changing data in order to make it more readable and organized. For example, you can arrange your book shelve alphabetically to expedite the process of finding useful books. Website owners can use web server logs to locate the most viewed web pages, traffic sources, and much more. Similarly, stockbrokers use data manipulation to forecast stock market trends.
Making data readable and understandable, you need a tool and that’s while I’m sending this newsletter. Data manipulation language helps you organize and move data in a database, Structured Query Language(SQL) is a commonly used Data manipulation language. SQL is used to update and retrieve data in a relational database.
When using SQL- for data manipulation, four functions can occur, namely:
- Select
- Update
- Insert
- Delete
These commands tell the database where to select data from and what to do with it.
To get started with data manipulation, you’ll want to understand the general steps and order of operations.
Again, I have curated a list of resources that will provide you with information for your decision in Data Manipulation.
Enjoy the journey!
Opportunities in Tech✍️🏾
Suggested Articles✍️🏾
Quote for the day
“Errors using inadequate data are much less than those using no data at all.” Charles Babbage
Book Recommendation📚📚
That's all for this letter. See you next week Sunday and stay safe! Please forward this email to your friends. If you've not subscribed yet, kindly subscribe below, and you can be a Patron.