I'm a Senior Developer/Software Architect working on a personal project with a friend. Our skills are more on the technical side of things than the creative side and are looking initially for some one off help designing some of the key pages and a style guide.
The link below is the prototype of the website we want to create. We are currently rewriting this from scratch.
The main things we would like are:
A style guide
Design for the Exercise Listing page (this will likely become several pages once proper UX design principles are applied to it)
The exercise pages are also to be completely redesigned. They are currently mostly variations on a single template but the vision is for them to be completely rewritten individually.
There are four main types of exercise page.
Query builder pages - http://sqlconfidence.com/Exercise/Exercise/?ExerciseId=2027
Query exercises - http://sqlconfidence.com/Exercise/Exercise/?ExerciseId=1016
Multiple choice exercises - http://sqlconfidence.com/Exercise/Exercise/?ExerciseId=1014
Unit tested exercises - http://sqlconfidence.com/Exercise/Exercise/?ExerciseId=2039
The simplest to explain is the multiple choice type. They are mostly a more complex version of what you would expect from a quiz website. There may also be extra components to design for these pages though, such as displaying relevant data or resources for the multiple choice questions.
Query exercises are the core of the website. There is a question and a correct answer. The user has to submit a query that returns the same results as the answer we have. What could be quite a bit of design work here is the method that's used to provide feedback to the user if they get the answer only partially correct. Currently we feed back information such as the number of columns being different, number of rows, correct data but in the wrong order and numerical columns being slightly off (e.g. their answer had a 1 but ours had a 2 is likely down to a small error). It's our feeling though that this is quite an intense form of feedback and it would be nice to create something that's more intuitive for the user.
Query builder exercises are similar to the query exercises, except that they are generally simpler and use a graphical interface for creating the queries to ease users into learning SQL. The thing we would really like to improve here is to simplify the query builder down to the essentials, rather than having a one size fits all query builder that we have right now.
Unit tested exercises are similar to the query exercises except that the user has to write update queries. So instead of comparing data sets, there are lists of tests that the user must pass.
I'm aware that this is quite a bit of work so happy to split it up in an agile fashion and focus on the essentials, get a reasonable looking website working and then once the essentials are done reasonably we could go back and iterate on the design as money and time allows.
The first set of designs I would expect to work on are the style guide, exercise list page and one of the simpler exercise pages.
I would be looking to approach the project as previously mentioned in an agile fashion, so the work would include discussions on the design and further explanation of the concepts and how the website is intended to work.
I would like rough initial quotes for that initial set of work as well as links to a portfolio of any similar work. I would prefer designers that have experience with designing for applications such as this rather than websites. A basic understanding of SQL would be a plus.