Posts

Showing posts from February, 2011

Why Pocket SQL?

Hello all, When I Google'ed for a quick reference of SQL commands, there was vast amount of data available in different websites to pick, then i wanted to try bring all of them under a single roof. So here are my efforts in the form of "Pocket SQL". I'm just writing for the interview oriented you can just get a fast review of SQL commands. So, What ever I'm posting here is truly for the interview based. Now get ready to jump in SQL ocean.

SQL and its featuers

SQL is the language used to communicate with the server to access, manipulate and control data. The main features: easy to use. SQL is a non-procedural language. reduces the amount of time required for creating and maintaining system

What is RDBMS?

RDBMS is composed of relations, managed by relational operations, and governed by data integrity constraints

what are scalar data types

The datatypes which hold a simple value like char, varchar, number etc.