5. Understanding Advanced Database Programming Objects and Error Handling | SQL Server 2014 Development Essentials

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

SQL Server 2014 Development Essentials

By : A. Masood-Al-Farooq

3 (3)

SQL Server 2014 Development Essentials

3 (3)

By: A. Masood-Al-Farooq

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.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Microsoft SQL Server Database Design Principles

1. Microsoft SQL Server Database Design Principles

Database design

Table design

Relationships

Data integrity

The basics of data normalization

The SQL Server database architecture

The importance of choosing the appropriate data type

Summary

2. Understanding DDL and DCL Statements in SQL Server

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

3. Data Retrieval Using Transact-SQL Statements

Understanding Transact-SQL SELECT, FROM, and WHERE clauses

Using T-SQL functions in the query

Multiple table queries using UNION, EXCEPT, INTERSECT, and JOINs

Subqueries

Common Table Expressions

Organizing and grouping data

Using the Transact-SQL analytic window functions

Summary

4. Data Modification with SQL Server Transact-SQL Statements

4. Data Modification with SQL Server Transact-SQL Statements

Inserting data into SQL Server database tables

Updating data in SQL Server database tables

Deleting data from SQL Server database tables

Using the MERGE statement

The TRUNCATE TABLE statement

The SELECT INTO statement

Summary

5. Understanding Advanced Database Programming Objects and Error Handling

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

6. Performance Basics

Components of SQL Server Database Engine

The SQL Server 2014 in-memory OLTP engine

Indexes

Query optimization statistics

The fundamentals of transactions

SQL Server 2014 tools for monitoring and troubleshooting SQL Server performance

Summary

Index

Index

Customer Reviews

3 (3)

5 star

0%

4 star

33.3%

3 star

33.3%

2 star

33.3%

1 star

0%

Control-of-flow keywords

Control-of-flow keywords help SQL Server determine when and how Transact-SQL statements should execute. With these keywords, you can add logic around and within Transact-SQL statements to control program execution. Control-of-flow keywords add greater flexibility in OLTP application design and help you write clever code. Control-of-flow keywords include BEGIN…END, IF…ELSE, CASE, WHILE, BREAK, CONTINUE, RETURN, GOTO, and WAITFOR.

BEGIN…END keywords

The BEGIN…END keywords identify a code block. We typically use them to group Transact-SQL statements. The BEGIN…END blocks can be nested. We also use BEGIN…END statements to identify a code block in an IF…ELSE clause, WHILE loop, and CASE element. The following is the basic syntax for the BEGIN…END keyword block:

BEGIN
     {
    sql_statement | statement_block
     }
END

The following is a basic example of BEGIN…END:

USE [AdventureWorks2012];
GO

BEGIN
    DECLARE @Today [datetime];
    SET @Today = CURRENT_TIMESTAMP;

   ...

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

SQL Server 2014 Development Essentials

Search

Your notes and bookmarks