Ebook Download MCSE/MCSD Training Guide: SQL Server 7 Database Design with CDROM (MCSE Training Guide), by David Besch, Sean Baird
This book MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird offers you much better of life that could produce the top quality of the life better. This MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird is what individuals currently require. You are here and you might be specific and certain to get this publication MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird Never ever question to get it even this is simply a publication. You can get this publication MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird as one of your collections. Yet, not the compilation to display in your shelfs. This is a valuable book to be reviewing collection.
MCSE/MCSD Training Guide: SQL Server 7 Database Design with CDROM (MCSE Training Guide), by David Besch, Sean Baird
Ebook Download MCSE/MCSD Training Guide: SQL Server 7 Database Design with CDROM (MCSE Training Guide), by David Besch, Sean Baird
MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird. Join with us to be member here. This is the site that will certainly offer you alleviate of looking book MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird to check out. This is not as the other website; the books will remain in the forms of soft file. What benefits of you to be member of this website? Get hundred collections of book connect to download as well as obtain constantly updated book on a daily basis. As one of guides we will certainly offer to you currently is the MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird that features a really completely satisfied concept.
This letter might not influence you to be smarter, yet guide MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird that we offer will evoke you to be smarter. Yeah, at least you'll know more than others who do not. This is just what called as the high quality life improvisation. Why must this MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird It's due to the fact that this is your preferred theme to check out. If you like this MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird theme around, why don't you review the book MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird to enrich your discussion?
Today book MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird we offer below is not type of common book. You know, reviewing now does not imply to handle the printed book MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird in your hand. You could get the soft data of MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird in your device. Well, we imply that the book that we proffer is the soft file of the book MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird The content and all things are very same. The difference is only the kinds of the book MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird, whereas, this condition will specifically be profitable.
We discuss you also the means to get this book MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird without visiting the book store. You could continue to go to the link that we give and all set to download and install MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird When many people are hectic to seek fro in guide establishment, you are really simple to download the MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird right here. So, what else you will choose? Take the inspiration here! It is not only supplying the ideal book MCSE/MCSD Training Guide: SQL Server 7 Database Design With CDROM (MCSE Training Guide), By David Besch, Sean Baird however likewise the appropriate book collections. Here we constantly provide you the very best and also simplest means.
Books in the Training Guide series are intended for advanced-level classes covering various technologies, whose students will attempt the related Microsoft certification exam. The SQL Server 7 Database Design exam is applicable to both the MCSE and MCSD certification programs as an elective and is a required exam for the MCDBA certification. Included on the CD-ROM is Top Score Software to allow students to test themselves as they work through the book.
- Sales Rank: #11846440 in Books
- Brand: Brand: New Riders Publishing
- Published on: 1999-06
- Original language: English
- Number of items: 1
- Dimensions: 1.69" h x 8.25" w x 9.59" l,
- Binding: Textbook Binding
- 542 pages
- Used Book in Good Condition
From the Back Cover
The Microsoft Certified Systems Engineer (MCSE) certification continues to increase in popularity. Employers often require this certification because it proves applicants have mastered the ability to design, develop, implement, and support solutions with Microsoft products and technologies. Computer professionals who become Microsoft Certified are recognized as experts and are sought after industry-wide. Having MCSE credentials increases an administrator's salary potential by thousands of dollars. In order to obtain their MCSE, candidates are required to pass six exams-four core exams and two elective exams. This curriculum is very rigorous and extremely challenging. The MCSE exams, which cost $100 each, are much more difficult than the Novell CNE exams. Candidates are in need of a complete, concise, inexpensive study guide to fully prepare them to pass the exams.
Most helpful customer reviews
1 of 1 people found the following review helpful.
This Was a Necessary Book to Get at the Time But of Limited Value
By A dad
I took and passed the SQL Server Database Design Exam. But after having got through the SQL Server Database Administration Exam, which I thought was much more difficult, mainly because they weren't great materials to help one prepare for the actual exam questions, I worked very hard before I sat for this exam.
At the time, there were a handful of books to prepare oneself for this exam, and I got all of them. Once I saw what this book was, the way it was organized and the quality of the sections, I immediately rejected all but the practice questions and exams along with their answers and explanations. I still think that was the only truly worthwhile aspect of this book.
The actual exam didn't have one question from any of my books. I continue to believe that Microsoft created so many versions of the exam and that it did not work with any of these authors and publishers that all such books were of very limited value. The actual Microsoft Press material were great for learning SQL Server database design, but didn't prepare one for the actual exam questions. Therefore, one had to practice using such books as this Training Guide just to try to anticipate questions.
19 of 36 people found the following review helpful.
One of the WORST technical books I have ever read!
By John P.
Pure JUNK! I flew through 5 other books for my MCSE, this is my 6th and one of the worst technical books I have EVER read.
The first chapter is a absolutely excellent introduction to relational databases and follows a very good real-world example. Chapter 2 is about files and stuff and is OK.
Chapter 3 is a DISASTER! It is PAINFULLY unclear that what you are doing in this chapter is implementing the theory you learned in chapter 1. Why couldn't the author just state that in a simple sentence? First you are told about data types and how to create tables, that's fine.
Then you are told about constraints. This is it. This is what relational databases are build on. If you don't get this, the no MCSE for you, its off to "do you want fries with that?"
You are NEVER EVER told that you have the option of using the word CONSTRAINT. It IS an optional part of the CREATE TABLE syntax and therefore should be included in the definition -- but it is completely omitted from this book.
The first example of a constraint is on the bottom of p107 and of course doesn't use the word CONSTRAINT so you don't have the foggiest idea what the heck this statement means. To make matters much worse, in this first example the terms CHECK and DEFAULT show up. Hmm. What do those mean? OH! Those are actual constraint terms! They just so happen to be first introduced about 10 pages later. Gee, thanks!
So you're not told that what you are doing is implementing what was introduced in chapter 1, you are not told about the optional term which makes it easier to read the expression, and the example you are given does not use that word but does use some other terms you will be introduced to later. At this point it is IMPOSSIBLE TO FOLLOW THE TEXT. (Unless of course you already know this stuff, as a number of other reviewers said they did -- this is my first book on SQL.)
Oh wait a minute, I take that back, the term CONSTRAINT is shown, on the next page, in an example, with no explanation, still using those other terms that have not yet been introduced, while trying to introduce the table vs column concept, still making it IMPOSSIBLE TO FOLLOW THE TEXT. Could there be a worse condemnation of a technical book?
So after going through this crushingly convoluted introduction to constraints, do you think at least we could get into them? No of course not. Lets stick in about 3 pages about the Identity column just so you really lose track of where you are! Then a whole bunch of mumbo jumbo, then finally, almost without introduction you are into the first of the constraints, the Primary Key constraint.
Primary Key constraint. What's that? Lets see... hmmm... OH YA! The 'Relational' in Relational Database has something to do with that there Primary Key thing, doesn't it? Probably need one of them before you can git yerself one of them there Foreign Keys, or something.
So don't you think that, when you are introduced to the way in which you actually create a Foreign Key you should be reminded that this is how you relate tables in a relational database? Not a chance. You are first shown how to relate tables in a SQL Server 7 relational database on page 115. You are told, "The FOREIGN KEY constraint is used to enforce referential integrity between tables." Read that sentence again. Are you snoring yet?
What the text SHOULD say is, "Finally we are going to show you how to relate tables together, the whole basis of the relational database model, by using the FOREIGN KEY constraint."
Never before have I read a book that would go off on tangents and drill deep down into the details while completely omitting the big picture necessary to put those details into context.
Then there are the dozens of extremely annoying things like, right there on page 115, in case you're not confused enough, the first bullet says, "For cross database referential integrity, use a trigger." Gee thanks! Triggers are introduced on page 361, with ZERO explanation here! Now that is really clear, thanks dude. A little one-sentence explanation saying that I know we haven't talked about triggers yet but we will in chapter whatever, but basically a trigger is a ...
Another one like that, on page 281 there is a big headline "Using a Stored Procedure with INSERT" Of course, stored procedures are introduced on page 348. I don't know dude, but the planet I'm from, we're not born knowing what a stored procedure is. You?
Page 94 says that, "as a rule, fields that require fewer than 20 characters should be fixed length" meaning they should use CHAR rather than VARCHAR. Page 100 shows you an example with LastName varchar(30). Perfect. Page 108 shows you an example with LastName char(30). Wrong-O, according to your rule. There are tons of examples of this stuff.
So in summary, this book is nearly impossible to follow when it explains the most important concepts, has many little annoying problems, as well as lots of problems with explaining things that you won't know unless you already know them.
Again, one of the worst technical books, EVER!
17 of 20 people found the following review helpful.
Good choice for a big book. You'll also need a small one.
By Dr. Robert C.A. Goff, MCSD, MCSE, MCDBA
Like a visit to the Wizard of Oz, every exam candidate sees a different 70-029 exam. The main thrust of my 3 hour exam was (pretend there is no SQL 7 Server GUI) recognizing how various tasks and procedures are accomplished in T-SQL, and their uses and consequences. This is in sharp contrast to 70-028, which tests your facility with the GUI. And there are data structures to interpret, and maybe some ugly BCP and more practical DTS questions.
Besch, et al. do a good job of focusing on T-SQL approaches, while mentioning the alternative GUI tools. I found the text comfortable and readable. Their treatments of data modeling and creating physical storage are excellent. Physical design is a little tougher reading, but the material is covered fairly well. The chapter on indexing is comprehensive, except for the discussion of Full-Text searches.
While the BCP (Bulk Copy Program) is a powerful, but horrid thing to learn and use, with its dozens of optional parameters and flags, the book's explanation of it is about as lucid as you are likely to find. It will make you grateful for the new DTS (the GUI Data Transformation Services), which is not covered in sufficient detail, though just as likely to show up on the exam.
The several chapters on structures of the SQL language cover a vast amount of territory, and cover it fairly well. Database maintenance is addressed in a cursory way.
WEAKNESSES: The SQL language chapters (and some other areas) rely too heavily on formal syntax diagrams -- the kind that show all the possible choices of required and optional parameters of a given statement. While these are great for future reference, they make some pretty difficult reading when you are first learning SLQ. You'll have to expend some calories to translate the diagrams into reality. In some areas the subsequent examples provide adequate clarification. In others, the reader is left with the vague malaise of fuzzy theory. Replication and security are significantly slighted. The details of the workings of DTS are inadequate. The "Review Questions" (different from the "Exam Questions") often expect knowledge that has not yet been (and sometimes never will be) covered. But the info is usually useful in the answers provided.
The examples contrasting Full-Text predicates vs Full-Text functions are not sufficient. The important series of steps required to set up and use Full-Text search are left unclear. A numbered list of essential steps would have been useful.
Coverage of optimization of execution plans and Server Profiler is only marginally adequate.
IF YOU ARE NEW to SQL Server, the condensed nature of any exam book will leave gaps in your understanding. I would strongly encourage you to read a second, smaller book, like Exam Cram, after completing this one. It will clarify the fuzzy spots and provide a different perspective on the material. Regardless, you will need to take notes and maybe do some flash cards (home made) to congeal all the knowledge. But take heart in the certainty that you'll be able to apply much of the data structure knowledge to exam 70-100 (Solutions Architectures).
STRENGTHS: In addition to the good things mentioned above, the Fast Facts final review chapter is wonderful. The end of chapter exam questions do a good (though slightly buggy) job of reviewing the types of information that will be tested, though the format is not quite right.
CONCLUSION: Despite its shortcomings, I really liked this book. Consider a "small" book as an adjunct. Take notes. Look up fuzzy syntax in the Books On Line. And, by all means, run the SQL exercises in Query Analyzer.
MCSE/MCSD Training Guide: SQL Server 7 Database Design with CDROM (MCSE Training Guide), by David Besch, Sean Baird PDF
MCSE/MCSD Training Guide: SQL Server 7 Database Design with CDROM (MCSE Training Guide), by David Besch, Sean Baird EPub
MCSE/MCSD Training Guide: SQL Server 7 Database Design with CDROM (MCSE Training Guide), by David Besch, Sean Baird Doc
MCSE/MCSD Training Guide: SQL Server 7 Database Design with CDROM (MCSE Training Guide), by David Besch, Sean Baird iBooks
MCSE/MCSD Training Guide: SQL Server 7 Database Design with CDROM (MCSE Training Guide), by David Besch, Sean Baird rtf
MCSE/MCSD Training Guide: SQL Server 7 Database Design with CDROM (MCSE Training Guide), by David Besch, Sean Baird Mobipocket
MCSE/MCSD Training Guide: SQL Server 7 Database Design with CDROM (MCSE Training Guide), by David Besch, Sean Baird Kindle
Tidak ada komentar:
Posting Komentar