Chapter 7. SQL
Information in this chapter:
• SQL: A Short Introduction
Abstract
Structured Query Language (SQL) is a common language for directly interacting with databases and comparable systems. Although the database management systems available today have their particular quirks, SQL possesses the benefit of providing one major interface to many nonhomogeneous database management systems. Using basic SQL queries, it's possible to write and receive data from a MySQL database or an Oracle, PostgreSQL, or Microsoft SQL database. But SQL is not only about fetching data from a database table or comparable storage engine. It is also about including data manipulation, triggering structural changes to the database, granting and revoking privileges for ...