Offering 6,284 videos in 230 categories! ...and 9,756 customer reviews!
Your Account |
Help |
Review this video!
Total Training for Microsoft SQL Server Development takes you inside the latest, coolest, and most powerful database software platform, Microsoft's SQL Server 2005. The tutorials focus on key elements in a logical sequence. You can easily find what you need-including all the SQL Server 2005 basics, best practices, dozens of targeted examples, and sample code. If you design or develop SQL Server 2005 databases, this video series is what you need to succeed!
Highlights
* Master the fundamentals of SQL Server technology. * Learn how to write better queries to return the exact data required. * Avoid slow iterative code by refactoring cursors into queries using user-defined functions and case expressions. * Develop stored procedures using T-SQL. * Understand how transactions affect performance, how to detect blocking transactions, and how to minimize the impact of locking and blocking. * Create triggers to build custom audit trails and enforce database rules.
System Requirements
For optimal video playback, we recommend the following:
Windows: Microsoft Windows 2000 or XP 2.0 GHz processor or higher 512 MB RAM 1024x768 screen resolution 64 MB dedicated video RAM
Macintosh: Macintosh OS X version 10.3+ 1.25 GHz PowerPC G4 or higher 512 MB RAM 1024x768 screen resolution 64 MB dedicated video RAM
NOTE: Customers who run Apple OS X Leopard may have problems with running "Total Training" instructional videos like this one. Many of these problems can be resolved with a patch supplied by Total Training at http://www.totaltraining.com/supt/updates.asp#leopard.
Disc 2 Features:
T-SQL and Stored Procedures Triggers and Audit Trails User-Defined Functions Indexing for Performance Transactions, Locking and Blocking Introduction to Optimization Theory
NOTE: Customers who run Apple OS X Leopard may have problems with running "Total Training" instructional videos like this one. Many of these problems can be resolved with a patch supplied by Total Training at http://www.totaltraining.com/supt/updates.asp#leopard.
This video was added to our catalog on February 07, 2007 in Software Training.
Product availability: available now, ships immediately!
One of the better training videos for SQL Server.
This dvd covers most of the basics of T-SQL. Not a lot of details, but it is a good start. I think it is best for someone that has had previous experience with T-Sql. Good examples and the video quality, presentation, etc is actually pretty good.
