O'Reilly logo

LPIC-1/CompTIA Linux+™ Certification All-in-One Exam Guide by Robb Tracy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing SQL Data

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.

How Databases Work

A database is a collection of information organized so that data can be quickly selected and retrieved based on a search query ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required