The SQL Server 2000 Book

SQL Server makes up one of the fundamental building blocks of database management. Surely whatever database server your company chooses is what you should learn. It just so happens my organization chose MS SQL 2000. To make a long story relatively short, I was very new to SQL and knew very little about it. So as not to enter into the "panic-mode" I went to Amazon with hopes I could find a book on SQL 2000 with great recommendations. I think I found it in "The SQL Server 2000 Book. At first glance, the SQL language seemed very intimidating and complex to me, but it's really not all that bad. Anthony Sequeira's book had a lot to do with making it less intimidating to me. Hey if it could help a thick-head like me, I'm sure it could help you too. I would also recommend "MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, 70-228, Second Edition" put out by Microsoft Press. Both books have been a tremendous help. This book is designed for the system or database administrator, IT manager, and IT professional working with SQL Server because it covers four main topic technologies and architecture; planning; administering and optimizing, and using SQL Server 2000. Some of the critical topics featured in the book include backing up and restoring databases, optimizing SQL Server, using replication, configuring XML and Internet support, and automating administrative tasks.

This book is ideal for the system or database administrator, IT manager, and IT professional working with SQL Server. It covers four main topic areas: technologies and architecture, planning and installing, administering and optimizing, and using SQL Server 2000.

Explains how to deploy the relational database system, how to utilize Transact SQL and English Query, how to create databases, how to provide security, how to back up and restore databases, and how to automate administrative tasks. Chapter 1 of The SQL Server 2000 Book provides you with a solid understanding of exactly what SQL Server 2000 is and why it is such an important product.