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

Buy

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.)

Networked Control Systems: Theory and Applications
Networked Control Systems: Theory and Applications
Networked control systems (NCS) consist of sensors, actuators and controllers the operations of which may be distributed over geographically disparate locations and co-ordinated by the exchange of information passed over a communication network. The communication network may be physically wired or not. The widespread applications of the Internet...
General, Organic, and Biochemistry
General, Organic, and Biochemistry

The ninth edition of General, Organic, and Biochemistry is designed to help undergraduate health-related majors, and students of all other majors, understand key concepts and appreciate the significant connections between chemistry, health, disease, and the treatment of disease. This text continues to strike a balance between...

Common English Mistakes Explained With Examples: Over 300 Mistakes Almost Students Make and How To Avoid Them In Less Than 5 Minutes A Day (Book 1)
Common English Mistakes Explained With Examples: Over 300 Mistakes Almost Students Make and How To Avoid Them In Less Than 5 Minutes A Day (Book 1)

Speak and write English as if it were your native tongue!

- Do you usually make mistakes in English?

- Do you feel tired of making the same mistakes in English again and again?

- Would you like to learn how to avoid and correct those typical mistakes so you are...


Mastering IBM i: The Complete Resource for Today's IBM i System
Mastering IBM i: The Complete Resource for Today's IBM i System

The IBM i operating system running on IBM Power Systems is a platform in transition. Many think the system is obsolete, largely due to its infamous green screen. Nothing, though, could be further from the truth. When IBM embraced open-source software such as Linux, MySQL, and Zend PHP, the system cemented a formidable position in...

Beginning iPhone Development with Swift: Exploring the iOS SDK
Beginning iPhone Development with Swift: Exploring the iOS SDK

The team that brought you the bestselling Beginning iPhone Development, the book that taught the world how to program on the iPhone, is back again for Beginning iPhone Development with Swift.This definitive guide is up to date with Apple's new Swift programming language and the latest and greatest iOS 8 SDK, and Xcode...

Deep Learning with TensorFlow: Explore neural networks and build intelligent systems with Python, 2nd Edition
Deep Learning with TensorFlow: Explore neural networks and build intelligent systems with Python, 2nd Edition

Delve into neural networks, implement deep learning algorithms, and explore layers of data abstraction with the help of TensorFlow.

Key Features

  • Learn how to implement advanced techniques in deep learning with Google's brainchild, TensorFlow
  • Explore deep neural...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy