This course covers ways to extract, transform, and load data using SQL Server 2008. SQL Server provides many tools for your ETL needs.
Objectives:
This course covers ways to extract, transform, and load data using SQL Server 2008. SQL Server provides many tools for your ETL needs.
Bulk copy data
Use distributed queries
Demonstrate SQL Server Integration Services
Apply alternative ETL solutions
Topics:
ETL Techniques
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
