Microsoft SQL Server 7.0 Database Implementation Online Training Kit BRAND NEW

Microsoft SQL Server 7.0 Database Implementation Online Training Kit (NEW/SEALED)
Candidates for the MCP exams can learn all they need to know about Microsoft SQL Server with the help of this training kit. This title is also targeted at SQL Server implementers, system engineers, and developers who are responsible for planning and deploying Microsoft SQL Server and writing Transact-SQL code.As the latest installment in the series of training kits from Microsoft Press, Microsoft SQL Server 7.0 Database Implementation Training Kit focuses on how to work with data in SQL Server 7 and prepares you for the 70-029 Microsoft Certified Professional (MCP) exam. SQL Server is a mammoth product, and administrating it is far different from mere data manipulation. This title offers a self-paced program for learning how to create and access SQL Server databases with foresight and skill.

The book begins with a discussion on Transact-SQL--the Microsoft flavor of SQL used to work with SQL Server. During the first few chapters, the book shows you how to create database objects, implement constraints and rules, and work with indexes. Clear syntax diagrams and straightforward examples help make these important issues more intuitive. The course moves on to multi-table queries, explaining join types, subqueries, and cursor manipulation. While this section covers a lot of material, part of the appendix offers a review of basic querying concepts.

As you progress through the chapter lessons, you\'ll learn about locking scenarios, transaction management, distributed database configurations, and stored procedures. Each lesson clearly frames the information to be learned and includes an overview and summary section. In addition, review questions prompt you to play with real-world scenarios while an accompanying CD-ROM provides multimedia presentations of key concepts. This training kit addresses the core database competencies essential for anyone looking to exploit SQL Server\'s powerful capabilities. -- Stephen Plain