Beginning Microsoft SQL Server 2012 Programming Paperback – Apr 16 2012
|New from||Used from|
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.
To get the free app, enter your e-mail address or 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.
Inside This Book(Learn More)
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.
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