Beginning SQL Server 2012 for Developers takes you through the entire database development process, from installing the software to creating a database to writing the code to connect to that database and move data in and out. By the end of the book, you’ll be able to design and create solid and reliable database solutions using SQL Server 2012.
· Takes you through the entire database application development lifecycle
· Includes brand new coverage of SQL Server 2012 features
· Introduces the freely-available Express Edition

About the Author

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.

Table of Contents:
Chapter 1: Overview and Installation · Why SQL Server 2012? · Evolution of SQL Server · Hardware Requirements · The Example · Installation · Security Chapter 2: SQL Server Management Studio · A quick Overview of SSMS · Query Editor Chapter 3: Database Design and Creation · Defining a Database · Prebuilt Database Within SQL Server · Choosing the Database · Gathering the Data · Determining the information to store in the Database · External and Ignored Information · Normalization · Creating the Sample Database Chapter 4: Security and Compliance · Logins · Server Logins and Database Users · Roles · Schemas · Before yo can Proceed with your Solution · Declarative Management Framework Chapter 5: Defining Tables · What Is a Table? · SOL Server Data Types · Columns As More Than Simple Data Repositories · Creating a Table in SOL Server Management Studio · Creating a Table Through Ouery Editor · Creating a Table: Using a Template · Creating and Altering a Template · The ALTER TABLE Statement · Defining the Remaining Tables · Setting a Primary Key · Creating a Relationship · Building a Relationship · Relationships: Database or Application Chapter 6: Creating Indexes and Database Diagramming · What Is an Index? · Determining What Makes a Good Index · Determining What Makes a Bad Index · Reviewing Your Indexes for Performance · Creating an Index · Creating an Index in Query Editor · Dropping an Index · Altering an Index · When an Index Does Not Exist · Diagramming the Database Chapter 7: Database Backups and Recovery · Backup Strategies · Transaction Logs · When Problems May Occur · Backups: Taking a Database Offline · Backing Up the Data · Restoring a Database · Detaching and Attaching a Database · Producing SOL Script for the Database Chapter 8: Database Maintenance · Creating a Database Maintenance Plan · Executing the Plan · Setting Up Database Mail · Modifying a Maintenance Plan Chapter 9: Data Insertion, Deletion, and Transactions · Inserting Data ; · Transactions · Deleting Data Chapter 10: Selecting and Updating Data · Retrieving Data · Limiting a Search: The Use of WHERE · String Functions · Order! Order! · The LIKE Operator · Creating Data: SELECT INTO · Updating Data · Using More Than One Table Chapter 11: Building a View · Why a View? · Creating a View: SOL Server Management Studio · Creating a View Using a View · Creating a View Using T -SOL Syntax · Indexing a View Chapter 12: Stored Procedures, Functions, and Security · What Is a Stored Procedure? · Creating a Stored Procedure · Returning Results · Controlling the Flow · Bringing It All Together · Security · User-Defined Functions Chapter 13: Essentials for Effective Coding · Variables · Temporary Tables · Aggregations · Grouping Data · HAViNG · Distinct Values · Functions · RAISERROR · Error Handling Chapter 14: Advanced T -SQL and Debugging · Sequences Instead of IDENTITY · Creating a SEQUENCE · Subqueries · The APPLY Operator · Common Table Expressions · Pivoting Data · Ranking Functions · Cursors · Debugging Your Code Chapter 15: Triggers · What Is a Trigger? · The DML Trigger · DDL Triggers Chapter 16: Connecting via Code · General Application Security · Connecting with Excel or Excel Visual Basic for Applications (VBA) · Visual Studio · Java