| |||||||||||||||
 Trade In this Item for up to £0.25
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Hands-On Microsoft SQL Server(TM) 2005 Integration Services for an Amazon.co.uk gift card of up to £0.25, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
|
There is a newer edition of this item:
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
In-depth coverage of Microsoft’s powerful new data integration tool
Learn to maximize the features of SQL Server 2005 Integration Services from this essential guide. Hands-On Microsoft SQL Server 2005 Integration Services makes learning SSIS easy through the use of extensive real-world exercises structured around every component within the tool. You will learn to collect corporate data from various sources and transform that data for analysis, mining, and reporting.
From the Back Cover
Extract, transform, and consolidate data from disparate sources and move it to single or multiple destinations using SQL Server 2005 Integration Services -- the next-generation data integration platform. Hands-On Microsoft SQL Server 2005 Integration Services shows you, step-by-step, how to build and manage SSIS packages, draw out meaningful information from raw data, and deliver de-duplicated and cleansed data to business applications and corporate reports. Inside, you'll get detailed information on migrating to SQL Server 2005 Integration Services, enhancing performance, and implementing encryption policies to secure SSIS packages.
ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS:
- Build packages with the SSIS Import and Export Wizard and BIDS
- Create expressions using variables, functions, and operators
- Lay out package workflow with Control Flow Containers and tasks
- Secure SSIS packages and encrypt sensitive data
- Monitor and audit runtime events using log providers
- Respond to external triggers with event handlers
- Transform and manipulate input using Data Flow Components
- Standardize, de-duplicate, and cleanse data with Fuzzy Lookup and Fuzzy Grouping transformations
- Load Data warehouse using Slowly Changing Dimension transformation
- Deploy, optimize, troubleshoot, and debug SSIS packages
Concordance
Front Cover | Copyright | Table of Contents | Excerpt | Index
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
I especially liked the data flow chapters and the review sections given after the exercises where author discusses more ways to do the same thing or what else could be done.
The de-duplication example was particularly helpful for me to develop a real life solution.
Listmania!
Look for similar items by category
- Books > Computing & Internet > Certification > Subjects > Microsoft > SQL Server
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
