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.
Here it showing how it works:


Here are some similar web sites:
Piximilar | Google Image Search | Altavista

HOME

Unforgettable Moments of ICC Cricket World Cup 2011

The champions celebrate with the World Cup trophy

Indian cricket fans celebrate their team's World Cup win on the streets of Kolkata

Anil Kumble, who was part of four unsuccessful World Cup campaigns, is given a chance to hold the trophy

Beauty of Web

IE9 has really impressed a lot of users. This version of IE has lot of features compared to the previous versions. The use of CSS3, JQuery, and HTML5 in IE9 runs everything smoothly. I visited a site Beauty of Web where it has listed some amazing sites that are really beautiful. I am wondering what else is remaining to do in the thin client. Rich graphics and so responsive performance of IE9 is really great. To browse these sites you need IE9 or any other browsers that support HTML5 and CSS3. Some sites will take time to download its content (It depends upon your internet speed) so be patient. 

1. Endlessmural
Welcome to the Endless Mural. An interactive, collaborative art website built in HTML5. View


2. National Museum of China
The National Museum of China has created an outstanding VR experience to display our finest art work while keeping load time to a minimum. HTML5 in Internet Explorer 9 is perfect for this: easy to develop with great flexibility, and thanks to the Internet Explorer 9’s all-around speed, even the 3D Javascript scenario runs flawlessly... Explore

Internet Explorer 9

Here are some great features of IE9 which make it different from other browsers:
Pin sites to the taskbar

You can access websites that you visit regularly by pinning them to the taskbar on your Windows 7 desktop.

Search in the Address bar

You can now search directly from the Address bar. If you enter a website's address, you'll go directly to the website. If you enter a search term or incomplete address, you'll launch a search using the currently selected search engine. Click the address bar to select your search engine from the listed icons or to add new ones.