Book description
Design, implement, and deliver a successful database solution with Microsoft SQL Server 2014
In Detail
SQL Server 2014 Development Essentials is an easy-to-follow yet comprehensive guide that is full of hands-on examples. With Microsoft SQL Server 2014, you can design, build, and deploy mission-critical database applications. The variety of new in-memory features enable you to design high performance database applications that can improve the performance of your applications, making them as much as ten times more efficient in some cases.
Whether you are thinking about becoming a database developer, architect, or administrator, or you are a seasoned database expert, this book will provide you with all the skills you need to successfully create, design, and deploy databases using SQL Server 2014. You will also learn how to add, modify, and delete data stored within a database. You will use Transact-SQL statements to create and manage advanced database objects that include scalar and table-valued functions, views, stored procedures, and triggers. Finally, you will learn about how SQL Server works, how indexes and statistics improve query performance, and the new SQL Server 2014 in-memory technologies.
What You Will Learn
- 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
Table of contents
-
SQL Server 2014 Development Essentials
- Table of Contents
- SQL Server 2014 Development Essentials
- Credits
- About the Author
- Acknowledgments
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Microsoft SQL Server Database Design Principles
-
2. Understanding DDL and DCL Statements in SQL Server
- Understanding the DDL, DCL, and DML language elements
- Understanding the purpose of SQL Server 2014 system databases
- An overview of database recovery models
- Creating and modifying databases
- Creating and managing database schemas
- Creating and managing tables
- Grant, deny, and revoke permissions to securables
- Summary
- 3. Data Retrieval Using Transact-SQL Statements
- 4. Data Modification with SQL Server Transact-SQL Statements
-
5. Understanding Advanced Database Programming Objects and Error Handling
- Creating and using variables
- Control-of-flow keywords
- Creating and using views
- Creating and using stored procedures
- Creating and using user-defined functions
- Creating and using triggers
- Handling Transact-SQL errors
- Summary
-
6. Performance Basics
- Components of SQL Server Database Engine
- The SQL Server 2014 in-memory OLTP engine
-
Indexes
- The cost associated with indexes
- How SQL Server uses indexes
- The structure of indexes
- Index types
-
Guidelines for designing and optimizing indexes
- Avoid overindexing tables
- Create a clustered index before creating nonclustered indexes when using clustered indexes
- Index columns used in foreign keys
- Index columns frequently used in joins
- Use composite indexes and covering indexes to give the query optimizer greater flexibility
- Limit key columns to columns with a high level of selectability
- Pad indexes and specify the fill factor to reduce page splits
- Rebuild indexes based on the fragmentation level
- Query optimization statistics
- The fundamentals of transactions
- SQL Server 2014 tools for monitoring and troubleshooting SQL Server performance
- Summary
- Index
Product information
- Title: SQL Server 2014 Development Essentials
- Author(s):
- Release date: July 2014
- Publisher(s): Packt Publishing
- ISBN: 9781782172550
You might also like
book
Microsoft® SQL Server 2012 Unleashed
Buy the print version of¿ and get the eBook version for free! eBook version includes chapters …
book
What's New in SQL Server 2012
Unleash the new features of SQL Server 2012 Upgrade your skills to the latest version of …
book
Mastering SQL Server 2017
Leverage the power of SQL Server 2017 Integration Services to build data integration solutions with ease …
book
SQL Server 2017 Developer's Guide
Build smarter and efficient database application systems for your organization with SQL Server 2017 About This …