DATA MANIPULATION AND QUERYING WITH SQL ASSIGNMENT 1
Ryan Guda HIM-650: Health Care Data Management
College of Nursing and Health Care Professions, Grand Canyon University
Prof. Valerie Doebler May 12, 2021
1. Command CREATE TABLE
2. ALTER table by adding column
3. Command INSERT values for populating table
, 4. Perform six (6) queries to the Provider Table:
a. Command SELECT from Provider Table querying Last Name, Hire Date
b. SELECT from Provider Table querying Hire Date
c. Command SELECT from Provider Table querying specific Provider by
Last Name and First Name
Ryan Guda HIM-650: Health Care Data Management
College of Nursing and Health Care Professions, Grand Canyon University
Prof. Valerie Doebler May 12, 2021
1. Command CREATE TABLE
2. ALTER table by adding column
3. Command INSERT values for populating table
, 4. Perform six (6) queries to the Provider Table:
a. Command SELECT from Provider Table querying Last Name, Hire Date
b. SELECT from Provider Table querying Hire Date
c. Command SELECT from Provider Table querying specific Provider by
Last Name and First Name
