For your Linux+/LPIC-1 exam, you need to be familiar with how to manage data within an SQL database. Implementing and managing an SQL database is a huge topic, much larger than we have time or space to delve into here. However, I will give you some basic installation steps and also show you how to add information to the database as well as how to retrieve information from it. To accomplish this, the following topics will be addressed in this part of this chapter:
• How databases work
• Installing MySQL
• Managing data in the SQL server
Let’s begin by discussing how SQL database work.
A database is a collection of information organized so that data can be quickly selected and retrieved based on a search query ...