SQL tuning improvements existing execution plans. The authors discuss the removal of brakes in the execution plan. Such "brakes" or bottlenecks can be recognized by a formal analysis of the execution
Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool
Pro Oracle SQL, Second Edition unlocks the power of SQL in the Oracle database—one of the most potent SQL implementations on the market today. To master it requires a multi-pronged approach:
In this SQL primer/CD-ROM package, De Haan (applied mathematics, Technical University, The Netherlands) shows developers, administrators, system architects, and hobbyists how to write SQL and how to m
Introduces a series of effective techniques to solve essential problems in the Oracle database using PL/SQL, with a focus on the stored procedures, how to code them, and practical uses for them in the
SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Needto export
This book is not just another theoretical text on statistics or data mining. Instead, it's designed for database administrators who want to buttress their understanding of statistics to support data m
An unhealthy database is not just an inconvenience: it can bring a business to its knees. And if you are the database administrator, the health of your SQL Server implementation can be a direct reflec
Expert Oracle Application Express Security covers all facets of security related to Oracle Application Express (APEX) development. From basic settings that can enhance security, to preventing SQL Inje
Pro SQL Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft's worldwid
Pro SQL Server 2012 Practicesis an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Mi
Pro TSQL 2012 Programmer's Guide is every developer's key to making full use of SQL Server 2012's powerful, builtin TransactSQL language. Discussing new and existing features, the book takes you on an
SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database
Ultra-Fast ASP.NET 4.5 presents a practical approach to building fast and scalable web sites using ASP.NET and SQL Server. In addition to a wealth of tips, tricks and secrets, you'll find advice and c
Beginning SQL Server 2012 Administration provides the essential skills and knowledge needed to begin a successful career as an SQL Server database administrator. It's an ideal book for those new to da
Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or fe
This book offers a systematic approach to addressing poor performance of applications based on Oracle, and explains how the database engine processes SQL statements. Sections cover foundations, identi
This guide combines the proven tutorial approach to teaching SQL with a collection of major SQL statements with example code for five major database systems: SQL Server, Oracle, DB2, MySQL and Access.
A comprehensive handbook for Oracle 9i database administration explains how to build and manage complex Oracle 9i databases and provides a primer on UNIX, an introduction to SQL and PL/SQL, and comple
