SQL Benefits and Features

SQL is both a comprehensive utility and an easy-to-understand language for computer database management.

Here’s a list of the market forces and major features that have made SQL immensely successful:

  1. Vendor independence
  2. Portability across computeer systems,
  3. SQL standards
  4. IBM endorsement (DB2)
  5. Microsoft Commitment
  6. Relational foundation
  7. High-level, English-like structure
  8. Interactive, ad hoc queries
  9. Programmatic database access
  10. Multiple views of data
  11. Complete database language
  12. Dynamic database definition
  13. Client/server architecture
  14. Extensibility and object technology
  15. Internet database access
  16. Java integration (JDBC)

These are the prominent reasons behind SQL emerging as the standard computer database management tool minicomputers, personal computers, mainframes as well as handheld devices.

There are many Database Management Systems (DBMS) that help develop and maintain databases. The most widely used are: Microsoft SQL Server, Oracle, MS Access, Sybase. The programming language used in coding databases is SQL. It stands for Server Query Language. In the name of a language word “Server” means that the database is stored on some sort of server to make it available to more users.

This hands-on tutorial with exercises will introduce you to some basic commands: CREATE TABLE, INSERT, SELECT, UPDATE, DELETE, and DROP.