What is SQL.Purpose of SQL.Who should learn

                                                1. What is SQL and Purpose of SQL

Introduction of SQL

• SQL stands for structured query language. SQL was initially developed at IBM is 1970s.  
• SQL is the the standard language to communicate with relational database management system  like oracle,MS access,MS SQL server, Mysql,Db2,Sybase etc.SQL is a command based        language.
•  SQL is domain specific not general purpose,used in design and management of data held in       RDBMS ( Relational database management system).
•  SQL is a command based language.
•  SQL lets you access and manipulate databases.
•  SQL became a standard of the american national standard institute (ANSI) in 1986,and of the    international organization for standardization(ISO) in 1987.

Purpose of SQL 

• SQL is used to create new database.
• SQL is used to create new tables in a database.
• SQL is used to insert records, update records,delete record in a database.
• SQL is used to retrieve data from database.
• SQL can set permission on tables procedures and views.
• SQL is used to create stored procedures in a database.
• SQL is used to create view in a database.

Who should learn SQL

• Database Developers.
• Database Admistrators.(DBA)
• Database Testers.

Database Developers:

                                      Design and deploy database table structures,forms,reports,and queries.

Database Admistrators:

                                      Keeping database upto data and  managing database access.writing reports documentation and operating manulas.

Database Testers:

1. Verify data Integrity ( completeness and correctness of data).
2. Verify data Manipulation (Add,Update,Delete).
3. Verify data Comparison (two database front end data with back end data).