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
chevron up
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
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

Creating and using views

A view is a virtual table whose result set is derived from a query. In reality, a view is simply a SELECT statement that is saved with the name in the database. Views are used just like regular tables without incurring additional cost, unless you are indexing the view. We typically create views based on one or more tables, views, CTEs, table-valued functions, or a combination of them all. We can reference views in Transact-SQL statements in the same way tables are referenced. We can also perform DML operations on views. The typical uses of views include:

  • A denormalized presentation of normalized data

  • Limiting access to specific columns of the underlying tables

  • Creating a reusable set of data

  • Restricting users' access to sensitive data

    Tip

    You should avoid using SELECT * in views, because when you do, the columns list is resolved each time you query the view. Moreover, the result set of the view query changes when the underlying table schema changes. A good practice is...

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 5
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