2020ok  Directory of FREE Online Books and FREE eBooks

Free eBooks > Computers & Internet > Certification Central > Publisher > Microsoft Press > Microsoft SQL Server 7.0 Database Implementation Training Kit

Microsoft SQL Server 7.0 Database Implementation Training Kit

by Microsoft Corporation

Download Book
(Respecting the intellectual property of others is utmost important to us, we make every effort to make sure we only link to legitimate sites, such as those sites owned by authors and publishers. If you have any questions about these links, please contact us.)

link 1

About Book

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

Book Description
This training teaches IS professionals and SQL developers how to implement database solutions using the latest version of the Microsoft SQL Server relational database management system. Students will gain an understanding of the product's architecture and, through the accompanying labs, attain hands-on experience with the procedures to plan, configure, and implement database solutions.

Upon course completion, students will be able to describe the elements of the Transact-SQL language, and configure the data storage architecture; create and manage files, databases transaction logs, and more; enforce data integrity; manage locking options and transactions to ensure data concurrency and recoverability; write queries that retrieve and modify data; design and create stored procedures and triggers and create views of data, including publishing it on the Web. This is the self-paced equivalent of the instructor-led training Course #833 and will prepare students for MCP exam 70-029, Implementing a Database Design on Microsoft SQL Server 7.0. CD includes lab exercises and 120-day trial software for SQL Server 7.0.



PLEASE READ: All comments must be approved before appearing in the thread; time and space constraints prevent all comments from appearing. We will only approve comments that are directly related to the article, use appropriate language and are not attacking the comments of others.

Message (please, no HTML tags. Web addresses will be hyperlinked):

Related Free eBooks

Related Tags

DIGG This story   Save To Google   Save To Windows Live   Save To Del.icio.us   diigo it   Save To blinklist
Save To Furl   Save To Yahoo! My Web 2.0   Save To Blogmarks   Save To Shadows   Save To stumbleupon   Save To Reddit