This comprehensive book will guide readers through Microsoft's brand new SQL 2005 certification, Certified Technology Specialist: SQL Server 2005 (exam: 70-431). This new exam is both a one-exam certification, granting students the Technology Specialist designation, and an entry exam for both the IT Professional Developer and IT Professional Administrator certifications. This entry-level exam gives readers a solid introduction to both the development and administrative aspects of SQL Server 2005.
· Installing Microsoft SQL Server 2005
· Creating and Configuring Databases
· Working with Tables and Views
· Performing Indexing and Full-Text Searching
· Introducing More Database Objects
· Implementing Security in SQL Server 2005
· Working with Relational Data
· Working with XML Data
· Working with Service Broker and HTTP
· Maintaining and Automating SQL Server
· Performing Backups and Restores
· Achieving High Availability through Replication
· Introducing More High-Availability Methods
· Monitoring and Optimizing SQL Server 2005