SQL Basics Primer Part 2

July 31st, 2006 — Vyoma

This is the second part of the series of SQL Basics Primer. As mentioned in the earlier post, we would now examine the data retrieval SQL requests from a table.

For sake of illustrations I would be using the following imaginary EMP_DATA table:

empid empname dept
3001 Tom Management
3002 Scott Management
4002 Daniel Security
6004 Laurel Programming
3003 Linda Management
4001 Jack Security
6001 Frank Programming
6002 Joe Programming
5001 Harrold Design
6003 Jim Programming

Read the rest of this entry »

Posted in Computer. No Comments »

SQL Basics Primer

July 27th, 2006 — Vyoma

Quite a few people (who are not from the industry I am in) have approached me with the intention of knowing a bit more about SQL. Hence I thought I should put up a basic primer on SQL here as a multi-part (or multi-post) primer.

SQL is Structure Query Language. It is a way of communicating with the DataBase Management System (DBMS). A DBMS has the stored data in a particular format, and has tools that retrieves and manipulates this data. The SQL communicates to the DBMS on what task requires to be done by it.

Read the rest of this entry »

Posted in Computer. No Comments »

Indian Government ‘Ban’ Blogger Hosted Blogs

July 20th, 2006 — Vyoma

Up until now, I had refrained from posting any of my political view, but I think I just have to do it this once.

In view of the recent Mumbai blasts, the Government of India has directed all ISP to ‘ban’ Blogger hosted sites and Geocities hosted sites.

The first time I got to know of this news, I felt this was outrageous, and any last bit of feeling of belonging I had for this piece of land seemed to diminish into oblivion.

Read the rest of this entry »

Posted in Blog, Internet. No Comments »

SEO, Spiders and Sitemaps

July 6th, 2006 — Vyoma

It has been a couple of week, and I have been working on my website, WiseTome.com. During this time, I learnt quite a bit on SEO - or Search Engine Optimization. I also learned about Spiders, not the ones that crawls the wall, but one that crawls the World Wide Web, and few things about SiteMaps.

SEO is a set of methods that has a purpose of improving the ranks of the websites and its pages in search engine listings. Spiders or Web Spiders or Web Crawlers is a program or an automated script that browses all the pages on the World Wide Web in an automatic manner and takes note of the content of these sites. SiteMaps are documents or pages that aid the spiders in crawling all the pages in a website.

Read the rest of this entry »

Posted in Internet. No Comments »