SQL : The Complete Reference, Second Edition

It's a very good transportation service. The item arrived here much earlier than I expected. This is my first time purchase from amazon and I regard it as a very good online shopping now.Thanks The Most Comprehensive SQL Resource AvailableGet in-depth details on all the powerful features and capabilities of SQL inside this one-stop guide. Featuring broad coverage of every aspect of this leading database language, this book provides you with an overview of SQL then shows you how to retrieve and update data, program with SQL, use stored procedures, and much more. Covering emerging standards and new related technologies including XML, Web services, EJB, J2EE, and JDBC, this book will help you gain the knowledge and essential skills you need to effectively work with SQL. Comprehensive, organized, and practical, this is the ultimate guide to understanding and using SQL.Master SQL basics and use simple, multi-table, and summary queries Understand key concepts and the latest developments in relational database technology Set up and manage SQL-based databases and write programs to access them Create and use the sample database to run the SQL query examples in the book Find out about Xpath, Xquery, and other XML-based database query standards Discover how J2EE-based applications relate to data management Use and program SQL databases with application servers to create powerful Web applications Preview the future of SQL—including MySQL and the impact of XML and Web ServicesNOTE: due to the large amount of text and graphics, this eBook file is 18.3 MG. We recommend that you download this eBook using the fastest Internet connection at your disposal, otherwise you may notice a longer downloading time than usual.

The Most Comprehensive SQL Resource Available

Get in-depth details on all the powerful features and capabilities of SQL inside this one-stop guide. Featuring broad coverage of every aspect of this leading database language, this book provides you with an overview of SQL then shows you how to retrieve and update data, program with SQL, use stored procedures, and much more. Covering emerging standards and new related technologies including XML, Web services, EJB, J2EE, and JDBC, this book will help you gain the knowledge and essential skills you need to effectively work with SQL. Comprehensive, organized, and practical, this is the ultimate guide to understanding and using SQL.

•Master SQL basics and use simple, multi-table, and summary queries

•Understand key concepts and the latest developments in relational database technology

•Set up and manage SQL-based databases and write programs to access them

•Create and use the sample database to run the SQL query examples in the book

•Find out about Xpath, Xquery, and other XML-based database query standards

•Discover how J2EE-based applications relate to data management

•Use and program SQL databases with application servers to create powerful Web applications

•Preview the future of SQL—including MySQL and the impact of XML and Web Services

SQLis the standard tool/language for organizing, managing, and retrieving data stored by a database, and this one-step resource aims to cover all aspects about SQL. It contains a CD-ROM with four databases including SQL Server 2000, IBM DB2 Version 7.2, and mySQL. The resource shows how to set up and manage SQL-based databases and write programmes to access them. It also teaches how to use and programme SQL databases with application servers and the Web to create applications. This updated second edition includes coverage of XML and Web services, and of the popular open source database, mySQL and a look ahead at Yukon Thoroughly revised and updated, this comprehensive reference includes new sections on XML and Web services, updates on the latest databases--including IBM DB2 Version 7.2, SQL Server 2000, and Oracle 9i Release 2--and information on SQL capabilities, standards, programming, and usage. Original. (Beginner) "SQL: The Complete Reference provides an in-depth discussion of SQL fundamentals, modern SQL products, and SQLs role in trends such as data warehousing, "thinclient" architectures, and Internet-based e-commerce. This book is your one-stop resource for all you need to know about SQL."--BOOK JACKET. Learn all you need to know about SQL with this one-stop resource. Updated to include information on Web services and XML, this complete guide also comes with a Windows 2000- and XP- compatible CD containing 4 databases (SQL Server 2000, IBM DB2 Version 7.2, Sybase, and mySQL). Aims to help you learn you need to know about SQL. Including information on Web services and XML, this guide also comes with a Windows 2000- and XP- compatible CD, containing 4 databases (SQL Server 2000, IBM DB2 Version 7.2, Sybase, and mySQL). The SQL language and relational database systems based on it are one of the most important foundation technologies in the computer industry.