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

 TEST DRIVE
 BUY ONLINE
 NEWSLETTER
 CONTACT US
 BUY OFFLINE
 REFERENCE
 LINKS

Testimonials

"Your SQL Server 2005 Programming videos are great and have helped me greatly. I think they are very well-prepared, content rich. Thank you for helping me as an SQL developer to sharpen my programming skills with PIVOT, CTE, ROW_NUMBER and other advanced features."
Richard Ragusa

"I am really impressed that we can do recursive queries in Transact-SQL 2005. That opens up new possibilities in tree processing. Also the cross tabulation feature will come handy for neat ad hoc reporting. The CD-ROM training is excellent. I gained a lot of useful knowledge."
Randy Keil

"I am very pleased with having SQLUSA SQL 2005 programming training cds in our training lab. I have found that it is much easier for me to follow instructions when I can see the real moving computer screens. It keeps me focused on the topic at hand since it is right in front of me. I am certain that the new CTE facility will change forever the way I program queries and sprocs."
Linda Nelson


 

SQLUSA.com
Search

GoogleCheckout
SQL 2005 Grand Prix
Practical SQL Server 2005 Administration
SQL 2005 Grand Slam
Microsoft SQL Server 2005 Programming
Multi-Dimensional Business Intelligence
SQL Server 2005 Crash Course
Practical SSIS
MCITP Database Administrator Ace
Microsoft MCDBA Ace
SQL 2005 Administration and BI
Data Warehousing with OLAP Cubes
SQL 2005 and SQL 2000 Administration
SQL 2005 Admin and Programming
SQL 2005 Programming and BI
SQL Server 2000 Training  

 Free Trial Registration
Email*
How Did You Hear About Us? 
Name
Country 
State 
Zip 
  *Required

Best Possible Career Investment
SQL Server 2005 Programming training is now available on 7 full-motion video CD-ROMs with narration. Learn SQL Server 2005 programming 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 the new programming features of SQL Server 2005 from The World Leader in SQL Server Training.

Master Microsoft SQL Server 2005
Design, and Programming are all included in this easy-to-learn video/audio CD-ROM collection from Silico-Magnetic Intelligence. Whether you are learning SQL Server 2005 Programming for the first time or adding to your professional skills set, you will find that SMI’s Practical Training via full-motion video 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/2005 Architect. By mastering one CD-ROM a day, you can become a Microsoft SQL Server 2005 developer in 7 days. Naturally, you can also proceed at your own pace, be it 4 days or 4 weeks. The comprehensive CD-ROM course is focused on practical solutions to real-world database, client and server design and 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 2005 Programming
VB, .Net, Cold Fusion, Web, Java, C++, C# and database developers, systems analysts, and software engineers who need to know more about the design and programming of SQL Server 2005.

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

Objective: Excellence in SQL Server Related Professions
The CD-ROM based course will allow learners to design, create and manage database objects, use the SELECT statement, insert/update/delete data, program in transact-SQL.There is strong emphasis on practical applications and real life examples. (See full list below)

About the Industry Expert Trainer
Kalman Toth, MCDBA, is a designer of over 60 databases worldwide with 15 years of database administration and development experience on SQL server 4.2, 6.5, 7.0, SQL Server 2000, SQL Server 2005 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.

Bonus Book 1: Microsoft SQL Server(TM) 2005: Database Essentials Step by Step
Your hands-on, step-by-step guide (336 pages) to learning the fundamentals of SQL Server 2005 programming. Get the guidance you need to start designing databases—one step at a time. With this practical tutorial, you’ll teach yourself the core skills for building and managing databases with the next generation of SQL Server. Discover how to:
Install and configure SQL Server 2005; Design database components with SQL Server Management Studio; Apply a three-step modeling approach to design databases that meet business requirements; Create, modify, and manage views; Write user-defined functions and stored procedures using T-SQL; Add, delete, and update information in your databases; Work with data from custom applications and legacy systems; Troubleshoot error messages and handle exceptions. CD features: All practice exercises; Code samples.

7 CD-ROMs Equivalent to 3 Years of Job Experience
SMI's CD-based SQL Server 2005 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 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.

One Year of Free Updates
Price includes 1 year of free updates from the time of purchase. Updated cd-s will be provided at no extra charge during this period.

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

Enlarge

Microsoft SQL Server 2005
Programming on 7 CD-ROMs


CD-ROM 1- SAMPLE DATABASES (3 hours 5 minutes)
1. Diagram of AdventureWorks Database
2. Primary Key and Foreign Key: RDBMS Basics
3. 1NF, 2NF & 3NF Normal Forms in AdventureWorks
4. AdventureWorks Sample Database Overview
5. AdventureWorks Business Scenarios
6. AdventureWorks Data Dictionary
7. Creating Database Diagrams
8. Pubs Sample Database Overview
9. Northwind Sample Database Overview
10. More on Pubs from the Query Editor
11. More on Northwind from the Query Editor
12. Advanced Review of the Pubs Database
13. Advanced Review of the Northwind Database
14. Accounting DB Review: GL, AP, AR & Inventory


CD-ROM 2 - DATABASE DESIGN (3 hours 5 minutes)
1. Logical Data Modelling
2. Data Types for Table Columns
3. Creating Tables by Statements
4. Advanced Create Table Examples
5. Create Special Tables and Copy Tables
6. Observing Table Behaviour
7. Creating Tables by Management Studio
8. Primary Key and Foreign Key Constraints
9. ALTER TABLE and Changing Tables by MS
10. Partitioned Table, Partition Function and Scheme
11. Code, Translate and Lookup Table Design
12. Normalization, NULLs and Debated Design Issues
13. Database Design and Programming Standards


CD-ROM 3 - THE SELECT STATEMENT (3 hours 7 minutes)
1. Inner Join, Self Join, Outer Join and Cross Join
2. Simple SELECT Queries
3. SELECT Examples Featuring ORDER BY
4. SELECT with Nested and Correlated Subqueries
5. SELECT with UNION, COMPUTE, ROLLUP and CUBE
6. SELECT with String, Date and Math Functions
7. SELECT with CHECKSUM and Statistical Functions
8. Dynamic SQL
9. SELECT with GROUP BY Clause
10. SELECT with PIVOT and UNPIVOT
11. Recursive Queries
12. ROW_NUMBER, RANK, DENSE_RANK and NTILE
13. TOP, TABLESAMPLE, INTERSECT and EXCEPT
14. Crosstab Query with CTE and PIVOT
15. Multidimensional Cross Tabulation
16. Business Intelligence Dashboards


CD-ROM 4 - MODIFY DATA (3 hours 10 minutes)
1. INSERT Statement with VALUES Using QE
2. INSERT.....SELECT Statement
3. INSERT.....EXEC Statement
4. DELETE Statement Examples
5. UPDATE Statement Examples
6. UPSERT: Combination of UPDATE and INSERT
7. Modifying Data with Cursors and Subqueries
8. Logged and Nonlogged Operations
9. Common Table Expression - CTE
10. The OUTPUT Clause
11. INSERT with CTE and OUTPUT
12. UPDATE with CTE and OVER(PARTITION BY...)
13. Deleting Duplicate Rows with CTE
14. Updating Binary Mask and CSV List Columns


CD-ROM 5 - DATA INTEGRITY (5 hours 3 minutes)
1. Data Integrity Implementation in AdventureWorks
2. Surrogate Key Architecture
3. Data Integrity Templates
4. Stored Procedure vs. Ad-hoc SQL Script
5. Entity, Domain and Referential Database Integrity
6. Entity Integrity Definition Using Management Studio
7. Scripting Tables and Related Objects Using MS
8. Domain Integrity Constraints Using Query Editor
9. Referential Integrity Explanation and Constraints
10. User Defined Data Integrity Objects
11. Business Rules Enforcement with Triggers
12. Visio Logical Database Diagram
13. Database Design with Visio
14. Database Diagram Design and Export
15. Comparing and Synchronizing Databases


CD-ROM 6 - PROGRAMMABILITY (3 hours 4 minutes)
1. Simple Stored Procedures
2. Stored Procedures with OUTPUT Parameters
3. Stored Procedures in AdventureWorks Database
4. CREATE TRIGGER Examples
5. Triggers with DELETED and INSERTED Tables
6. INSTEAD OF Triggers and AFTER Triggers
7. DDL (Data Definition Language) Triggers
8. Views Definition and Examples
9. CREATE FUNCTION Examples
10. User Defined Function with Assembly
11. Temporary Tables, Optimization and tempdb
12. EXECUTE AS for Execution Context Definition
13. Multiple, Nested and Correlated CTE-s
14. Debugging Stored Procedures and CTE-s


CD-ROM 7 - TRANSACT-SQL (3 hours 1 minute)
1. TRANSACT-SQL, Batch, and Scripts
2. BEGIN, COMMIT, ROLLBACK TRANSACTION
3. TRY, CATCH for Exception Handling
4. Locks, Isolation Levels and Deadlocks
5. Snapshot Isolation for OLTP Concurrency
6. PROGRAMMING STATEMENTS in Transact-SQL
7. User Defined and System Stored Procedures
8. Linked Servers and 4-part Addressing
9. CROSS APPLY and OUTER APPLY Operators
10. DBA Script Generator Using Query Editor
11. Undocumented T-SQL Features
12. Dynamic PIVOT and Crosstab Scripts


 

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

 
 

The future is just a click away! Your future!

 
     
  Copyright 2005, SMI Corp. All Rights Reserved.  
     
  Microsoft is a trademark of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.