DotNet Associates: April 2011

Saturday, April 30, 2011

Free Videos From TrainingSpot.com

Here are some Free Videos From TrainingSpot.com

Joining Tables using INNER Joins

Joining tables to find related data in your database is the true power of any relational database management system and SQL Server 2005. This video will show you the fundamentals of performing INNER JOINS and show you how to write them on your own.

Download This Free Video

Joining Tables using LEFT, RIGHT and FULL OUTER Joins
This video will introduce you to OUTER JOINS and show you the differences between LEFT, RIGHT and FULL OUTER JOINS. You will see several examples and will understand which type of join is right for you in any situation.

Download This Free Video

Using Aggregate Functions to Group Data

Calculating an average or determining the sum of multiple records can be achieved by using the Aggregate functions provided with SQL Server 2005. This video will show you how to use the most common aggregate functions and explain to you when they can be used.

Download This Free Video

Search Image using Image

1. Generally we use keyword for searching images. Where TinEye has given the facility to the user to search images based on another image. The image can be uploaded from your computer or you can give url of that image.

TinEye is the Reverse Image Search Engine and how it works:

The plugin adds a right-click menu item that allows you to search for an image to find out where it came from, how it is being used, if modified versions of the image exist, or to find higher resolution versions.
Download plugin for Mozilla FireFox , Crome, IE & Safari

2. Another search engine which do the same work as TinEye is Gazopa.