|
Learning SQL by Alan Beaulieu (Paperback - Aug 22, 2005)SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data.
Learning SQL moves you quickly through the basics and then on to some of the more commonly used advanced features. Among the topics discussed: -
SQL Data Statements--those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and delete
- SQL Schema Statements--those used to create database objects, such as tables, indexes, and constraints
- How data sets can interact with queries
- The importance of subqueries
- How conditional logic can be used in Data Statements
Best of all, Learning SQL talks to you in a real-world manner, discussing various platform differences that you're likely to encounter and offering a series of chapter exercises that walk you through the learning process. This means you'll be able to apply what you learn to any of several different databases; the book covers MySQL, Microsoft SQL Server, and Oracle Database, but the features and syntax should apply just as well (perhaps with some tweaking) to IBM DB2, Sybase Adaptive Server, and PostgreSQL.
Sams Teach Yourself SQL in 10 Minutes by Ben Forta (Paperback - April 10, 2004) Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in applying the SQL language. Forta's examples are clear and his writing style is crisp and concise. As with earlier editions, this revision includes coverage of current versions of all major commercial SQL platforms. New this time around is coverage of MySQL, and PostgreSQL. All examples have been tested against each SQL platform, with incompatibilities or platform distinctives called out and explained.
Microsoft SQL Server 2005 Unleashed by Ray Rankins, Paul Bertucci, Chris Gallelli, and Alex T. Silverstein (Paperback - Dec 31, 2006)
Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the basic syntax and information you’ll find in the product manuals, providing in-depth information derived from the authors’ real-world experience to help you build upon your working knowledge of the product and take your experience and knowledge to a higher level. This book focuses primarily on the information needed by system and database administrators, as well as for users with overlapping duties as both DBA and developer. Included is extensive coverage of the new features and upgraded tools and capabilities of SQL Server 2005, including .NET Framework integration, Integration Services, Service Broker, Database Mirroring and Snapshots, and Reporting Services. - Installing, upgrading, and administering SQL Server 2005
- Database maintenance, backup, and recovery
- Creating and managing tables, views, stored procedures, triggers, and user-defined functions
- Database and index design
- SQL Server query optimization, and performance monitoring and tuning
- Transactions, transaction management, and distributed transactions
- SQL Server Management Studio
- SQL Server Notification Services; Integration Services; Analysis Services; Reporting Services; Web Services
- SQL Server Service Broker
- SQL Server and Microsoft .NET Framework integration, including CLR-based stored procedures, functions, and triggers
- SQL Server high availability and SQL Server clustering and replication
- Database Mirroring
- Database Snapshots
- Using XML in SQL Server 2005
- SQL Server tools and utilities
SQL Cookbook by Anthony Molinaro (Paperback - Dec 16, 2005) You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level.
Microsoft SQL Server 2005 Reporting Services 2005 by Brian Larson (Paperback - Dec 12, 2005) Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.
Inside Microsoft SQL Server 2005: T-SQL Querying by Itzik Ben-Gan, Lubor Kollar, and Dejan Sarka (Paperback - April 26, 2006) A comprehensive, hands-on reference for database developers and administrators, this book focuses on advanced querying techniques using Transact-SQL (T-SQL), the database programming language built into SQL Server. Includes code and table examples.
Other SQL books samples:
-
Head First SQL: Your Brain on SQL by Lynn Beighley (Paperback - Sep 1, 2007)
-
Beginning SQL Server 2005 Administration by Dan Wood, Chris Leiter, and Paul Turley (Paperback - Nov 29, 2006)
-
Microsoft SQL Server(TM) 2005 Administrator's Companion (Pro - Administrator's Companion) by Edward Whalen, Victor Isakov, Marcilina Garcia, and Burzin Patel (Hardcover - Dec 13, 2006)
-
Inside Microsoft SQL Server(TM) 2005: Query Tuning and Optimization by Kalen Delaney, Sunil Agarwal, Craig Freedman, and Ron Talmage (Paperback - Sep 26, 2007)
-
MCTS Self-Paced Training Kit: Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) by Solid Quality Learning (Hardcover - Jun 28, 2006)
|
