SQL Server 2008 Database Administrator Portable Command Guide

SQL Server 2008 Database Administrator Portable Command Guide : MCTS 70-432 and MCITP 70-450

By (author) 

List price: US$34.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

To maximize your effectiveness as an SQL Server 2008 database administrator, you must keep track of hundreds of Transact-SQL commands, keywords, command arguments, options, and prompts - and Microsoft's MCTS 70-432 and MCITP 70-450 exams test you on many of those. Familiarizing yourself with all these commands is a daunting task. SQL Server 2008 Database Administrator Portable Command Guide: MCITP 70-432 and 70-450 brings them all together in one compact, portable, easy-to-use reference. Packed with configuration examples, real-world scenarios, and expert usage tips, this book covers everything IT professionals need to know about Transact-SQL 2.0 for SQL Server 2008, from basic concepts to advanced techniques. You'll learn how to use Transact-SQL to: * Work with the SQL Server Management Studio * Manipulate database objects and data * Write scripts involving Transactions, SQLCmd, and DAC * Manage backup and restore * Administer and maintain databases * Run system and user-defined stored procedures * Enforce security through database roles, logins, DDL triggers, data encryption, certificates, and keys * And much more It's the perfect take-anywhere guide to administering SQL Server 2008 databases - and passing Microsoft's two key SQL Server 2008 DBA exams.
show more

Product details

  • Paperback | 350 pages
  • 152 x 229mm
  • Pearson It Certification
  • Upper Saddle River, United States
  • English
  • 0789747383
  • 9780789747389

Table of contents

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
show more