2015
Lynda
Ron Davis
4h 9m
English
Microsoft SQL Server Integration Services, or SSIS, is an enterprise-level ETL tool: a tool for extracting, transforming, and loading data. Whether you're looking for information in flat files, via FTP, or on the web, SSIS allows you to transform it all into a uniform format for databases. In this course, Ron Davis teaches this mission-critical skill for IT professionals, developers, and data analysts. Ron covers the architecture of SQL Server Integration Services, the platform's tools, basic task scripting, and the variables, parameters, and expressions you can use to customize your ETL packages. Plus, discover how to use containers to group and repeat tasks, how to merge datasets with joins, and how to debug packages, and learn about common design patterns that will increase your efficiency in SSIS.
Topics include:
- Creating SSIS packages
- Coding and looping tasks
- Managing and administering SQL with SSIS tasks
- Optimizing data for extraction
- Making packages dynamic with variables and parameters
- Using sequences in a container
- Performing joins
- Handling errors
- Working with XML
Introduction
21m 35s
Welcome
1m 11s
What you should know before watching this course
2m 2s
Setting up the practice environment
1m 59s
Using the exercise files
16m 23s
1. Architecture
42m 48s
Version changes of SSIS from 2008-2014
7m 59s
The SQL Server Integration Service
2m 36s
Understanding packages
6m 50s
Managing with control flow
6m 46s
Moving data with data flow
4m 12s
Understanding variables
7m 7s
Understanding parameters
7m 18s
2. SQL Server Integration Services Tools
19m 3s
Utilizing the Import and Export Wizards
6m 21s
Working in the Explore window
3m 23s
Creating SQL Server Integration Services packages
4m 54s
Utilizing connection managers
2m 10s
The Source and Destination Assistants
2m 15s
3. SQL Server Integration Services Tasks
44m 54s
Coding the Script task
3m 10s
Looping and Sequence tasks
5m 25s
Data Preparation tasks
12m 49s
Data loading with the Execute SQL task
5m 59s
Using the Workflow tasks
7m 42s
Managing SQL with the SQL tasks
1m 57s
Administration of SQL using the SQL Management Objects tasks
7m 52s
4. Data Flow
38m 27s
Using destinations and understanding choices
5m 7s
Examining the Row transformations
7m 32s
Examining the Rowset transformations
14m 35s
Examining Split and Join transformations
11m 13s
5. Variables, Parameters, and Expressions
19m 32s
SQL Server Integration Services data typing
9m 10s
Defining and using variables and parameters
5m 29s
Using expressions to make dynamic packages
4m 53s
6. Performing Joins
13m 34s
Performing joins with the Lookup transformation
5m 8s
Performing joins with the Merge transformation
8m 26s
7. Debugging SQL Server Integration Services Packages
25m 22s
Designing to troubleshoot: Using precedence constraints
10m 39s
Using events
3m 47s
Working with logging
4m 36s
Handling errors
6m 20s
8. Common Designs in SQL Server Integration Services
23m 8s
Choosing the Script task or Script component
9m 35s
Working with XML
7m 35s
Deployment
2m 29s
Best practices
3m 29s
Conclusion
37s
Where to go next
37s
www.lynda.com/SQL-Server-tutorials/SQL-Server-Integration-Services/191941-2.html
Download File Size:488.66 MB
|
