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.
Every chapter will have some example, which will look like this.
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