Database design and write complex query

Any type of database work like Following

1. Database design
2. View and procedure with complex logic
3. Multiple table joining query
4. Advance SQL query like fetch data without loop
5. Query optimization for performance
6. Database structure with excel description
7. Design database based on ER Diagram
8. Procedure for Insert, update and delete operation