SQL JOINS

Nowadays SQL Joins are most commonly used SQL query to fetch data from different data tables. But most of us facing a problem in writing SQL joint queries. I found an interesting article on SQL Joins while Google-ing. This article author explains different SQL JOINS with the help of visual representation which is more easier than any theoretical explanation. Here i embedded that image. To read more about the article visit Visual Representation of SQL Joins

Android OS Naming in Different Releases

I dont know how many of you aware of android os naming convention. Common practice in all software industry is that they will provide different name for different releases of their product. Usually they will give different name for main releases (There is a major functionality changes on previous release) and not for patches. Likewise Android OS also named in different releases. Special here is Google using alphabetical order to name their android OS.

Here I listed table for android versions with its release name and release date.

Version	Release Name	Release date
Pre(1.0)*	Astro	Sep 28,2008
Pre(1.1)*	Bender	Feb 09,2009
1.5.x	Cupcake	Apr 30,2009
1.6.x	Donut	Sep 15,2009
2.0.x	Eclair	Oct 26,2009
2.2.x	Froyo	May 20,2010
2.3.x	Gingerbread	Dec 06,2010
3.x.x	Honeycomb	Feb 22,2011
4.0.x	Ice Cream Sandwich	Oct 19,2011
4.1.x	Jelly Bean	Jun 27, 2012

* The pre-release versions of Android were dubbed Astro and Bender, but these names could not ultimately be used for trademark reasons. But officially trademarked this as Android.

Easiest Way To Set Up Linux On Top Of Existing OS

Virtual Platform

VMplayer is software developed by vm-ware, provides virtual environment on top of any existing operating system. Virtual environment in the sense, the same physical hardware is shared to the operating system installed inside the VMPlayer (guest) with hiding existing operating system (host). So if anything happens inside the VMplayer will not affect main operating system where you installed VMplayer. This software is absolutely free of cost from vm-ware but you have to register an account at vm-ware to download the software.

VMplayer supports many guest operating systems on a single host operating system and keeps each guest OS files in a single file with extension vmdk on host machine. These vmdk files can be transferrable to any machine and can be reusable without having any configuration.

  

Trend sigma website offers free vmdk files for various linux operating systems. User can download any linux vmdk file from their site to use OS. This avoids manual installation effort for individuals.

Note: Virtualbox is open source software works similar to vmware.

Follow the Steps to Setup Linux

1. Download VMPlayer from Vmware website.
2. Install VM player on top of your existing windows OS.
3. Download vmdk zip files for any Linux.
4. Extract zip file and keep extracted file in permanent place.
5. Open VMPlayer -> Click Open Virtual machine -> Browse extracted vmx file -> Click next to finish.
6. Now virtual Linux is ready. Right Click on machine name from VMPlayer and click Play to start your new Linux.
7. Provide login credential user/password and enjoy!!!

Useful Links

• VMplayer official website: VM-ware
• Free Linux vmdk file: TrendSigma

Samsung Galaxy S3 Hands On Review

Samsung Galaxy S3 official released in market on May 3, 2012. This is most awaited smartphone with android 4.0 from Samsung. I found interesting Hands on review of this smart phone on internet. So i embedded here to spread the video for Samsung lovers. :)


Galaxy S3 Specification

Network	2.5G (GSM/ GPRS/ EDGE): 850 / 900 / 1800 / 1900 MHz
	3G (HSPA＋ 21Mbps): 850 / 900 / 1900 / 2100 MHz
	4G (Dependent on market)
Display	4.8 inch HD Super AMOLED (1280×720) display
OS	Android 4.0 (Ice Cream Sandwich)
Camera	Main(Rear): 8 Mega pixel Auto Focus camera with Flash & Zero Shutter Lag, BSI
	Sub (Front): 1.9 Mega pixel camera, HD recording @30fps with Zero Shutter Lag, BSI
Video	Codec: MPEG4, H.264, H.263, DivX, DivX3.11, VC-1, VP8, WMV7/8, Sorenson Spark
	Recording & Playback: Full HD (1080p)
Audio	Codec: MP3, AMR-NB/WB, AAC/AAC＋/eAAC＋, WMA, OGG, FLAC, AC-3, apt-X
Additional Featues	S Beam, Buddy photo share, Share shot
	AllShare Play, AllShare Cast
	Smart stay, Social tag, Group tag, Face zoom, Face slide show
	Direct call, Smart alert, Tap to top, Camera quick access
	Pop up play
	S Voice
	Burst shot & Best photo, Recording snapshot, HDR
Google™ Mobile Services	Google Search, Google Maps, Gmail, Google Latitude
	Google Play Store, Google Play Books, Google Play Movies
	Google Plus, YouTube, Google Talk,
	Google Places, Google Navigation, Google Downloads
Connectivity	WiFi a/b/g/n, WiFi HT40
	GPS/GLONASS
	NFC
	Bluetooth® 4.0(LE)
Sensor	Accelerometer, RGB light, Digital compass, Proximity, Gyro, Barometer
Memory	16/ 32GB User memory (64GB available soon) ＋ microSD slot (up to 64GB)
Dimension	136.6 x 70.6 x 8.6 mm, 133g
Battery	2,100 mAh

BeeTabz Tablets: Most Awaiting Tablet in India

Hurreeee…….!!!!!!! Good news for all tablet lovers in India. Most expected configuration in a single tablet is available now. It's like a dream tablet for everybody at cheaper rate in India with 100% quality assured. This dream has come true from India based company BeeLabz. Thanks to BeeLabz.

BeeLabz is a Evolving Leader in Tablet PC manufacturing and distribution, With its primary manufacturing units in China and Malaysia, Its one of the fastest growing technology company in South Asia. Every Company has a dream but we have only one smile and happiness in Customer's Face.

Beelabz marketing 6 different tablets in India in the name of BeeTabz with different price range from 3900 to 13500. Most common in all tabs is inbuilt SIM card support. BeeLabz providing special discounts on all tablets and this offer ends within May. Hurry up, don’t lose this special discounts.

Below here I listed out all tablet configurations with increasing price order. I liked much BeeTabz Prashi offering it for Rs.8650 from snapdeal. So I placed order before writing this article. Once I get this tab definitely I will give detailed review on this tab.

Tablet Name	BeeTabz Ashni	BeeTabz Ashni+	BeeTabz GeekT
Price	3999	6500	7500
Processor	IMAP x210	VIA 8650	MediaTek MTK6513
Processor Speed	1 Ghz	800 Mhz	650 Mhz
RAM	256 MB	256MB RAM	512MB RAM
Hard Disk	2GB	4GB	512MB
External Storage	Upto 32GB	Upto 32GB	Upto 16GB
External Memory Type	MicroSD	MicroSD	MicroSD
Operating System	Android 2.3	Android 2.3	Android 2.3
WiFi	Yes	Yes	Yes
2G	No	Phone Call/SMS/MMS	Phone Call/SMS/MMS/EDGE
3G	No	Yes + External	No
Mini-USB Port	1	1	1
Bluetooth	No	No	Yes
GPS	No	No	Yes
HDMI Output	Yes	No	No
Screen Size	7 Inch	7 Inch	7 Inch
Screen Type	Resistive	Resistive	Capacitive
Screen Resolution	800 * 480	800 * 480	800 * 480
Internal Speaker	Yes	Yes	Yes
Internal Microphone	Yes	Yes	Yes
Front Camera	0.3 MP	1.2 MP	0.3 MP
Back Camera	No	No	2.0 MP
Battery	3200 mAh	3200 mAh	3200 mAh
Battery Type	Li-Polymer	Li-Polymer	Li-Polymer
Warranty	1 Year	1 Year	1 Year
Accessories	Charger, USB Cable	Charger, USB Cable	Charger, USB Cable.

Tablet Name	BeeTabz Geekt+	BeeTabz Prashi	BeeTabz Prashi+
Price	9500	11500	13500
Processor	MediaTek MTK6513	Telechip 8803	Telechip 8803
Processor Speed	650 Mhz	1.2 Ghz	1.2 Ghz
RAM	512MB RAM	512MB	512MB
Hard Disk	4GB	4GB	4GB
External Storage	Upto 16GB	Upto 32GB	Upto 32GB
External Memory Type	MicroSD	MicroSD	MicroSD
Operating System	Android 2.3	Android 2.3 / 4.0	Android 2.3 / 4.0
WiFi	Yes	Yes	Yes
2G	Phone Call/SMS/MMS/EDGE	Phone Call/SMS/MMS	Phone Call/SMS/MMS
3G	Yes + Internal	Yes + Internal	Yes + Internal
Mini-USB Port	1	1	1
Bluetooth	Yes	Yes	Yes
GPS	Yes	Yes	Yes
HDMI Output	No	Yes	Yes
Screen Size	7 Inch	8 Inch	10 Inch
Screen Type	Capacitive	Capacitive	Capacitive
Screen Resolution	800 * 480	800 * 600	1024 * 600
Internal Speaker	Yes	Yes	Yes
Internal Microphone	Yes	Yes	Yes
Front Camera	0.3 MP	1.2 MP	1.2 MP
Back Camera	2.0 MP	2 MP	2 MP
Battery	3200 mAh	4800 mAh	4800 mAh
Battery Type	Li-Polymer	Li-Polymer	Li-Polymer
Warranty	1 Year	1 Year	1 Year
Accessories	Charger, USB Cable	Charger, USB Cable, Leather Case	Charger, USB Cable, Leather Case

Official Site: http://www.beelabz.in

SnapDeal Link: http://www.snapdeal.com/deal-bangalore_banashankari-Beelabz

P.N.: Beelabz are not prompt in dispatching order from day one. They are providing some nonsense reasons for delay. So i canceled my order and i have taken my full money back (my payment for 2 tabs). After they initiated refund, EBS portal took around 7 working days to complete refund process.
Advice here is to not to place any new order on beelabz untill they dispatch any existing customer orders and for existing customer, they can wait for some more time or they can go for refund option with their own interest. If they are not reaching, then you can raise ticket at snapdeal and EBS portal websites to awake them.