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.
- 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.
- Database Developers.
- Database Admistrators.(DBA)
- Database Testers.
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:
- Verify data Integrity ( completeness and correctness of data).
- Verify data Manipulation (Add,Update,Delete).
- Verify data Comparison (two database front end data with back end data).
