Peachpit Press 3/ed (6-2008) | PDF | 496 pages | 0321553578 | 5.2Mb

SQL: Visual QuickStart Guide /by Chris Fehily (Author) .SQL is a standard interactive and programming language for querying and modifying data and managing databases. This task-based tutorial and reference guide takes the mystery out learning and applying SQL. After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily immediately launches into the tasks that will get readers comfortable with SQL. In addition to covering all the SQL basics, this thoroughly updated reference contains a wealth of in-depth SQL knowledge and serves as an excellent reference for more experienced users.

Jones & Bartlett (12-2009) | PDF | 300 pages | 076378138X | 2.8Mb

Essential SQL on SQL Server 2008 /by Dr. Sikha Bagui (Author), Dr. Richard Earp (Author).This book, written for readers who have little or no previous experience with databases, SQL, or SQL Server, provides a very systematic approach to learning SQL (Structured Query Language) using SQL Server. Each chapter is written in a step-by-step manner and has examples that can be run using SQL Server. Using the sample tables and data provided, the reader of this book will be able to do all the examples to experience hands-on SQL programming in SQL Server. The text also presents a series of exercises at the end of the chapters to help readers gain proficiency with SQL. With this book you will learn: Beginning SQL commands how to retrieve and manipulate data using the simple SELECT statement. How to customize SQL Server 2008 s settings and about SQL Server 2008 s functions. How to create, alter, populate and delete tables. About joins, a common database mechanism for combining tables. Query development, the use of views and other derived structures. Simple set operations. About aggregate functions. How to write subqueries and correlated subqueries. How to create and use indexes and constraints. Transaction processing.

Packt (3-2010) | PDF | 376 pages | 1847197965 | 5.52Mb

MySQL Admin Cookbook /by Daniel Schneller (Author), Udo Schwedt (Author) .MySQL is the most popular open-source database and is also known for its easy set up feature. However, proper configuration beyond the default settings still is a challenge, along with some other day-to-day maintenance tasks such as backing up and restoring, performance tuning, and server monitoring. These tasks have not been covered thoroughly in the default documentation. This book provides both step-by-step recipes and relevant background information on these topics and more. It covers everything from basic to advanced aspects of MySQL administration and configuration. One of the things you are really going to love about this book is that all recipes are based on real-world experience and were derived from proven solutions used in an enterprise environment.
This book shows you everything you need to know about MySQL Administration. You will learn to set up MySQL replication to manage load balancing and deal with online backup and fail-over scenarios. As you consider the benefits of backing up, you might like to back up your database efficiently with advanced techniques covered in this book.
The book demonstrates how to create, modify, and delete indexes. You will also learn to identify duplicate indexes, which hinder your MySQL server performance. This book focuses on administration tasks and will help you as an administrator to optimize the database for efficiency and reliability.
You will learn to manage data efficiently by inserting data in existing database content and importing and exporting databases. The sooner you learn about taking advantage of metadata from this book, the sooner you can start using the space efficiently. Get to know about managing users and assigning privileges and regaining lost administrative user credentials. Finally, learn to manage the database schema by customizing it to automate database schema evolution in the context of application updates.