SQL Books - Page 6

Beginning SQL Server 2005 Programming (Programmer to Programmer)

Robert Vieira

Amazon Price: $26.39 List Price: $39.99 Usually ships in 7 to 12 days By: Wrox Amazon Marketplace: 39 new & used starting at $21.53

Buy at Amazon.com

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

Customer Reviews:
Total reviews: 24 Average rating: 4.0 of 5

Surely Disappointed. 2 out of 5 stars.
6 of 7 people found this review helpful.

I just bought 2 copies this book based on the reviews and the cost. I planned on using it to teach someone about SQL Server, using SQL Server 2005 Express edition. Well, for teaching purposes, this book is very disappointing. It is however, comprehensive in terms on making knowledgeable many aspects of SQL Server. But if you plan on self-teaching yourself SQL Server, this book lacks. The book does explain all the objects in SQL Server, including as it seems all software books, his personality laced diatribe. But it doesn't explain how to use the objects well. Just trying to learn T-SQL, it doesn't demonstrate or give any examples how to use each command or keyword in length. And there's just a hint of exercises in the back of the chapter to help the learner practice some more. And the book also assumes you have somewhat developed on SQL Server. What?! It's a beginners book.

Now I have to come up with full lesson plans, since this book doesn't even make a dent in doing so.

In conclusion, the book explains a plethora of objects. But if you are wanting to self teach, it will be difficult to learn with this book.

Just want a book that removes individual diatribes, gives many examples of each function, provides many exercises to further practice, with answers. This book doesn't fit the bill.

Editorial Review:

• After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release
• Once readers have grasped the fundamentals of database design and SQL concepts, they will then learn how to implement those concepts with Microsoft SQL Server 2005
• Addresses creating and changing tables, managing keys, database normalization, writing scripts, working with stored procedures, programming with XML, and using SQL Server reporting and data transformation services
• The companion Web site provides all of the code found in the book

SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach

Joseph Sack

Amazon Price: $37.79 List Price: $59.99 Usually ships in 24 hours By: Apress Amazon Marketplace: 39 new & used starting at $32.65

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: 4.0 of 5

Editorial Review:

SQL Server 2008 Transact–SQL Recipes: A Problem–Solution Approach is an example–based guide to the Transact–SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact–SQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.

• Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
• Current: Newly updated for SQL Server 2008.
• Comprehensive: Covers 30 different Transact–SQL problem domains.

What you’ll learn

• Create databases, tables, and indexes.
• Query and manipulate data.
• Store and manage XML inside the database.
• Move business logic into the database.
• Encrypt data and capture changes for compliance purposes.
• Implement Full–Text Search.
• Interface with Service Broker.
• And more!

Who is this book for?

Developers who use Microsoft SQL Server 2008 as their back–end database. Database administrators who create, manage, and secure those databases.

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±

SQL For Dummies

Allen G. Taylor

Amazon Price: $16.49 List Price: $24.99 Usually ships in 24 hours By: For Dummies Amazon Marketplace: 53 new & used starting at $13.48

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: 30 Average rating: 3.0 of 5

We love it! 5 out of 5 stars.
2 of 5 people found this review helpful.

Hardcore DBAs have knocked this book, but I have coworkers who reference it daily and they are now very experienced and knowledgable of SQL.

exactly as the title describes... 4 out of 5 stars.
0 of 0 people found this review helpful.

0 to sql in just a few days. starts with basic relational database information and continues all the way up through advanced SQL functions. handy tear-out quick-reference card included.

Editorial Review:

See how SQL interfaces with today's environments


Start building and using relational databases with SQL's newest features

The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal box. With this book to guide you through all the newest features of SQL, you'll soon be whipping up relational databases, using SQL with XML to power data-driven Web sites, and more!

Discover how to
* Use SQL in a client/server system
* Build a multitable relational database
* Construct nested and recursive queries
* Set up database security
* Use SQL within applications
* Map SQL to XML

PHP & MySQL For Dummies 3rd edition (For Dummies (Computer/Tech))

Janet Valade

Amazon Price: $16.49 List Price: $24.99 Usually ships in 24 hours By: For Dummies Amazon Marketplace: 46 new & used starting at $7.95

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Home Computing -> Internet -> General AAS
Subjects -> Computers & Internet -> Databases -> Database Design
Subjects -> Computers & Internet -> Databases -> Specific Databases -> MySQL & mSQL

Customer Reviews:
Total reviews: 15 Average rating: 4.0 of 5

Great starter book... 5 out of 5 stars.
1 of 1 people found this review helpful.

I liked this book and it's great for starters. The book had minimal errors. You learn how to program complete projects. When you're done with the projects, you are off to the races coding your own projects. I e-mailed the author and recieved a reply! The author cares about her work and it shows in this book. Happy coding and welcome to the PHP world never to look back...

Editorial Review:

Build an online catalog and a members-only site

Everything you need to know to create a dynamic PHP and MySQL Web site!

Been thinking of creating a high-quality interactive Web site? This book is just what you need to get started! Here's the fun and easy way(r) to develop a Web application in PHP 4, 5, or 6 and MySQL 5, test your software, enable your Web pages to display, change, and move database information, and much more.

Discover how to
* Plan and implement a Web database application
* Design and build a MySQL 5 database
* Build dynamic HTML forms
* Create scripts that store, retrieve, and update database information
* Display database information in a Web page

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.

Murach's SQL Server 2008 for Developers

Bryan Syverson, Joel Murach

Amazon Price: $33.08 List Price: $52.50 Usually ships in 24 hours By: Mike Murach & Associates Amazon Marketplace: 21 new & used starting at $30.00

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

Excellent technical reference for SQL Server 2008 5 out of 5 stars.
1 of 1 people found this review helpful.

After spent the past few years as developer/DBA for Oracle databases, SQL server is required during my recent projects. I find myself often spending too much time on simple issues such as how to perform a date and/or date time search. Microsoft SQL/T-SQL syntax is a little bit different from Oracle PL/SQL syntax.

This book really saves me time and effort. This format of this book is like a technical how-to manual or cook book. I extremely love this kind of format because I can quickly refer to a particular issue. The topic is usually concise and easy to understand.

This book is for developers not DBAs. I recommend this book for anyone who wants to learn SQL Server 2008. Of course, basic programming skills are the pre-requisites. In addition, it is very useful as an excellent technical reference book for more experienced programmers.

Editorial Review:

Every application developer who uses SQL Server 2008 should own this book. To start, this book presents the essential SQL statements for retrieving and updating the data in a database, because that's what every application developer needs to know. Then, it shows you how to design and create a database, because application developers often end up in the role of database designer and DBA. Next, it shows how to work with views, scripts, stored procedures, functions, triggers, cursors, transactions, locking, security, XML data, and BLOB data with FILESTREAM storage. These features allow you to create database applications that are thoroughly professional. Finally, this book shows how to use the CLR integration feature, so you can use C# or Visual Basic to code stored procedures, functions, triggers, aggregate functions, and user-defined types.

Beginning PL/SQL: From Novice to Professional (Beginning from Novice to Professional)

Donald Bales

Amazon Price: $29.69 List Price: $44.99 Usually ships in 24 hours By: Apress Amazon Marketplace: 45 new & used starting at $24.62

Buy at Amazon.com

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

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

Editorial Review:

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features.

Author Don Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule &emdash; cover whats most needed and used by PL/SQL professionals and avoid whats not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.

• Discover the 20% of PL/SQL that gives you 80% of the bangkey topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.
• Learn how to write production-level, object-oriented PL/SQLyoull explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQLs object-oriented features as well.
• Work through real examples of using of PL/SQLyoull learn PL/SQL by applying it to real-world business problems, not by heavy theory.

What youll learn

• How important SQL is in PL/SQL
• How to use PL/SQL in both a relational and object-relational setting
• How to create maintainable, modular, and reusable PL/SQL program units
• The importance of testing as you go, and of building a permanent test plan for each module
• The importance of building debugging capabilities into your code and building a permanent debug facility for each module
• The importance of documenting as you go, and in the process building a permanent documentation set for your reusable modules
• How to apply modular PL/SQL to solve real-world problems

Who is this book for?

Anyone who wants to learn how to create stored procedures against an Oracle database using PL/SQL. Programmers developing applications to be deployed against an Oracle database will need PL/SQL to take full advantage of the power Oracle has to offer. Database administrators who wish to implement functionality exposed only via PL/SQL package interfaces will also find this book useful.

About the Apress Beginning Series

The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." Youll start your journey by seeing what you need to knowbut without needless theory and filler. Youll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you thereit is your trusted guide through unfamiliar territory!

Oracle Database 10g PL/SQL Programming

Scott Urman, Michael McLaughlin

Amazon Price: $34.64 List Price: $54.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 47 new & used starting at $27.75

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 -> Oracle -> PL & SQL

Customer Reviews:
Total reviews: 21 Average rating: 4.0 of 5

Good, but could be much better 3 out of 5 stars.
6 of 6 people found this review helpful.

This is book did help me learn PL/SQL; however, it did it in a very painful manner. The book could have easily been condensed to half the size and still convey the same information, only clearly and to the point. Many of the chapters have long coding examples that are followed by a line-by-obvious-line description about what is going on. It's tempting to skip the code explanations; however, there is the occasional hidden piece of useful information in them that forces you to sift through the junk. To make matters worse, much of the code is needlessly commented. You know what type of comments I'm talking about; there will be a comment that reads '-- declare a variable of type varchar' and then a declaration immediately afterward. Wow, thanks for doubling the code size and killing some more trees. Topping that off, in some of the examples, the comments don't actually match what the code is doing. Grrr.

I invested a lot of time in reading this book and after it was all said and done my feeling on it was, meh, I guess I learned something. The book is pretty good, it's just needlessly big, too big and time consuming for the value that it brings to your skill set.

Editorial Review:

Create dynamic client/server applications using PL/SQL and the comprehensive information contained in this authoritative volume. Expert Oracle insiders cover the features of PL/SQL, explain scripting semantics and syntax, and fully detail the PL/SQL functionality of Oracle Database 10g. You’ll learn how to write powerful PL/SQL programs, interact with Oracle databases, perform complex calculations, and handle error conditions.

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.