• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Step 3. Databases and SQL > Database Basics

Database Basics

A database is simply a collection of structured information with a common theme. You actually use databases all the time. For example, a telephone directory is a database of information about people, including their name, address, and phone number. Your date book is structured information (hopefully) about your appointments and the things you need to do. In terms of software, databases are used for keeping track of such things as employee information, asset registers, and of course, product information.

The advantage of a database system over using a word-processing document or spreadsheet to keep track of data is that information is easily manipulated, updated, and reused with a database system. For example, by using a database system to store employee information, we can easily perform tasks, such as sorting employees by name or department, searching for employees with more than five years of service, or updating employee contact details.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint