Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library 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
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
chevron up
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
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

Data integrity

Data integrity ensures that the data within the database is reliable and adheres to business rules. Data integrity falls into the following categories:

  • Domain integrity: This ensures that the values of the specified columns are legal, which means domain integrity ensures that the value meets a specified format and value criteria. You can enforce domain integrity by restricting the type of data stored within columns (through data types), the format (through CHECK constraints and rules), or the range of possible values (through FOREIGN KEY constraints, CHECK constraints, DEFAULT definitions, NOT NULL definitions, and rules).
  • Entity integrity: This ensures that every row in the table is uniquely identified by requiring a unique value in one or more key columns of the table. You can enforce entity integrity through indexes, UNIQUE KEY constraints, PRIMARY KEY constraints, or IDENTITY properties.
  • Referential integrity: This ensures that the data is consistent between related tables. You can enforce referential integrity through PRIMARY KEY constraints and FOREIGN KEY constraints.
  • User-defined integrity: This ensures that the values stored in the database remain consistent with established business policies. You can maintain user-defined integrity through business rules and enforce user-integrity through stored procedures and triggers.
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 1
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