SQL Server 2000 Page
Tutorials
Certification Page
MCDBA: showcase your talents
MCDBA Requirements
Sandline Learning Affordable Online Computer Courses
Portable DBA: SQL Server, at Amazon USA 5 stars after 8 reviews
The Guru's Guide to Transact-SQL, at Amazon USA
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML, at Amazon USA
The Guru's Guide to SQL Server Boxed Set, at Amazon USA 3 volumes
Preparation Guide at microsoft.com
CertGuide
Administration
Operations Guide
Microsoft SQL
MSDN - look for P & T White Paper by Henry Lau
MS News
NTFAQ
Swynk
Compaq Whitepapers
sql-server.co.uk
learningcomputer.com
Bulk Copy Program
MCSE SQL Server 2000 Administration for Dummies (with CD-ROM), at Amazon USA
Osborne McGraw-Hill Study Guide, at Amazon UK for £36.99
or Amazon USA for $34.99
Microsoft Readiness Review, at Amazon UK for £20.99
or Amazon USA for $20.99
Exam Cram, at Amazon UK for £21.91
or Amazon USA for $24.49
Test Yourself MCDBA, at Amazon UK for £14.99
or Amazon USA for $20.99
SQL-Server-Performance.com: Start Preparing Today
SQL Server 2000 Administration, at Amazon UK for £34.99
or Amazon USA for $31.49 not specifically for the exam
Training Kit (Microsoft Press), at Amazon UK
or Amazon USA
Sybex Study Guide, 2nd Ed, at Amazon UK
or Amazon USA
Books recommended by Swiss reviewer of Microsoft Training Kit:
SQL Server 2000 Fast Answers for DBAs and Developers, at Amazon USA for Clustering , Failover clustering, Log Shipping,Security & sp_defaultdb, Cascading Updates + check constraints
Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook, at Amazon USA for locks & transactions, monitoring performance & how to use System monitor & Interprete Sys Mon Counters ie: % Processor time, % Priviledge time, as well as Lock modes
Inside Microsoft SQL Server 2000 (With CD-ROM), at Amazon USA for Conducting C2 Security-level Server audits + Understanding Affinity Masks + Performance Counters + RAID, Understanding Primary Domain Controllers, Data placement using filegroups, Full-text indexing + searching & catalogs, File and filegroup restores, Using Global temporary tables, Recovery models, Explicit & Implicit Tansactions & Triggers,Locking , Lock modes & Lock Granularity & Query Lock Hints, Lock Compatibility, Setting up Profiler Traces
Professional SQL Server 2000 Programming, at Amazon USA for Practise Using DTS, Replication
Beginning SQL Server 2000 DBA: From Novice to Professional, at Amazon USA for DML and Querying + Connectivity:Network libraries & Protocols, Security Replication, Backup & Recovery:Differential backups. How to Monitor+Profile+Tune
Preparation Guide at microsoft.com
CertGuide
Practice Exam Cert21.com
PDSA eBook
Exam Cram: Implementing the Physical Database
???
PDSA Courseware
SQL Server 2000 Programming, by Rebecca Riordan, at Amazon UK for £36.99
or Amazon USA for $34.99 elementary level... not specifically for the exam
Microsoft Readiness Review, at Amazon UK for £20.99
or Amazon USA for $20.99
Microsoft SQL Server 2000 Programming by Example, at Amazon UK for £23.60
or Amazon USA for $27.99 ...not specifically for the exam
The Guru's Guide to Transact SQL, at Amazon UK for £37.99
or Amazon USA for $34.96 ...not specifically for the exam
Professional SQL Server 2000 Programming, at Amazon UK for £39.09
or Amazon USA for $41.99 ...not specifically for the exam
SQL Server 2000: Stored Procedure Programming, at Amazon UK for £31.34
or Amazon USA for $31.49
Forward123.co.uk Questions & Answers with Detailed Solutions $15
Osborne McGraw-Hill Study Guide, at Amazon UK for £39.62
or Amazon USA for $34.99
New Riders Training Guide, at Amazon UK for £36.99
or Amazon USA for $34.99
Inside SQL Server 2000, at Amazon UK
Training Kit (Microsoft Press), at Amazon UK
Sybex Study Guide, at Amazon UK
Readiness Review (Microsoft Press), at Amazon UK
MDX Solutions: With Microsoft SQL Server Analysis Services, at Amazon USA
The Data Warehouse Toolkit : Practical Techniques for Building Dimensional Data Warehouses, by Ralph Kimball, at Amazon USA
Microsoft Sql Server 7 Data Warehousing Training Kit, at Amazon USA
Unlocking OLAP With SQL Server 7 and Excel 2000, at Amazon USA
SQL Server 2000 Web Application Developer's Guide, at Amazon USA
About: MCDBA
CertSites
Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition examnotes.net
Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition examnotes.net
MCDBA Links examnotes.net
MCDBA Forum examnotes.net