Practical Microsoft SQL Server 2008 Training
on Video & Audio CD-ROMs

 TEST DRIVE
 BUY ONLINE
 BUY OFFLINE
 CONTACT US
 REFERENCE
 NEWSLETTER
 LINKS


Testimonials

 

 

 

 

 
 

SQLUSA.com
Search

 GoogleCheckout
SAVE $10!

 Free Trial Registration
Email*
How Did You Hear About Us? 
Name
Country 
State 
Zip 
  *Required
SQL Server Training: Best Career Investment
SQL Server 2008 training is now available on 21 full-motion CD-ROMs with audio narration for configuration, administration, programming, data transfer and design. Learn SQL Server 2008 the fun way! Multimedia training is far more effective than live class training. It simulates the real-world environment for excellent memory retention and success on the job as an IT professional. You can stop the video any time and practice the lesson on your SQL Server. 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, slow classroom training with inexperienced instructors. Learn the new features of SQL Server 2008 from The World Leader in SQL Server Training.

The Best SQL Server 2008 Training
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 2008 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,  video MCDBA, Senior SQL Server 2000/2008 Architect. By mastering one CD-ROM a day, you can become a Microsoft SQL Server 2008 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 2008 Training
Database administrators (DBA-s) and system administrators, who implement and manage Microsoft SQL Server 2008 RDBMS; MCITP, MCTS and MCSE candidates; VB, Web, .NET, Java, C++ and database developers; systems analysts and software engineers who need to know more about the administration and programming of SQL Server 2008 as well as logical data modelling and database design.

Prerequisites for Multimedia SQL Server 2008 Training
SQL Server 2008 learners must have a solid working knowledge of the Windows environment. Any database or programming experience is a huge plus. This is the most extensive, practical and the best Microsoft SQL Server 2008 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 2008 RDBMS. It shows and tells applying live screen image video and audio, how to install and configure an SQL Server 2008, create and manage databases and database devices both in Management Studio and with scripts in Query Editor, backup and restore SQL Server 2008 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 2008. 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 2008 and Sybase. His clients include: Citibank, Bank of Sweden, Deloitte-Touche, Swiss Bank, Lehman Brothers, Salomon Brothers, Merrill Lynch, Reuters, IBM and major consumer website companies. He holds an M.Phil. degree in Computing Science and Physics from Columbia University, where he taught computer science.

CD 22: Bonus
The bonus CD-ROM features practical business survival scripts for SQL Server 2008 database administrators, designers and developers. It has as well a collection of important ready-to-run utilities. The bonus CD also includes a complete set of accounting database table definitions for GL, AP, AR and Inventory.

CD 23: SQL Server 2008 Express
SQL Server 2008 Express Edition is the free, easy-to-use, lightweight version of SQL Server 2008. 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.

 

21 CD-ROMs Equivalent to 3 Years of Job Experience
SMI's CD-based SQL Server 2008 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 the 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 2008 Administration training on 21 full-motion screen image video and rich audio CD-ROMs $995.
Enlarge
 

CD-ROM 1 - OVERVIEW (2 hours 41 minutes)
1. Introduction and Welcome Notes
2. Your First SQL 2008 Email Report to the CEO
3. 2008 the Sequel to 2005
4. What is New in SQL Server 2008
5. History of Relational Database Technology and SQL
6. Microsoft DBA Career Opportunity
7. Women as SQL Server 2008 DBA-s
8. SQL Server 2008 for VB, Java, C++ & Web Developers
9. The Advantages of the SQL Language
10. Microsoft's Business Intelligence Strategy
11. Cutting Edge Technologies in SQL Server 2008
12. New Streamlined Installation & Configuration
13. Enhanced OLAP Analysis Scale & Performance
14. Enterprise Reporting Engine & Internet Reports
15. New Temporal and Spatial Data Types
16. Ten Guidelines for DBA & Developer Excellence


CD-ROM 2 - MANAGEMENT TOOLS (3 hours 2 minutes)
1. Editions of SQL Server 2008
2. Installing & Configuring SQL Server 2008
3. Default and Named Server Instances
4. Program Group & Books Online - BOL
5. Configuration Manager
6. Management Studio - SSMS
7. SSIS Import and Export Wizard
8. Query Editor
9. Query Designer
10. SQL Server Profiler
11. SQLCMD Command Prompt Utility & PowerShell
12. Database Engine Tuning Advisor - DTA
13. Business Intelligence Development Studio(BIDS)
14. Analysis Services - SSAS
15. Reporting Services - SSRS
16. Real-Time Event Notifications


CD-ROM 3 - ENTERPRISE SECURITY (3 hours 2 minutes)
1. Principals, Securables and Permissions
2. Metadata Visibility by Principals
3. Setting up Logins with Management Studio
4. Setting up Logins, DB Users, Roles with Statements
5. Fixed Server Roles and Permissions
6. Additional Login and Role Statements
7. DB User and Role Management by MS
8. Creating Security Accounts in the Enterprise
9. SCHEMAs and Security Hierarchy
10. Transparent Data Encryption (TDE) of Data
11. Extensible Key Management & Data Auditing
12. CREATE CERTIFICATE, Encryption and Decryption
13. 3DES Encryption of Credit Card and Bank Data
14. Asymmetric Key Encryption & Decryption
15. Text Encryption and Decryption
16. RSA 512-bit, 1024-bit & 2048-bit Encryptions


CD-ROM 4 - DATABASE BACKUP (3 hours 5 minutes)
1. Site Server Architecture and Deployment
2. RAID Disk Storage Architecture
3. Storage Offers from Major Computer Manufacturers
4. Dell SQL Server Database Advisor Tool
5. GUI Database Backup with Management Studio
6. Database Backup Using Scripts
7. Differential, Transaction Log & COPY-ONLY Backup
8. Advanced Backup Options Using Scripts
9. Advanced Backup Using MS Visual Interface
10. Creating a Database Maintenance Plan
11. The bcp Utility for Flat File Import/Export
12. Configuring Database Mail
13. Backup Success or Failure Email Notification
14. Enabling Database Backup File Compression
15. Database and Backup File Encryption
16. 7 Keys to SQL Server 2008 DBA Success


CD-ROM 5 - DATABASE RESTORE (3 hours 2 minutes)
1. Restoring Transaction Log Backups in Order
2. Restore a Database to a Point in Time after Crash
3. Disaster Recovery Planning
4. Backup Set Verify with RESTORE VERIFYONLY
5. Database Restore Using Management Studio
6. Restore Database Using Scripts
7. Recovery of Databases at Server Startup
8. Copy Database Using Backup, Copy & Restore
9. Restoring the master & msdb Databases
10. Working with Media Sets and Families
11. Initializing and Password Protecting Media
12. Overwrite or Append to Media
13. Moving 2 Terabyte DB from Phoenix to Boston
14. Restore Completion Database Mail Notification
15. Flat File Bulk Import with BULK INSERT
16. Openrowset, Opendatasource and Openquery


CD-ROM 6 - PERMISSIONING (2 hours 35 minutes)
1. Builtin and Implied Permissions
2. Understanding Permissions Hierarchy
3. CREATE SCHEMA with AUTHORIZATION
4. System Administrator(sa) Permissions
5. Non-sa Server Roles Permissions
6. Fixed Database Role Permissions
7. Object Ownership Within the Database
8. Managing Permissions
9. Object Permissioning Using Object Explorer
10. Statement Permissioning Using Object Explorer
11. Object Ownership Chains
12. ALTER SCHEMA and ALTER AUTHORIZATION
13. Developing Permissioning Strategy
14. Securing Against SQL Injection Attacks
15. Working with the New PUBLIC Server Role
16. TOP 7 SQL Server Security Vulnerabilities


CD-ROM 7 - DATABASE INFRASTRUCTURE (2 hours 42 minutes)
1. Create Database by Management Studio
2. Accounting Database Setup and Initialization
3. Create Database by Statement Execution
4. Exploring Database Properties - sp_helpdb
5. Create Database with Filegroups
6. Alter Database with Management Studio
7. Alter Database with Scripts
8. Create Database Advanced Features
9. Remove or Rename Database
10. Creating Database Snapshots for Reporting
11. Moving Databases between Different Servers
12. Very Large Databases - VLDB
13. Managing Database Policies
14. Configuring Database Audit Specifications
15. Database Console Commands - DBCC
16. Generate SQL Server Scripts Wizard


CD-ROM 8 - SAMPLE DATABASES (3 hours 5 minutes)
1. Installing SQL Server Sample Databases
2. Visio Diagram of AdventureWorks Database
3. Primary Key and Foreign Key: RDBMS Basics
4. 1NF, 2NF & 3NF Normal Forms in AdventureWorks
5. AdventureWorks Sample Database Overview
6. AdventureWorks Business Scenarios
7. AdventureWorks Data Dictionary
8. AdventureWorks2008 New Features
9. AdventureWorks2008 Differences from AW
10. HierarchyID Based Trees in AdventureWorks2008
11. Creating Database Diagrams
12. pubs Sample Database Overview
13. Northwind Sample Database Overview
14. Advanced Design Review of pubs
15. Advanced Design Review of Northwind
16. Accounting DB Review: GL, AP, AR & Inventory


CD-ROM 9 - DATABASE DESIGN (3 hours 5 minutes)
1. Logical Data Modelling
2. Data Types for Table Columns
3. New DATE, TIME, DATETIMEOFFSET & DATETIME2
4. Creating Tables by Statements
5. Advanced Create Table Examples
6. Create Special Tables and Copy Tables
7. Observing Table Behaviour
8. Creating Tables by Management Studio
9. Primary Key and Foreign Key Constraints
10. ALTER TABLE and Changing Tables by MS
11. Partitioned Table, Partition Function and Scheme
12. The Create Partition Wizard
13. Code, Translate and Lookup Table Design
14. 3NF Normalization and Reducing NULLs
15. Database Design and Programming Standards
16. Improve DW Performance with Data Compression


CD-ROM 10 - 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 for Automatic Query Generation
9. The GROUP BY Clause - Aggregate Functions
10. Recursive Queries - Tree Processing
11. ROW_NUMBER, RANK, DENSE_RANK and NTILE
12. TOP, TABLESAMPLE, INTERSECT and EXCEPT
13. Crosstab Query with CTE and PIVOT
14. Multidimensional Cross Tabulation - GROUPING SETS
15. Business Intelligence Dashboards
16. Data Warehouse Star Join Query Optimization


CD-ROM 11 - 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. MERGE: 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
15. Change Data Capture for Data Warehousing
16. Updating HierarchyID for Reparenting in Org Chart


CD-ROM 12 - DATA INTEGRITY (3 hours 3 minutes)
1. Data Integrity Constraints in AdventureWorks2008
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. Enterprise-Level Data Integrity
13. Logical Database Modelling with Visio
14. Relational Database Design with Visio
15. Database Diagram Design and Export
16. Comparing and Synchronizing Databases


CD-ROM 13 - PROGRAMMABILITY (3 hours 4 minutes)
1. Stored Procedure Architecture and Design
2. Table-Valued and OUTPUT Parameters
3. Stored Procedures in AdventureWorks2008 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 Cascading CTE-s
14. Grouping Set for Multiple Groupings Definition
15. Spatial Data Types: Geography & Geometry
16. Debugging Stored Procedures and CTE-s


CD-ROM 14 - 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 Reference
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
13. Query Plan Guides and Plan Forcing
14. User-Defined Table Type & Table Parm
15. FILESTREAM for Cost-Effective Storage
16. Configuring SPARSE Columns for Space Saving


CD-ROM 15 - SSIS IN THE ENTERPRISE (3 hours 8 minutes)
1. Overview of Integration Services
2. The SSIS Import/Export Wizard
3. Exporting Data to Flat File
4. Exporting Data to Excel
5. Exporting Data to Another Database
6. Exporting Data in XML Format
7. Importing from Flat File to Database
8. Importing from Excel to Database
9. Importing from Access 2007 to Database
10. Importing XML Data to Database
11. Importing XML Content to Database
12. Understanding Control Flow in SSIS Package
13. Configuring Data Flow Source & Destination
14. Mapping Columns from Source to Destination
15. Scheduling SSIS Package for Execution
16. Database to Database Object Transfer


CD-ROM 16 - SQL SERVER AGENT (2 hours 50 minutes)
1. Automating Administrative Tasks
2. SQL Agent Roles: Operator, Reader and User
3. Overview of Job Scheduling in Windows Environment
4. Properties of Jobs, Defining Jobs Using Management Studio
5. Setting up Multi Steps Jobs with Success and Failure Options
6. Creating Jobs Using Scripts
7. Database Mail Setup for Notifications
8. Configuring Operators Using MS
9. Configuring Alerts Using MS
10. Configuring Proxies Using MS
11. Trouble Shooting SQL Server Agent
12. Automating Night Processing
13. Database Maintenance Plan Jobs


CD-ROM 17 - REPLICATION (2 hours 40 minutes)
1. Log Shipping for Disaster Recovery
2. Live Demonstration of Log Shipping
3. Configuring Log Shipping from Primary to Standby
4. Failover to Standby DB in Case of Disaster
5. Snapshot, Transactional and Merge Replication Overview
6. Live Demonstration of Transactional Replication
7. Configuring Publishers, Subscribers and Distributors
8. Replication Agents and Monitors
9. Setting up Distributor Publisher Using Scripts
10. Examining the Distributor Database
11. Disable Publishing and Distribution
12. Peer-to-Peer Transactional Replication
13. Database Mirroring for Failover Redundancy 14. Automatic Recovery of Data Pages in Mirroring
15. Transaction Log Stream Compression


CD-ROM 18 - MANAGEMENT STUDIO (2 hours 52 minutes)
1. Dynamic UI, Docking, Auto Hiding Windows
2. Working with Query Editor
3. Navigating with Object Explorer
4. SSIS Object Explorer - Package Management
5. Policy Management: Policies, Conditions & Facets
6. Resource Governor Configuration
7. Server and Database Dashboards - Summary Page
8. Advanced Template Explorer and Design
9. Solution Explorer Projects to Store Scripts
10. Management Studio Top Menubar Walk Through
11. Toolbar and Server Right Click Menu
12. SQL Server 2008 Properties
13. Databases Right Click Menu & Properties
14. Server Registration Export and Import 15. SQL Server Agent, Activity Monitor and Logs
16. Replication, Security, and Support Services


CD-ROM 19 - PERFORMANCE TUNING (3 hours 4 minutes)
1. Ten Step Performance Tuning Bootcamp
2. Dynamic Management Views and Functions
3. Performance Data Collection into Repository
4. Deadlock Visualization and Avoidance
5. Correlating Perfmon Chart with Profiler Trace
6. 24/7 Monitoring of Production Databases
7. Windows Performance Monitor
8. Setting up Trace Using SQL Profiler
9. Analyzing Trace Table in Query Editor
10. sp_who, sp_lock and sp_monitor Commands in QE
11. Review of the Options Available in SQL Profiler
12. Index Design and Maintenance Using DBCC
13. Index Defragmentation and Reindexing with Fill Factor
14. Index-Related Dynamic Management Views & Functions
15. Database Engine Tuning Advisor
16. Horizontal and Vertical Partitioning


CD-ROM 20 - EXTRA TOPICS (3 hours 2 minutes)
1. Sending Email Messages with Results of Queries
2. Formatting Queries/Sprocs for HTML Email
3. Configuring SQL Reports for Email Distribution
4. SQL Server Configuration Manager
5. SQL Server 2008 Surface Area Configuration
6. Command Prompt Utilities
7. XML Overview, FOR XML Clause & OPENXML
8. Xquery - XML Query Language
9. Advanced Xquery Examples
10. Primary and Secondary XML Indexes
11. Example for Application Programming using CLR
12. Creating Indexed Views
13. Full-text Indexing, Full-text Search
14. Enabling Parallelism for Partitioned Tables
15. Upgrading and Migrating to SQL Server 2008
16. Service Packs and Downloads at Microsoft.com


CD-ROM 21 - HOW TO (3 hours 3 minutes)
1. How To Resolve Performance Bottlenecks
2. How To Use XML Bulk Load for Large Datasets
3. How To Create an Index with Included Columns
4. How To Filter Invalid Data with TRY-CATCH
5. How To Setup Event Notification for Logins
6. How To Debug Sprocs with Visual Studio 2008
7. How To Use the SQLCMD Utility
8. How To Connect as Dedicated Administrator
9. How To Maintain DB-s in 24/7 Web Environment
10. How To Monitor CPU Busy, Disk Reads and Writes
11. How To Configure an ODBC Datasource
12. How To Use Windows Event Viewer
13. How To Configure Linked and Remote Servers
14. How To Administer from Command Prompt
15. How To Use the PowerShell Scripting Shell
16. How To Import/Export XML Data


Bonus CD
1. DBA Survival Scripts
2. Developer Survival Scripts
3. Database Designer Survival Scripts
4. Sample Scripts Used in Videos
5. Ten Step Performance Tuning Bootcamp Scripts
6. Table Space Usage Stored Procedure
7. Database Compare Script
8. Directory Tree with CTE Script
9. Calendar Generator Function
10. Export Table Data as INSERTS Sproc
11. SQL Server 2008 Audit Script
12. Accounting Table Definitions Script
13. Complex CTE-s Scripts
14. Application User Password Encryption Sprocs
15. Email Encryption Sprocs



 

Availability:
Products usually ship on the next 1 or 2 business days.
Shipping worldwide with UPS Air.

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