The Next Evolution of IT

IT as a Service

Subscribe to IT as a Service: eMailAlertsEmail Alerts newslettersWeekly Newsletters
Get IT as a Service: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

IT as a Service Authors: Elizabeth White, Pat Romanski, Ed Witkovic, Alan Williams, Liz McMillan

Microsoft SQL Server : News Feed Item

Silico-Magnetic Intelligence Introduces Version 2.0 of Multimedia Training for SQL Server 2005

Silico-Magnetic Intelligence Introduces Version 2.0 of Multimedia Training for SQL Server 2005

NEW YORK, April 20 /PRNewswire/ -- Silico-Magnetic Intelligence Corp. has today released Version 2.0 of its full-motion video and audio CD-ROM training course for Microsoft SQL Server 2005 Administration.

With the "Practical Microsoft SQL Server 2005 Administration on 21 CD-ROMs" V2.0 training course, database administrators will learn techniques for configuring, administering and programming Microsoft SQL Server 2005, which has a host of new advanced features. Expert database, data warehouse and BI architect Kalman Toth's friendly presentation style makes this complex technical subject matter easy to understand. At the conclusion of this course the student will be prepared for successful database administration, design and programming of SQL Server 2005, including all the new features such as Management Studio UI, recursive queries, enhanced reporting, improved error control, integrated projects and database mirroring. Since the course is practical in nature, DBA (Database Administrator) and SQL developer candidates should be able to pass job interviews and perform to excellence in DBA/developer capacity.

Version 2.0 adds practical instructions in the following database operational areas: 3DES encryption of credit card and bank data, database backup encryption, comparing and synchronizing databases, bulk loading large XML files, using SSIS for automated data transfer, manipulating binary mask and csv list columns, creating high-performance indexes with included non-key columns and using the new TRY-CATCH feature to filter out invalid data destined to databases or data warehouses from external sources. Version 2.0 has extensive support for Business Intelligence reporting, including: creation of crosstab reports, programming multi-dimensional crosstab reports using the new PIVOT feature, generating Business Intelligence dashboards and preparing reports to be used in Excel spreadsheet for further analysis. A typical multi- dimensional crosstab report would be: year-to-date sales revenue tabulation by month (across) for each sales region and for each office within the region (left columns).

All 21 CD-ROMs contain full-motion screen image video with rich audio narration. This particular method of multimedia training represents the best learning environment for the student. It is also the most cost-effective way of acquiring database knowledge and administration skills. Each CD-ROM (chapter) is organized into units, typically 10 to 20 minutes in length. Students can replay each unit as many times as necessary to master it. Database scripting and programming can be mastered as they are run in Query Editor (programming tool supplied), and explained by the expert trainer in the background. Mastering the 21 CD-ROM SQL Server 2005 Administration training series is equivalent to three years of on-the-job experience.

The training package is priced at $995, and is currently shipping. For more information and a free test-drive visit

Any questions, email Sophie Korduba at [email protected] or call 1-845-290-6857.

This release was issued through eReleases(TM). For more information, visit

Silico-Magnetic Intelligence Corp.

CONTACT: Sophie Korduba, Silico-Magnetic Intelligence Corp.,
+1-845-290-6857, or [email protected]

Web site:

More Stories By PR Newswire

Copyright © 2007 PR Newswire. All rights reserved. Republication or redistribution of PRNewswire content is expressly prohibited without the prior written consent of PRNewswire. PRNewswire shall not be liable for any errors or delays in the content, or for any actions taken in reliance thereon.