Knight's 24–Hour Trainer
Home > Computing and Information Technology > Databases > Database software > Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services
Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services

Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

A unique book-and-video package for learning Microsoft SQL Server Integration Services If you need a practical, hands-on introduction to Microsoft SQL Server 2008 Integration Services (SSIS), this book and video package from foremost SSIS authority Brian Knight gets you thoroughly up to speed. Each lesson in the book includes three major components: a thorough description of how each SSIS feature or process works; a tutorial that walks you through the process or technique; and a video lesson that demonstrates it. If you take full advantage of this comprehensive package, you will gain enough experience to tackle your first SSIS project with confidence. SQL Server Integration Services 2008 (SSIS) builds on the revolutionary database product suite first introduced by Microsoft in 2005 and is a powerful tool for performing extraction, transformation, and load (ETL) operations essential to data warehousing If you're just learning SSIS, the step-by-step tutorials in this book and DVD training package will ready you to tackle your own first project Every lesson in the book is supplemented by instructional video on the DVD Note:As a part of this title, video lessons are included on DVD. For the e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

Table of Contents:
Preface. Welcome To SSIS. Section I: Installation and Getting Started Lesson 1: Moving Data with the Import and Export Wizard. Lesson 2: Installing SQL Server Integration Services. Lesson 3: Installing the Sample Databases. Lesson 4: Creating a Solution and Project. Lesson 5: Exploring Business Intelligence Development Studio. Lesson 6: Creating Your First Package. Section II: Tasks. Lesson 7: Connecting Control Flow Tasks with Precedence Constraints. Lesson 8: Manipulating Files with the File System Task. Lesson 9: Coding Custom Script Tasks. Lesson 10: Using the Execute SQL Task. Lesson 11: Using the Send Mail Task. Lesson 12: Using the FTP Task. Lesson 13: Creating a Data Flow. Section III: Data Flow. Lesson 14: Extracting Data from Sources. Lesson 15: Loading Data to a Destination. Lesson 16: Changing Data Types with the Data Conversion Transform. Lesson 17: Creating and Replacing Columns with the Derived Column Transform. Lesson 18: Rolling Up Data with the Aggregate Transform. Lesson 19: Ordering Data with the Sort Transform. Lesson 20: Joining Data with the Lookup Transform. Lesson 21: Auditing Data with theRow Count Transform. Lesson 22: Combining Multiple Inputs with the Union All Transform. Lesson 23: Cleansing Data with the Script Component. Lesson 24: Separating Data with the Conditional Split Transform. Lesson 25: Altering Rows with the OLE DB Command Transform. Lesson 26: Handling Bad Data with the Fuzzy Lookup Transform. Lesson 27: Removing Duplicates with the Fuzzy Grouping Transform. Section IV: Variables and Expressions. Lesson 28: Making a Package Dynamic with Variables. Lesson 29: Making a Connection Dynamic with Expressions. Lesson 30: Making a Task Dynamic with Expressions. Section V: Containers. Lesson 31: Using Sequence Containers to Organize a Package. Lesson 32: Using For Loop Containers to Repeat Control Flow Tasks. Lesson 33: Using the Foreach Loop Container to Loop Through a Collection of Objects. Section VI: Configuration. Lesson 34: Easing Deployment with Configuration Tables. Lesson 35: Easing Deployment with Configuration Files. Lesson 36: Configuring Child Packages. Section VII: Troubleshooting and Logging. Lesson 37: Logging Package Data. Lesson 38: Using Event Handlers. Lesson 39: Troubleshooting Errors. Lesson 40: Using Data Viewers. Lesson 41: Using Breakpoints. Section VIII: Deployment and Administration. Lesson 42: Deploying Packages. Lesson 43: Configuring the SSIS Service. Lesson 44: Securing SSIS Packages. Lesson 45: Running SSIS Packages. Lesson 46: Scheduling Packages. Section IX: Data Warehousing. Lesson 47: Loading a Dimension Table. Lesson 48: Loading a Fact Table. Section X: Wrap Up and Review. Lesson 49: Bringing It All Together. Appendix A: SSIS Component Crib Notes. Appendix B: Problem and Solution Crib Notes. Appendix C: What’s on the DVD? Index.

About the Author :
Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at Jumpstart TV. He is the author of ten SQL Server books. Brian has spoken at conferences like PASS, SQL Connections, and TechEd and many Code Camps. His blog can be found at http://www.pragmaticworks.com. Brian watches his 401k wither away in Jacksonville, Florida. Devin Knight is a BI consultant at Pragmatic Works. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services (John Wiley & Sons, Inc.). Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, Florida, Devin is a participating member of the local users’ group (JSSUG). Visit his blog at http://pragmaticworks.com/community/blogs/. Mike Davis (Jacksonville, Florida) is an author, developer, consultant, and trainer with Pragmatic Works. He has expertise in many areas of Business Intelligence including Integration Services, Reporting Services, Analysis Services, Database Administration, and .NET Software Development. Mike has created enterprise level BI and software solutions for numerous corporations. As a trainer he travels the world teaching classes on SQL Server and BI. He also participates as a speaker at events like SQL Saturdays, SQL Server launches, SQL server user groups, and SQL PASS. In his spare time Mike plays guitar and darts. He is a member of the North Florida Dart League.


Best Sellers


Product Details
  • ISBN-13: 9780470496923
  • Publisher: John Wiley & Sons Inc
  • Publisher Imprint: Wrox Press
  • Height: 229 mm
  • No of Pages: 384
  • Sub Title: Microsoft SQL Server 2008 Integration Services
  • Width: 188 mm
  • ISBN-10: 0470496924
  • Publisher Date: 30 Jul 2009
  • Binding: SF
  • Language: English
  • Spine Width: 23 mm
  • Weight: 612 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services
John Wiley & Sons Inc -
Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!