SYM 400 Expanding the Scope of Queries COMPLETE

docx

School

Grand Canyon University *

*We aren’t endorsed by this school

Course

400

Subject

Computer Science

Date

Jan 9, 2024

Type

docx

Pages

5

Uploaded by PeanutButterEater102

Report
Expanding the Scope of Queries 1 SYM 400 Introduction to Database Structures
Expanding the Scope of Queries 2 The first step is to access LopesCloud, click on the second box with this week’s assignment name and start up the VM Now that I have connected to the SQL Server I need to provide a list of all of the records pertaining to the FirstName "John" in the Person table that includes the full name and number of records. To do this I input the following query: SELECT CONCAT(FirstName, ‘ ‘, MiddleName, ‘ ‘, LastName) AsEmployees_Named_John From Person.Person Where FirstName = John There was 58 results for employees named John altogether. To get the column count I used the following query: SELECT*FROM Person.Person Where FirstName = ‘John’ SELECT Count (*) From Person.Person Where FirstName = ‘John’
Expanding the Scope of Queries 3 Now I need to delete a specific record for John T. Moore from the database using his business entity ID since he was an was an erroneous entry. To do this I use the following SQL transaction: Delete * From Person.Person Where BusinessEntity = ‘18327’ :
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Expanding the Scope of Queries 4 Next the human resources manager has requested a full list of the e-mail address for each employee. To do this I used this query: SELECT CONCAT (FirstName, ‘ ‘, LastName) as FullName, pe.EmailAddress From Person.Person as pp Inner Join Person.EmailAddress as pe ON pp.BusinessEntityID = pe.EmailAddressID Now I need to identify the full name of the employee using email address ana17@adventure-works.com while using a WHERE clause. To do this I added one more line to the query used in question 3: SELECT CONCAT (FirstName, ‘ ‘, LastName) as FullName, pe.EmailAddress From Person.Person as pp Inner Join Person.EmailAddress as pe ON pp.BusinessEntityID = pe.EmailAddressID WHERE EmailAddress = ‘ana17@adventure-Works.com
Expanding the Scope of Queries 5 This shows that David Coleman was the employee with this specific email and adding this WHERE clause line saved me from having to filter through 19167 results manually finding the employee using this email.

Related Documents

BIT 415 Topic 4 DQ2.docx
ITT 370 802.11 Standards.docx
8288-questions-1-10.txt
CIS9350 Syllabus Spring 2023.docx
SYM 400 Topic 2 DQ1.docx
SYM 400 Tables Keys and Constraints.docx
ITT 307 Topic 3 DQ1.docx
SYM 400 Storage Indexing and Views COMPLETE.docx
ITT 307 Installing GUI Hash Generator.docx
ITT 370 Topic 2 DQ1.docx
Database Optimization and Performance Tuning Paper COMPLETE.docx
Term Group Project Deliverable 1.docx
Recommended textbooks for you
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
SEE MORE TEXTBOOKS