Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
SQL Clearly Explained, Third Edition (The Morgan Kaufmann Series in Data Management Systems)

Buy

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. The second edition of this book included some material about the object-relational extensions. However, that set of commands has been greatly extended and the new edition takes that into account. The XML extensions are entirely new to the third edition. A chapter on basic relational concepts will be also added to broaden the audience and make the book more complete in its own right.

All of the chapters will be revised to be sure they are up to date. Chapter 10 ("Views, Temporary Tables, and Indexes") from the second edition will be expanded to include common table expression (CTEs). The material in the existing Chapter 14 ("Unimplemented SQL-92 Features 251") will be disbursed through the chapters where the particular type of operation is discussed. While the content throughout will be updated where necessary, the existing organizational structure through chapter 14 will remain largely intact because this coverage represents the stable portion of the SQL language.

There will be two NEW chapters at the beginning of the book. Chapter 1 ("The Relational Data Model") covers the relational data model conceptual material; Chapter 2 ("Manipulating Relations with Relational Algebra") covers the relational algebra material that will be pulled from the retrieval chapters. Part 5 ("Non-relational SQL Extensions") will now include the non-relational SQL extensions in three chapters. Chapter 17 (NEW) will cover XML. Chapter 18 will contain the object-relational conceptual material from the original chapter 15 and chapter 19 (NEW) will cover SQL object-relational support. (Some of chapter 19 will come from the second edition, however, a great deal of object-relational support has been added to the current standard and therefore needs to be added.) The other NEW chapter is Chapter 14, which covers triggers and stored procedures. This material was missing from previous editions. Many readers should find it a useful addition.

  • 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
(HTML tags aren't allowed.)

Hacking the Human
Hacking the Human

Information security is about people, yet in most organizations protection remains focused on technical countermeasures. The human element is crucial in the majority of successful attacks on systems and attackers are rarely required to find technical vulnerabilities, hacking the human is usually sufficient.Ian Mann turns the black art of...

UML for Mere Mortals(R)
UML for Mere Mortals(R)

Need to get results with UML...without unnecessary complexity or mind-numbing jargon? You need UML for Mere Mortals®. This easy-to-read introduction is perfect for technical professionals and business stakeholders alike: anyone who needs to create, understand, or review UML models, without becoming a hard-core modeler.

...
Just the Arguments: 100 of the Most Important Arguments in Western Philosophy
Just the Arguments: 100 of the Most Important Arguments in Western Philosophy

Does the existence of evil call into doubt the existence of God? Show me the argument. Philosophy starts with questions, but attempts at answers are just as important, and these answers require reasoned argument. Cutting through dense philosophical prose, 100 famous and influential arguments are presented in their essence, with...


Integrating PHP Projects with Jenkins
Integrating PHP Projects with Jenkins

Today's web applications require frequent updates, not just by adding or upgrading features, but by maintaining and improving the software’s existing code base as well. This concise book shows PHP developers how to use Jenkins, the popular continuous integration server, to monitor various aspects of software quality...

Delphi in a Nutshell
Delphi in a Nutshell

Aimed at the working Delphi developer, Delphi in a Nutshell is an effective desktop reference to this popular programming tool. Besides listing all core classes and methods, this book also provides a host of expert dos and don'ts for mastering the newest features in Delphi's Object Pascal.

The heart of this book is...

Athletic Scholarships For Dummies
Athletic Scholarships For Dummies

Get insider tips on navigating the recruitment process

Find the right school, the right program, the right coach, and the most money

You're prepared for challenges on the athletic field. But are you prepared for the challenges of winning an athletic scholarship? Let this friendly guide be your coach. It
...

©2021 LearnIT (support@pdfchm.net) - Privacy Policy