Microsoft SQL Server 2000 Programming
Training on 7 Full-Motion Video & Audio CD-ROMs

 TEST DRIVE
 BUY ONLINE
 BUY OFFLINE
 REFERENCE
 CONTACT US
 LINKS


Testimonials


"This is definitely the best multimedia training to get on learning SQL Server progamming. It touches on all the areas you need to know to become proficient in managing and programming your databases. I can highly recommend it."
Paul Walker

"Your SQL programming course allows me to study during my lunchtime, at night and weekend while I'm at home. As soon as I am finished, I plan on updating my resume and starting my job search for better pay and more challenge! I am pretty good in Cold Fusion and VB, but my SQL was weak. It is now getting stronger every day. Thanks again for the great multimedia training package. "
Debbie Hill

"I was promoted to project manager at a bank in Houston as a direct result of your sql server programming training course. I got a raise too. I can fairly say that the five hundred bucks I spent on the sqlusa training package was the best investment of my life. Not only the money was well invested, but my time as well. It was an extremely gratifying experience to learn from an outstanding database practitioner."
Bruce Muller

"Very good cd-rom based course – studying with a partner was very beneficial and fun. Good format, good material, great trainer. This moving picture training format is very real. Hope I'll be able to do the data warehouse and business intelligence training soon."
Kumar Gupta

"I took a database course by a theoretical-trainer without real practical experience. My questions were answered with ... I'll tell you at the end of the course ..and naturally the answers never came.. Your multimedia video and audio training by an experienced SQL guru is really refreshing. Much better value than live training. Kalman truly knows everything about practical MS SQL programming one should know in the real business world.
"
Christian Bassermann

 

The future is just a click away! Your future!
SQLUSA Leading Edge
Training Products

 
 
Practical SQL Server 2000 Administration - 21 CD
Microsoft SQL Server 2000 Grand Slam - 30 CD
Crash Course in SQL Server 2000 - 3 CD
SQL Server 2000 Programming - 7 CD
Data Warehousing with OLAP Cubes - 5 CD
120 Minutes to Stardom in SQL2K - 1 CD
Crash Course & Data Warehousing - 8 CD
Programming and DW - 12 CD

Best Possible Career Investment
SQL Server 2000 Programming training is now available on 7 full-motion CD-ROMs with narration. Learn the fun way! Multimedia training is far more effective than boring hard to follow textbooks. It simulates the real-world environment for excellent memory retention. Learn from your own computer at a pace that suits you. You can replay the video and audio instructional units as many times as you need to. Save big over expensive classroom training with inexperienced instructors. Learn from a real sql pro.

Master Microsoft SQL Server 2000 Programming with this easy-to-learn video/audio CD-ROM collection from Silico-Magnetic Intelligence. Whether you are learning SQL Server 2000 Programming for the first time or adding to your professional skills set, you will find that SMI’s Training via full-motion CD-ROM™ contains thorough, outstanding, well-prepared content that is second to none. Like training one-on-one with an experienced database professional: each unit is presented in full-motion screen image video allowing you to see the steps and hear the explanations.

Instructions by a Top SQL Expert
The instructor is Kalman Toth, MCDBA, Senior SQL Server 2000 Architect. By mastering one CD-ROM a day, you can become a Microsoft SQL Server 2000 developer in 7 days. Naturally, you can also proceed at your own pace be it three days or seven weeks. The comprehensive CD-ROM course is focused on solutions to real-world database, client and server programming problems. Full-motion screen video and rich audio make the subject matter understandable, and reusable as reference material in the future.

Audience for SQL Server 2000 Programming
VB, Web, Java, C++ and database developers, systems analysts, software engineers, MCDBA, MCSE and MCSA candidates who need to know the programming of SQL Server 2000 as well as database design. This intensive course gives an essential grounding for the Microsoft examination 70-029 Designing and Implementing Databases with Microsoft SQL Server 7.0 and 70-229 Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.

Prerequisites for the Best SQL Server Programming Training
SQL Server 2000 programming learners must have a solid working knowledge of the Windows environment, and any programming experience is a huge plus. This is the most extensive, and the best Microsoft SQL Server Programming multimedia training currently available in North America, or anywhere in the World.

Objective: Excellence in SQL Server Programming
The CD-ROM based course will allow learners to design normalized relational databases, create tables and indexes, use all variations of the select statement, insert, delete and update table data, configure data integrity, create views, stored procedures and triggers, write transact-SQL programs. (See full list below)

About the Industry Expert Trainer
Kalman Toth, MCDBA, is a designer of over 50 databases worldwide with 15 years of database administration and development experience on SQL server 4.2, 6.5, 7.0, SQL Server 2000 and Sybase. His clients include: Citibank, Bank of Sweden, Deloitte-Touche, Swiss Bank, Lehman Brothers, Salomon Brothers, Merrill Lynch, Reuters, IBM and major website companies. He holds an M.Phil. degree in Computing Science from Columbia University, where he taught computer science.

Free Bonus from Que Publishing:
Microsoft SQL Server 2000 Programming by Example

This excellent 770 pages manual complements the multimedia training. SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques, used in SQL Server 2000, primarily using Transact-SQL. Even if you are a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples. Get up to speed on SQL Server 2000 and learn how to take full advantage of its new features.

7 CD-ROMs Equivalent to 2 Years of Job Experience
SMI's CD-based SQL Server 2000 training is like training one-on-one with an international industry expert -- full motion screen video allows you to see the steps, hear the explanations, and perform the critical programming tasks. This is complete training solution for passing related certification exams, 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. The multimedia training package is priced at $495.



 
 
Multimedia Microsoft SQL Server 2000 Programming training on 7 full-motion screen image video and rich audio CD-ROMs $495.

Enlarge

Microsoft SQL Server 2000
Programming on 7 CD-ROMs


CD-ROM 1 - SAMPLE DATABASES (92 min)
1. Primary Key and Foreign Key: RDBMS Basics
2. Pubs Sample Database Overview
3. Northwind Sample Database Overview
4. More on Pubs from the Query Analyzer
5. More on Northwind from the Query Analyzer
6. Advanced Review of the Pubs Database
7. Advanced Review of the Northwind Database


CD-ROM 2 - DATABASE DESIGN (142 min)
1. Logical Data Modelling
2. Data Types for Table Columns
3. Creating Tables by Statements
4. Additional Create Table Examples
5. Create Special Tables and Copy Tables
6. Observing Table Behaviour
7. Creating Tables by Enterprise Manager
8. Primary Key and Foreign Key Constraints
9. ALTER TABLE and Changing Tables by EM
10. Normalization and Debated Design Issues
11. Database Design and Programming Standards


CD-ROM 3 - THE SELECT STATEMENT (122 min)
1. Inner Join, Outer Join and Cross Join
2. The SELECT Statement Using the pubs DB
3. SELECT Examples Featuring ORDER BY
4. SELECT Examples with Subqueries
5. SELECT Examples Featuring COMPUTE
6. SELECT with String, Date and Math Functions
7. SELECT with Statistical Functions
8. Dynamic SQL
9. SELECT Statement with GROUP BY Clause


CD-ROM 4 - MODIFY DATA (80 min)
1. Table INSERT Using Enterprise Manager
2. INSERT Statement with VALUES Using Query Analyzer
3. INSERT.....SELECT Statement
4. DELETE Statement Examples
5. UPDATE Statement
6. Modifying Data with Cursors and Subqueries
7. Logged and Nonlogged Operations


CD-ROM 5 - DATA INTEGRITY (80 min)
1. Entity, Domain, Referential and User-Defined Database Integrity
2. Entity Integrity Definition Using Enterprise Manager
3. Scripting Tables and Related Objects Using Enterprise Manager
4. Domain Integrity Constraints Using the Query Analyzer
5. Referential Integrity Explanation and Constraints
6. User Defined Data Integrity Objects
7. Business Rules Enforcement with Triggers


CD-ROM 6 - PROGRAMMING OBJECTS (100 min)
1. Simple Stored Procedures
2. Stored Procedures with the OUTPUT Parameters
3. Stored Procedures in the Northwind Database
4. CREATE TRIGGER Examples
5. Trigger Examples with DELETED and INSERTED Tables
6. INSTEAD OF Triggers and AFTER Triggers
7. Views Definition and Examples
8. CREATE FUNCTION Examples
9. Temporary Tables, Optimization and tempdb


CD-ROM 7 - TRANSACT-SQL (98 min)
1. TRANSACT-SQL, Batch, and Scripts
2. BEGIN, COMMIT, ROLLBACK TRANSACTION
3. Locks, Isolation Levels and Deadlocks
4. PROGRAMMING STATEMENTS in Transact-SQL
5. User Defined and System Stored Procedures
6. Linked Servers and 4-part Addressing
7. DBA Script Generator Using Query Analyzer
8. Undocumented T-SQL Features

Availability: the product usually ships on the next business day.

 
 

The future is just a click away ! Your future!

 
     
  Copyright 2003-2004, SMI Corp. All Rights Reserved.  
     
  Microsoft is a trademark of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.