SQL Clearly Explained

2nd Edition

Authors: Jan Harrington Jan Harrington
Paperback ISBN: 9781558608764
eBook ISBN: 9780080517582
Imprint: Morgan Kaufmann
Published Date: 11th April 2003
Page Count: 352
72.95 + applicable tax
75.95 + applicable tax
45.99 + applicable tax
57.95 + applicable tax
6600.00 + applicable tax
Unavailable
Compatible Not compatible
VitalSource PC, Mac, iPhone & iPad Amazon Kindle eReader
ePub & PDF Apple & PC desktop. Mobile devices (Apple & Android) Amazon Kindle eReader
Mobi Amazon Kindle eReader Anything else

Institutional Access


Table of Contents

Part 1: Getting Started: Installing MySQL. Using the MySQL Client. Introduction to SQL. Part II: Performing Interactive Data Manipulation: Simple SQL Retrieval. Retrieving Data from More than One Table. Advanced Retrieval Operations. Calculations and Grouping Queries. Modifying Data. Part III: Managing Database Structure: Schemas, Domains, and Tables. Views, Temporary Tables, and Indexes. Part IV: Program-Based Data Manipulation. Users, Sessions, and Transaction Control. Embedded SQL. Dynamic SQL. Part V: Unimplemented Features in the SQL Standards: Unimplemented SQL-92 Features. Unimplemented SQL3 Features. Part VI: Appendices: The Online Bookstore Database. QLSTATE Return Codes. SQl Syntax summary.

Description

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.

Key Features

  • Second edition of classic SQL handbook
  • Updated to cover changes in the SQL language standard (SQL:1999)
  • Includes CD with MySQL software

Readership

db application developers, db administrators, SQL programmers, comp sci students


Details

No. of pages:
352
Language:
English
Copyright:
© Morgan Kaufmann 2003
Published:
Imprint:
Morgan Kaufmann
eBook ISBN:
9780080517582
Paperback ISBN:
9781558608764

About the Authors

Jan Harrington Author

Jan L. Harrington, author of more than 35 books on a variety of technical subjects, has been writing about databases since 1984. She retired in 2013 from her position as professor and chair of the Department of Computing Technology at Marist College, where she taught database design and management, data communications, computer architecture, and the impact of technology on society for 25 years.

Affiliations and Expertise

Professor and Department Chair, Computer Science, Marist College, Hyde Park, NY, USA

Jan Harrington Author

Jan L. Harrington, author of more than 35 books on a variety of technical subjects, has been writing about databases since 1984. She retired in 2013 from her position as professor and chair of the Department of Computing Technology at Marist College, where she taught database design and management, data communications, computer architecture, and the impact of technology on society for 25 years.

Affiliations and Expertise

Professor and Department Chair, Computer Science, Marist College, Hyde Park, NY, USA