SQL Server Books - Page 2

Microsoft® SQL Server® 2008 T-SQL Fundamentals (PRO-Developer)

Itzik Ben-gan

Amazon Price: $31.49 List Price: $49.99 Usually ships in 24 hours By: Microsoft Press Amazon Marketplace: 42 new & used starting at $25.97

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS

Customer Reviews:
Total reviews: 2 Average rating: 5.0 of 5

Editorial Review:

This book walks you through your first steps in T-SQL (also known as Transact-SQL), which is Microsoft SQL Server s dialect of the standard ANSI-SQL language. You ll learn the theory behind T-SQL querying and programming, how to develop T-SQL code to query and modify data, and get an overview of programmable objects. Although this book is intended for beginners, it is not merely a step-by-step book. It goes beyond the syntactical elements of T-SQL and explains the logic behind the language and its elements. Many aspects of SQL are unique to the language, and are very different from other programming languages. This book helps you adopt the right state of mind and gain a true understanding of the language elements. You learn how to think in terms of sets and follow good SQL programming practices. The book is not version-specific; it does, however, cover language elements that were introduced in recent versions of SQL Server, including SQL Server 2008. To complement the learning experience, the book provides exercises that enable you to practice what you ve learned. The book starts with a theoretical background to T-SQL querying and programming (Chapter 1) laying the foundations for the rest of the book, and also coverage of creating tables and defining data integrity. The book moves on to various aspects of querying and modifying data (Chapters 2 through 8), then to a discussion of concurrency and transactions (Chapter 9), and finally provides an overview of programmable objects (Chapter 10). This book features a companion Web site that makes available to you all the code used in the book, the errata, additional resources, and more.

A Guide to SQL

Philip J. Pratt, Mary Z. Last

Amazon Price: $57.95 List Price: $62.95 Usually ships in 24 hours By: Course Technology Amazon Marketplace: 20 new & used starting at $51.22

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Computer Science -> Software Engineering -> Information Systems
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General

Customer Reviews:
Total reviews: 12 Average rating: 3.0 of 5

great service not so great book 2 out of 5 stars.
0 of 0 people found this review helpful.

The delivery service for this book was excellent..no doubt about that. The book itself was confusing to navigate through, and it lacks material

Excellent for beginners 5 out of 5 stars.
0 of 0 people found this review helpful.

I have used several editions of this book with nary a complaint from students. The book uses real, honest-to-goodness, standard SQL. SQL is a standardized language, but the 900 lb. gorillas in the market like Oracle and Microsoft refuse to follow the standard. If you use some flavor of Microsoft Jet SQL or Oracle, this book will be of use, but will not teach you all of the "extensions" that the big SQL players have made in their proprietary versions of SQL. Still, pretty much all of the code in this book will run, even from the bone-headed SQL prompt in Microsoft Access!

As other reviewers have noted, this is not a general DBMS book, although good design principles are followed. If you want a relatively short and comprehensive introduction to DBMS, I recommend Pratt and Adamski's _Concepts of Database Management_ 6th ed. There are many outstanding DBMS books out there, but Pratt and Adamski is the arguably the briefest. The chapters on normalization are very good--very practical with very little set theory. I regard database design as little more than applied set theory, and if your set theory is weak, Pratt and Adamski is the book for you.

Editorial Review:

A GUIDE TO SQL, 8E, illustrates the basics of SQL programming using straightforward instruction and extensive hands-on exercises. Phil Pratt and Mary Last continue to present basic SQL commands in a business context using Oracle. A new running case, for a total of three, presents lessons in a real-world context for managing orders, parts, customers, and sales reps. The text provides hands-on projects at the end of each chapter, including review questions, running cases, and extensive exercises, providing students with the opportunity to solve problems and apply skills from each chapter.

Programming Microsoft SQL Server 2008 (PRO-Developer)

Leonard Lobel, Andrew J. Brust, Stephen Forte

Amazon Price: $37.79 List Price: $59.99 Usually ships in 24 hours By: Microsoft Press Amazon Marketplace: 38 new & used starting at $25.99

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS

Customer Reviews:
Total reviews: 1 Average rating: 5.0 of 5

Editorial Review:

Written by industry professionals who have been working with SQL Server 2008 since the earliest code, this reference expertly covers the programming fundamentals for SQL Server 2008 with crucial real-world context and extensive code samples.

Get the hands-on programming instruction, practical examples, and best practices you need to master the core programmability features in SQL Server 2008. Led by three experts in database design and business intelligence solutions, you ll learn the essential tools and techniques for developing robust applications. Discover how to:
-Program views, stored applications, triggers, and functions using T-SQL
-Work with the new data types, LINQ, and the ADO.NET Entity Framework
-Automate common administration and maintenance tasks
-Debug databases, reports, and objects using Microsoft Visual Studio® 2008
-Write transactional code and implement local and distributed transactions
-Use business intelligence tools, such as SQL Server Reporting Services, SQL Server Analysis Services, and SQL Server Integration Services

Many of the book s examples, exercises, and code samples are available for download from the companion Web site.

Microsoft ® Office 2007 Business Intelligence

Doug Harts

Amazon Price: $26.39 List Price: $39.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 47 new & used starting at $19.85

Buy at Amazon.com

Browse similar items by category:
Subjects -> Business & Investing -> Small Business & Entrepreneurship -> New Business Enterprises
Subjects -> Business & Investing -> General
Subjects -> Business & Investing -> General AAS

Customer Reviews:
Total reviews: 9 Average rating: 4.5 of 5

Editorial Review:

Extract and analyze mission-critical enterprise data using Microsoft Office 2007

This authoritative volume is a practical guide to the powerful new collaborative Business Intelligence tools available in Office 2007. Using real-world examples and clear explanations, Microsoft Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop shows you how to use Excel, Excel Services, SharePoint, and PerformancePoint with a wide range of stand-alone and external data in today's networked office. You will learn how to analyze data and generate reports, scorecards, and dashboards with the Office tools you're already using to help you in your everyday work.

• Create Excel PivotTables and PivotCharts and apply Conditional Formatting
• Convert Excel spreadsheets into Excel Tables with Conditional Formatting and Charting
• Connect external data to Excel using Office Data Connections and SharePoint
• Create SharePoint dashboards that display data from multiple sources
• Add Key Performance Indicators and Excel Services reports to your dashboards
• Harness advanced SQL Server 2005 data analysis tools with the Excel Data Mining Add-In and Visio Cluster Diagrams
• Generate integrated PerformancePoint Scorecards
• Create Visio PivotDiagrams and Windows Mobile spreadsheets

Applied Microsoft SQL Server 2008 Reporting Services

Teo Lachev

Amazon Price: $32.97 List Price: $49.95 Usually ships in 24 hours By: Prologika Press Amazon Marketplace: 30 new & used starting at $31.24

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS

Customer Reviews:
Total reviews: 2 Average rating: 5.0 of 5

Editorial Review:

Ever wished for a tool that can turn enterprise data into meaningful reports that could be shared easily with co-workers, customers, and partners?

Microsoft SQL Server 2008 Reporting Services is the "magic wand" you need to unleash the hidden power of data. The author, who has worked closely with the Reporting Services Development Team, takes you on an insightful tour that provides an authoritative yet independent view of the technology.

Supplying much-needed technological information to workers, administrators, and developers, Applied Microsoft SQL Server 2008 Reporting Services shows you how to apply Reporting Services in real life to build innovative Business Intelligence solutions that drive decisions. Information workers will learn how to design feature-rich standard and ad hoc reports. The book gives administrators the necessary background to install, upgrade, and manage the report environment. It teaches developers powerful ways to extend Reporting Services and integrate it with a wide range of applications.

The book doesn't assume any prior experience with Microsoft Reporting Services. It is designed as an easy-to-follow guide for navigating safely the most intricate aspects of the technology. New concepts are introduced with step-by-step instructions and hands-on lessons. Video presentations help the reader stay on track when a picture is worth more than a thousand words.

The book website at www.prologika.com provides sample chapters, source code, discussion forum, and online video tutorials.

Delivering Business Intelligence with Microsoft SQL Server(TM) 2/E 2008

Brian Larson

Amazon Price: $31.49 List Price: $49.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 26 new & used starting at $29.78

Buy at Amazon.com

Browse similar items by category:
Subjects -> Business & Investing -> Industries & Professions -> MIS
Subjects -> Computers & Internet -> Certification Central -> Publisher -> Osborne-McGraw-Hill
Subjects -> Computers & Internet -> Certification Central -> MS SQL Server

Editorial Review:

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

Microsoft SQL Server 2008 Administrator's Pocket Consultant

William R. Stanek

Amazon Price: $21.34 List Price: $34.99 Usually ships in 24 hours By: Microsoft Press Amazon Marketplace: 41 new & used starting at $20.59

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS

Customer Reviews:
Total reviews: 3 Average rating: 5.0 of 5

Editorial Review:

Get the practical, pocket-sized guide for IT professionals who need to administer, maintain, and optimize SQL Server 2008. Written by award-winning author William Stanek, this portable reference delivers essential details for using SQL Server 2008 to help protect and manage your company s data whether automating tasks, creating indexes and views, performing backups and recovery, replicating transactions, tuning performance, managing server activity, importing and exporting data, or performing other key tasks. Featuring quick-reference tables, lists, and step-by-step instructions, this handy, one-stop guide provides fast, accurate answers on the spot whether you re at your desk or in the field!
Key Book Benefits
Provides fast facts and immediate reference for administering SQL Server 2008 Delivers must-know details for taking advantage of the improved scalability, security features, and management tools in SQL Server 2008 Features concise tables, easy-to-scan lists, and step-by-step instructions for fast answers, wherever you need them

Microsoft SQL Server 2008 Analysis Services Unleashed

Irina Gorbach, Alexander Berger, Edward Melomed

Amazon Price: $37.79 List Price: $59.99 Usually ships in 24 hours By: Sams Amazon Marketplace: 16 new & used starting at $37.35

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS

Editorial Review:

As the foundation of the Microsoft Business Intelligence Strategy, Microsoft SQL Server 2008 Analysis Services provides users with faster access to data and even more tools for managing and analyzing data across multidimensional objects (databases, dimensions, cubes).

 

Microsoft SQL Server 2008 Analysis Services Unleashed is the ultimate guide for anyone who is planning to use the latest version of Analysis Services. It gives readers insight into the way Analysis Services functions, and explains practical methods for designing and creating multidimensional objects. It also provides valuable insight into the reasons behind the design decisions taken by the product development team. The authors have been involved with Analysis Services from its earliest days. They have documented in detail the internal features of Analysis Services 2008, explaining server architecture, main data structures, data processing, and query resolution algorithms.

 

• Discover the new functionality introduced in Analysis Services 2008 including MDX enhancements and new DMV (dynamic memory views)
• Work with the Business Intelligence Development Studio, the new Dimension Editor, and Aggregation Designer interfaces
• Enjoy complete coverage of new Shared Scalable Databases scale-out infrastructure
• Learn the key concepts of multidimensional modeling
• Explore the multidimensional object model and its definition language
• Integrate multidimensional and relational databases
• Build client applications to access data in Analysis Services
• Unravel the inner workings of the server architecture, including main data structures, data processing, and query resolution algorithms
• Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts
• Gain a deeper understanding of the internal and external protocols for data transfer, including the XML/A protocol
• Discover how Analysis Services manages memory
• Explore the security model, including role-based security, code-access security, and data security

 

Category: Microsoft SQL Server

Covers: Microsoft SQL Server 2008 Analysis Services

User Level: Intermediate-Advanced

 

$59.99  USA / $65.99 CAN / £38.99 Net UK±

Data Mining with Microsoft SQL Server 2008

Jamie MacLennan, ZhaoHui Tang, Bogdan Crivat

Amazon Price: $44.36 List Price: $50.00 Usually ships in 24 hours By: Wiley Amazon Marketplace: 32 new & used starting at $29.95

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Data Mining
Subjects -> Computers & Internet -> Databases -> SQL -> General

Customer Reviews:
Total reviews: 2 Average rating: 3.0 of 5

A plug-in developer must read 5 out of 5 stars.
3 of 3 people found this review helpful.

This book was a very useful resource while developing a plug-in algorithm to the SQL Server Data Mining framework. I have had mixed results in the past trying to integrate into the framework, but both this book and the previous SQL Server 2005 version answered all my questions and helped me and my company to create a much improved product offering. With a little bit of time vague requests like "build a recommendation engine" can be turned into crowd pleasers, without having to delve into custom algorithm development and extensive research.

The price tag is a little steep, but the content is well worth it.

Editorial Review:

Understand how to use the new features of Microsoft SQL Server 2008 for data mining by using the tools in Data Mining with Microsoft SQL Server 2008, which will show you how to use the SQL Server Data Mining Toolset with Office 2007 to mine and analyze data. Explore each of the major data mining algorithms, including naive bayes, decision trees, time series, clustering, association rules, and neural networks. Learn more about topics like mining OLAP databases, data mining with SQL Server Integration Services 2008, and using Microsoft data mining to solve business analysis problems.

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes

Ben Forta

Amazon Price: $13.59 List Price: $19.99 Usually ships in 24 hours By: Sams Amazon Marketplace: 48 new & used starting at $11.30

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Relational Databases
Subjects -> Computers & Internet -> Databases -> SQL -> General

Customer Reviews:
Total reviews: 4 Average rating: 5.0 of 5

Editorial Review:

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through 10-minute lessons, you’ll learn everything you need to know to take advantage of Microsoft SQL Server’s T-SQL language.

 

This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints, XML, and much more.

 

You’ll learn what you need to know methodically, systematically, and simply–in highly focused lessons designed to make you immediately and effortlessly productive.

 

Tips point out shortcuts and solutions

 

Cautions help you avoid common pitfalls

 

Notes explain additional concepts, and provide additional information

 

10 minutes is all you need to learn how to…

• Use T-SQL in the Microsoft SQL Server environment
• Construct complex T-SQL statements using multiple clauses and operators
• Filter data so you get the information you need quickly
• Retrieve, sort, and format database contents
• Join two or more related tables
• Make SQL Server work for you with globalization and localization
• Create subqueries to pinpoint your data
• Automate your workload with triggers
• Create and alter database tables
• Work with views, stored procedures, and more

 Register your book at www.samspublishing.com/register to download examples and source code from this book.