Use of SQL

Running head : Use of SQL

Use of SQL The analysis of SQL on the basic of the following statement is as follows

Vishnu pointed out to Lucy that use of SQL as a Data Definition Language is most commonly a database professional 's responsibility while the end user most commonly deploys SQL as a manipulation language

The statement can be broken into several parts as follows

SQL as a Data Definition Language : The SQL is an excellent Data Definition Language (DDL ) statement in database scenario as it entails the creation

of schema , database elements like table , views , triggers stored procedures , cursors , objects and packages . The data or information belonging to any organization must be stored and to facilitate such storage one requires creating a placeholder for it . The creation of such placeholders is mechanized using the SQL language and would create provision for data definition so that appropriate data can be stored and retrieved . Only storing is not the priority however storing in a standard form is appropriate for its successful retrieval

For example : SQL and a DDL can be used to create schemas , database tables , procedures and packages for storing data definition and behavior

The end user most commonly deploys SQL as a manipulation language Navathe (2003 ) says that the SQL language is most commonly used for fetching the right kind of scenario in any business and is often used by the end user for fetching the right data for purpose . The reports which are desired for giving the higher priority to the requirement of data in any organization would embark the fulfillment of objectives from time to time

For example : In the following cases , SQL as a DML language is used by the users for fetching their purpose

Fetching the details of employees and their jobs

Calculation of Others The business scenario of EBay requires that all customers ' clicks are recorded and patterns for searching and navigation is taken up well . The very record of such instances must be produced for data analysis and data storage for fetching the right kind of material . The basics of getting the job done are the crucial requirement of data warehouse which would be required for fetching the data and storing it in appropriate formats for getting the job done . The data warehouse in such scenario is useful the following purposes

Organizational data is essential for storage and must be done accordingly for fetching the right pattern and usage

The consumer behavior on the internet is an essential behavior for fetching the right kind of usage and to top the list it must tap the right kind of consumer behavior and setup

Fetching the right kind of consumer behavior would entail the organization to improve the pages and would embark the quality and volume for data pattern and usage

Thus in this scenario the data usage is to be done for sure and the requirement of data warehouse is an essentiality

References

Navathe , Elmasri (2003 . Database Systems , Prentice Hall . SQL PAGE 1...