Head First SQL: Your Brain on SQL ISBN:0596526849 Published: 01 September, 2007 Author: Lynn Beighley
Maybe you've written some simple SQL queries to interact with databases. But now you want more, you want to really dig into those databases and work with your data. Head First SQL will show you the fundamentals of SQL and how to really take advantage of it.
Beginning SQL Server 2005 Express for Developers ISBN:1590597206 Published: 12 February, 2007 Author: Robin Dewson
Assuming neither database nor programming background, Beginning SQL Server 2005 Express for Developers introduces all the fundamental database administration and SQL programming features of SQL Server 2005 Express Edition, the free relational database management system from Microsoft that provides a major subset of full SQL Server 2005 functionality.
This book is a comprehensive guide that covers installing and configuring SQL Server 2005 Express; creating, backing up, and restoring databases; creating tables, then querying and manipulating them with T-SQL; coding stored procedures and triggers, and using Reporting Services to deliver information to end users. Detailed, clear, and highly readable, this book will make you a competent and confident database administrator and programmer.
SQL Hacks ISBN:0596527993 Published: 21 November, 2006 Author: Andrew Cumming
Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. The book offers 100 hacks -- unique tips and tools -- that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems.
Murach's SQL Server 2005 for Developers ISBN:1890774391 Published: 22 December, 2006 Author: Bryan Syverson
If you want to learn SQL, you've picked the right book. Unlike most SQL books, this one starts by showing you how to use SQL queries to extract and update the data in a database, because that's what every application developer needs to know first. Then, it shows how to design and implement a database, how to use server-side features like views, stored procedures, cursors, and transactions, and how to use the CLR integration feature (new in SQL Server 2005) to create database objects in a .NET language like C# or Visual Basic.
With this breadth of material, this book works well for application developers and SQL programmers, but it's also a great first book for DBAs-in-training.
MySQL Cookbook ISBN:059652708X Published: 27 November, 2006 Author: Paul DuBois
Along with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch.
Creating your MySQL Database: Practical Design Tips and Techniques ISBN:1904811302 Published: 20 November, 2006 Author: Marc, DeLisle
If you're creating a dynamic web application using open-source tools, then you're probably going to be setting up a MySQL database. Getting the design of this database right for your application and its data is vital, but it's often an intimidating and little-known process for non-developers and developers alike. Written by the creator of the popular phpMyAdmin tool, this book is a short but complete guide on how to design good data structures for MySQL.
Joe Celko's Analytics and OLAP in SQL ISBN:0123695120 Published: 24 July, 2006 Author: Joe Celko
The volume, use, design, and type of data make a big difference in the representation of data, the type of queries used, and its physical storage. Traditional on-line transaction processing systems (OLTP) are generally searched for current information: Did John Smith pay his bill on time? The OLAP system is a product whose architecture is built to handle massive amounts of data with totally different access methods - and the users want a different information, generally including historical data: give me all the monthly sales patterns for the last 3 years on this group of products.
SQL Server 2005 for Developers ISBN:1584503882 Published: 30 June, 2006 Author: Robert Ericsson
SQL Server 2005 for Developers teaches you how to leverage these new tools by covering the topics relevant to developers. Samples throughout the book illustrate the features of SQL Server 2005 in a realistic manner, and provide insights into the new ways for developers to manipulate servers and databases. Specific discussions of similarities and differences between SQL Server 2005 and past versions allow you to use what you already know and apply it efficiently. After working through the book, you?ll be up to speed and ready to integrate SQL Server 2005 into your own projects.
Learning SQL on SQL Server 2005 ISBN:0596102151 Published: 26 April, 2006 Author: Sikha Bagui
Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, Learning SQL on SQL Server 2005 starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005.
