|
Invest
in Your Career
Learn SSIS from a top industry expert.
Practical SQL Server 2005 SSIS is now
available on full-motion 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, video 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
Database developers, business intelligence developers, software engineers, DBAs, data warehouse architects,
systems analysts, IT managers and project managers who design,
develop, implement and manage Microsoft SQL Server 2005
Integration Services based DW, ETL and BI applications. Network and Database
Administrator candidates, VB, Java, C++, ASP.NET and database
developers who need to know more about applying data transfer and transformation in large-scale business environment.
Prerequisites
SSIS students must have a solid working
knowledge of the Windows environment. SQL Server 2005 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 and transform that data for OLAP analysis, mining, and reporting. Build robust, high-performance Business Intelligence solutions with SSIS. Extract, transform, and load (ETL) data from disparate sources and move it to single or multiple destinations using SSIS. Video lessons show you, step-by-step, how to build and manage SSIS packages, draw out meaningful information from raw data, and deliver data to web, business applications and enterprise reports. Learn migrating to SSIS, enhancing performance, and implementing encryption policies to secure SSIS packages. Build packages with the SSIS Import and Export Wizard and 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. (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 2005. 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 1: Microsoft SQL Server 2005 Integration Services Step by Step 
Teach yourself the fundamentals of SQL Server Integration Services—one step at a time. This practical, learn-by-doing tutorial delivers the guidance you need to transform and consolidate data—and build solutions that support your SSIS needs. Discover how to:
•Design and execute packages that transform data between files and relational databases
•Configure connection managers to access other data sources
•Create data flows that alter, split, match, and merge data
•Develop event-handlers and monitor package performance
•Encrypt sensitive information and control access to packages
•Customize script code to automate Control Flow and Data Flow tasks
•Debug, troubleshoot, and optimize packages
CD features:
•All practice exercises
•Sample databases
•Fully searchable eBook
Bonus Book 2: Expert SQL Server 2005 Integration Services (Programmer to Programmer) 
There are two keys to a successful ETL solution: using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements. With SQL Server 2005 Integration Services, half the battle is won. The out-of-the-box features provide the depth and breadth of functionality and flexibility needed to create scalable solutions. Even more, the usability and rapid learning curve reduce solution development time.
The second ingredient is correct ETL architecture and design. When considerable effort is spent testing scenarios and proving out designs, valuable testing, implementation, and deployment time is lost. This book fills that gap. As a practical guide for Integration Services ETL development, you will learn ways to implement your ETL solution requirements from the data to the administration and everything in-between. Each chapter begins with a review of pertinent ETL concepts and moves into working those out into a design with multiple examples and related Integration Services features. Putting it all together to get a solution over the goal line requires knowing the big picture and coordinating all the pieces. The book, in short: ETL soup to nuts with Integration Services.
As a practical guide for Integration Services ETL development, this book shows you ways to implement your ETL solution requirements from the data to the administration and everything in between. Each chapter begins with a review of pertinent ETL concepts and moves into working those out into a design with multiple examples and related Integration Services features with the end goal of putting it all together to get a solution.
|
