Introduction

Beginning SQL Server 2012 for Developers is for those people who see themselves as becoming either developers, database administrators, or a mixture of both but have yet to tread that path with SQL Server 2012. This edition of my book is for readers who wish to learn and develop on the free version of SQL Server 2012, SQL Server 2012 Express, or either the trial or licensed versions of SQL Server 2012.

Whether you have no knowledge of databases, or have knowledge of desktop databases such as MS Access, or even come from a server-based background such as Oracle, this book will provide you with the insight to get up and running with SQL Server 2012.

Right from the start, your basic knowledge will be expanded, and you will soon be moving from a perceived beginner through to a competent and professional developer. It is the aim of this book to cater to a wide range of developers, from those who prefer to use the graphical interface for as much work as possible to those who want to become more adept at using the SQL Server 2012 programming language, T-SQL. Where practical, each method of using SQL Server 2012 is demonstrated, explained, and expanded so that you can evaluate what works best in your situation. You will also find a chapter on how to work with using Excel, .NET, and Java and incorporate them with T-SQL.

There are plenty of examples within the book of every action along with details about the security of your data. You will also learn the best way to complete a task and even how to make the correct decision when there are two or more choices that could be made.

Once you reach the end of this book, you will be able to design and create solid and reliable database solutions competently and proficiently.