Computer Science > ESSAY > HIM 650 Data Manipulation and Querying with SQL. Latest 2022 - Grand Canyon University. (All)

HIM 650 Data Manipulation and Querying with SQL. Latest 2022 - Grand Canyon University.

Document Content and Description Below

In June 1970, Dr. E. F. Codd published the paper, “A Relational Model of Data for Large Shared Data Banks", in the Association of Computer Machinery (ACM) journal, Communications of the ACM (Lorentz... & Gregoire, 2003). IBM used Codd’s findings when they started working on a new language for relational database management. Originally the language was called Structured English Query Language (SEQUEL). The project had a few implementations and revisions, and the language changed several times. The final name for the language is SQL, which is still used today. SQL/DS (1981) and DB2 (1983) are some of the commercial products developed by IBM. Other vendors including Oracle, Sybase and Ingres announced their own commercial SQL-based products (Pickett, 2020). SQL is a specialized programming language that is used for managing relational databases and performing different operations on that data. SQL has many uses to include modifying database tables and index structures. SQL is used to add, update, and delete rows of data within a database. The retrieval of different subsets of information in a database for transaction processing and analytics applications is also done in SQL (Boyini, 2018). There are two main sets of commands that are used to create and modify databases in SQL. The first set of commands are Data Definition Language, and they are used to develop and delete databases and its objects. The second set of commands are Data Manipulation Language and these are used to insert, modify, and delete data stored in a database (IAC Publishing, 2020). SQL functions are sub-programs that are commonly used throughout SQL database applications. These functions are used for processing and manipulation data. SQL functions may have zero or more input parameters but can return only one value. The simplest way to classify SQL functions is to divide them into built-in functions and user-defined functions. [Show More]

Last updated: 2 years ago

Preview 1 out of 15 pages

Buy Now

Instant download

We Accept: