ISBN 9788126540136,Knight's Microsoft Sql Server 2012 Integration Services 24-Hour Trainer

Knight's Microsoft Sql Server 2012 Integration Services 24-Hour Trainer

Rs649

Availability: Available

Usually ships in: 2-3 business days

(Free Delivery)

We Accept
ISBN 9788126540136
Check delivery information
 
ISBN 9788126540136
Publisher

Wiley India Pvt Ltd

Publication Year 2013
ISBN-13

ISBN 9788126540136

ISBN-10 8126540133
Binding

Paperback

Number of Pages 528 Pages
Language (English)
Subject

Computer Engineering

 TABLE OF CONTENTS : -


Preface
Welcome to  Ssis


Section 1: 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 Sql Server Data to ols
• Lesson 6: Creating Your First Package
• Lesson 7: Upgrading Packages to  Sql Server 2012
• Lesson 8: Upgrading to  The Project Deployment Model


Section 2: Control Flow


• Lesson 9: Using Precedence Constraints
• Lesson 10: Manipulating Files With The File System Task
• Lesson 11: Coding Custom Script Tasks
• Lesson 12: Using The Execute Sql Task
• Lesson 13: Using The Execute Process Task
• Lesson 14: Using The Expression Task
• Lesson 15: Using The Send Mail Task
• Lesson 16: Using The Ftp Task
• Lesson 17: Creating a Data Flow


Section 3: Data Flow


• Lesson 18: Extracting Data From Sources
• Lesson 19: Loading Data to  a Destination
• Lesson 20: Changing Data Types With The Data Conversion Transform
• Lesson 21: Creating and Replacing Columns With The Derived Column Transform
• Lesson 22: Rolling Up Data With The Aggregate Transform
• Lesson 23: Ordering Data With The Sort Transform
• Lesson 24: Joining Data With The Lookup Transform
• Lesson 25: Auditing Data With The Row Count Transform
• Lesson 26: Combining Multiple Inputs With The Union All Transform
• Lesson 27: Cleansing Data With The Script Component
• Lesson 28: Separating Data With The Conditional Split Transform
• Lesson 29: Altering Rows With The Ole Db Command Transform
• Lesson 30: Handling Bad Data With The Fuzzy Lookup
• Lesson 31: Removing Duplicates With The Fuzzy Grouping Transform



Section 4: Making Packages Dynamic


• Lesson 32: Making a Package Dynamic With Variables
• Lesson 33: Making a Package Dynamic With Parameters
• Lesson 34: Making a Connection Dynamic With Expressions
• Lesson 35: Making a Task Dynamic With Expressions


Section 5: Common Etl Scenarios


• Lesson 36: Loading Data Incrementally
• Lesson 37: Using The Cdc Components In Ssis
• Lesson 38: Using Data Quality Services
• Lesson 39: Using The Dqs Cleansing Transform
• Lesson 40: Creating a Master Package


Section 6: Containers


• Lesson 41: Using Sequence Containers to  Organize a Package
• Lesson 42: Using For Loop Containers to  Repeat Control Flow Tasks
• Lesson 43: Using The Foreach Loop Container to  Loop Through a Collection Of Objects


Section 7: Configuring Packages


• Lesson 44: Easing Deployment With Configuration Tables
• Lesson 45: Easing Deployment With Configuration Files
• Lesson 46: Configuring Child Packages


Section 8: Troubleshooting Ssis


• Lesson 47: Logging Package Data
• Lesson 48: Using Event Handlers
• Lesson 49: Troubleshooting Errors
• Lesson 50: Using Data Viewers
• Lesson 51: Using Breakpoints


Section 9: Administering Ssis


• Lesson 52: Creating and Configuring The Ssis Catalog
• Lesson 53: Deploying Packages to  The Package Catalog
• Lesson 54: Configuring The Packages
• Lesson 55: Configuring The Service
• Lesson 56: Securing Ssis Packages
• Lesson 57: Running Ssis Packages
• Lesson 58: Running Packages In T-Sql and Debugging Packages
• Lesson 59: Scheduling Packages


Section 10: Loading a Warehouse


• Lesson 60: Dimension Load
• Lesson 61: Fact Table Load


Section 11: Wrap Up and Review


• Lesson 62: Bringing It All to gether


Appendix A: Ssis Component Crib Notes
Appendix B: Problem and Solution Crib Notes
Appendix C: What's On The Dvd?
Index

Scroll