1)Please write a complete three tier web application to implement an URL shortener like [login to view URL] It should meet the following constraints:
The shortened URL path (after the /) should not be longer than 6 – 8 characters, and they should be from the charset [A-Za-z0-9]
Each unique URL should have a unique short URL and vice versa
2)Please review [login to view URL] and recommend 10 things we could do in order to improve the performance or Page Load Time
Design a Single sign on feature that could be used across multiple domains and multiple publications, for example build a single sign on login/registration feature which will track a unified user profile across [login to view URL] and [login to view URL]
3) Please create a database schema to represent students and courses. Each student can sign up for multiple courses, and each course can be taken up by multiple students. Once you have designed the schema to capture the marks scored by each student for each course they have taken up, write the SQL queries to output the following
a)Print all courses, the total # of students who signed up for each course, the average marks across all students who have taken that course
b) Now print the same list as above, but print them in descending order of the average marks in each course
c) Rank all students by the average marks secured across all courses taken by each student
Hi, I have read through your project description carefully and I am confident that I can complete this project within the designated time period and your budget. I will guarantee your 100% satisfaction. Can we discuss the details further? Waiting for your reply!
Hi,
I am willing to work in your budget.
I am a web professional having 3.5 years of experience working as PHP developer. I can create and design PHP programs and websites. I have experience working with Oracle, MSSQL and MySQL. I also have extensive knowledge of CSS, HTML, XHTML and SQL.
I have excellent math skills with the ability to solve complex problems. I also have the ability to pay close attention to details and to make excellent decisions.
I am looking forward to meeting with you in person to discuss my credentials and the job requirements more thoroughly.
You can reach me for an interview on Skype, I am available most anytime.
Thanks & Regards
Webxon
Hi,
l went through your list of tasks.
Task 1: I have the code ready for URL shortner. I will just need to modify as per the requirement.
Task 2: First go to "inspect elements" in Chrome and run the audit, from that itself few things can be known like its showing we need to compress , zip and place stylesheets , JS file properly. Other than that we can use Impage sprite and Reduce HTTP requests.
Task 3: Damn easy! :p
I have more than 2 years of experience in web dev.
Let me know if you need any other information. Looking forward to you.