Database Reference
In-Depth Information
Part C
The Structured Query
Language
The next six chapters will focus on the Structured Query Language (SQL). This
language has become the universal standard database language. It is therefore
imperative that as a student of computer science, or a practicing IT professional,
you are not just familiar, but have a working knowledge of the language. The
objectives of this division are:
to provide a solid overview of SQL as a database language;
•
•
to help you gain a good working knowledge of the main
SQL data definition statements;
to help you gain a good working knowledge of the main
•
SQL data manipulation statements;
to help you gain insights and a good working knowledge
•
of logical views and system database security;
to discuss and illustrate the importance and usefulness of
•
the system catalog;
to discuss some limitations of SQL.
•
Chapters to be covered include:
Chapter 10 — Overview of SQL
•
•
Chapter 11 — SQL Definition Statements
•
Chapter 12 — SQL Data Manipulation Statements
•
Chapter 13 — Logical Views & Security
•
Chapter 14 — The System Catalog
•
Chapter 15 — Some Limitations of SQL