Thorough and updated coverage of database design and SQL for DB2 are the focus of this guide for the relational database-management system used on IBM i computer systems. Suitable for classroom instru
This Study Guide is targeted at IT professionals who are working towards becoming an Oracle Certified Associate in the PL/SQL developer track. The book provides information covering all of the exam t
SQL Injection Attacks and Defense, First Edition: Winner of the Best Book Bejtlich Read Award "SQL injection is probably the number one problem for any server-side application, and this book unequale
This book describes how the Oracle RDBMS arrives at an Execution Plan. This book covers useful tools useful for getting Explain Plans as well as useful Hints used to give directives to the Cost-Base
Providing the best solutions to Oracle customers, this comprehensive manual answers some of SQL's most exciting challenges. Covering all the elements of an Oracle query—including new features f
Transact-SQL, or T-SQL, is Microsoft Corporation's powerful implementation of the ANSI standard SQL database query language, which was designed to retrieve, manipulate, and add data to relational data
This textbook outlines the structure of Oracle?‥?s primary database language PL/SQL as a server-side Web scripting language for developing AJAX Web applications. It covers topics like Oracle SQL, Ora
With tools for gaining as many as 30 times the execution speed, this handbook educates database administrators on how to rewrite SQL into PL/SQL and how to use advanced Oracle bulk array processing t
In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzles—and then helps solve them with a variety of solutions and explanations. Joe d
Improve the performance of relational databases with indexes designed for today's hardware Over the last few years, hardware and software have advanced beyond all recognition, so it's hardly surprisi
This examination of how SQL functions on the iSeries considers at all possible environments, including the traditional 5250 green screen applications, the SQL scripting tool within iSeries Navigator,
PL/SQL is Oracles version of SQL, the industry standard for enterprise-level database interaction. Explains how to write powerful, flexible programs, and to automate a multitude of database tasks. The
Prepare for the Oracle Certified Associate SQL Certified Expert exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two
