Mastering SQL

This text instructs in the use of SQL, a programming and query language. It shows how to develop database applications, administer databases and work interactively with data. It gives explanations of relational database technology's conceptual underpinnings and it guides in an approach to problem solving that will help in the application of SQL techniques. In addition to the hands-on tutorial material, the book provides an SQL reference. The accompanying CD offers a collection of SQL compilers to try out and lets the reader test the examples in the book. The items covered include: developing applications that use SQL; designing and implementing databases; performing operations on data; analyzing and deriving data using complex queries; combining SQL with other languages; building applications that generate SQL dynamically; enforcing business rules on data; finding and correcting data anomalies; resolving concurrency issues; handling database errors programmatically; optimizing SQL operations; using dynamic and embedded SQL; and combining SQL and Java - SQLJ and JDBC