- You'll save an extra 5% on Books purchased from Amazon.ca, now through July 29th. No code necessary, discount applied at checkout. Here's how (restrictions apply)
Beginning Microsoft SQL Server 2012 Programming Paperback – Apr 16 2012
|New from||Used from|
Special Offers and Product Promotions
Customers Who Bought This Item Also Bought
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.
To get the free app, enter your mobile phone number.
From the Back Cover
Get the tools to change the way you develop database applications
This step-by-step tutorial will show you how to create more productivemanagement applications and gain business intelligence from your SQLServer database environment. You'll learn the foundation objects of SQL and basic queries and joins. You'll then add objects to your database and use items that are important to the physical design. Next, you'll explore SQL Server scripting. By the end, you'll have gained the necessary skills to build a world-class database for your world-class application, using the full capabilities of SQL Server 2012.
Beginning Microsoft SQL Server 2012 Programming:
Explores the key concepts for developing SQL Server applications, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and the development of Business Intelligence applications
Walks you through client-connectivity enhancements, security and compliance, and data warehouse performance improvements
Addresses essential topics including managing keys, writing scripts, and working with stored procedures
Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services
Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.
Find articles, ebooks, sample chapters and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.
Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that guides you through all the techniques involved.
About the Author
Paul Atkinson works for Huron Healthcare as a BI Architect and Team Lead developing both traditional and real-time BI solutions. His training classes in high-performance TSQL programming are among the most popular course offerings available at Huron.
Robert Vieira is a Software Architect with Huron Consulting Group and is considered one of the leading authorities on Microsoft SQL Server. He speaks at conferences nationally and is well known for his unique tutorial approach in his teaching and writing.
Most Helpful Customer Reviews on Amazon.com (beta)
With that understanding, let's turn to what the book IS. It IS a very thorough, high-level introduction to the fundamentals of SQL Server. Some of the content applies to all versions of SQL, but as the title implies, a good portion is specific to SQL Server 2012. Someone with years of experience working with earlier versions of the product will be able to quickly skim the Table Of Contents to find the "new" material. Someone new to the product will be able to read the book from start to finish, gaining a good grasp of the basic concepts, without feeling overwhelmed.
Topics include basic DDL operations, proper uses of triggers, views and their ilk (along with warnings of what NOT to do), old and new JOIN syntaxes, concurrency, XML, and even some introductory Integration Services and Reporting Services material. I've been administering and developing against SQL Server for over 15 years, and still found some new and useful information in the SSIS and SSRS sections.
In short, reading this won't make you a SQL Server expert, only experience can do that. If you're new to the game however, this is a good place to start. I'd recommend it to anybody just starting out.
Before the book dives into the basics starting of T-SQL fundamentals, it gives an overview of RDBMS basics and then moves on to CRUD operations of SQL, Joins etcs and covers advanced topics such as XML and Locking. It also gives some overview of SSIS, BI and other SQL server related activities like administration.
In short, I will recommend this book to all the newbies who want to get introduced to the enchanting world of T-SQL for the newest edition of MS SQL Server.
1. There are two online appendices on the contents page, but the book does not include the two appendices. I have checked Wrox's online site for the book, but they are not there, either. I have posted a question on the P2P forum in the Wrox's site regarding this, but I have not yet heard any response.
2. In some chapters, some SQL statements shown on the book are missing from the code downloaded from Wrox's site. Quite frustrating that I had to type out all the SQL statements myself.
Added on 21 October, 2012:
Regarding 1: five months have passed since I have posted the question of the online appendices on the P2P forum in the Wrox's site and there is still no answer. The writers of the book and the publisher are very UNPROFESSIONAL. Changed from four stars to three.
Look for similar items by category
- Books > Computers & Technology > Databases > Beginning & Introductory
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Microsoft > Development > SQL Server
- Books > Computers & Technology > Networking & Cloud Computing > Data in the Enterprise > Client-Server Systems
- Books > Computers & Technology > Programming > Introductory & Beginning
- Books > Computers & Technology > Web Development > Programming > SQL