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

Algebra und Diskrete Mathematik 1: Grundbegriffe der Mathematik, Algebraische Strukturen 1, Lineare Algebra und Analytische Geometrie, Numerische Algebra
Algebra und Diskrete Mathematik 1: Grundbegriffe der Mathematik, Algebraische Strukturen 1, Lineare Algebra und Analytische Geometrie, Numerische Algebra
Algebra und Diskrete Mathematik gehören zu den wichtigsten mathematischen Grundlagen der Informatik. Dieses zweibändige Lehrbuch liegt jetzt in korrigierter zweiter Auflage vor und führt umfassend und lebendig in den Themenkomplex ein. Dabei ermöglichen ein klares Herausarbeiten von Lösungsalgorithmen, viele Beispiele,...
Adobe Photoshop for Underwater Photographers
Adobe Photoshop for Underwater Photographers
In a matter of a few short years, the underwater digital camera went from a novelty item to the predominant method for taking underwater pictures. Never before has a technology advanced so rapidly. Thanks to digital, though, underwater  photography has evolved into a shootto-edit process. Rather than having to get each image just right...
Adobe InDesign CS2 @work: Projects You Can Use on the Job
Adobe InDesign CS2 @work: Projects You Can Use on the Job

Adobe InDesign CS2 is a powerful, but complicated, page layout technology. Sure, learning how to use the various tools and techniques is important, but what you really need and want to know is how to put those tools and techniques to use to complete projects at work. That's where Adobe InDesign CS2 @...


The Brave New World of e-HR : Human Resources in the Digital Age
The Brave New World of e-HR : Human Resources in the Digital Age
"Technology is everywhere in our world. We see it everyday in activities such as banking, shopping, flying, entertainment, or communicating. We live with technology, and we are surrounded by it. We cannot escape its influence and how it shapes our lives. But work organizations are also as dependent on technology as we all are for our daily...
Semantic Web and Peer-to-Peer: Decentralized Management and Exchange of Knowledge and Information
Semantic Web and Peer-to-Peer: Decentralized Management and Exchange of Knowledge and Information
The Semantic Web and Peer-to-Peer are two technologies that address a common
need at different levels:

• The Semantic Web addresses the requirement that one may model, manipulate
and query knowledge and information at the conceptual level rather than at the
level of some technical implementation. Moreover, it pursues
...
Hands-On Data Structures and Algorithms with Python: Write complex and powerful code using the latest features of Python 3.7, 2nd Edition
Hands-On Data Structures and Algorithms with Python: Write complex and powerful code using the latest features of Python 3.7, 2nd Edition

Learn to implement complex data structures and algorithms using Python

Key Features

  • Understand the analysis and design of fundamental Python data structures
  • Explore advanced Python concepts such as Big O notation and dynamic programming
  • Learn functional...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy