Databases, SQL and MySQL

A database consists of data that is structured in a certain order or according to a set of pre-defined rules. An example from the real world would be a phone book which contains information about the subscribers - names, addresses, phone numbers. The information in the phone book is structured in an alphabetical order and this allows us to quickly find any number as long as we know the subscriber's names. The alphabetical order is an advantage since it saves time while we are looking for a given subscriber.

In computer systems, a database is a structured collection of data. The specific structure is defined by the way the data is organized, which depends on the database model used. The most commonly used model today is the relational database model.

In order to manage the information stored in a database, a set of tools is required. Such a set is the SQL language. SQL stands for Structured Query Language and is meant for database management purposes. The database management process is related to various database operations such as retrieving, adding, removing, changing and updating data.

MySQL is one of the most widely used relational database management systems (RDBMS). It is being used for various web-based applications. It provides reliable mechanisms through which the information stored in a database can be managed.

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

503 valid RCPT command must precede DATA

1. Pop before smtp - check your email for new mail before trying to send email. This adds your...

Which files can be executed with crontab

Which files can be executed with crontab There are no specific file types that can or cannot be...

What is web hosting?

What is web hosting? Upon seeing this question you may say what an odd question and everyone...

What is SSI and how to activate it

What is SSI and how to activate it SSI (Server Side Includes) are directives that are placed...

How do I test my Web Site before moving the domain name to my new server?

Once your have your web site configured on your new server (or hosting account), you should test...

Powered by WHMCompleteSolution