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

An overview of database recovery models

The recovery model determines how the transactions are logged, whether the backups of transaction logs are allowed, and the type of restore options available to recover the database. The SQL Server 2014 database can be configured to one of three recovery models, which are explained in the following sections.

The simple recovery model

When you use the simple recovery model, SQL Server logs a minimal amount of transactions in the transaction log file, and the transaction log is truncated as soon as transactions are committed. Simple recovery does not allow backups of transaction log files; therefore, databases with a simple recovery model are vulnerable to data loss because you cannot restore the databases to a specific point in time.

The bulk-logged recovery model

With the bulk-logged recovery model, bulk operations are minimally logged in the transaction log file, reducing the overall size of the transaction log file. All other operations are fully logged...

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