SQL Clearly Explained
35%
off

SQL Clearly Explained

3.8 (5 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 11 business days
When will my order arrive?

Description

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.
show more

Product details

  • Paperback | 480 pages
  • 190.5 x 228.6 x 30.48mm | 975.22g
  • Morgan Kaufmann Publishers In
  • San Francisco, United States
  • English
  • 3rd edition
  • Illustrated; Illustrations, unspecified
  • 0123756979
  • 9780123756978
  • 90,139

Table of contents

Chapter 1: The relational data model

Chapter 2: Manipulating relations with relational algebra

Chapter 3: Introduction to SQL

Chapter 4: Simple SQL retrieval

Chapter 5: Retrieving data from more than one table

Chapter 6: Advanced retrieval operations

Chapter 7: Calculations and grouping queries

Chapter 8: Data Modifications

Chapter 9: Schemas and tables

Chapter 10: Views, temporary tables, CTEs and indexes

Chapter 11: Keeping the design up to date

Chapter 12: Users and access rights

Chapter 13: Users, sessions, and transaction manipulation

Chapter 14: Triggers and stored procedures

Chapter 15: Embedded SQL

Chapter 16; Dynamic SQL

Chapter 17: XML support

Chapter 18: The object-relational data model

Chapter 19: Object-relational support
show more

Review Text

"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
"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
show more

Review quote

"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
show more

About Jan L. Harrington

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.
show more

Rating details

5 ratings
3.8 out of 5 stars
5 20% (1)
4 40% (2)
3 40% (2)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X