MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft® SQL Server 2000 Database Design and Implementation
Exam 70-229
Résumé
Official Microsoft study guide for the database development skills tested on the job—and on MCP Exam 70-229
Learn how to deliver powerful database solutions—and prepare for MCP Exam 70-229—with this official Microsoft study guide. Exam 70-229 is an elective for MCSE/MCSA certification and a core exam on the MCDBA track. Build your expertise designing and implementing data-driven business applications using SQL Server 2000 by working at your own pace through the book's lessons and hands-on exercises. The second edition of this popular TRAINING KIT now features a testing tool to measure what you know and where to focus your studies—before taking the actual exam. Topics include developing a logical data model; creating databases; using Transact-SQL and Data Transformation Services (DTS) to manipulate data; extracting data in XML format; programming business logic using stored procedures, transactions, triggers, user-defined functions, and views; optimizing database performance by using SQL Profiler and the Index Tuning Wizard; and implementing security. You also get a CD-ROM loaded with practice exercises and an easy-search electronic version of the study guide.
Contents
- Self-Paced Training For Microsoft SQL Server 2000
Database Design And Implementation
- Introduction to Microsoft SQL Server 2000
- Using Transact-SQL on a SQL Server Database
- Designing a SQL Server Database
- Implementing SQL Server Databases and Tables
- Implementing Data Integrity
- Accessing and Modifying Data
- Managing and Manipulating Data
- Implementing Stored Procedures
- Implementing Triggers
- Implementing Views
- Implementing Indexes
- Managing SQL Server Transactions and Locks
- Designing and Administering SQL Server 2000 Security
- SQL Server Monitoring and Tuning
- Preparation for MCP Exam 70-229
- OBJECTIVE DOMAIN 1: Developing a Logical Data Model
- OBJECTIVE DOMAIN 2: Implementing the Physical Database
- OBJECTIVE DOMAIN 3: Retrieving and Modifying Data
- OBJECTIVE DOMAIN 4: Programming Business Logic
- OBJECTIVE DOMAIN 5: Tuning and Optimizing Data Access
- OBJECTIVE DOMAIN 6: Designing a Database Security Plan
- Appendix: Questions and Answers
- Glossary
L'auteur - Microsoft Corporation
The Microsoft Windows Server 2003 team designs, builds, tests, documents and supports Microsoft Windows server products and solutions.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Microsoft Press |
| Auteur(s) | Microsoft Corporation |
| Parution | 15/07/2001 |
| Nb. de pages | 820 |
| Format | 19 x 23,5 |
| Couverture | Broché |
| Poids | 1580g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780735619609 |
| ISBN13 | 978-0-7356-1960-9 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
