Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
SQL The Complete Reference, 3rd Edition


Get comprehensive coverage of every aspect of SQL from three leading industry experts. Revised with coverage of the latest RDBMS software versions, this one-stop guide explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications. 

SQL: The Complete Reference, Third Edition shows you how to work with SQL commands and statements, set up relational databases, load and modify database objects, perform powerful queries, tune performance, and implement reliable security policies. Learn how to employ DDL statements and APIs, integrate XML and Java scripts, use SQL objects, build web servers, handle remote access, and perform distributed transactions. Techniques for managing in-memory, stream, and embedded databases that run on today's mobile, handheld, and wireless devices are included in this in-depth volume.

  • Build SQL-based relational databases and applications
  • Create, load, and modify database objects using SQL
  • Construct and execute simple, multitable, and summary queries
  • Implement security measures with authentication, privileges, roles, and views
  • Handle database optimization, backup, recovery, and replication
  • Work with stored procedures, functions, extensions, triggers, and objects
  • Extend functionality using APIs, dynamic SQL, and embedded SQL
  • Explore advanced topics such as DBMS transactions, locking mechanisms, materialized views, and two-phase commit protocol
  • Understand the latest market trends and the future of SQL
About the Author

James R. Groff is senior vice president of business strategy at Oracle Corporation. He is a SQL expert whose SQL-oriented software company, TimesTen Performance Software, was acquired by Oracle in 2005.

Paul N. Weinberg is senior vice president of NetWeaver MDM at SAP. He is a SQL expert whose SQL-oriented software company, A2i, Inc., was acquired by SAP in 2004. Weinberg is the bestselling author, with James Groff, of the previous editions of this book.

(HTML tags aren't allowed.)

Structural Engineer's Pocket Book
Structural Engineer's Pocket Book
Until now there has been no comprehensive pocket reference guide for professional and student structural engineers. The Structural Engineers Pocket Book is a unique compilation of all table, data, facts, formulae and rules of thumb needed for scheme design by structural engineers in the office, in transit or on site.

By bringing together
Working with Microsoft Dynamics(TM) CRM 3.0
Working with Microsoft Dynamics(TM) CRM 3.0
Get a practical, hands-on introduction to the fundamentals of adapting Microsoft CRM 3.0 to meet your specific business needs. With topics that include developing new functionality, designing implementations, and integrating Microsoft CRM with other business applications—including Microsoft Office OutlookВ® and Microsoft...
Developing Change Leaders
Developing Change Leaders

Implementing change is a major business challenge. Is your leadership up to the task?

With change initiatives failing so frequently despite many books on the market addressing separately the topics of leadership and change management, Developing Change Leaders tackles in one concise volume the...

Oracle9iR2 Data Warehousing
Oracle9iR2 Data Warehousing

Oracle9IR2 Data Warehousing is a guide to using the Data Warehouse features in the latest versions of Oracle—Oracle9i Release 1 and Release 2. Written by people on the Oracle development team that designed and implemented the code, this updated and expanded edition provides an insider’s view of how the Oracle9i Release 2...

Photoshop CS3 for Screen Printers (Wordware Applications Library)
Photoshop CS3 for Screen Printers (Wordware Applications Library)
There are between 20,000 and 30,000 registered screen printing companies in the U.S. and many thousands more worldwide. Additionally, there are thousands of companies that are run from backyards, garages, and storage facilities. All of these screen printing companies have one thing in common—they all use some type of graphics program to...
iPhone and iPad Apps for Absolute Beginners, iOS 5 Edition
iPhone and iPad Apps for Absolute Beginners, iOS 5 Edition

The iPhone is the hottest gadget of our generation, and much of its success has been fueled by the App Store, Apple’s online marketplace for iPhone applications. Over 1 billion apps were downloaded during the nine months following the launch of the App Store, ranging from the simplest games to the most complex business apps....

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