SQL Injection Attacks and Defense /by Justin Clarke (Author).SQL injection represents one of the most dangerous and well-known, yet misunderstood, security vulnerabilities on the Internet, largely because there is no central repository of information to turn to for help. This is the only book devoted exclusively to this long-established but recently growing threat. It includes all the currently known information about these attacks and significant insight from its contributing team of SQL injection experts.
# What is SQL injection?-Understand what it is and how it works
# Find, confirm, and automate SQL injection discovery
# Discover tips and tricks for finding SQL injection within the code
# Create exploits using SQL injection
# Design to avoid the dangers of these attacks

Oracle 11g Streams Implementer's Guide /by Ann L.R McKinnell (Author), Eric Yen (Author). Distributed database systems proliferate the world of data sharing providing an ability to access real-time data anywhere, anytime. Oracle Streams, a built-in feature of the Oracle database, is a data replication and integration feature critical to the success and wellbeing of enterprises in today's fast moving economy. This book provides the reader with solid techniques to master Oracle Streams technology and successfully deploy distributed database systems.
This book quickly goes over the basics and gets you up and running with a simple Oracle 11g Streams environment. It will serve as an excellent companion to the Oracle Streams Administration Guide. It is intended for Oracle database architects and administrators, and provides in-depth discussion on must-know information for the design, implementation, and maintenance of an Oracle Streams environment.
The book does not attempt to regurgitate all the information in the Oracle Streams Administration Guides, but rather provides additional clarification and explanation of design, implementation, and troubleshooting concepts that are often elusive in Streams documentation. It also identifies helpful tools and Oracle resources to add to your knowledge base, as well as tried and tested tricks and tips to help you tame Oracle Streams.

Inside Microsoft SQL Server 2008 T-SQL Querying /by Itzik Ben-Gan (Author), Lubor Kollar(Author), Dejan Sarka(Author), Steve Kass (Author) .Tackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals—and gain practical approaches and advanced techniques to optimize your code’s performance.
Discover how to:
* Move from procedural programming to the language of sets and logic
* Optimize query tuning with a top-down methodology
* Assess algorithmic complexity to predict performance
* Compare data-aggregation techniques, including new grouping sets
* Manage data modification—insert, delete, update, merge—for performance
* Write more efficient queries against partitioned tables
* Work with graphs, trees, hierarchies, and recursive queries
* Plus—Use pure-logic puzzles to sharpen your problem-solving skills

Microsoft SQL Server 2008 Bible /by Paul Nielsen (Author), Uttam Parui (Author), Mike White (Contributor) .Harness the power of SQL Server, Microsoft’s high-performance database and data analysis software package, by accesing everything you need to know in Microsoft SQL Server 2008 Bible. Learn the best practices, tips, and tricks from this comprehensive tutorial and reference, which includes specific examples and sample code, with nearly every task demonstrated in both a graphical and SQL code method. Understand how to develop SQL Server databases and data connections, how to administer the SQL Server and keep databases performing optimally, and how to navigate all the new features of the 2008 release.
*Master the data architecture concepts that drive database technologies
*Write elegant set-based queries that respond well to a comprehensive indexing strategy
*Code an efficient and robust data abstraction layer with stored procedures
*Learn the best way to connect to SQL Server with ADO or Microsoft Access
*Use PowerShell and Policy-based Management to better administer your servers
*Use Analysis Services, MDX, and Excel to analyze data trends
*Optimize performance with data compression, resource governor, and partitioning

Creating your MySQL Database: Practical Design Tips and Techniques: A short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily /by Marc DeLisle (Author) .For most of us, setting up the database for an application is often an afterthought. While you don't need to be a professional database designer to create a working application, knowing a few insider tips and techniques can make both the process easier and the end result much more effective.

This book doesn't set out to make you an expert in data analysis, but it does provide a quick and easy way to raise your game in this essential part of getting your application right.
What you will learn from this book?
* Asking users the right questions to collect relevant data for the system you are building
* Detecting bad structures
* Sound data-naming techniques, for both table and column names
* Modeling data with future growth in mind
* Implementing security policies with data privileges and views
* Tuning the structure for performanceProducing system documentation (data dictionary, relational schema)
* Testing the model with appropriate SQL queries