SQL Server 2000 Training
 
  Practical Microsoft SQL Server 2000 Administration
Training on 21 Full-Motion Video & Audio CD-ROMs

 TEST DRIVE
 BUY ONLINE
 NEWSLETTER
 CONTACT US
 BUY OFFLINE
 REFERENCE
 LINKS
 SITE SEARCH


Testimonials

"We needed to upgrade our IT staff's skills in SQL 2000 really quick. Your full-motion video CD-ROM course really helped us. We successfully implemented the recommended design and coding standards. We look forward to purchase future multimedia training products from you."
Jim Van Deventer

"10K raise SQLUSA! Thank you SQLUSA! After I worked my way through the 21 cd-s in two months, I became the SQL2K star of our IT department. This training is just simply incredible! Very, very practical. I am using what I learned every day."
Alex Livingston

"I attribute my professional success and confidence to your CD-ROM tranining package alone. It has given me the required skills not only in SQL Server 2000 administration but also in overall development of my aptitudes. My friends, to whom I have recommended your SQL traning CD-s, are presently undergoing self-training and are very happy."
Kevin Whitmore

"Your multimedia SQL training set is far the best available today on the market. The difference is the expert trainer and full-motion realistic video. I am happy I purchased it. It was a good career investment for me."
Bill Cheung

"I believe you can spend thousands of dollars on training classes and not become as prepared for the MCDBA exams as you would by purchasing the SQLUSA 21 cd training set. These cd-s really focus on the practical knowledge you need to pass the tests. You should have seen how I breezed through my job interview. Like a pro with confidence. Thanks a lot for the great training."
Eva Bravo

"This is the best product I have ever bought for SQL server 2000 administration. It is even better than the live training I took. Thank you and keep up the good work."
Betty Johnson

"In the online publishing business we rely on our databases to operate on a daily basis. If our databases are down, we can not publish our magazines. Thanks to your 21 DBA training CDs our network admin staff is able to keep our sql databases in top running condition."
John Reinhold

"I just wanted to thank you guys for the practical sql training CD-s. I got a dream job as a junior DBA with an international bank. Not only do I make good money but I get recognition and respect as well."
Diane Fontana

"With the ease of use and the wealth of practical information provided in your 21 CD-ROMS, it far outdistances thick computer books even week-long live training. Within a month I became an expert SQL Server 2000 administrator. I have Oracle experience, and am really impressed how capable is Microsoft SQL server 2000. Thank you for the great training cds."
Andrew Flynn

"What a wonderful way of getting trained in Microsoft sql server 2000 administration. With your full-motion and sound cd-s I got prepared for the real world of a dba. I passed two job interviews with ease, and now I have to choose between two great offers. Even my friends are impressed. It is a real pleasure doing business with SQLUSA."
Mary Bluedorn

"I was laid off from my job as a VB developer 3 months ago, and decided to switch to a database career. Day and night for two months I played the SQL server 2000 CD-ROMS until I knew everything on them. I felt like a clone of Kalman after a while. I passed an interview with a breeze, and am now working for an engineering company as an SQL2K DBA making 45K. "
Tim Crow

"As the CIO of a major pharmaceutical firm, I am looking for practical training opportunities for our IT staff. Your Microsoft SQL Server 2000 CD-ROM instruction course was a great success with the database group. More significantly our database operations have improved as a result."
Bob Carter

"I have really found the advanced how to features of the video training course tremendous. These are the kind of things you can never get in classroom or bootcamp training and really important in real life database administration."
Mark Benner

"A beautiful self-paced, self-training course for everyone who works or who will want to work with Microsoft SQL servers."
Linda Gomez

"I would certainly recommend anyone who wishes to enter the dynamic world of database administration or get a certification to learn from SQLUSA's 21 CD-ROMS training series. You see the real SQL Server 2000 in full motion video and you hear an expert MCDBA narrate it in the backgound. You can replay any unit as many times as you wish."
Siva Advani

"Thank you sqlusa! I have learned a lot about SQL server 2000 programming and administration. This will help me at work a lot! The cd-rom course content met all of my expectations."
Kay Fitzgerald

"Clear, concise, easy-to-understand presentation on the cd-roms. The instructor is hands-on, very well-informed and knowledgeable. The units are fast paced, no chance of getting bored. The full motion screen images teach you the real-world way. "
Nick Pontikis

"SQLUSA's 21 CD-ROM training for SQL server 2000 database administration has been an invaluable asset to our training endeavors. Our students' testing and job interviewing confidence have significantly increased since we deployed the program."
Adam Saunders

"I find the 21 CD-ROM course very challenging and fun at the same time. I have learned a lot more than I learned in a 5-day training class I took last year. CD-s are real cool. I can replay them again and again. I feel my money has been well spent. I’m sure glad I found the SQLUSA site and have recommended it to many others."
Gina Malossini

"I am a college professor and I am using your multimedia training course to teach my students real world knowledge besides computer science theory. The students in my classes love this approach. After all they need practical knowledge to get jobs after college graduation."
Jim Getty

"I've learned much more from your full-motion screen video CD-s than I did in two 1-week classes I took which cost eight times as much. Your company has been very responsive and helpful in the ordering process and after sale support. That is very important to me and I am certain important to anybody wishing to master SQL2K administration. One more note, I can use the 21 CD-ROMS for reference whenever I need them."
Ashley Thompson

"I am a C++ developer with a mortgage finance company and was given DBA duties without any training. My manager approved the purchase of your excellent 21 cd training package. I feel much better about performing database administration tasks since then. The fear factor of losing data is gone. I use the cd-s as reference whenever I need guidance in some areas of database management. Kalman is a true master of SQL server 2000 and its applications."
Steve Donovan

"When I got my job as dba I was not nervous, or anxious, rather confident. Very confident. Thanks to SQLUSA's unique training cd-s which are truly realistic and the great trainer who prepared and teaches the lessons. I feel home doing my job, because the screens, the mouse movements are exactly the same as on the training videos."
Julia Cartwright

"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

 

120x240_sendcash_15k_1x_2.gif

 
SQLUSA
The World Leader in SQL Server 2000 Training

 

Best Possible Career Investment
SQL Server 2000 Administration training is now available on 21 full-motion CD-ROMs with narration. Learn SQL Server 2005 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 The World Leader in SQL Server Training.

Master Microsoft SQL Server 2000
Administration, 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 2000 Administration for the first time or adding to your professional skills set, you will find that SMI’s Practical 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 administrator in 21 days. Naturally, you can also proceed at your own pace, be it ten days or ten weeks. The comprehensive CD-ROM course is focused on practical solutions to real-world database, client and server administration 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 2000 Administration
Database administrators (DBA-s) and system administrators, who implement and manage Microsoft SQL Server 2000 RDBMS, MCDBA, MCSE and MCSA candidates. VB, Web, Java, C++ and database developers, systems analysts, and software engineers who need to know more about the administration and programming of SQL Server 2000 as well as database design. This intensive course gives an essential grounding for the Microsoft examination 70-028 Administering Microsoft SQL Server 7.0, 70-228 Administering Microsoft SQL Server 2000 in the Enterprise, 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 SQL Server 2000 Training
SQL Server 2000 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 Administration multimedia training currently available in North America, or anywhere in the world.

Objective: Excellence in Database Professions
The CD-ROM based course will allow learners to identify and configure all major aspects of a Microsoft SQL Server 2000 RDBMS. It shows and tells applying live screen image video and audio, how to install and configure an SQL Server 2000, create and manage databases and database devices both in Enterprise Manager and with scripts in Query Analyzer, backup and restore SQL Server 2000 databases, design, create and manage database objects, program in transact-SQL, import and export data, implement automated tasks and optimize the performance of SQL Server 2000. 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 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.

21 CD-ROMs Equivalent to 3 Years of Job ExperienceSQL Server 2000 Training
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 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.

SQL Server 2000 Free Trial Version
In case you do not have access to SQL Server 2000, a free 120-day evaluation version of SQL Server 2000 Enterprise Edition is included.

CD-ROM 22: Bonus
The bonus CD-ROM features survival scripts for SQL Server 2000 database administrators, designers and programmers. It also has a large collection of questions tipically given at exams and interviews. Answers are provided for all of the questions.

Free Bonus from Microsoft Press:
SQL Server 2000 Administrator's Pocket Consultant
SQL Server 2000 Training
This guide of over 400 pages is the ideal concise, immediate reference you’ll want with you at all times as you deal with the details of Microsoft SQL Server 2000 database administration. The hands-on, fast-answers guide focuses on what you need to do to get the job done quickly. With extensive easy-to-read tables, lists, and step-by-step instructions, it’s the portable, readable guide that will consistently save you time and minimize system downtime by giving you the right information when you need it most. Manage tables, indexes, and views; query and manipulate data; import and export data; and integrate SQL Server data with other data sources. Profile and monitor SQL Server, conduct data backup and recovery, and take charge of automation and maintenance.

Free Bonus from Que Publishing:
Microsoft SQL Server 2000 Programming by Example
SQL Server 2000 Training
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.

Microsoft SQL Server 2000 Grand Slam
This multimedia training suite, includes all training products, covers database design, administration, programming, data warehousing and business intelligence. It is a complete solution for MCDBA candidates, IT professionals interested in advancing their career and companies implementing Microsoft and Cognos platform based applications. Click here to order.

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

Enlarge

Practical Microsoft SQL Server 2000
Administration on 21 CD-ROMs


CD-ROM 1 - OVERVIEW (74 min)
1. Introduction and Welcome Notes
2. Visit Monster, Dice and HotJobs for Available DBA Positions
3. History of Relational Database Technology and SQL
4. MCDBA Certification by Microsoft
5. How to Pass Certification Exams
6. How to Prepare Your Resume
7. Database Administrator (DBA) Interview Tips
8. Women as SQL Server 2000 DBA-s
9. SQL Server 2000 Admin. as Elective in MCSE Certification
10. SQL Server 2000 for VB, Java, C++ and Web Developers
11. How to Get a Free Trial Copy of SQL Server 2000


CD-ROM 2 - TOOLS (62 min)
1. SQL Server 2000 Program Group
2. Service Manager
3. Enterprise Manager
4. Import and Export Data
5. Query Analyzer
6. SQL Profiler
7. Books Online
8. Client Network Utility
9. Server Network Utility
10. Analysis Manager
11. English Query
12. IIS Virtual Directory
13. Wizards
14. Command Prompt Tools


CD-ROM 3 - SECURITY (64 min)
1. Setting up Logins with Enterprise Manager
2. Setting up Logins, DB Users, Roles with Statements
3. Fixed Server Roles
4. Additional Login and Role Statements
5. DB User and Role Management by Enterprise Manager
6. Creating Security Accounts in the Enterprise
7. The Create Login Wizard


CD-ROM 4 - DATABASE BACKUP (73 min)
1. RAID Storage Description
2. Storage Offers from Major Computer Manufacturers
3. Database Backup Using the Enterprise Manager
4. Database Backup Using the Query Analyzer
5. More Details on RAID Storage
6. Advanced Backup Options Using the Query Analyzer
7. Advanced Backup Options Using Enterprise Manager
8. Creating a Database Maintenance Plan


CD-ROM 5 - DATABASE RESTORE (63 min)
1. Database Restore Using Enterprise Manager
2. Restore Statements Using Query Analyzer
3. Recovery of Databases at Startup
4. Copy Database Using Restore
5. Rebuilding the Master Database
6. Media Sets and Families
7. Initializing and Password Protecting Media
8. Overwrite or Append to Media


CD-ROM 6 - PERMISSIONING (67 min)
1. System Administrator(sa) Permissions
2. Non-sa Server Roles Permissions
3. Fixed Database Role Permissions
4. Object Ownership Within the Database
5. Managing Permissions
6. Statement Permissioning in Enterprise Manager
7. Object Ownership Chains
8. Permissioning Strategy


CD-ROM 7 - CREATE DATABASE (64 min)
1. Create Database by Enterprise Manager
2. Create Database by Statement Execution
3. Checking DB Properties by Enterprise Manager
4. Checking DB Properties by sp_helpdb
5. Create Database with Filegroups
6. Alter Database by Enterprise Manager
7. Alter Database by Query Analyzer
8. Advanced Detail on Create and Alter Database
9. Remove Database
10. Create Database Wizard


CD-ROM 8 - 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 9 - 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 10 - 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 11 - 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 12 - 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 13 - 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 14 - TRANSACT-SQL (110 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
9. TRANSACT-SQL Debugger


CD-ROM 15 - DATA TRANSFORMATION SERVICES (98 min)
1. Bcp, BULK INSERT and DTS Export Wizard
2. DTS Import Wizard
3. Using DTS Import Wizard for DB to DB Transfer
4. Designing DTS Packages
5. Transfer Databases and Copy SQL Server 2000 Objects
6. DTSRUN, Advanced Features and Meta Data
7. Automating File Imports into Database


CD-ROM 16 - SQL Server Agent (102 min)
1. Overview of Job Scheduling in Windows Environment
2. Properties of Jobs, Defining Jobs Using Enterprise Manager
3. Setting up Multi Steps Jobs with Success and Failure Options
4. Creating Jobs Using Scripts
5. Configuring Operators Using Enterprise Manager
6. Configuring Alerts Using Enterprise Manager
7. Trouble Shooting SQL Server Agent
8. Automating Night Processing


CD-ROM 17 - REPLICATION (86 min)
1. Snapshot, Transactional and Merge Replication Overview
2. Publishers, Subscribers and Distributors
3. Replication Agents and Monitors
4. Setting up a Publication Using Enterprise Manager
5. Publisher and Distributor Setup Usimg Enterprise Manager
6. Subscription and Replication Monitoring Setup
7. Setting up Distributor Publisher Using Scripts in Query Analyzer
8. Examining the Distributor Database
9. How to Use the Replication Monitor
10. Log Shipping for Failover Redundancy


CD-ROM 18 - ENTERPRISE MANAGER (82 min)
1. Enterprise Manager Top Menubar Walk Through
2. Enterprise Manager Toolbar and Server Right Click Menu
3. SQL Server 2000 Properties
4. Databases Right Click Menu
5. Database Properties Panel and DTS
6. SQL Server Agent, Current Activity and SQL Server 2000 Logs
7. Replication, Security, Support Services and Meta Data Services


CD-ROM 19 - PERFORMANCE TUNING (152 min)
1. Windows Performance Monitor
2. Setting up Trace Using SQL Profiler
3. Examining the Content of a Saved Trace
4. Examining Trace Table in Query Analyzer
5. sp_who, sp_lock and sp_monitor Commands in Query Analyzer
6. Review of the Options Available in SQL Profiler
7. Tracing an SQL Batch in SQL Profiler
8. Index Design and Maintenance Using DBCC
9. Index Defragmentation and Reindexing with Fill Factor
10. Horizontal and Vertical Partitioning
11. 24/7 Monitoring of Production Databases


CD-ROM 20 - EXTRA TOPICS (86 min)
1. XML Overview, FOR XML clause in SELECT
2. Installing SQL Server 2000
3. Command Prompt Utilities
4. Example for Application Programming in DB Library for C
5. Full-text Indexing, Full-text Search
6. English Query Interface to the pubs Database
7. Service Packs and Downloads at the Microsoft Website
8. Installing Analyis Services for Data Warehousing


CD-ROM 21 - HOW TO (114 min)
1. How To Administer Databases
2. How To Configure an ODBC Datasource
3. How To Use Windows Event Viewer
4. How To Configure Linked and Remote Servers
5. How To Administer from Command Prompt
6. How To Export Table into XML File
7. How To Import XML File into Table
8. How To Maintain DB-s in 24/7 Web Environment


Bonus CD-ROM
1. DBA Survival Scripts
2. Developer Survival Scripts
3. Administration Questions & Answers
4. Database Design Questions & Answers
5. SQL Programming Questions & Answers
6. Database Compare Script
7. Column Level Encryption & Decryption

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

 
 

SQL Server 2000 Administration

The future is just a click away! Your future!

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