Microsoft SQL Server 7.0 Database Implementation Online Training Kit: McSe Training for Exam 70-029 (It-Online Training Kit)

Just recently purchased SQL 7.0 Design On-line training kit. If you don't like to read thick tomes, then this is for you. I was expecting a book with a cd, but the book is actually the Readiness review for 70-29. Everything is on the CD. It is a audio/video/text training kit for SQL. I really didn't know what to expect when I purchased it. It is a hands-held approach to SQL 7.0 Design. The MS Press Interactive training. It has lesson plans, little quizes for each lesson and you can read along as the pleasant voices tell you the lesson. It allows to do hands-on during the lessons. I like it.

I think it is good supplement to the SQL 7.0 Design training kit that comes with the SQL 7.0 eval. You need to install and get some real hands-on still. The On-line recommends at least 1 year of relational db exp in order to fully benefit the lessons. I doubt that the people who purchase these books really have any exp (like myself) Only bad thing is the price. I don't really like the readiness review books. So, for a cd seems a bit pricey with the readiness book. And No SQL eval software. Marketing gimmick I don't like.

The Online was a nice review from SQL 70-29 design training kit. I learn much better when I can see, hear, and read at the same time. However, it is an OVERVIEW of the test subjects. Not a Manual how to pass the test. I don't think any of the training kits were ever meant to be that way. I passed 70-28 sql admin using training kit, hands-on, BOL (this is the best resource for SQL) and Transcenders. 900/1000. I plan to do the same with 70-29 and 70-19. This works for me, but...

my mcse+i mct ccna ccda


Good training for SQL DB design   April 5, 2000
Cade Bryant (Fort Lauderdale, FL)
11 out of 11 found this review helpful

This is a fun and engaging way to learn SQL Server 7, but if you're taking the MS exam, I would definitely recommend following up with a more detail-oriented book and a practice test. If you're new to databases, read a general database-design book (such as Database Design for Mere Mortals by Hernandez) before using this training kit. Hands-on practice with SQL 7 is necessary as well.

The simulations on the CD are a great concept, but some are too easy. In many exercises, you are loading pre-written scripts. This is convenient; but in order to become truly familiarized with the syntax, you need lots of practice actually typing out the code.


Good overview, but still lacking essential material   November 26, 2000
Adrian Tan
9 out of 9 found this review helpful

For those who just want to achieve MCDBA and if only score is relevant to you, here is my score 897/1000 for (70-029) and 920/1000 for (70-028).

Look at my review on SQL Server 7.0 System Administration Online Training Kit (70-028). I hold the same opinion for this (70-029) training kit.

Yes, there are still mistakes, and not enough coverage of the subject material. I can never stress enough; you still need to have the 'Inside MS SQL Server 7.0', 'Books Online' (comes with the 120 days evaluation SQL Server 7.0 software with this kit) and actual code implementation experience. You need more time to prepare and expose yourself to this particular course. Time is the essence. This examination can be a long one, more difficult than others, but nothing is difficult if you have the determination to succeed.


A good place to start   July 5, 2000
Robert Pierce
5 out of 5 found this review helpful

This book is an excellent starting point for those who wish to tackle the 70-029 exam. However, don't expect to pass it without additional resources. I recommend "Professional Sql Server 7.0 Programming" by Robert Vieira. I also suggest the Transender practice tests and lots of practice with the product.

However, this book is great for beginners. It is well written, easy to understand with numerous examples that clarify the topics. Four thumbs up!