2020ok  Directory of FREE Online Books and FREE eBooks

Free eBooks > Computers & Internet > Networking > Data in the Enterprise > Client-Server Systems > Sams Teach Yourself Microsoft SQL Server 6.5 in 21 Days

Sams Teach Yourself Microsoft SQL Server 6.5 in 21 Days

by Rick Sawtell


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

Amazon.com
Teach Yourself Microsoft SQL Server 7.0 in 21 Days introduces you to every aspect of Microsoft's flagship back-end database engine. Organized with a FAQ-like summary at the end of every chapter, the book familiarizes you with all the features and even brings you up to expert level on a few of them.

Focusing on SQL Server Standard Edition, authors Waymire and Sawtell explain how to install the software under Windows NT Server 4. After a quick synopsis of the tools and utilities on the SQL Server CD-ROM, the authors walk you through the process of creating databases (and related entities) and establishing accounts for the people and processes that will access them.

The authors place considerable emphasis on security, showing you exactly how to set up user logins and access permissions. They also include information on preparing for and recovering from disasters, RAID schemes, backup routines, and restoration of backed-up data. The book wraps up by showing you how to use SQL Server's programming abilities to create customized applications. On top of their coverage of triggers and stored procedures--and of Structured Query Language (SQL) generally--the authors include a good tutorial on the fundamentals of Transact-SQL programming. There's also information on automating administrative tasks with the SQL Server Agent. --David Wall

Book Description
Sams Teach Yourself Microsoft SQL Server 7 in 21 Days gives you the new features and capabilities of SQL Server 7, in a tutorial environment. This book features information on: Row-level locking; SQL Server Query Analyzer (formerly the ISQL/w); Microsoft Manage-ment Console (platform that the Enterprise Manager is now based upon); Update Replication feature (multisite, improved performance and scriptable replication objects); New Wizards such as: Create Database, Create Job, Index Tuning, Version Upgrade and Security; SQL Server Agent which provides unattended job execution and alter/response management; New Transact-SQL statements such as ALTER PROCEDURE, ALTER TRIGGER; and information on recursive triggers and local cursors. It walks you through the features of SQL Server 7, increasing the performance and scalability of your database.

Book Info
Designed to teach you in just 21 days, all the skills you need to learn Microsoft SQL Server 7.0 from a Microsoft Certified Trainer. Paper.

From the Back Cover

Sams Teach Yourself Microsoft SQL Server 7 in 21 Days gives you the new features and capabilities of SQL Server 7, in a tutorial environment. This book features information on: Row-level locking; SQL Server Query Analyzer (formerly the ISQL/w); Microsoft Manage-ment Console (platform that the Enterprise Manager is now based upon); Update Replication feature (multisite, improved performance and scriptable replication objects); New Wizards such as: Create Database, Create Job, Index Tuning, Version Upgrade and Security; SQL Server Agent which provides unattended job execution and alter/response management; New Transact-SQL statements such as ALTER PROCEDURE, ALTER TRIGGER; and information on recursive triggers and local cursors. It walks you through the features of SQL Server 7, increasing the performance and scalability of your database.



About the Author

Rick Sawtell is both a Microsoft Certified Solutions Developer as well as a Microsoft Certified Trainer. Richard Waymire is a Principal Engineer with Aris Corp. in Bellevue, WA. He is also a Microsoft Certified Trainer (MCT), Solution Developer (MCSD), and Microsoft Certified Systems Engineer (MCSE).

Comments

SEND A COMMENT

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