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:
- Vendor independence
- Portability across computeer systems,
- SQL standards
- IBM endorsement (DB2)
- Microsoft Commitment
- Relational foundation
- High-level, English-like structure
- Interactive, ad hoc queries
- Programmatic database access
- Multiple views of data
- Complete database language
- Dynamic database definition
- Client/server architecture
- Extensibility and object technology
- Internet database access
- 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.