Sql - Books On Amazon.com Check eBay.com!


 Page 1   |   First Page   |   Next Page…
Related Topics: |sql|


BOOK
Sams Teach Yourself SQL in 10 Minutes (3rd Edition)
Ben Forta
$10.98

About this product:

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.

BOOK
Microsoft SQL Server 2008 Management and Administration
Ross Mistry
$26.96

About this product:

If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft’s flagship database platform. SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production environments to offer step-by-step solutions and powerful tips you won’t find anywhere else. Every chapter begins with a section identifying SQL Server 2008’s most significant new improvements, and concludes with a convenient summary of best practices. Each chapter also outlines the benefits of leveraging Windows Server 2008.

 

Understand how to:
  •          Master DBA tips, tricks, and best practices proven in actual enterprise environments
  •          Install, upgrade or transition to SQL Server 2008.
  •          Harden and Secure an implementation.
  •          Encrypt SQL Server from an end-to-end perspective.
  •          Implement high availability–and leverage SQL Server 2008’s major improvements to failover clustering and database mirroring
  •          Save time with SQL Server 2008’s new policy-based management tools
  •          Performance tune and troubleshoot a SQL Server 2008 environment.
  •          Optimize application performance and manage workloads with the powerful new Resource Governor
  •          Implement Performance Studio, maintenance plans, Transparent Data Encryption and much more…
Bonus Content:
  •          The book is based on Windows Server 2008
  •          Step by step instructions of how to implement a failover cluster on Windows Server 2008
  •          SQL Server PoweShell Administration Tasks
  •          Consolidate and virtualize SQL Server with Hyper-V
  •          Step by step instructions on how to install Hyper-V
  •          Proactively Monitor SQL Server with Operations Manager
  •          Install Windows Server 2008 certificates to encrypt SQL Server data
Contributing Writers include:

Hilary Cotter — SQL Server MVP

John Welch — SQL Server MVP

Marco Shaw — PowerShell MVP

Maciej Pilecki — SQL Server MVP

Shirmattie Seenarine — Technical Writer

BOOK
Microsoft SQL Server 2008 Reporting Services
Brian Larson
$31.49

About this product:
The Definitive Guide to Microsoft SQL Server 2008 Reporting Services

Create and deliver data-rich reports across the enterprise using this complete server-based reporting solution. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. The book explains how to maximize all of the powerful features, including the new Tablix data format, as well as enhanced performance, scalability, and visualization capabilities.

  • Install, configure, and customize SQL Server 2008 Reporting Services
  • Create SELECT queries to extract data
  • Generate reports from the Report Wizard and from scratch
  • Add charts, images, and gauges
  • Build reusable report templates
  • Use the new Tablix data format to create reports with any structure
  • Export reports to Word, Excel, PDF, HTML, XML, and other formats
  • Enable end-user access to reports via the Report Server and its Report Manager web interface
BOOK
Microsoft® SQL Server® 2008 Internals (Pro - Developer)
Adam Machanic
$37.79

About this product:
Delve inside the core SQL Server engine and put that knowledge to work with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you ll gain the deep knowledge you need to exploit key architectural changes and capture the product s full potential. Discover how SQL Server works behind the scenes, including: What happens internally when SQL Server builds, expands, shrinks, and moves databases How to use event tracking from triggers to the Extended Events Engine Why the right indexes can drastically reduce your query execution time How to transcend normal row-size limits with new storage capabilities How the Query Optimizer operates Multiple techniques for troubleshooting problematic query plans When to force SQL Server to reuse a cached query plan or create a new one What SQL Server checks internally when running DBCC How to choose among five isolation levels and two concurrency models when working with multiple concurrent users

BOOK
Delivering Business Intelligence with Microsoft SQL Server 2008
Brian Larson
$29.92

About this product:

Maximize the Business Intelligence Tools in Microsoft SQL Server 2008

Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization.

  • Understand the goals and benefits of business intelligence
  • Design and create relational data marts and OLAP cubes
  • Manage Analysis Services databases using BI Development Studio
  • Cleanse data and populate data marts with SQL Server Integration Services
  • Take advantage of the flexibility of the Unified Dimensional Model
  • Manipulate and analyze data using MDX scripts and queries
  • Use data mining to identify data patterns, correlations, and clustering
  • Develop and distribute interactive reports with SQL Server 2008 Reporting Services
  • Integrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control
BOOK
SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL (2nd Edition)
Michael J. Hernandez
$38.62

About this product:

Unless you are working at a very advanced level, this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a "Mere Mortal" will indeed be empowered to perform the superhuman. Do not walk past this book!
--Graham Mandeno, Database Consultant

SQL Queries for Mere Mortals provides a step-by-step, easy-to-read introduction to writing SQL queries. It includes hundreds of examples with detailed explanations. This book provides the tools you need to understand, modify, and create SQL queries
--Keith W. Hare, Convenor, ISO/IEC JTC1 SC32 WG3--the International SQL Standards Committee

I learned SQL primarily from the first edition of this book, and I am pleased to see a second edition of this book so that others can continue to benefit from its organized presentation of the language. Starting from how to design your tables so that SQL can be effective (a common problem for database beginners), and then continuing through the various aspects of SQL construction and capabilities, the reader can become a moderate expert upon completing the book and its samples. Learning how to convert a question in English into a meaningful SQL statement will greatly facilitate your mastery of the language. Numerous examples from real life will help you visualize how to use SQL to answer the questions about the data in your database. Just one of the "watch out for this trap" items will save you more than the cost of the book when you avoid that problem when writing your queries. I highly recommend this book if you want to tap the full potential of your database.
--Kenneth D. Snell, Ph.D., Database Designer/Programmer

I don't think they do this in public schools any more, and it is a shame, but do you remember in the seventh and eighth grades when you learned to diagram a sentence? Those of you who do may no longer remember how you did it, but all of you do write better sentences because of it. John Viescas and Mike Hernandez must have remembered because they take everyday English queries and literally translate them into SQL. This is an important book for all database designers. It takes the complexity of mathematical Set Theory and of First Order Predicate Logic, as outlined in E. F. Codd's original treatise on relational database design, and makes it easy for anyone to understand. If you want an elementary- through intermediate-level course on SQL, this is the one book that is a requirement, no matter how many others you buy.
--Arvin Meyer, MCP, MVP

Even in this day of wizards and code generators, successful database developers still require a sound knowledge of Structured Query Language (SQL, the standard language for communicating with most database systems). In this book, John and Mike do a marvelous job of making what's usually a dry and difficult subject come alive, presenting the material with humor in a logical manner, with plenty of relevant examples. I would say that this book should feature prominently in the collection on the bookshelf of all serious developers, except that I'm sure it'll get so much use that it won't spend much time on the shelf!
-- Doug Steele, Microsoft Access Developer and author

Over the last several decades, SQL has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using SQL now totals in the millions. If you are accessing corporate information from the Internet or from an internal network, you are probably using SQL. This new edition of SQL Queries for Mere Mortals helps new users learn the foundations of SQL queries, and is an essential reference guide for intermediate and advanced users.

The accompanying CD contains five sample databases used for the example queries throughout the book in four different formats: Microsoft SQL Server 2000 and later, Microsoft Access 2000 and later, MySQL version 5.0 and later, and SQL scripts that can be used with most other implementations of the language.

BOOK
Microsoft® SQL Server® 2008 T-SQL Fundamentals (PRO-Developer)
Itzik Ben-gan
$24.75

About this product:
Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance including exercises and code samples that show you how to develop code to query and modify data. You ll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries. Discover how to: Apply T-SQL fundamentals, create tables, and define data integrity Understand logical query processing Query multiple tables using joins and subqueries Simplify code and improve maintainability with table expressions Explore pivoting techniques and how to handle grouping sets Write code that modifies data Isolate inconsistent data and address deadlock and blocking scenarios

BOOK
Oracle PL/SQL Programming (Animal Guide)
Pribyl Bill
$39.99

About this product:
If you're doing database application development in the Oracle environment, you're going to have to know PL/SQL, the company's extended query and update language. If you want your programs to exploit the special capabilities of Oracle software, you'll need to know the language well. That's where the third edition of Oracle PL/SQL Programming comes into play. It's an absolutely comprehensive reference (as well as a rather extensive tutorial) on PL/SQL, ideally suited to answering your questions about how to perform some programming tasks and reminding you of the characteristics of functions, triggers, and other elements of the database programmer's toolkit. The new edition covers calls to Java methods from within PL/SQL programs, autonomous transactions, object type inheritance, and the new Timestamp and XMLType data types. There's also more information about server internals--the way PL/SQL programs are run--than before, better enabling readers to optimize their code for fast and safe execution.

Steven Feuerstein takes care to explain, with prose and example code, the characteristics of PL/SQL elements. In explaining number conversions, for example, he explores Oracle's different ways of formatting numbers, then details the behavior of the to_number function under different conditions (with and without a specified format model, and with National Language Support information attached). It's a helpful approach that will have readers using the index to locate places in which Feuerstein mentions language elements of interest. --David Wall

Topics covered: How to use Oracle PL/SQL in all its manifestations through Oracle9i. Fundamentals of program structure (loops, cases, exceptions, etc.) and execution get attention, as do data types, transaction management, triggers, and the object-oriented aspects of the language. There's also coverage of calls to external Java and C programs.

BOOK
Microsoft SQL Server 2005 Unleashed
Alex T. Silverstein
$37.87

About this product:
<>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.

 

Detailed information on…

  • 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—NEW!
  • SQL Server Notification Services; Integration Services—NEW!; Analysis Services; Reporting Services—NEW!; Web Services—NEW!
  • SQL Server Service Broker—NEW!
  • SQL Server and Microsoft .NET Framework integration, including CLR-based stored procedures, functions, and triggers—NEW!
  • SQL Server high availability and SQL Server clustering and replication
  • Database Mirroring—NEW!
  • Database Snapshots—NEW!
  • Using XML in SQL Server 2005
  • SQL Server tools and utilities

 

CD-ROM includes

  • 8 bonus chapters covering topics such as Notification Services, Service Broker, and Full-Text Search
  • Code samples, scripts, and sample databases
  • A PDF version of the entire book

 

Introduction

Part I Welcome to Microsoft SQL Server

1 SQL Server 2005 Overview

2 What’s New in SQL Server 2005

Part II SQL Server Tools and Utilities

3 SQL Server Management Studio

4 SQL Server Command-Line Utilities

5 SQL Server Profiler

Part III SQL Server Administration

6 SQL Server System and Database Administration

7 Installing SQL Server 2005

8 Upgrading to SQL Server 2005

9 Client Installation and Configuration

10 Security and User Administration

11 Database Backup and Restore

12 Database Mail

13 SQL Server Scheduling and Notification

14 SQL Server High Availability.

15 Replication

16 Database Mirroring

17 SQL Server Clustering

Part IV Database Administration

18 Creating and Managing Databases

19 Creating and Managing Tables

20 Creating and Managing Indexes

21 Implementing Data Integrity

22 Creating and Managing Views in SQL Server

23 Creating and Managing Stored Procedures

24 Creating and Managing User-Defined Functions

25 Creating and Managing Triggers

26 Transaction Management and the Transaction Log

27 Database Snapshots

28 Database Maintenance

Part V SQL Server Performance and Optimization

29 Indexes and Performance

30 Understanding Query Optimization

31 Query Analysis

32 Locking and Performance

33 Database Design and Performance

34 Monitoring SQL Server Performance

Part VI SQL Server Application Development

35 What’s New for Transact-SQL in SQL Server 2005

36 SQL Server and the .NET Framework

37 Using XML in SQL Server 2005

38 SQL Server Web Services

Part VII SQL Server Business Intelligence Features

39 SQL Server 2005 Analysis Services

40 SQL Server Integration Services

41 SQL Server 2005 Reporting Services

Bonus Chapters on the CD

42 Managing Linked and Remote Servers

43 Configuring, Tuning, and Optimizing SQL Server Options

44 Administering Very Large SQL Server Databases

45 SQL Server Disaster Recovery Planning

46 Transact-SQL Programming Guidelines, Tips, and Tricks

47 SQL Server Notification Services

48 SQL Server Service Broker

49 SQL Server Full-Text Search

Index

 

BOOK
SQL Cookbook (Cookbooks (O'Reilly))
Anthony Molinaro
$22.49

About this product:

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.

Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT FROM WHERE . But there is "so" much more you can do with the language. In the "SQL Cookbook," experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:

Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out

Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function

Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set

"Bucketization," and why you should never use that term in Brooklyn.

How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques

The technique of "walking a string," which allows you to use SQL to parse through the characters, words, or delimited elements of a string

Written in O'Reilly's popular Problem/Solution/Discussion style, the "SQL Cookbook" is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, weall have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The "SQL Cookbook" moves quickly from problem to solution, saving you time each step of the way.

 Page 1   |   First Page   |   Next Page…
Related Topics: |sql|


Items relating to "sql":
| Books | DVD | Electronics | Blended | TV |


Read Financial Markets  |   Home  |   Blog  |   Web Tools  |   News  |   Articles  |   FAQ  |   About  |   Contact

© 2001-2009 Robert Vahid Hashemian
Support the effort
Liked this page?
Please consider creating a link to it
from your Web site.

hashemian.com
هاشمیان.com

 Home

 Blog

 Web Tools Add Free Web Tools custom Google Toolbar button (Requires Toolbar >V4)
Usage

 News

 Articles

 FAQ

 About

 Contact

 Financial Markets Book
Read Complete Book

Search Amazon:  
Amazon Logo


Get Kindle, $259

aStore - Hashemian.com on Amazon

Visits: Powered by hashemian.com

 

 

 

 

 

Search Hashemian.com



eBay