SQL Example, Codes and Tutorials

SQL: A brief Introduction
SQL stands for Structured Query Language. It is easy and allows us to create a database. It is an ANSI language which allows an user to write queries to access, modify and delete the customize data. SQL consist of data definition language (DDL) and data manipulation language (DML).

1. Data Normalization
   In this section we will learn about the concepts of data normalization. The most important thing in database designing is to make sure that the data get properly distributed among the tables. 
                
2. Create a database
   we can create a database by using the Database name. In SQL the key word 'Show databases' finds the existing databases. You may create your own or use an existing one after that create connection with database.
            
3. The INSERT INTO Statement
   To insert records into a table, use the key word insert into 'table name',  just write a list of column names separated by commas, followed by a closing parenthesis then using keyword values, write the list of values enclosed in parenthesis.
            
4. The UPDATE Statement
   The UPDATE statement is used to modify the data in the database table in a specified manner. In the syntax of update statement the keyword 'set' is used to assign a new value to a selected column. The statement is accomplished by a where clause.
            
5. The DELETE Statement
   The DELETE statement is used to delete rows in a table. database will update that is why deletion and insertion of data will be done.
             

6. The SELECT Statement
   SELECT key word is used to select data from a table. The tabular result is stored in a result set. SELECT column_name give the path FROM table_name.
            

7. The WHERE Clause
   WHERE clause is used with the SELECT keyword. 'Where' is a clause which is used for searching the data with a particular condition. 
   

8. The Aggregate Functions
   In this section we are going to illustrate aggregate function, with the help of which we can use many arithmetic operation like average, count, maximum and many more in SQL.