SQL types.docx - SurName1 Name Professor Subject Date Topic...

This preview shows page 1 - 3 out of 7 pages.

SurName1 Name Professor Subject Date Topic: Differentiating Types of SQL Introduction SQL stands for “Structured Query Language”. It is a database development and maintenance language that facilitates hum-system interaction. SQL is specialized for database use and finds its application only on database schemas for developing a relational collection of entities and their attributes. By invoking SQL commands, the user can be able to store, retrieve, edit and view data from a database with various relations. There two main parts that constitute the SQL code. These include; database development code (data definition language) and the procedural commands for data modification (data manipulation language). The data definition language is used for writing the various relations, their relationships as well as the views that apply to the database. The data manipulation language is used for the various functions that invoke movement of data to and from relations. Basically, with the data definition language, you apply back end programming to define the various entities in the database while with the data manipulation language you define how data is t be accessed or written as well as the editing functions such as delete, duplicate, cascade and ordering in any format. The essence of SQL is to ensure that a database can be defined with the requisite retrieval mechanisms as well as disk space, according to user specifications (Rockoff 29). Standard SQL
Image of page 1

Subscribe to view the full document.

SurName2 The standard SQL was designed by the International Business Machine (IBM) in the 70s under the initial name; SEQUEL (Structured English Query Language). It then grew to later versions from SQL 86 to SQL 2008, with new improvements on each from the previous. All standards however maintained compatibility with the latter and newer versions. The later version of SQL (SQL 92) introduced data definition commands that are applicable to date. These include; the NATURAL JOIN, the UNION JOIN, set operations, an INFORMATION SCHEMA, the creation of a template table under the instruction CREATE TEMP TABLE _tablename and new operations for changing data types. This involved mainly the type casting command; CAST (expr As Type) for instance; CAST (myname As STRING). The striking feature about that SQL version (SQL 92) was its inter-compatibility and interoperability. The language was designed to
Image of page 2
Image of page 3
  • Fall '16
  • joe jane

{[ snackBarMessage ]}

Get FREE access by uploading your study materials

Upload your study materials now and get free access to over 25 million documents.

Upload now for FREE access Or pay now for instant access
Christopher Reinemann
"Before using Course Hero my grade was at 78%. By the end of the semester my grade was at 90%. I could not have done it without all the class material I found."
— Christopher R., University of Rhode Island '15, Course Hero Intern

Ask a question for free

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern