Emergency-Need to solve this SQL Queries- Need to Complete in 12-14 hours from now.
$100 USD
Cancelled
Posted about 9 years ago
$100 USD
Paid on delivery
I’ve attached some documents for your review of tasks that I would expect the candidate to be able to perform with little oversight post two weeks of training/orientation on the legacy system.
· [login to view URL] is a very simple select statement used to produce the report2.xlsx. Counting was done on the reporting layer (SSRS). You should be able to understand the SQL that was used as one of the simplest examples of required work.
· Health Utilization [login to view URL] is a work activity that maps the input form to the oracle database.
o You should be able to understand the JSP that loads the page, the JSP that saves the page, and the .xsl. I’ve included all of the queries that are pulled from the data access layer as tabs in the spreadsheet. Given this information, you should be able to understand any business rules identified here and recreate the “Form Breakdown” tab.
§ Question: Can you identify where data is checked for correct values?
· [login to view URL] is an example of fairly poorly written code. What would your approach to be to refactor this for efficiency?
· [login to view URL] is code that was written to generate a report. You should be able to walk through this and be comfortable creating something similar in fashion. This code does contain performance issues as well and like the clicksql, I’m curious to know how you would approach refactoring this?