Description
1. Overview and Installation
2. SQL Server Management Studio
3. Database Design and Creation
4. Security and Compliance
5. Defining Tables
6. Creating Indexes and Database Diagramming
7. In-memory Tables
8. Database Backups and Recovery
9. Database Maintenance
10. Data Insertion, Deletion, and Transactions-- Disk-Based
11. Selecting and Updating Data from Disk-Based Tables
12. Working with In-Memory Tables
13. Building a View
14. Stored Procedures, Functions, and Security
15. Natively Compiled Stored Procedures
16. Essentials for Effective Coding
17. Advanced T-SQL and Debugging
18. Triggers
19. Connecting via Code
Author: Robin Dewson
Publisher: Apress
Published: 12/16/2014
Pages: 684
Binding Type: Paperback
Weight: 2.55lbs
Size: 9.25h x 7.50w x 1.37d
ISBN13: 9781484202814
ISBN10: 1484202813
BISAC Categories:
- Computers | Programming | Microsoft
- Computers | Database Administration & Management
- Computers | Security | General
About the Author
Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.