SQL Home

  • SQL (Structured Query Language) is a standard programming language to maintain data in a database.
  • Although SQL is both an ANSI and an ISO standard.
  • It is pronounced as SEQUEL.

How to learn

We will learn it in more detail and will try to make it easy, accurate and more explanatory in all aspects.
For all our examples we will use modified version of Northwind database.

Examples

Every chapter will have some example, which will look like this.

Try This

SELECT * FROM Customers
CHECK IT
On clicking the button "CHECK IT" you will be able to run the command and see the result, for now just try it.

Before we start

  • Sql is case in-sensitive so Where/WHERE/where all are same
  • Some databases use semicolon to indicate the end of command, say SELECT * FROM Cusomers;
  • Single line Comment can be put by using double dash --, after -- in that line will be treated as comment
  • Multiple line comment can be put by using /* one or more line of comment */
Rest we will learn in our chapters