Learning SQL

24/9/2013

0 Comments

 
If you are trying to learn SQL(pronounced sequel), it would be best to learn it the hard way .Its a nice tutorial to learn sql. They emphasize basically on SQLite3 which is recommended for starters as it is pretty lightweight and implements most of the SQL.

You can also join this Course. Its a really great course from Stanford@Coursera, teaches you not only SQL but also introduces you to XML and JSON.

If you are a Windows user, I found this excellent application to try out SQL queries in a nice GUI way. Database Master is a pretty standalone app. You can connect to most of the SQL databases out there.
It provides the output in awesome looking excel format. You will forget command line once you use this.
I regret not knowing it earlier, but you know its never too late :)
Picture
database master on my system
0 Comments

Screenshot it

15/9/2013

0 Comments

 
PictureMy Homescreen
If you have an android 4.0+(ICS or above), screenshots are built right into your phone. Just press Volume Down and Power key simultaneously and hold for a second. The image would be automatically saved in your gallery. 

If you use 2.3 or lower, screenshot is not builtin. You may have to root you phone and install other apps available on play store.
0 Comments

Friend's Birthday Reminder

15/9/2013

0 Comments

 
Picturesync list
Its a little embarrassing if you meet your friend on his birthday and don't wish him and then later see it on facebook and wish him online. 

  So here is a  nice little hack to export  birthday of facebook friends into google calendar or any other calendar. 
  1. Select Events from left side of your homepage.
  2. click on little settings icon next to Today button.
  3. Click Export and export your friends birthdays.

I use google calendar as my default calendar app in google chrome, so it took over from there and now would automatically sync any changes in that calendar. Then it syncs to my android phone.
Pretty neat huh!
0 Comments