更新时间：2021-09-03 10:07:37
封面
版权页
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 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
Index
