MCSE SQL Server 2000 Database Design and Implementation
Exam 70-229
Résumé
The book is organized according to the exam objectives, including:
- Introducing SQL Server 2000
- Database design
- Grouping and normalizing data
- Data access and modification
- Programming
- Views
- Constraints, defaults and triggers
- Stored Procedures and UD functions
- Indexes
- Replication
- Monitoring
Contents
Pt. I Exam Preparation
- 1 Introducing SQL Server 2000 11
- 2 Database Design for SQL Server 2000 53
- 3 Physical Database Design and Implementation 107
- 4 Querying and Modifying Data 191
- 5 Advanced Data Retrieval and Modification 249
- 6 Programming SQL Server 2000 329
- 7 Working with Views 389
- 8 Triggers 445
- 9 Stored Procedures and User-Defined Functions 505
- 10 Boosting Performance with Indexes 557
- 11 Implementing and Understanding Replication Methodologies 617
- 12 Monitoring and Tuning SQL Server Databases 673
- Fast Facts
- Study and Exam Prep Tips
- Practice Exam
L'auteur - Thomas Moore
Thomas Moore, MCSE, MCSE, MCDBA, MCT, CTT, has been in
the computer industry for more than 20 years. Thomas has a
wide variety of expertise in all hardware environments and
with most Microsoft Server products. "My first and lasting
love, besides my wife and family, however, is programming."
Thomas is comfortable in any programming language
environment, achieving his MCSD and MCDBA certifications
from their inception. Over the past 12 years he has been
working for a variety of Microsoft partners and currently
is a Systems Analyst for TechServices Web Development Group
in Fort Wayne, Indiana, where he has been for the past
three years. Thomas enjoys staying up-to-date, although
like most of us, he finds it a challenge to keep up with
the pace of the industry. Thomas's most recent
certification achievements include being one of the first
Windows 2000 MCSEs in the world and achieving the same
standard as a SQL Server 2000 MCDBA.
Autres livres de Thomas Moore
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | New Riders |
| Auteur(s) | Thomas Moore |
| Parution | 15/03/2002 |
| Nb. de pages | 898 |
| Format | 21 x 24 |
| Couverture | Relié |
| Poids | 1895g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780735711297 |
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
