* Gives programmers two-in-one coverage, with both a “how-to” on SQL functions and a complete SQL functions reference
* SQL is the standard language for database queries; this book’s advanced coverage helps programmers write their own SQL functions
* Covers both the internationally standardized SQL 99 functions and the hundreds of additional functions introduced by vendors, including the subtle variations required to successfully migrate or interoperate between vendor products
* Covers the latest versions of the major relational database management system (RDMS) applications: Microsoft SQL Server, Oracle, IBM DB2, and MySQL

Download Here

Like most PL/SQL programmers, you’ve found Oracle PL/SQL Programming to be a reference book you can’t do without. Packed with examples and recommendations, it’s a book that has helped everyone, from Oracle Forms developers to database administrators, make the most of PL/SQL. But you can’t always carry it with you, and even at your desk there are times when you just need a reminder, a quick answer to a problem you’re up against. For times like those, PL/SQL experts Stephen Feuerstein, Bill Pribyl, and Chip Dawes have written a new edition of Oracle PL/SQL Language Pocket Reference. Updated for Oracle9i, this little book is easy to take with you and use anywhere for quick problem solving.

The second edition of the Oracle PL/SQL Language Pocket Reference boils down the most vital information from Oracle PL/SQL Programming into a convenient quick reference to PL/SQL basics. This compact book will be indispensable for new and seasoned Oracle database developers alike. It summarizes features available in Oracle9i and provides essential information on PL/SQL block structure, fundamental language elements, control statements, and use of procedures, functions, packages, triggers, Oracle objects, external procedures, and methods of calling Java classes from PL/SQL.

O’Reilly’s Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you’ve reached a sticking point in your work and need to get to a solution quickly, the new edition of Oracle PL/SQL Language Pocket Reference is the book you’ll want to have.

Download Here

Securing SQL Server is one of the most important responsibilities of the SQL Server professional. Ensuring your data are safe requires a combination of good systems and database administration, and intelligent application design - weaving a security plan that matches the capabilities and vulnerabilities of each contributing part.

But at its root, security is concerned with controlling access - authenticating who can access the data on the server, authorizing what users can do with those data, and securing data as they are transported. These core topics are the focus of this book.

Download Here

This is the second edition of the popular practitioner’s guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how to use it effectively. Packed with tips, tricks, and good information, SQL Clearly Explained, Second Edition teaches database users and programmers everything they need to know to get their job done including
· formulating SQL queries,
· understanding how queries are processed by the DBMS,
· maximizing performance,
· using SQL to enter, modify, or delete data,
· creating and maintaining database structural elements, and
· embedding SQL in applications.

Features
· Updated and expanded to include changes in the SQL standard (SQL:1999) as well as recently implemented aspects of SQL-92.
· Includes CD with examples from the book as well as MySQL, a popular open-source DBMS, on which the examples are based.
· Web enhanced with extra features available online at www.mkp.com.

* Second edition of classic SQL handbook
* Updated to cover changes in the SQL language standard (SQL:1999)
* Includes CD with MySQL software

Download Here