This book is designed to teach application developers all of the skills they need to use SQL to work with a Microsoft SQL Server 2008 database. But it's also a great first book for developers who are on the path to becoming a DBA.
Unlike most SQL Server 2008 books, this one starts by showing you how to use SQL queries to...
The Microsoft Office Access 2003 database management system can be a powerful tool for you whether you need to handle business or personal information. The concept of distributing data among related tables is not new, but the way the concept is implemented in Access 2003 makes information management a snap. Access 2003 is extremely...
Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload. You'll learn...
Database design involves how to best structure the tables and queries that are used with databases in order to provide optimum performance, storage, manageability, and flexibility. With relational databases, you can use those tables to organize your data and retrieve information from your database. This book provides you with an easy-to-understand...
How to effectively use BigQuery, avoid common mistakes, and execute sophisticated queries against large datasets
Google BigQuery Analytics is the perfect guide for business and data analysts who want the latest tips on running complex queries and writing code to communicate with the BigQuery API. The book uses...
Google Hacks is a collection of industrial-strength, real-world, tested solutions to practical problems. This concise book offers a variety of interesting ways for power users to mine the enormous amount of information that Google has access to, and helps you have fun while doing it. You'll learn clever and...
LINQ, Language INtegrated Query, is a new extension to the Visual Basic and C# programming languages designed to simplify data queries and database interaction. It addreses O/R mapping issues by making query operations like SQL statements part of the programming language. It also offers built-in support for querying in-memory collections like...
In this comprehensive book, you’ll learn to write Structured Query Language (SQL) statements to access an Oracle database and use PL/SQL (Procedural Language/SQL) to write programs containing SQL statements. Developed in compliance with the new SQL2003 specification, this definitive resource explains how to use the latest Oracle...
Taken as a whole, this series covers all major fields of application for commercial sensors, as well as their manufacturing techniques and major types. As such the series does not treat bulk sensors, but rather places strong emphasis on microsensors, microsystems and integrated electronic sensor packages. Each of the individual volumes is tailored...
Queries not running fast enough? Wondering about the in-memory database features in 2014? Tired of phone calls from frustrated users? Grant Fritchey’s book SQL Server Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization...
Hibernate Recipes, Second Edition contains a collection of code recipes and templates for learning and building Hibernate solutions for you and your clients, including how to work with the Spring Framework and the JPA. This book is your pragmatic day-to-day reference and guide for doing all things involving Hibernate. There are many books...
