You can’t go to college to become a DBA. Sure, you can take some basic classes on database theory and design, and maybe even a couple classes on specific databases, but there is no comprehensive college program you can take to become a DBA. Of course, there are the one-week classes many training centers offer on SQL Server, but as probably already know, they just cover the basics and don’t really teach you everything you need to know. Besides, these can cost a fortune to attend, and if you have to foot the bill yourself, or if you don’t have a training center in your city, they are probably not a practical option. So what options does an intelligent individual, such as yourself, have if you want to become a DBA (or to become a master DBA, if you are already a newbie DBA)? If you can’t get the training you really need from classes, where do you turn? If you are like most DBAs I know, you go the self-taught route. This is not an easy path, but if you are serious about becoming a DBA and making it your career, I think you will find that doing it yourself is the best possible route. What You Need to Learn You may not be aware of this if you are new to databases, but there are actually many different sub-specialties of database work. The major ones include:
- DBA (Database Administrator): Generally, responsible for the day-to-day administration of SQL Server and its databases.
- Database Modeler/Designer: Models and designs databases.
- Database (Transact-SQL) Developer: Writes Transact-SQL applications, generally writing scripts and stored procedures.
- Data Warehouse Specialist: Administers, and perhaps develops, data warehousing-based applications.
The focus of this article is on becoming a DBA. In many ways, the DBA has to be the best-rounded person (as compared to the other sub-specialties) in regards to knowledge of SQL Server. To be a successful DBA, not must you only know how to administer SQL Server, you need to be familiar with all aspects of SQL Server, including database design, development, and data warehousing. No, you don’t have to know everything about each sub-specialty, but the more you know, the better you can perform your job. You really need to become a SQL Server jack-of-all-trades. As you can imagine, this can become a large undertaking.
So Where Do I Begin?
Fortunately, there are many good books on SQL Server, so the best place to start in your journey to becoming a master DBA is to begin building a library of top-notch books, and of course, reading them from cover to cover. In some cases, I find myself rereading some books over and over again, picking up more information each time I read them.
Here are the books I recommend, and in the order I suggest you read them. Of course, you can read them in any order you want, and you can skip subjects of little interest to you.
Books Recommended for all Up and Coming DBAs
- Microsoft SQL Server 2000 DBA Survival Guide: One of the best books for the beginning DBA. It as been around since SQL Server 6.5, and has gotten better with each new version.
- Beginning SQL Server 2000 Programming: A great book for mastering the basics of Transact-SQL development.
- Professional SQL Server 2000 Database Design: Probably the best book ever written on SQL Server database design.
- Admin 911: SQL Server 2000: Consider this book a compilation of real-world tricks and tips that you probably will not find in other books.
- Inside Microsoft SQL Server 2000: The definitive source on how SQL Server really works. Consider it like your SQL Server graduate school.
- Microsoft SQL Server 2000 Performance Tuning Technical Reference: Performance tuning is an on-going job for the DBA, and this book is a must read.
- Microsoft SQL Server 2000 Analysis Services Step by Step: Even if you may not be ready for data warehousing yet, you should still learn the basics, and this book covers them well.
Optional Books for Those Who Really Want to Excel as DBAs
- Professional SQL Server 2000 Programming: I highly recommend this book to everyone who wants to master Transact-SQL development.
- Microsoft SQL Server 2000 Resource Kit: A huge book, and you will learn about topics you had never even thought of before.
- Beginning SQL Server 2000 for Visual Basic Developers: If you have to support VB developers who use SQL Server as their database, then you need to understand how VB works with SQL Server.
- MCSE Microsoft Windows 2000 Advanced Server Clustering Services Training Kit: If you need to cluster your SQL Servers, this is one of the few books available on this very difficult subject.
- Professional SQL Server 2000 DTS: If you need to move data between databases, or are involved in data warehousing, this book is the bible on DTS.
To find out more about each of these books, click on the book’s title.
You may have noticed that the above list focuses on SQL Server 2000. That is because it is the current version of SQL Server, and it has the most books available. Even if you will be working with SQL Server 7.0, the books recommended above will still be very useful. There is not that much different between the two versions.
Reading the first set of recommended books will probably take you over 300 hours. This is a big number, but don’t let it scare you away. If you devote just one hour a day to reading these books, you will have them all read within a year.
There are a lot of books available on SQL Server 2000, and I feel that the ones I have recommended above are the best of the lot.
Other Learning Resources
While reading books is one of the best ways to learn much of the material you need to know, it is only way to learn more about SQL Server. Since you are reading this article at a website, you already know that websites on SQL Server often include much content that can help you along your path of becoming a master DBA. While my web links page has many links to SQL Server-related websites, several of my favorites include:
I like these sites because they have a lot of original content that you can’t find anywhere else on the web. And as you can imagine, Microsoft’s website has thousands of web pages devoted solely to SQL Server. If you live in a larger city, you might be able to join a SQL Server user’s group. Most meet at least once a month, offering programs to help you better master SQL Server. Do a search on www.google.com to find a SQL Server user’s group near you. You can also learn a lot by dropping by the various SQL Server newsgroups (find list here). And if you run across a question in your self-study that you can’t find an answer to, you can ask them here. Practice What You Learn While reading about SQL Server is important, it doesn’t replace getting your hands dirty by using it. That means you will need access to a computer that has SQL Server on it. Fortunately, several of the books I have recommended above come with a 120-day evaluation copy of SQL Server 2000, so you should have no problem getting access to it. I would suggest following as many of the various examples in the books you read. Besides this, I suggest you try to come up with some practical project you can develop on your own, such creating a personal database to track your books, CDs, DVDs, or whatever you collect, to get even more practice. Or if you have a friend who runs a business, volunteer to develop a SQL Server database for them.