Beginning Microsoft SQL Server 2012 Programming (Programmer to Programmer) - Softcover

Atkinson, Paul; Vieira, Robert

Softcover

ISBN 10: 1118102282 ISBN 13: 9781118102282

Publisher: Wrox, 2012

Synopsis

Get up to speed on the extensive changes to the newest release of Microsoft SQL Server

The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly proceeds to show you how to implement the fundamental concepts of Microsoft SQL Server 2012.

You'll explore the key additions and changes to this newest version, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and development of BI applications.

• Covers new features such as SQL Azure for cloud computing, client-connectivity enhancements, security and compliance, data replication, and data warehouse performance improvements
• Addresses essential topics including managing keys, writing scripts, and working with store procedures
• Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services

Beginning Microsoft SQL Server 2012 Programming demystifies even the most difficult challenges you may face with the new version of Microsoft SQL Server.

About this title

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.

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.

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 productive management applications and gain business intelligence from your SQL Server 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

wrox.com

Programmer Forums

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.

Code Downloads

Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.

Read More

Find articles, ebooks, sample chapters and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

From the Inside Flap

Get the tools to change the way you develop database applications

This step-by-step tutorial will show you how to create more productive management applications and gain business intelligence from your SQL Server 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

wrox.com

Programmer Forums

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.

Code Downloads

Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.

Read More

Find articles, ebooks, sample chapters and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

Edition details

• Publisher: Wrox
• Publication date: 2012
• ISBN 10: 1118102282
• ISBN 13: 9781118102282
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 864