Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Read books on your computer or other mobile devices with our FREE Kindle Reading Apps.
SQL Programming Joes 2 Pros: Programming & Development for Microsoft SQL Server 2008 (SQL Exam Prep Series 70-433 Volume 4 of 5)
 
 
Share your own customer images

SQL Programming Joes 2 Pros: Programming & Development for Microsoft SQL Server 2008 (SQL Exam Prep Series 70-433 Volume 4 of 5) [Kindle Edition]

Pinal Dave (Author), Rick A. Morelan (Author)
4.1 out of 5 stars  See all reviews (7 customer reviews) |
Digital List Price: $9.99 What's this?
Print List Price: $38.99
Kindle Purchase Price: $9.99
Prime Members: $0.00 (borrow for free from your Kindle) Prime Eligible
When Purchased, You Save: $29.00 (74%)
  • Includes free wireless delivery via Amazon Whispernet
  • Length: 478 pages
  • Due to its large file size, this book may take longer to download

For Kindle Device Owners

Borrow this book for free on a Kindle device with Amazon Prime. Buy a Kindle today and start your Amazon Prime free trial to borrow this book at no cost.

With Prime, Kindle owners can choose from over 145,000 titles to borrow for free – including all seven Harry Potter books (available on June 19) and more than 100 current and former New York Times Bestsellers – as frequently as a book a month, with no due dates. Learn more about Kindle Owners' Lending Library.

Formats

 Amazon Price New from Used from
Kindle Edition $9.99   -- --
Paperback $35.09   -- --

Book Description

Publication Date: September 26, 2011
The SQL developer needs to be able to create processes for the working database by using one of the many programming objects (like functions, stored procedures, constrains, or triggers). By creating objects that talk with SQL you simply the way other programs (like applications or web pages) can interconnect. These eternal programs only need to call on the names of your programming objects by name rather than needing to submit large pieces of advance code. With SQL Programming Development (Volume 4 of 5) in the SQL Server Joes 2 Pros development series, you learn how programming objects work in SQL Server.

Customers Who Bought This Item Also Bought

Product Details

Customer Reviews

Most Helpful Customer Reviews
13 of 16 people found the following review helpful
A Review of the Reviewers January 5, 2012
Format:Paperback
First, I do not own this book and I have not read it, but I would encourage you to read on.

I was looking at the Microsoft Press book for the 70-433 test and the reviews are just average so I decided to dig deeper and I came across the Joes 2 Pros series of books. The reviews looked great. This particular book, at the time I'm writing this review (1/5/2012), has 4 reviews and they are all 5 star.

However, I started to read the reviews and they all, to me, seemed to be too perfect so I dug a bit deeper. I decided to look at the other reviews that these reviewers have written.

Mr. Doshi has written 3 reviews. They are all 5 star and they are all for CreateSpace books, the publisher of this book.

Bill P has written the one review for this book.

SQLWriter has written 2 reviews. Both 5 stars and both for books from this publisher.

Groovechampion has written many more reviews, but only 5 of them are for books. All the book reviews are 5 star, and all are for books, once again, for this publisher. Furthermore, when someone made a comment under one of his reviews that was slightly negative about the publisher taking a long time to publish, Goovechampion replied. In his reply, he referenced the fact that the author was currently in India researching his next project. Rather strange that an impartial reader would know the location of an author working on a new book.

These books may indeed be excellent. But something, to me, smells fishy about the reviews.
Was this review helpful to you?
5 of 5 people found the following review helpful
Format:Paperback|Amazon Verified Purchase
SQL Programming Joes 2 Pros: Programming and Development for Microsoft SQL Server 2008 is the fourth volume in the very informative Joes 2 Pros series. These education books are more than just an overview of SQL Server, they are a textbook for learning and designed to take beginners and turn them into professionals.

To start out with, let's review the layout of this book. It is not simply a manual chock full of small text and lots of detail. In fact, this book will remind you more of a college text book - complete with examples, quizzes and a glossary. Readers have multiple chances to check in with their learning and make sure they are absorbing as much information as possible.

Each chapter has multiple "Points to Ponder" section at the end of every subject. These "Points to Ponder" are more than just a summary of what you've already read - so don't skip ahead to these bullet points and think you're getting the full view. These points do go over the highlights, but also add thought problems to the mix, so that your brain can interpret the problems from many different angles.

If you are simply flipping through this book, the first thing you will notice is how many pictures and detailed illustrations there are. As mentioned before - this is not a manual with tiny print. The authors are determined to make sure their readers learn and understand the concepts, and provide screen shots directly from SQL Server so that readers know exactly what to look for. The illustrations point out the important details, and there are also pictures of what will happen if things go wrong - which any student will recognize as a huge help!

If you think a book with so many pictures isn't going to be serious, then think again. The Joes 2 Pros series takes learning seriously, and includes many examples and demonstrations for readers to follow along with on their own computers. You can also download companion files to serve as extra practice. Combine these exercises with the quizzes at the end of every chapter, and readers will soon be confident in their programming and development skills.

In fact, the goal of the authors is to take beginners and get them to a level where they can become Microsoft Certified Technical Specialists. If you follow the Joes 2 Pros series from beginning to tend (this is the fourth volume in a five book series), you can be confident that this goal will be achieved. If you are an intermediate or advanced user, though, this book will not bore you. It is a great way to learn about new features or fill any gaps in your knowledge.

One chapter especially worth pointing out is Chapter 13: Performance Tips, written by Pinal Dave - Technology Evangelist and Microsoft MVP. This chapter specifically focuses on how to optimize and streamline SQL Server performance. Learning these steps is almost as critical as learning the basics, and in this chapter, Pinal Dave explains why these "little things that count."

Overall, this book is a must-have for anyone who works with SQL Server. It is a great learning tool, and believe it or not, a great read! Each chapter introduces the topic with a short story that serves as an example for the material about to be covered, which makes this book both entertaining and informative. Five stars!
Comment | 
Was this review helpful to you?
3 of 3 people found the following review helpful
By Bill P
Format:Paperback
I highly recommend this book for both beginning and advanced SQL Server programmers and DBAs. It is concise, easy to read and clear. For those just starting out in their SQL Server career, I can't recommend this book enough. For those more advanced in their careers, this books and its companions in the series are great refresher books.

This book is easy to read without feeling like you are about to fall asleep. There are lots of examples throughout the book, as well as many figures (pictures of both queries and their results). Exercises have a progression through the chapter and build upon the prior exercise or example.

This book covers a lot of topics, including constraints, triggers, views, stored procedures, user-defined functions, error messages and error handling, and other topics. There is also a chapter on Performance Tips that covers "little things" that help contribute to better performance. The little things add up!

Get this book and read it!
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
Search Customer Reviews
Only search this product's reviews

More About the Author

› Visit Amazon's Rick A Morelan Page
Rick A Morelan
Joes2Pros is the brainchild of Rick A. Morelan.

Rick has been working with Microsoft since the late 90s and has attained over 30 Microsoft certifications in applications, networking, databases and .NET development, including MCDBA, MCTS, MCITP, MCAD, MOE, MCSE and MCSE+. His SQL certification in 2008 is the 4th generation of SQL certification in Implementation, Administration, and BI which also includes (SQL 7.0, SQL 2000, SQL 2005, and SQL 2008).

Rick has provided training for Northwest University, Volt Technical Education, and Microsoft. He currently works as a Software Design Engineer in Test for the Windows Mobile group, Bellevue College, and Moretechnology.com.

As the author of the "SQL Joes 2 Pros" book and video series, the focus is upon delivering the most effective and relevant learning material. Rick has comprehensive real-world knowledge in the subjects to prepare you for real-world troubleshooting issues while backing it up with the IT certification.

Rick lives near Seattle, Washington. Being someone dedicated to software designing and training, he is also an ardent charity worker. He trains service dogs that assist people with mobility needs. He also assists in walking the dogs and helps the puppies socialize more. Click here (See page 2).

Rick also happens to be in the Guinness Book of world records for producing the largest dog biscuit. To view the certificate, Click here

Rick has attended many trainings at Koenig-Solutions in SQL Server and C#.

Popular Highlights

 (What's this?)
&quote;
Data types are the simplest and most frequently used constraints. &quote;
Highlighted by 6 Kindle users
&quote;
data types are the first line of defense in constraining bad data and ensuring field inputs are valid. &quote;
Highlighted by 5 Kindle users
&quote;
But protecting your data also requires human intelligence and review  in the workplace, these are known as sanity checks of your &quote;
Highlighted by 4 Kindle users

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(1)

Your tags: Add your first tag
 
See most popular tags

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums

So You'd Like to...


Create a guide

Look for Similar Items by Category