Crash Course in Microsoft SQL Server 2005
on 3 Full-Motion Video & Audio CD-ROMs

 TEST DRIVE
 BUY ONLINE
 REFERENCE
 CONTACT US
 LINKS


Testimonials


"I had to learn SQL Server 2005 real quickly, basically during a weekend. SQLUSA's Crash Course saved my job. It is the only product on the market which gives you a basic working knowledge of SQL Server 2005 in such a short period of time. Job well done."
Kevin Werbach


"The video portion of the training lets you view the computer screen user interfaces used to administer, design, and program SQL Server as though you were looking over the instructor's shoulder. All you have to do is follow the mouse and the cursor as the instructor talks you through the short and practical lessons."
MSDN Magazine




Computer Headlines

 

 
SQLUSA
The World Leader in SQL Server Training

 
 
Practical SQL Server 2005 Administration - 21 CD
Crash Course in SQL Server 2005 - 3 CD
SQL 2005 Grand Slam - 38 CD
SQL 2005 Grand Prix - 35 CD
Microsoft SQL Server 2005 Programming - 7 CD
Multi-Dimensional Business Intelligence - 7 CD
SQL Server 2000 Training  

Supercharge Your Career Today
A long weekend Crash Course in SQL Server 2005 is now available on full-motion CD-ROMs with narration. Learn the fun way! Multimedia training is far more effective than textbooks. It simulates the real-world environment for excellent retention. You can replay the video and audio instructional units as many times as you need to.

Learn Microsoft SQL Server 2005 with this easy-to-follow CD-ROM collection from Silico-Magnetic Intelligence. Whether you are learning Microsoft SQL Server 2005 for the first time or adding to your professional skills set, you will find that SMI’s Practical Training via CD-ROM™ contains thorough, outstanding, well-prepared content that is second to none:

3 CD-ROMs with Over 7 Hours of Instruction
The instructor is Kalman Toth, MCDBA, Senior SQL Server Architect. By mastering one CD-ROM a day, you can become a Microsoft SQL Server 2005 programmer in 3 days, just a long weekend. You can also proceed at your own pace. The introductory CD-ROM course is focused on practical solutions to real-world database, client and server SQL programming and administration problems. Full-motion screen video and rich audio make the subject matter understandable, and reusable as reference material.

Audience
Software engineers, IT managers and technical project managers who design, develop, implement and manage Microsoft SQL Server 2005 based applications. MCSE & MCITP candidates, VB.NET, Java, C++, ASP.NET and database developers who need to know more about applying SQL Server 2005 in business environment.

Prerequisites
SQL Server 2005 students must have a solid working knowledge of the Windows environment, and programming experience in any computer language. This is the best Microsoft SQL Server 2005 multimedia crash training currently available in North America, or anywhere in the World.

Objectives
The CD-ROM based crash course will teach students to setup tables, populate them with data, change data in tables, delete rows from tables. Write SQL queries, use transact-SQL built-in function. Create indexes, stored procedures, views and triggers. The CD course shows and tells applying live screen image video and audio, how to install and configure an SQL Server, create and manage databases and database devices both in Management Studio and with scripts in Query Editor, backup and restore SQL databases, import and export data, understand olap datawarehouse basics and implement automated tasks. (See full list below.)

About the Trainer
Kalman Toth, MCDBA, is an IT professional with over 14 years of database administration and development experience with SQL server 4.2, 6.5, 7.0, 2000 and 2005. In addition Kalman Toth has substantial Sybase and Oracle experience. His clients include: Citibank, Bank of Sweden, Deloitte-Touche, Swiss Bank, Lehman Brothers, Salomon Brothers, Merrill Lynch, and IBM. He holds an M.Phil. degree in Computing Science from Columbia University, where he taught computer science.

Free Bonus CD: SQL Server 2005 Express
SQL Server 2005 Express Edition is the free, easy-to-use, lightweight version of SQL Server 2005. Using Microsoft Visual Studio Express or the development tool of your choice, you can start building applications right away. Best of all, as your needs grow, your applications will seamlessly work with the rest of the SQL Server product family. Easily manage SQL Server Express with the Community Technology Preview (CTP) of SQL Server Management Studio Express, a new tool designed specifically to handle basic database administration tasks.

Free Bonus Book: SQL Server 2005 Bible
Use this comprehensive tutorial and reference (1293 pages) to increase productivity and write stored procedures using the language with which you're most familiar. The revised content covers new features such as XML integration, Web services, the .NET Common Language Runtime (CLR), and security updates, making this book a must for any developer or database administrator transitioning to the new version of SQL Server. You'll learn to develop SQL Server database and data connections, administer SQL Server, and keep databases performing at their peak. In addition, you'll find dozens of specific examples in both a graphical format and as SQL code as well as numerous best practices describing the most effective way to accomplish a given task. Seasoned database developers think inside the box, because that's where the cool code is. This comprehensive reference takes you inside the latest, coolest, and most powerful box, Microsoft's SQL Server 2005. Each of the book's seven sections focuses on key elements in a logical sequence, so you can easily find what you need—including all the basics, best practices, dozens of targeted examples, and sample code. If you develop, manage, or maintain SQL Server 2005 databases, this in-depth book is what you need to succeed! Master the fundamentals of SQL Server technology; Write better logic queries for greater success; Manage and secure a production database 24/7/365; Integrate with .NET CLR and XML; Understand SOA and emerging technologies; Meet business intelligence goals with new tools; Measure performance, lock transactions, and scale very large databases;

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. This is 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.

 
 

Multimedia Crash Course in Microsoft SQL Server 2005 on 3 full-motion screen image video and rich audio CD-ROMs $395.

Enlarge

Crash Course in
Microsoft SQL Server 2005
on 3 CD-ROMs


CD-ROM 1 - Crash Course in SQL Server 2005 Day 1( 145 min)
1. Welcome Aboard
2. Relational Database Systems & Design
3. Client-Server Architecture and DB Configuration
4. SQL: Structured Query Language
5. Systems Analysis: Entity-Relationship Modeling
6. Data Integrity in the Enterprise
7. SQL Server 2005 New Features
8. Query Editor Primer
9. Management Studio: Database Administration
10. The AdventureWorks Sample Database
11. SELECT: Writing Simple SQL Queries
12. Exploring & Managing Database Objects
13. Transact-SQL Identifiers and Comments
14. Transact-SQL Keywords and Data Types
15. Numeric, Date and String Functions
16. DDL - Data Definition Language


CD-ROM 2 - Crash Course in SQL Server 2005 Day 2 (148 min)
1. ROW_NUMBER, Ranking & Tiling Functions
2. Subqueries & Common Table Expressions(CTE)
3. GROUP BY Clause and Aggregate Functions
4. Joining Tables with Primary and Foreign Keys
5. Correlated Subqueries, PIVOT and Temporary Tables
6. Populating Tables: INSERT, UPDATE & DELETE
7. Transact-SQL IF and WHILE Statements
8. Stored Procedures and User-Defined Functions
9. Everything You Wanted to Know about Views
10. Table Indexing and Query Optimization
11. UNION, ROLLUP and CUBE
12. AFTER Triggers and INSTEAD OF Triggers
13. Transactions, Blocking and Deadlocks
14. SQLCMD, bcp, & osql Utilities
15. Database Backup and Restore
16. SSIS: SQL Server Integration Services


CD-ROM 3 - Crash Course in SQL Server 2005 Day 3 (143 min)
1. SQL Server Agent: Job Scheduling & Execution
2. TRY-CATCH for Application Error Control
3. Troubleshooting & Debugging
4. Dynamic Management Views & Functions
5. Column-Level Encryption of Sensitive Data
6. Application Performance Tuning
7. Books Online for Quick Reference
8. DB Operation Monitoring: SQL Server Profiler
9. Data Replication Across Servers
10. XML Datatype & XQuery
11. SSIS Import and Export Wizard
12. Data Warehouse, Data Mart & Data Mining
13. The AdventureWorksDW Sample Data Warehouse
14. Analysis Services: OLAP Cubes & Mining Structures
15. Business Intelligence Development Studio
16. Success Secrets to SQL Server 2005 Programming


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

 
 

The future is just a click away! Your future!

 
 
SQLUSA Latest News Bulletin. It's easy to be overwhelmed by the raft of new features in SQL Server 2005. In fact, many users are, but once they delve a bit deeper, that sense of shock turns to pleasant surprise at the functionality and performance of Microsoft's new enterprise-class database management system, said Joanne Cummings, Technology Writer, Redmond Developer News.
< tr> tr>
     
  Copyright 2003-2007, SMI Corp. All Rights Reserved.