Est. Budget: $100.00
First task is about writing some SQL statement. So a good knowledge of SQL syntax is needed. You must know when to use GROUP BY, INNER JOIN, OUTER LEFT/RIGHT JOIN, SUBQUERIES, CASE, FUNCTIONS and other syntax.
Second task is about Database theory. A good knowledge of DBMS Buffer Organisation, DBMS and SQL server Indexing, Transaction Management are needed.