This Online Training Kit offers rich multimedia instruction for learning how to design and implement enterprise database solutions using SQL Server 7.0. Readers work at their own pace through this next-generation, interactive learning system -- gaining practical experience writing Transact SQL-code and mastering the procedures for planning, configuring, and deploying a SQL Server database. As they develop this real-world expertise, they're also preparing for MCP Exam 70-029 -- a core credit for the Microsoft Certified Database Administrator certification and an elective for becoming a Microsoft Certified Systems Engineer. Kit also includes a copy of the SQL Server Database Implementation MCSE Readiness Review -- an MCP exam readiness assessment book and CD.
Book Description
Product Details
Would you like to update product info or give feedback on images?
|
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
48 of 50 people found the following review helpful:
4.0 out of 5 stars
Interesting approach to SQL 7.0 Design,
By A Customer
This review is from: Microsoft SQL Server 7.0 Database Implementation Online Training Kit: McSe Training for Exam 70-029 (It-Online Training Kit) (Paperback)
Hello Fellow Travellers,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
11 of 11 people found the following review helpful:
4.0 out of 5 stars
Good training for SQL DB design,
By
This review is from: Microsoft SQL Server 7.0 Database Implementation Online Training Kit: McSe Training for Exam 70-029 (It-Online Training Kit) (Paperback)
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.
9 of 9 people found the following review helpful:
4.0 out of 5 stars
Good overview, but still lacking essential material,
This review is from: Microsoft SQL Server 7.0 Database Implementation Online Training Kit: McSe Training for Exam 70-029 (It-Online Training Kit) (Paperback)
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.
Share your thoughts with other customers: Create your own review
|
|
Front Cover | Front Flap | Table of Contents | First Pages | Index | Back Flap | Back Cover | Surprise Me!
Inside This Book
(learn more)
Key Phrases - Statistically Improbable Phrases (SIPs):
(learn more)
correct answer, current activity window, graphical showplan, advanced query techniques, site index, maintaining indexes, index for each statement, optimizer hint specifies, rental tracking system, query plan information, query analysis applications, first optional result, commands that active users, second optional result, column definition section, more clustered indexes, being bulk copied, backorder table, determines whether null values, fewer indexes per table, one optional result, defined relationships between tables, specifies the data values, logical database model, foreign key mapped Key Phrases - Capitalized Phrases (CAPs): (learn more)
Server Enterprise Manager, Server Profiler, Books Online, Database Implementation Training, Performance Monitor, Review Lessons, Further Reading Microsoft, Utilities Reference, Microsoft Access, Server Query Analyzer, Data Transformation Services, Index Tuning Wizard, Using Query Analyzer, Create Trace Wizard, Resource Kit, Import Wizard, Resource Guide, Fundamentals of Relational Database Design, Paul Litwin, Export Wizard, Best Count, Actual Count, Gaye Phillips, Microsoft Search, Implementing Data Integrity Browse Sample Pages:
Front Cover | Front Flap | Table of Contents | First Pages | Index | Back Flap | Back Cover | Surprise Me!
correct answer, current activity window, graphical showplan, advanced query techniques, site index, maintaining indexes, index for each statement, optimizer hint specifies, rental tracking system, query plan information, query analysis applications, first optional result, commands that active users, second optional result, column definition section, more clustered indexes, being bulk copied, backorder table, determines whether null values, fewer indexes per table, one optional result, defined relationships between tables, specifies the data values, logical database model, foreign key mapped Key Phrases - Capitalized Phrases (CAPs): (learn more)
Server Enterprise Manager, Server Profiler, Books Online, Database Implementation Training, Performance Monitor, Review Lessons, Further Reading Microsoft, Utilities Reference, Microsoft Access, Server Query Analyzer, Data Transformation Services, Index Tuning Wizard, Using Query Analyzer, Create Trace Wizard, Resource Kit, Import Wizard, Resource Guide, Fundamentals of Relational Database Design, Paul Litwin, Export Wizard, Best Count, Actual Count, Gaye Phillips, Microsoft Search, Implementing Data Integrity Browse Sample Pages:
Front Cover | Front Flap | Table of Contents | First Pages | Index | Back Flap | Back Cover | Surprise Me!
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
