Dear esteemed experts, computer wizards and honourable teachers,
I need your help.
In the coming weeks my SQL skills are to be put to the test and I need to demonstrate the following:
A simple query involving SELECT, FROM and WHERE
Use of parameters within SQL to filter data
Understand the LEFT JOIN and the INNER JOIN
Understand the database the DBA is using
Grouping and Aggregation of data
Demonstrate Case Statements
Would anyone kind enough to go through the effort of the doing following:
Create some sample database and tables that I can add into my SQL Server 2012 Express.
Request 6-10 queries from me where I can demonstrate the above which I will post in this thread.
Finally, please check my work, leaving me some feedback.
There is an exam that I need to pass and I would sincerely appreciate your help.
I would welcome your advice, alternatively, any online tutorials, tests that I can be pointed towards in order to improve my understanding.
Thank you
What I have tried:
I have created a database at home which I have split into tables. However, this is all nicely ordered and formatted according to my needs which I don't think I can use to test myself.