Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying SQL Server 2014 Development Essentials
  • Table Of Contents Toc
  • Feedback & Rating feedback
SQL Server 2014 Development Essentials

SQL Server 2014 Development Essentials

By : A. Masood-Al-Farooq
3 (3)
Buy this Book
close
close
SQL Server 2014 Development Essentials

SQL Server 2014 Development Essentials

3 (3)
By: A. Masood-Al-Farooq
Buy this Book

Overview of this book

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. 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.
Table of Contents (8 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Microsoft SQL Server Database Design Principles
Icon
1. Microsoft SQL Server Database Design Principles
Icon
Database design
Icon
Table design
Icon
Relationships
Icon
Data integrity
Icon
The basics of data normalization
Icon
The SQL Server database architecture
Icon
The importance of choosing the appropriate data type
Icon
Summary
2
2. Understanding DDL and DCL Statements in SQL Server
Icon
2. Understanding DDL and DCL Statements in SQL Server
Icon
Understanding the DDL, DCL, and DML language elements
Icon
Understanding the purpose of SQL Server 2014 system databases
Icon
An overview of database recovery models
Icon
Creating and modifying databases
Icon
Creating and managing database schemas
Icon
Creating and managing tables
Icon
Grant, deny, and revoke permissions to securables
Icon
Summary
3
3. Data Retrieval Using Transact-SQL Statements
Icon
3. Data Retrieval Using Transact-SQL Statements
Icon
Understanding Transact-SQL SELECT, FROM, and WHERE clauses
Icon
Using T-SQL functions in the query
Icon
Multiple table queries using UNION, EXCEPT, INTERSECT, and JOINs
Icon
Subqueries
Icon
Common Table Expressions
Icon
Organizing and grouping data
Icon
Using the Transact-SQL analytic window functions
Icon
Summary
4
4. Data Modification with SQL Server Transact-SQL Statements
Icon
4. Data Modification with SQL Server Transact-SQL Statements
Icon
Inserting data into SQL Server database tables
Icon
Updating data in SQL Server database tables
Icon
Deleting data from SQL Server database tables
Icon
Using the MERGE statement
Icon
The TRUNCATE TABLE statement
Icon
The SELECT INTO statement
Icon
Summary
5
5. Understanding Advanced Database Programming Objects and Error Handling
Icon
5. Understanding Advanced Database Programming Objects and Error Handling
Icon
Creating and using variables
Icon
Control-of-flow keywords
Icon
Creating and using views
Icon
Creating and using stored procedures
Icon
Creating and using user-defined functions
Icon
Creating and using triggers
Icon
Handling Transact-SQL errors
Icon
Summary
6
6. Performance Basics
chevron up
Icon
6. Performance Basics
Icon
Components of SQL Server Database Engine
Icon
The SQL Server 2014 in-memory OLTP engine
Icon
Indexes
Icon
Query optimization statistics
Icon
The fundamentals of transactions
Icon
SQL Server 2014 tools for monitoring and troubleshooting SQL Server performance
Icon
Summary
7
Index
Icon
Index

Components of SQL Server Database Engine

SQL Server Database Engine has two major components: Relational Engine and Storage Engine. We have already covered the SQL Server Storage Engine architecture in the first chapter of this book. In this section, we'll be covering the SQL Server Relational Engine architecture and other topics to optimize the SQL Server Relational Engine.

The SQL Server Relational Engine architecture

The SQL Server Relational Engine is also known as the query processor because it produces the optimal execution plan for your query or each query stored in a batch or stored procedure. Then, it executes this query plan to deliver the desired results to the client in a format specified in the submitted Transact-SQL statement.

The following diagram outlines the query optimization process:

The key phases of the query optimization process are explored in the next sections.

Parsing and binding

The SQL Server Relational Engine includes a command parser that checks the query to make sure...

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
SQL Server 2014 Development Essentials
End of Section 6
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon