SQL Server 2014 Development Essentials

• Author: Basit A. Masood-Al-Farooq
• Language: English
• Published: July 25, 2014
• Page: 214
• Size:  3 MB
• Format: pdf

What you will learn from this book

• Get introduced to SQL Server 2014's new in-memory database engine.
• Understand SQL Server database architecture and relational database design.
• Use joins, subqueries, CTEs, and windowing functions to write advanced Transact-SQL queries.
• Learn about tools that let you monitor SQL Server database performance.
• Identify and troubleshoot blocks or deadlocks that might slow down a system.
• Design, create, and manage advanced database objects that include scalar and table-valued functions, views, stored procedures, and triggers.
• Use SQL Server 2014's structured error handling blocks to handle errors that occur in the Transact-SQL batches and programmable objects.

Approach

This book is an easy-to-follow, comprehensive guide that is full of hands-on examples, which you can follow to successfully design, build, and deploy mission-critical database applications with SQL Server 2014.

Who this book is written for

If you are a database developer, architect, or administrator who wants to learn how to design, implement, and deliver a successful database solution with SQL Server 2014, then this book is for you. Existing users of Microsoft SQL Server will also benefit from this book as they will learn what's new in the latest version.