SQL Clearly Explained (The Morgan Kaufmann Series in Data Management Systems)

by JanL.Harrington (Author)

• Used

  Paperback
  2003

  $3.25

  This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how to use it effectively. Packed with tips, tricks, and good information, SQL Clearly Explained, Second Edition teaches database users and programmers everything they need to know to get their job done including * formulating SQL queries, * understanding how queries are processed by the DBMS, * maximizing performance, * using SQL to enter, modify, or delete data, * creating and maintaining database structural elements, and * embedding SQL in applications. Features * Updated and expanded to include changes in the SQL standard (SQL:1999) as well as recently implemented aspects of SQL-92. * Includes CD with examples from the book as well as MySQL, a popular open-source DBMS, on which the examples are based. * Web enhanced with extra features available online at www.mkp.com.

• Used

  Paperback
  1998

  $15.75

  Written with both beginner and intermediate database developers in mind, this clear, concise guide teaches readers about the relationships between the distribution of data in a database and the way in which queries of various types are processed. SQL (structured query language) is a complete data manipulation language for relational databases that allows users to modify database structure (tables, views, and indexes), as well as modify and retrieve data. The book teaches not only SQL syntax but also explains the proper structure of SQL queries and how a query affects the SQL processor and system performance.