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

1 comments:

hannah said...
This comment has been removed by a blog administrator.

Post a Comment