|
Invest
in Your Career
Learn SSIS from a top industry expert.
Practical SQL Server 2008 SSIS is now
available on full-motion screencast CD-ROMs with narration. Learn the
fun way! Multimedia training is far more effective than
classroom training. It simulates the real-world environment providing excellent
retention. You can replay the video and audio instructional
units as many times as you needed.
Learn SSIS with this easy-to-follow CD-ROM
collection from Silico-Magnetic Intelligence. Whether you
are learning SSIS for
the first time or adding to your professional skills set,
you will find that SMI’s SSIS Training
via CD-ROM™ contains thorough, outstanding, well-prepared
content that is second to none.
7 CD-ROMs with Over 18 Hours of Instruction 
The instructor is Kalman
Toth, MCDBA, MCITP, Senior SQL Server Database, Data Warehouse
and Business Intelligence Architect. By mastering one CD-ROM
a day, you can become an SSIS developer in just 7 days. You can also proceed
at your own pace. The thorough CD-ROM course is focused
on practical solutions to real-world SSIS package design, development, testing, debugging, deployment,
and maintenance problems. Full-motion screen video and rich
audio make the subject matter understandable, and reusable
as reference material.
Audience
Complete SQL Server 2008 Integration Services video course for DBAs, database developers, business intelligence developers and software engineers who design, develop, implement and manage DW, ETL and BI applications. C#, VB, Java, C++ and .NET developers who need to know more about applying data transfer and transformation in business environment.
Prerequisites
SSIS students must have a solid working
knowledge of the Windows environment. SQL Server 2008 administration and
programming experience in SQL, and the knowledge of at least one computer language
are helpful. This is best SSIS
multimedia training currently available in North America,
or anywhere in the World.
Objectives
Learn to maximize the numerous features of SSIS from this essential video guide. Multimedia course makes learning SSIS easy through the use of extensive practical, real-world exercises structured around every component within Business Intelligence Development Studio. You will learn to collect enterprise data warehouse data from various sources such as SQL Server OLTP databases, Access databases, Excel worksheets, Oracle and DB2 databases, and transform that data for OLAP analysis, mining, and reporting. Build robust, high-performance Business Intelligence solutions with SSIS visual package designer. Extract, transform, and load (ETL) data from disparate sources and move it to single or multiple destinations using SSIS data flow transformations. Video lessons show you, step-by-step, how to build, manage and deploy sophisticated SSIS packages, draw out meaningful information from raw data, and deliver data to web, business applications and enterprise reports. Learn migrating DTS packages to SSIS, enhancing performance, and implementing encryption policies to secure SSIS packages. Build packages with the easy-to-use SSIS Import and Export Wizard and the Visual Studio based BIDS. Create expressions using variables, functions, and operators. Lay out package workflow with Control Flow Containers and tasks. Monitor and audit runtime events using log providers. Respond to external triggers with event handlers. Process input using Data Flow tasks. 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. Learn about XML configuration file, deployment security and the manifest file. Discover all SSIS command prompt utilities. (See full list below).
About the Trainer
Kalman
Toth, MCDBA,
is an IT professional with over 16 years of database administration
and development experience with SQL server 4.2, 6.5, 7.0,
2000 and 2008. Kalman Toth was a developer on IBM's marketing
Data Warehouse project operated by Dun & Bradstreet.
He has designed OLAP data warehouse/BI/SSIS
solutions for major online dating, diet and fitness websites.
His clients include: Citibank, Bank of Sweden, Deloitte-Touche,
Swiss Bank, Lehman Brothers, Salomon Brothers, Merrill Lynch,
and IBM. He holds M.Phil degree in Physics and M.Phil. degree
in Computing Science from Columbia University, where he
had taught computer science.
CD-ROM Features
SMI's CD-based training is like training one-on-one with
an expert -- full motion video allows you to see the steps,
hear the explanations, and perform the critical tasks. You can pause the video at any time and practice along. This
is the complete training solution for passing a certification
exam, excelling on an interview and performing well in the
workplace. It is convenient, giving you the freedom to learn
at your own pace, wherever and whenever it suits your schedule.
CD-ROM is easy to use, with streamlined interface featuring
one-click navigation. 100% guaranteed.
Bonus Book: Professional Microsoft SQL Server 2008 Integration Services 
Authorative textbook of 1008 pages by authors Brian Knight, Erik Veerman, Grant Dickinson, Douglas Hinson, Darren Herbold. The new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS). Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than ever.
Case studies and tutorial examples acquired over the three years since the previous edition will contribute to helping illustrate advanced concepts and techniques. New chapters include coverage of data warehousing using SSIS, new methods for managing the SSIS platform, and improved techniques for ETL operations.
|
