Book description
Book-and-video package gets novices up to speed on Microsoft SQL Server 2012
If you need a practical, hands-on introduction, especially to SQL Server Integration Services (SSIS), this book-and-video package from authority Brian Knight is the perfect solution. Each lesson includes three major components: a description of how each SSIS feature or process works, a tutorial that walks you through the process or technique, and an accompanying video lesson. It's a complete learning package that will give you the confidence you need to start your first SSIS project.
Guides novice database administrators and developers who are learning Microsoft SQL Server 2012 and SQL Server Integration Services (SSIS)
Provides expert instruction from leading SQL Server authority and author, Brian Knight
Includes a book and a video, complete instruction that includes lessons, hands-on tutorials, and video demonstrations by the author
Covers the very latest changes and updates in the SQL Server 2012 release
Microsoft SQL Server 2012 Integration Services 24-Hour Trainer makes SQL Server 2012 and SSIS much less intimidating.
Note: CD-ROM/DVD and other supplementary materials are not included as part of the e-book file, but are available for download after purchase.
Table of contents
- Cover
- Contents
- Welcome to SISS
-
Section 1
- Chapter 1: Moving Data with the Import and Export Wizard
- Chapter 2: Installing SQL Server Integration Services
- Chapter 3: Installing the Sample Databases
- Chapter 4: Creating a Solution and Project
- Chapter 5: Exploring SQL Server Data Tools
- Chapter 6: Creating Your First Package
- Chapter 7: Upgrading Packages to SQL Server 2012
- Chapter 8: Upgrading to the Project Deployment Model
-
Section 2
- Chapter 9: Using Precedence Constraints
- Chapter 10: Manipulating Files with the File System Task
- Chapter 11: Coding Custom Script Tasks
- Chapter 12: Using the Execute SQL Task
- Chapter 13: Using the Execute Process Task
- Chapter 14: Using the Expression Task
- Chapter 15: Using the Send Mail Task
- Chapter 16: Using the FTP Task
- Chapter 17: Creating a Data Flow
-
Section 3
- Chapter 18: Extracting Data from Sources
- Chapter 19: Loading Data to a Destination
- Chapter 20: Changing Data Types with the Data Conversion Transform
- Chapter 21: Creating and Replacing Columns with the Derived Column Transform
- Chapter 22: Rolling Up Data with the Aggregate Transform
- Chapter 23: Ordering Data with the Sort Transform
- Chapter 24: Joining Data with the Lookup Transform
- Chapter 25: Auditing Data with the Row Count Transform
- Chapter 26: Combining Multiple Inputs with the Union All Transform
- Chapter 27: Cleansing Data with the Script Component
- Chapter 28: Separating Data with the Conditional Split Transform
- Chapter 29: Altering Rows with the OLE DB Command Transform
- Chapter 30: Handling Bad Data with the Fuzzy Lookup
- Chapter 31: Removing Duplicates with the Fuzzy Grouping Transform
- Section 4
- Section 5
- Section 6
- Section 7
- Section 8
-
Section 9
- Chapter 52: Creating and Configuring the SSIS Catalog
- Chapter 53: Deploying Packages to the Package Catalog
- Chapter 54: Configuring the Packages
- Chapter 55: Configuring the Service
- Chapter 56: Securing SSIS Packages
- Chapter 57: Running SSIS Packages
- Chapter 58: Running Packages in T-SQL and Debugging Packages
- Chapter 59: Scheduling Packages
- Section 10
- Section 11
- Appendix C: What's on the DVD?
- Preface
- John Wiley & Sons, Inc. End-User License Agreement
- Advertisement
Product information
- Title: Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer
- Author(s):
- Release date: November 2012
- Publisher(s): Wrox
- ISBN: 9781118479582
You might also like
book
Professional Microsoft SQL Server 2012 Integration Services
An in-depth look at the radical changes to the newest release of SISS Microsoft SQL Server …
book
Professional Microsoft SQL Server 2014 Integration Services
Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL …
book
Microsoft® SQL Server 2012 Unleashed
Buy the print version of¿ and get the eBook version for free! eBook version includes chapters …
book
Microsoft SQL Server 2014 Unleashed
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage …