SQL Server 2008 Database Administrator Portable Command Guide

Part I. Working with the SQL Server Management Studio
1. Understanding System Databases
2. Using a Query Window
3. Introduction to Transact-SQL
4. Preparing Drives for Data

Part II. Using T-SQL to Work with Database Objects
5. Understanding Basic Database Objects
6. Creating Objects with Create
7. Creating Tables and Views
8. Modifying and Removing Objects

Part III. Using T-SQL to Work with Data
9. Adding Data with the Insert Statement
10. Querying Data with the Select Statement
11. Filtering Data with the Where clause
12. Modifying Data with the Update Statement
13. Deleting Data with the Delete Statement
14. Importing and Exporting Data

Part IV. Using T-SQL Scripts
15. Using Transactions
16. Using SQLCmd and DAC

Part V. Backup and Restore
17. Understanding Recovery Models
18. Backing up the Database
19. Backing up the Log
20. Restoring Database and Log
21. Restoring to Point In Time
22. Backing up and Restoring System Databases

Part VI. Managing and Maintaining Databases
23. Optimizing Databases with Indexes
24. Using DBCC CheckDB
25. Verifying Database Integrity
26. Using Dynamic Management Views and Functions
27. Using SQL Profiler from the Command Line
28. Using the Dedicated Administrator Connection
29. Using Peverify

Part VII. Stored Procedures
30. System Stored Procedures
31. Using Sp_configure
32. User-defined Stored Procedures

Part VIII. Database Security
33. Understanding Server and Database roles
34. Creating Logins
35. Modifying Database Security
36. Using DDL Triggers

Part IX. Protecting Data with Encryption
37. Encrypting Data
38. Managing Certificates and Keys