SQL Clearly Explained

— —

Jan L. Harrington (Professor and Department Chair, Computer Science, Marist College, Hyde Park, NY, USA)

SQL Clearly Explained

Jan L. Harrington (Professor and Department Chair, Computer Science, Marist College, Hyde Park, NY, USA)

$74.95

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Morgan Kaufmann Publishers In
23 April 2010

Database programming; SQL Server & MS SQL

Series: The Morgan Kaufmann Series in Data Management Systems

SQL Clearly Explained, Third Edition, provides an in-depth introduction to using SQL (Structured Query Language). Readers will learn not only SQL syntax, but also how SQL works.

Although the core of the SQL language remains relatively unchanged, the most recent release of the SQL standard (SQL:2008) includes two sets of extensions: 1) support for object-relational databases and 2) support for XML. As a result, the set of standard SQL commands has been greatly extended and this new edition takes that into account.

This new edition includes updated tips and tricks to reflect the current concepts of SQL and XML standards; several new chapters covering object-relational and XML extensions; and an ancillary package that includes case studies, a syllabus, exams and more.

This book is intended for working SQL programmers, database administrators, database designers, database analysts, and application system developers as well as those who are developing new features for database management systems who want to know about user needs. This would include anyone working with electronic content in the relational database context but also XML. Web services, etc.

By: Jan L. Harrington (Professor and Department Chair Computer Science Marist College Hyde Park NY USA)
Imprint: Morgan Kaufmann Publishers In
Country of Publication: United States
Edition: 3rd Revised edition
Dimensions: Height: 235mm, Width: 191mm, Spine: 30mm
Weight: 990g
ISBN: 9780123756978
ISBN 10: 0123756979
Series: The Morgan Kaufmann Series in Data Management Systems
Pages: 480
Publication Date: 23 April 2010
Audience: Professional and scholarly , Undergraduate
Format: Paperback
Publisher's Status: Active

1. The relational data model2. Manipulating relations with relational algebra3. Introduction to SQL4. Simple SQL retrieval5. Retrieving data from more than one table6. Advanced retrieval operations7. Calculations and grouping queries8. Data Modifications9. Schemas and tables10. Views, temporary tables, CTEs and indexes11. Keeping the design up to date12. Users and access rights13. Users, sessions, and transaction manipulation14. Triggers and stored procedures15. Embedded SQL16. Dynamic SQL17. XML support18. The object-relational data model19. Object-relational support

Jan L. Harrington, the author of 30 books, including SQL, Clearly Explained (Academic Press), has been writing about databases since 1984. She is a professor and chair of the department of computer science and information systems at Marist College, where she teaches database design and management, object-oriented programming, data communications, and computer architecture.

Reviews for SQL Clearly Explained

"""This book functions as a very good tutorial, taking you from the basics through expert topics in a very straightforward manner."" --Bill Arledge, Consulting DB2 Product Manager ""SQL Clearly Explained is one of those rare books that delivers 100 percent what its title promises. If you need to use SQL on the job, and who doesn't, then this book should be on your desk."" --Craig S. Mullins, DB2 Consultant and IBM Information Champion, Mullins Consulting, Inc. ""This book is of great value to SQL practitioners. It also makes an excellent college-level text."" --Rudy Limeback, SQL Consultant, r937.com"