新生學校財團法人新生醫護管理專科學校圖書館 |

SQL clearly explained

Record Type:	Electronic resources : Monograph/item
Title/Author:	SQL clearly explained/ Jan L. Harrington.
Author:	Harrington, Jan L.
Published:	Burlington, MA :Morgan Kaufmann, : c2010.,
Description:	1 online resource (xvii, 462 p.) :ill. :
Notes:	Includes index.
Subject:	SQL (Computer program language) -
ISBN:	9780123756978

SQL clearly explained
Harrington, Jan L.

SQL clearly explained[electronic resource] /Jan L. Harrington. - 3rd ed. - Burlington, MA :Morgan Kaufmann,c2010. - 1 online resource (xvii, 462 p.) :ill. - The Morgan Kaufmann series in data management systems.

Includes index.

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.

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.

ISBN: 9780123756978

Source: 1093447:10557673Elsevier Science & Technologyhttp://www.sciencedirect.comSubjects--Topical Terms:

73218
SQL (Computer program language)
Index Terms--Genre/Form:

239592

LC Class. No.: QA76.73.S67 / H37 2010

Dewey Class. No.: 005.13/3

SQL clearly explained
LDR:04594cmm 2200397Ia 4500 001 166944
003 OCoLC
005 20111122091345.0
006 m d
007 cr cn|||||||||
008 160302s2010 maua o 001 0 eng d
019 $a 715190144 $a 720625226
020 $a 9780123756978
020 $a 0123756979
020 $a 9780123756985 (electronic bk.)
020 $a 0123756987 (electronic bk.)
029 1 $a AU@ $b 000045963938
029 1 $a NZ1 $b 13448958
035 $a (OCoLC)613958927 $z (OCoLC)715190144 $z (OCoLC)720625226
035 $a ocn613958927
037 $a 1093447:10557673 $b Elsevier Science & Technology $n http://www.sciencedirect.com
040 $a OPELS $b eng $c OPELS $d CDX $d OCLCQ $d N $d E7B $d YDXCP $d OCLCQ
049 $a TEFA
050 4 $a QA76.73.S67 $b H37 2010
072 7 $a COM $x 051310 $2 bisacsh
072 7 $a COM $x 051280 $2 bisacsh
072 7 $a COM $x 051130 $2 bisacsh
082 0 4 $a 005.13/3 $2 22
100 1 $a Harrington, Jan L. $3 73168
245 1 0 $a SQL clearly explained $h [electronic resource] / $c Jan L. Harrington.
250 $a 3rd ed.
260 $a Burlington, MA : $c c2010. $b Morgan Kaufmann,
300 $a 1 online resource (xvii, 462 p.) : $b ill.
490 1 $a The Morgan Kaufmann series in data management systems
500 $a Includes index.
505 0 $a 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.
520 $a 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.
588 $a Description based on print version record.
650 0 $a SQL (Computer program language) $3 73218
650 7 $a COMPUTERS $x Programming Languages $x C?2bisacsh# $3 257077
650 7 $3 72593
655 4 $3 239592
830 0 $3 239589