Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Self-Paced Training Kit (Exam 70-448) Microsoft SQL Server 2008 Business Intelligence Development and Maintenance (MCSA) [Paperback]

Erik Veerman , Teo Lachev , Dejan Sarka
4.0 out of 5 stars  See all reviews (2 customer reviews)
List Price: CDN$ 73.99
Price: CDN$ 46.39 & FREE Shipping. Details
You Save: CDN$ 27.60 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 3 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Friday, October 24? Choose One-Day Shipping at checkout.

Formats

Amazon Price New from Used from
Paperback CDN $46.39  
Join Amazon Student in Canada


Book Description

April 15 2009 0735626367 978-0735626362 1

Ace your preparation for the skills measured by MCTS Exam 70-448—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:

  • Create SSIS packages; troubleshoot data flow and control flow
  • Configure, debug, and deploy SSIS solutions
  • Develop SSAS cubes for OLAP and data mining services
  • Implement custom logic with MDX
  • Optimize storage design and query performance
  • Create SSRS reports; enable interactivity; write custom code
  • Manage the report environment
  • Configure security features for SSIS, SSAS, and SSRS


Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.

Your kit includes:

  • Official self-paced study guide.
  • Practice tests with multiple, customizable testing options and a learning plan based on your results.
  • 200 practice and review questions.
  • 180-day trial of SQL Server 2008 Enterprise Edition.
  • Case scenarios, exercises, and best practices.
  • Fully searchable eBook of this guide, plus sample chapters from related books.

Ace your preparation for the skills measured by MCTS Exam 70-433—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:

  • Create and manage database objects
  • Query and modify data; implement subqueries and CTEs * Optimize table structures and data integrity
  • Create stored procedures, functions, and triggers
  • Manage transactions, error handling, and change tracking
  • Tune query performance
  • Implement database mail, full-text search, Service Broker, scripts
  • Work with XML and SQLCLR Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.

Your kit includes:

Official self-paced study guide.
  • Practice tests with multiple, customizable testing options and a learning plan based on your results.
  • 200 practice and review questions.
  • Case scenarios, exercises, and best practices.
  • Fully searchable eBook of this guide, plus sample chapters from related books.
  • A Note Regarding the CD or DVD and Practice Files

    Assess your skills with practice tests. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.

    For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.


    Special Offers and Product Promotions

    • Join Amazon Student in Canada


    Frequently Bought Together

    Self-Paced Training Kit (Exam 70-448) Microsoft SQL Server 2008 Business Intelligence Development and Maintenance (MCSA) + MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 Implementation and Maintenance + Self-Paced Training Kit (Exam 70-433) Microsoft SQL Server 2008 Database Development (MCSA)
    Price For All Three: CDN$ 139.17


    Customers Who Bought This Item Also Bought


    Product Details


    Product Description

    About the Author

    Dejan Sarka is MCT and MCDBA certified and a Microsoft MVP for SQL Server. He teaches and consults for Solid Quality Mentors, speaks at TechEd and PASS, and develops OLTP, OLAP, and data mining solutions.


    Inside This Book (Learn More)
    Browse Sample Pages
    Front Cover | Copyright | Table of Contents | Excerpt | Index
    Search inside this book:

    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


    Customer Reviews

    5 star
    0
    3 star
    0
    2 star
    0
    1 star
    0
    4.0 out of 5 stars
    4.0 out of 5 stars
    Most helpful customer reviews
    2 of 3 people found the following review helpful
    4.0 out of 5 stars Standard quality for MS Press Sept. 20 2011
    By Dragan
    Format:Paperback
    I got exactly what I expected and much better than in most other books about the same topic. Developers often rush to start with the design, and MS did the right thing insisting that the configuring, deploying and administration should be mastered first. Many projects would have been more successful if it had been the case. I have given it 4 stars just because only Henderson, Delaney and the like merit 5.
    Was this review helpful to you?
    1 of 3 people found the following review helpful
    Format:Paperback
    So far, I found one error when i did Chapter 3, Lesson 1, Exercise 3 following context step-by-step, even I threw all my work and used sample project comes with companion CD, I got same error. At the end, found solution thru GOOGLE. MS Press should post corrigenda/Errata by each published book. Wasted 30 minutes for this issue. I may consider for my next same TK series purchase because of the poor reader support from publisher.
    Was this review helpful to you?
    Most Helpful Customer Reviews on Amazon.com (beta)
    Amazon.com: 4.2 out of 5 stars  27 reviews
    30 of 32 people found the following review helpful
    5.0 out of 5 stars Get Educated June 25 2009
    By R. R. Jacobsen - Published on Amazon.com
    Format:Paperback|Verified Purchase
    This book is a wonderful comprehensive review of the key components used for SQL Server 2008 certification (exam 70-448). It covers SSIS, SSAS and SSRS in such a manner as to provide great background alongside some basic hands-on exercises to perform.

    There is a practice exam disc included with the book which really helps in terms of studying for the exam and another disc with an evaluation copy of SQL Server 2008. All of this can take you from doing what I would call "cowboy SQL work" to a more professional, well founded, and optimized approach towards working with BI tools used with SQL Server.

    The authors provide some good practical real-life recommendations on how to apply some of the techniques covered which helps round out the training. Collectively, this text has opened my eyes to more features and functionality in SQL than I did before picking it up and offers a way to actually apply the learning material -- albeit at a simple, high level. Just the same, one can always go deeper and experiment with some of the techniques. In the first chapter alone I learned of a technique that solved a problem which a consulting firm I worked with had an allergic reaction towards solving. I'm thinking the consulting firm might have benefited from this book.

    I'm grateful that a careful reading of the exercises does allow one to complete the the vast majority of exercises and not have to deal with a problem so often faced in similar type texts -- nobody proof-read the thing to make sure the commands were accurate and actually worked! Seems like a pretty basic concept but this is so often not the case.

    My only warnings to readers is that initial installation of the SQL Server evaluation software and setting up the DB's used as examples can prove tricky (but this is a MSFT issue, not one with the book or the way in which the conveys information). Why is it that sample DB's and installation of same cannot be made easier as it was with SQL 2005 early on? And I have a bit of a bone to pick regarding the Measure Up practice exam which has some out of synch references to the materials in the book. For example, the exam references Chapter 1 Lesson 5 yet the book has only 3 lessons in Chapter 1.

    Finally, in the back of the book is a coupon code for taking the exam -- practically worth the price of the book. Your biggest investment will be the time necessary to study for the exam but in today's economy that would be a great investment to make.
    19 of 21 people found the following review helpful
    4.0 out of 5 stars Solid coverage of the exam material July 26 2009
    By Leslie Self - Published on Amazon.com
    Format:Paperback
    Great book. I thought the layout was well done and flowed very logically. The examples, if studied carefully, provided good insight to the concepts and the functionality that is available in the BI stack. There is a lot of material on the exam and I'm impressed at how much was able to be packed into the 600 or so pages. One definitely has to work the examples to get the full understanding, though.

    I do have to say that, to me, one of the drawbacks of the book was the set of practice exam questions that was included. I thought the questions were good enough, but the explanations were lacking. There wasn't enough detail as to why the answers were right or wrong. I've always used the Transcender exams to supplement any written material so that may be causing some of the bias, but I thought the explanations could have gone deeper than they did.

    (Side note: I also purchased the Transcender exams for this exam. The combination of book and exam prep worked well for me. Passed the exam on the first try!)

    I would definitely recommend purchasing the book. It not only met my expectation of an exam prep book, but it will also stay on my shelf as a reference book.
    15 of 16 people found the following review helpful
    5.0 out of 5 stars Great Resource for the 70-448 Exam! May 5 2010
    By Adam Sottosanti - Published on Amazon.com
    Format:Paperback
    I bought this book with the intention of using it and the practice exams included to study for my 70-448 exam, and I couldn't be more pleased with it. I passed the exam and I owe a lot of my success on the exam to this book. Without this book I would have not known which areas to study and passing the test would have been much harder. The book is organized very well, is well written, and prepares you to perform well on the exam. I have been using the MS BI tools for several years now so I didn't intend to get much out of the book besides a passing score on the exam, but I ended up learning about quite a few things I had never utilized in each of the tools. Good luck to anyone taking this exam!
    7 of 7 people found the following review helpful
    5.0 out of 5 stars good book for exam preparation Sept. 20 2009
    By Jurgen Muljana - Published on Amazon.com
    Format:Paperback|Verified Purchase
    This book provides a good preparation for MCTS exam. It concisely addresses topics examined in the exam. It successfully avoids the temptation of going into too much details but covers everything necessary to be succesful in the exam. It is absolutely a good book to get the certification.
    6 of 6 people found the following review helpful
    5.0 out of 5 stars Pass the 70-448 or use it toward the upgrade exams. Sept. 6 2009
    By Engelbert Gal - Published on Amazon.com
    Format:Paperback
    I am glad this book is available as it is one of the few sources of information for the 70-448. I personally used this book to use to study for the upgrade exams where I could not find specific books for the test.

    I enjoyed reading the book and it suited my needs well. I recommed that any person interested in BI start with this book, create a good foundation of knowledge, build best practices and then progress to individual books based on their focused are of study. For example WROX SSIS 2008 would be a great companion as a reference guide. I am disappointed that the MS exams do not focus on each specific technology, but that is a complaint of MS certs, not this book. This book is a wonderful guide for the information contained in their exams. For a newbie to SSIS SSAS SSRS, or a person seeking information for an upgrade exam, no other book comes close.
    Search Customer Reviews
    Only search this product's reviews

    Look for similar items by category


    Feedback