1 / 7

School Academy Homework

School Academy Homework. Homework for November 2011. Nikolay Kostov. Telerik Corporation. www.telerik.com. Create a PHP application that allows browsing given folder's subfolders and files and displaying file's contents. Files and Processes Homework.

fynn
Download Presentation

School Academy Homework

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. School Academy Homework Homework for November 2011 Nikolay Kostov Telerik Corporation www.telerik.com

  2. Create a PHP application that allows browsing given folder's subfolders and files and displaying file's contents Files and ProcessesHomework

  3. Create a PHP application that allows interactive execution of shell commands Files and ProcessesHomework (2)

  4. MySQL Exercises Write a SQL query to find all information about all departments Write a SQL query to find all department names Write a SQL query to find the salary of each employee Write a SQL query to find the full name of each employee Write a SQL query to find all different employee salaries. Write a SQL query to find all information about the employees whose job title is “Sales Representative“

  5. MySQL Exercises (2) Write a SQL query to find the names of all employees whose first name starts with the prefix "Sa“ Write a SQL query to find the names of all employees whose last name contains the sequence "ei“ Write a SQL query to find the salary of all employees whose salary is in the range [20000…30000] Write a SQL query to find the names of all employees whose salary is 25000, 14000, 12500 or 23600

  6. MySQL Exercises (3) Write a SQL query to find all employees that have salary more than 50 000. Order them in decreasing order by salary Write a SQL query to find all employees that do not have manager Write a SQL query to find the top 5 best paid employees Write a SQL query to find all employees along with their address. Use inner join with ON clause Write a SQL query to find the average salary in the department #1

  7. PHP Project Create an online music store with the following requirements: Users with sopping carts Companies: Record Company has many albums Albums: Each Album has many tracks Each album has a price, artists, category (Jazz, Blues, Hip-Hop, Pop, Rock, etc.) Administration: each company, album, artist, track and category must be editable

More Related