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

Understanding the DDL, DCL, and DML language elements

As mentioned earlier, the Transact-SQL statements have three categories: DDL statements, DCL statements, and DML statements. Each of the commands in these categories include keywords and parameters that can be used to create, modify, and query SQL Server 2014 databases and tables. Let's have a quick look at the keywords and the purpose of each T-SQL statement type in the following sections.

Data Definition Language (DDL) statements

The T-SQL DDL statements include keywords that you can use to create databases and database objects, modify databases and database objects, and remove databases and database objects. The DDL statements consist of the following keywords: CREATE, ALTER, and DROP. Using these DDL keywords, you can create and modify the structure of your databases and create and modify all kinds of database objects (tables, schemas, indexes, stored procedures, functions, views, triggers, login accounts, database users, server and...

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