SQL Clearly Explained by Jan L. Harrington
(The Morgan Kaufmann Series in Data Management Systems)

No critic rating

Waiting for minimum critic reviews

See Reader Rating

Synopsis

SQL 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. Understanding the how as well as the what will aid in creating SQL statements that execute as quickly as possible.
The book is organized into five parts. Part I presents the theoretical material underlying relational databases and SQL. Part II covers interactive SQL retrieval. Part III discusses the creation and management of database structure. It also covers non-data elements in the database environment, such as managing users/user accounts and transaction control. Part IV introduces several techniques for SQL programming: embedded SQL (using a high-level host language), dynamic SQL, and triggers/stored procedures. Part V discusses the non-relational extensions that have been added to the SQL standard: XML and object-relational capabilities. It covers object-oriented concepts, including the differences between pure object-oriented databases and object-relational databases. It also looks at SQL's object-relational features.

Demonstrates how to formulate SQL queries and how queries are processed to maximize performance of the database management system

Explains use of SQL to enter, modify or delete data to maintain database structural elements

Covers in great detail new SQL application for XML to meet the growing XML usage in development of online content

 

About Jan L. Harrington

See more books from this Author
Andy Ihnatko describes himself as "the world's 42nd most-beloved industry personality" because "it's vaguely credible but utterly impossible to prove or disprove, and thus precisely the sort of tagline I was looking for." An unabashed geek ("The bashings ended when I left high school for Rensselaer Polytechnic, thank God"), Andy's been writing about tech since 1989. In the past, he's written for every single magazine or website with the word "Mac" in it, highlighted by 10 years as MacUser and then Macworld's back-page opinion columnist. He's currently the "Chicago Sun-Times"' technology columnist. In his pursuit of "heroically stupid applications of technology," Andy has built an animatronic Darth Vader doll that could be controlled over the Internet via telepresence to hassle his roommate's cats and written and published a complete set of plans and instructions for converting any Classic-style Macintosh into a fully functional 2.5-gallon aquarium. "The Original MacQuarium" was one of the Internet's first e-Books and can be downloaded from several sites after a quick Google search. This is Andy's fourth book. Andy lives in Boston with his two goldfish, Click and Drag. He invites you to visit his aptly named "Colossal Waste Of Bandwidth" at www.andyi.com. Dr. Jan L. Harrington has been working with and writing about the Macintosh since March 1984. In her day job, she is Associate Professor and Chair of the Department of CS/IS/IT at Marist College, where she carries the torch for Macintosh users with great enthusiasm. Her 30+ published books include more than a dozen Macintosh-specific titles, including several on various flavors of the Macintosh OS.
 
Published May 28, 2003 by Morgan Kaufmann. 480 pages
Genres: Computers & Technology, Education & Reference. Non-fiction

Reader Rating for SQL Clearly Explained
80%

An aggregated and normalized score based on 20 user ratings from iDreamBooks & iTunes


Rate this book!

Add Review
×