Interactive SQL

For Insert SQL For Update SQL For Select SQL For Delete SQL Learn Programmer
Level SQL

SQL Fundas

SQL Select SQL Insert SQL Update SQL Delete SQL Distinct SQL Where SQL And & Or SQL Order By SQL Data Types SQL Cross Join SQL Inner Join SQL Left Join SQL Right Join SQL Full Join SQL Self Join SQL Union SQL Top SQL Like SQL Wildcards SQL In SQL Between SQL Alias SQL Select Into SQL Create Table SQL Drop SQL Alter SQL Constraints SQL Not Null SQL Unique SQL Primary Key SQL Foreign Key SQL Check SQL Default SQL Create Index SQL Identity SQL Views SQL Dates SQL Nulls SQL IsNull() SQL NullIf() SQL Create DB

SQL Functions

SQL Functions SQL Count() SQL Sum() SQL Min() SQL Max() SQL Len() SQL Round() SQL Upper() SQL Lower() SQL Avg() SQL Group By SQL Having SQL PatIndex() SQL Substring() SQL Sqrt() SQL Rand() SQL Concat()

Next Chapter » Insert SQL

How to Learn Programmer Level SQL

Step 1 SQL Beginners Read everything listed here	Step 2 Interactive SQL Basic Learn Basics in Interactive way	Step 3 Interactive SQL Medium Learn SQL that you will use often
Step 4 Interactive SQL Advanced You are a programmer, if you learn this	Step 5 Interactive SQL Manipulate data. Learn SQL Insert/ Update/ Select/ Delete .	Step 6 Your Feedback Mail your doubts and Feedback.

We roll out our Flag ship tutorial - Interactive SQL. In Interactive SQL, the query gets executed on the webpage itself and displays the result. Any user can modify any of the Interactive SQL queries and view the output in all the variations. Expect to see our tutorials on technologies such as HTML, CSS, Javascript, ASP.net, PHP etc shortly.

Usually any web or desktop application needs SQL to perform operations like save / update / delete and to retrieve data from the database. The SQL commands are common across all database applications. You can use the same syntax in almost all databases like SQL Server, Oracle or MySQL, except for minor variations. Here we are targeting TSQL of Microsoft SQL Server.

In our tutorial you will learn how to perform database operations that will be used by the user inetrface. You can design your user interface in any technology such as ASP.net, ASP, PHP etc. All these user interfaces use HTML and server side code using SQL to perform database operations.

We aim to be different and provide industry standard help that will make you visit our website often. This website can be used in your professional career as a quick reference.

Next Chapter » Insert SQL