HIM650 Health Care Data Management Research May 19, 2021.

HIM650 Health Care Data Management Research May 19, 2021. Data Manipulation and Querying With SQL Used as commands for storing, manipulating, and retrieving data in the database, learning the Structured Query Language (SQL) has become an essential skill for everyone working with databases. Almost all significant database vendors support SQL in their products. Being versed with SQL will allow someone to work with databases regardless of vendor, operating system, and device to use. In this paper, the writer will discuss the history and the intention of the Standard Query Language (SQL). Provide samples of data manipulation and querying using SQL. The History and Intention of the Standard Query Language The initial version of the Standard Query Language (SQL), originally developed by IBM Researchers — Raymond F. Boyce and Donald D. Chamberlain in the 1970s, was known as Structured English Query Language (SEQUEL). IBM initially used SEQUEL to manipulate and retrieve data from its databases (Data Flair, 2021). SEQUEL was designed to support the relational database model of Edgar Codd. This English computer scientist worked for IBM, first proposed in his 1970 paper in Communication of the Association for Computing Machinery (ACM). IBM released different versions of SQL from 1979 to 1983, namely System/38, SQL/DS, and DB2, after subjecting the query language to commercial testing. ANSI and ISO made SQL the Standard "Data Language SQL" in 1986. According to Soper (2013), the ideas and capabilities of SQL were based on relational algebra. SQL is not a programming language, but rather it is a data sub-language. The Standard Query Language can be further subdivided into three components, namely Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL). 2 These components present the intention of the Standard Query Language. DDL uses a series of commands to define and manage databases and their constraints, while DML uses statements to create, read, update, and delete data in the database. DCL helps create user accounts and managing permissions and for security purposes (Soper, 2013). Data Manipulation and Querying With SQL The database schema: 1. PATIENT — PatientId, Name, Date of Birth CREATE TABLE PATIENT (PatientId int not null PRIMARY KEY Patient_Name varchar(35) not null, DOB date not null); INSERT into Patient VALUES (1001,'Erwin Lampa',date''); INSERT into Patient VALUES (1002,'Rogel Cal-Ortiz',date''); INSERT into Patient VALUES (1003,'Jonathan Pena',date''); INSERT into Patient VALUES (1004,'Jay Baniqued',date'');