Mastering SQL (W/CD) 01 Edition

0.0

Mastering SQL is the ideal resource for all your SQL programming needs. Comprehensive authoritative and product independent this book offers a practical approach to this all-important programming and query language. Inside you'll learn SQL by using SQL--to develop database applications administer databases and work interactively with data. As you go you'll benefit from the author's clear explanations of relational database technology's conceptual underpinnings and you'll acquire an approach to problem solving that will help you apply SQL techniques as effectively as possible. The book assumes no prior background but covers the language thoroughly. In addition to the hands-on tutorial material the book provides a complete SQL reference. This is not a book you will quickly outgrow. Coverage includes: 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 Combining SQL and Java -- SQLJ and JDBC