|
"Addresses the core database competencies essential for anyone looking to exploit SQL Server's powerful capabilities."
— Stephen Plain
October, 1999
About the Book
Microsoft-official training for the skills you need on the job—and on the exam.
Learn how to design and implement enterprise database solutions using SQL Server™ 7.0—and prepare for the Microsoft® Certified Professional (MCP) exam—with this single training kit. Work at your own pace through a system of modular lessons and hands-on labs to comprehend product architecture, write Transact-SQL code, and master the procedures for planning, configuring, and deploying a database using SQL Server 7.0. As you gain this work-ready expertise, you’ll also be preparing for MCP Exam 70-029—a core credit for the new Microsoft Certified Database Administrator certification and an elective for becoming a Microsoft Certified Systems Engineer. Make this official Microsoft Training Kit your next step to career advancement!
HERE’S WHAT YOU’LL LEARN:
• Developing a logical data model
• Designing solutions for performance, maintainability, scalability, availability, and security
• Configuring the physical database—files, tables, indexes, and views
• Writing and executing Transact-SQL statements, scripts, and processes to develop data services
• Implementing stored procedures and triggers
• Creating and managing explicit, implicit, and distributed transactions to ensure data integrity
• Methods and tools for populating the database
• Monitoring and optimizing database performance
• Diagnosing and resolving problems
HERE’S WHAT’S INSIDE:
• A comprehensive training manual that maps to MCP exam goals and objectives
• Hands-on, skill-building exercises with practice files on CD-ROM
• A complete online version of the book
• 120-day evaluation copy of Microsoft SQL Server 7.0
Related Books
MCSA/MCSE Self-Paced Training Kit (Exam 70-270): Installing, Configuring, and Administering Microsoft® Windows® XP Professional, Second Edition
MCSE Self-Paced Training Kit: Migrating to Active Directory®; Exam 70-272
MCSA/MCSE Self-Paced Training Kit (Exam 70-299): Implementing and Administering Security in a Microsoft® Windows Server™ 2003 Network
Customer Rating
Number of Ratings: 3
| Average Rating: |
|
|
