Training Home | Web Design | Microsoft SQL Server 2005 Development

Microsoft SQL Server 2005 Tutorial Video

Learn how to take your skills to the next level. This Microsoft SQL Server 2005 training DVD is the ultimate in comprehensive learning for the discerning professional.

The training uses broadcast quality audio and video to deliver concise and informative training right to your desktop. The Tutorial comes complete with practical working files and presented via an intuitive, easy-to-use interface, This Microsoft SQL Server 2005 tutorial video makes learning simple, quick and enjoyable. All training courses are authored by professional instructors who have a passion for teaching.

Self Paced, Affordable Training Videos - Tutorials Taught by Professionals

Reduce learning time by 80%. Learn from a professional trainer from your own desk.
Suitable for beginners to advanced users. ideal for users who learn faster when shown.
Visual training method, offering users increased retention and accelerated learning.
Breaks even the most complex applications down into simplistic steps.

For evaluation purposes the links below offer an insight into the quality of these Microsoft SQL Server 2005 tutorials. In order for the free demo videos to play QuickTime needs to be installed.

Free Demo Tutorial 1
Quicktime »
Windows Media Player »

Free Demo Tutorial 2
Quicktime »
Windows Media Player »

This Weeks Limited Offer

25% off AutoCAD 2010 Videos

OVER 9 hours of Video Training - ONLY $74.95

We are pleased to announce that we have just released our Amazing AutoCAD training videos. This highly intuitive and engaging training course is only $74.95, which is amazing value. To try a free demo just follow the link below. To try for FREE Click Here »

Customer Testimonials

Just a note to say that the enthusiasm and quality of instruction by Chad Perkins is incredible. He is an amazing instructor who really understands After Effects and teaches it so effortlessly.
mike d.

SQL SERVER OVERVIEW

Understanding Client Server Architecture
Introducing the Tools
Selecting an Edition
Creating Sample Databases

USING MANAGEMENT STUDIO

Arranging the Workspace
Registering Servers
Explaining Items in the Object Explorer
Explaining the Database Properties Dialog
Explaining the Columns Properties Dialog
Continuing with Object Explorer Items
Using the Query Editor

DESIGNING RELATIONAL DATABASES

Understanding Normalization
Discovering Patterns
Avoiding Over Complexity
Managing Optional Data
Creating Physical Keys
Using the Database Diagrammer Tool
Final Comments

WORKING WITH SINGLE TABLE QUERIES

Understanding Query Flow
Filtering Data with the Where Clause
Columns, Expressions & Scalar Functions
Using Case Expressions
Working with Nulls & Coalesce
Selecting Environment Functions
Working with Dates & Times
Parsing Strings
Converting Data
Sorting Data
Topping Off the Query with Predicates

MERGING DATA WITH JOINS & UNIONS

Working with Inner Joins
Using Left Outer Joins
Multiplying Data with Cross Joins
Referencing Self-Joins
Working with Complex Joins
Finding the Set Difference
Stacking Data with Unions

WORKING WITH SUBQUERIES

Using Subqueries as Expressions
Including Subqueries as Lists
Adding Subqueries as Derived Tables
Working with Correlated Subqueries
Solving for X with Relations Division

AGGREGATING DATA

Using the New Windowing Functions
Using Aggregate Functions
Grouping a Data Set
Nesting Aggregations
Filtering Groups & Adding Grand Totals
Generating Cross Tab Tables
Calculating Cumulative Sums

USING FULL-TEXT SEARCH

Creating a Full-Text Index
Searching for Words
Using a Fuzzy Search to Search for Phrases

SELECTING DATA THROUGH VIEWS

Creating Views
Preventing Disappearing Rows
Protecting from Schema Changes
Nesting Views

DISTRIBUTED QUERIES

Linking to External Data Sources
Executing Distributed Queries
Looking at Where the Work Takes Place
Using Pass Through Queries
Controlling Distributed Transactions

MODIFYING DATA

Inserting Data
Updating Data
Deleting Data
Using the Output Clause
Final Comments & Credits

T-SQL & STORED PROCEDURES

Introducing T-SQL
Working with Variables
Controlling Procedural Flow
Examining SQL Server with Code
Using Temp Tables
Developing Dynamic SQL
Introducing Stored Procedures
Passing Parameters
Returning Parameters
Working with a Cursor
Handling Errors
Explaining the Raise Error
Controlling Transactions

TRIGGERS & AUDIT TRAILS

Introducing After Triggers
Using "Instead of" Trigger
Disabling Triggers
Using the Update Function
Selecting Transaction Data
Nesting & Recursion
Enforcing Complex RI
Auditing Data Changes

USER-DEFINED FUNCTIONS

Creating Scalar Functions
Working with Inline Table-Valued Functions
Using Multi-Statement Table-Valued UDFs
Navigating a Hierarchy
Having Fun with Apply
Exploring Functions in Nordic

INDEXING FOR PERFORMANCE

Introducing Indexes
Creating Indexes
Examinging Query Execution Plans, Pt. 1
Examinging Query Execution Plans, Pt. 2

TRANSACTIONS, LOCKING & BLOCKING

Introducing ACID
Understanding Transactional Faults
Stepping through a Transaction
Exploring Locks
Working with Locks
Viewing Deadlocks
Using Snapshot Isolation

INTRODUCTION TO OPTIMIZATION THEORY

Deconstructing the Database System
Walking through Optimization Theory
Optimization Theory Continued
Final Comments & Credits

Microsoft SQL Server 2005 Tutorial Info

Title Information.

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!. Close »

Instructor : Paul Nielsen

All Training Courses by this author

Publisher:

Total Training

Duration:

8 hours - 107 lessons

Platform:

PC or Mac

Fomat :

DVD Video

Price:

$99.99
Sale Price: $69.99

£48.43

€56.62

Select your delivery option

ONLY 5 LEFT!

Microsoft SQL Server 2005 Related Training Videos :

Microsoft Visual Studio 2005 Productivity with .NET Framework 2.0 | Microsoft ASP.NET 2.0 Building Web Applications (set 1) | Microsoft ASP.NET 2.0 Building Web Applications (set 2) | Microsoft ASP.NET AJAX - Online | ASP.NET Beginners Training | Microsoft Windows 7 Training

Join our Newsletter and Save

By joining our newsletter you will be notified of special offers and limited promotions. We don't sell, rent or otherwise disclose your details to any 3rd party. Sign up today and take advantage.

Just Released Training Titles

Adobe Photoshop CS5 Training
Microsoft Office 2010
Learning Microsoft Project 2010
Learning Microsoft Excel 2010
Carrara 8 Training

Learn Online - Instant Access - Low Price

Giving you amazing freedom to learn at your own pace these online training videos combine high quality professionally created content, broadcast standard high definition video and crystal clear audio, at an extremely cost effective price. The tutorials are presented via an easy to use interface.

You can now access an entire library of professionally created tutorials in High Definition video for the same price as our competitors charge from one DVD.

Users are bound by no constants on the amount of titles that can be viewed, access can be from any location and where available, working files are included at no extra charge.

Customer Comments

These classes deliver at a depth even well-written books cannot convey; and the ability to review your work is very valuable. Also, topics like PERL and Ruby are pleasant and unexpected additions (I have a math/physics background). I am now a subscriber, and will probably remain so.
paul s.