SQL Tutorial

Technical Definition:

SQL ----------- Structured Query Language

SQL is a language that is used to access and manipulate database.

Simple Definition:

SQL is a language used to create and talk to the database.

Explanation:

When we create a database it is useless if we can’t do anything with it; electronic database is made for the purpose of making life easy by making information and data centralized and getting standard information in the form of related records from database in niche of time. SQL is a language that is made to create and communicate with the database that is through that language we can not only create our database but further on we can operate the already developed database in the way we want; most probably useful way. When we make a database especially relational database we made tables with related data in them. We can feel the need to add data, delete data, update data and obviously access data from those tables. SQLdatabase. gives you privilege to access data, insert that is add data, delete data and last but not the least update data from

Some Important Facts about SQL:

SQL is an ANSI (American National Standard Institute) standard

SQL is not case sensitive

Separate SQL statements with a semicolon as some database demand a semicolon at the end of each and every SQL statement.  In fact separating the SQL statements in a database system with a semicolon is a standard way of writing SQL statements; when a call is sent to the server for execution; more than one SQL statements are executed in the one same call.

Summary of functions that SQL is capable of

SQL ----- create database

SQL ----- create tables in database

SQL ----- insert data in database

SQL -----update data in database

SQL -----delete data from database

SQL -----access data from database or we can say retrieve data from database

SQL -----create stored procedures in database

SQL -----create views in database

SQL -----sets permission on tables, stored procedures and views

SQL -----execute different queries and sub queries for performing different operations on database