Tuesday, March 16, 2010

SQL Server Video Tutorial - Bonus Exercise: Two Table OUTER Joins

SQL Server video!

SQL Server Screencast: Bonus Exercise: Two Table OUTER Joins

This training video is brought to you by the folks at LearnItFirst, one of the web's largest training videos companies.

Bonus Exercise: Two Table OUTER Joins

Description of this video:

Note: This video is from LearnItFirst.com's Writing Queries for SQL Server (2005/2008 Edition) training course.

This short two step exercise video will give you another opportunity to work with two table OUTER JOINs.

Highlights from this video:

  • Two table OUTER JOINs
and much more

SQL Server 2005/2008 Queries video tutorial

Other Links You Might Be Interested In:

Monday, March 15, 2010

SQL Server Video - Functions for Working with Dates: DATEPART, DA TENAME, YEAR, MONTH and more

SQL Server Screencast: Functions for Working with Dates: DATEPART, DATENAME, YEAR, MONTH and more

This SQL Server 2005/2008 Queries tutorial comes from the LearnItFirst IT Training Video Library.

Functions for Working with Dates: DATEPART, DATENAME, YEAR, MONTH and more (Screencast)

More info about this video:

Starting with this video there will be several videos on working with dates.  In this video Scott will introduce several functions that are available to you to retrieve certain parts of the date.

Highlights from this video:

  • DATEPART
  • DATENAME
  • YEAR
    • extracts just the year
  • MONTH
    • extracts just the month
  • Using each function
and much more

SQL Server 2008/2005 Query Writing training video

This video is part of LearnItFirst's Writing Queries for SQL Server (2005/2008 Edition) training course.

SQL Server training videos

ISA Server Tutorial Video - ISA Server Disaster Recovery: How to Restore Your ISA Server Settings From a Backup

ISA 2006 Admin Tutorial Video: ISA Server Disaster Recovery: How to Restore Your ISA Server Settings From a Backup

The worst-case scenario has happened: your ISA Server settings are gone and/or your ISA Server is down (and your users are mad as you-know-what because they can no longer access the internet). How do you restore ISA Server? Can you get the internet working again?

Highlights from this video:

  • The concepts of the ISA restore
  • How to restore ISA Server from backup
  • Import vs. Overwrite: understanding the ISA Server restore options
  • Do you want to import server-specific information?
  • How to restore a remote ISA Server's backup to a new ISA Server
  • Do you want to import user permission settings?
and much more

ISA 2006 Admin training

This video is part of LearnItFirst's ISA Server 2006 Administration training course.

Related Links:

ISA Server training videos

Sunday, March 14, 2010

Visual Basic Video Tutorial - Pt. 1 - What Is Test driven Develop ment (TDD)? What are Unit Tests? How Can I Use Them?

Visual Basic video!

Visual Basic .NET Video Tutorial: Pt. 1 - What Is Test driven Development (TDD)? What are Unit Tests? How Can I Use Them?

This training video is brought to you by the folks at LearnItFirst, one of the web's largest training videos companies.

Pt. 1 - What Is Test driven Development (TDD)? What are Unit Tests? How Can I Use Them?

Description of this video:

Note: This video is from LearnItFirst.com's Visual Basic Programming with Visual Studio 2005 training course.

So many 'modern day' programmers do things completely backwards - they write the application code first and then, when things inevitably fail, they find themselves refactoring, rethinking, and just plain frustrated. Why, oh why, haven't more programmers learned the beauty of unit testing and test driven development (TDD)? If more programmers modernized their approaches to thinking about programming, they would find that they would save huge blocks of time and, in the process of saving time, write more efficient code.

Highlights from this video:

  • What is Test Driven Development (TDD)?
  • What are some of the core principles of TDD?
  • What are units? What are tests?
  • Why should I consider unit tests?
and much more

Visual Basic .NET video tutorial

Other Links You Might Be Interested In:

SQL Server Video Tutorial - Quick Demo: How to Create a SQL Server Login

SQL Server   training video

SQL Server Tutorial: Quick Demo: How to Create a SQL Server Login

A SQL Server training video from the LearnItFirst the web's largest IT Training Video Library

Quick Demo: How to Create a SQL Server Login

In this short video we will take a look at a demonstration of how to create a SQL Server login and what it looks like in the SQL Server Management Studio.

Highlights from this video:

  • How to create a new login
    • Logging in with your newly created login
  • Diagram of logins
  • Using code to change databases
and much more

SQL Server 2008 DBA video tutorial

N.B.: This training video comes from LearnItFirst's SQL Server 2008 Database Administration video course.

Saturday, March 13, 2010

SQL Server Video - ISNULL and COALESCE: The Two Trickiest Functio ns You Will Ever Meet, Part 2

SQL Server Training: ISNULL and COALESCE: The Two Trickiest Functions You Will Ever Meet, Part 2

This SQL Server 2005/2008 Queries tutorial comes from the LearnItFirst IT Training Video Library.

ISNULL and COALESCE: The Two Trickiest Functions You Will Ever Meet, Part 2 (Video)

More info about this video:

This video will continue where the previous video left off, and will continue to cover the functions ISNULL and COALESCE.  In this video Scott will continue to show the differences between ISNULL and COALESCE; it is vital that you understand the differences between these two functions. 

Highlights from this video:

  • ISNULL v COALESCE
    • why is it so important to know the differences?
  • NULLs
    • NOT IN and NULLs
  • Expanding queries
and much more

SQL Server 2008/2005 Query Writing training video

This video is part of LearnItFirst's Writing Queries for SQL Server (2005/2008 Edition) training course.

SQL Server training videos

SQL Server Video - Pt 3 - How to Delete Duplicate Rows in a SQL S erver Table Using the Rank() Function

MSSQL Programming and Query Writing Screencast: Pt 3 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

This SQL Server Programming and Queries tutorial comes from the LearnItFirst IT Training Video Library.

Pt 3 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function (Screencast)

More info about this video:

This final video on how to delete duplicate rows in a SQL server table via use of the RANK ( ) function will show you an alternative placement of the ranking function.

Highlights:

  • Where can I put the RANK function and where will it accurately work?
  • Reason for JOIN of actual table to duplicates

MSSQL Programming and Query Writing training video

This video is part of LearnItFirst's SQL Server Programming (SQL Server 2005/2000): Transact SQL training course.

SQL Server training videos