This helpful guide is perfect for those looking to enhance their SQL skills in the database. Experienced developer Anthony Molinaro shares his favorite techniques and features, including using window functions and powerful, database-specific features like SQL Server's PIVOT and UNPIVOT operators. You'll also learn how to create histograms and perform advanced data warehousing techniques. Written in a Problem/Solution/Discussion style, the SQL Cookbook is a quick and efficient way to take your SQL skills to the next level.

Query Solutions and Techniques for Database Developers (Cookbooks (O'Reilly))

SQL Cookbook

SQL Pocket Guide is the ultimate reference for programmers and database administrators who use SQL in their work. This pocket guide covers the language's complexity, with examples that illustrate the key aspects of SQL found in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2. The guide also explains how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It covers SQL functions, regular expression syntax and type conversion functions and formats. The third edition includes important database changes, including Oracle's new support of recursive WITH syntax and PostgreSQL's recursive WITH support and some window functions.

A Guide to SQL Usage

SQL Pocket Guide

Learn SQL quickly with this easy-to-follow guidebook updated for the latest database management systems including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008. Master all the SQL fundamentals, including creating database structures, manipulating data, and generating reports. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Practice your skills with end-of-chapter exercises. Get started with Learning SQL and put the power and flexibility of this language to work.

Master SQL Fundamentals

Learning SQL

Learn how to maximize the power of MySQL with High Performance MySQL. This guide covers advanced techniques for designing schemas, indexes, and queries, as well as tuning your MySQL server, operating system, and hardware. Discover practical ways to safely scale applications through replication, load balancing, high availability, and failover. With updated examples from MySQL 5.5 and InnoDB performance, this third edition provides illustrative case studies and stories that demonstrate MySQL's principles in action. Optimize your querying features, take advantage of multi-core CPUs and solid-state disks, and explore backup and recovery strategies with this comprehensive guide.

Optimization, Backups, and Replication

High Performance MySQL

SQL Antipatterns is an expert guide to identifying and correcting the most common errors that developers make in SQL, whether you're a beginner or an experienced programmer. With practical examples covering everything from logical and physical database design to queries and application development, this book will help you avoid and fix common mistakes like Index Shotgun and Keyless Entry. You'll also learn the latest techniques for full-text search and SQL injection attack resistance. With SQL Antipatterns, you'll gain unparalleled insight into the playbook of an SQL expert and become a master of relational database design.