• Practice and Learn SQL 1
  • Practice and Learn SQL 2
  • Practice and Learn SQL 3
  • Practice and Learn SQL 4

Practice and Learn SQL

Becoming fluent in SQL takes practice. Reading up, studying the theory or simply knowing the syntax will take you so far; but only regular practice on the full range of the language will make you fluent.
Practicing SQL should also be hassle-free and (yes!) fun. With Knowledify, you will play the role of a freshly hired employee. Through a series of assignments more and more complex around the new database system that you new employer has deployed, you will move up within the company and become masterful in the art of SQL.

Features:› Assignments increase in complexity and breadth as you progress› Explore through practical training advanced usage of the language› Consult contextual reference articles as you are practicing› Intellisense and code-completion allows you to quickly write up complex queries

Why should you install Knowledify?› Practice on statements and SQL constructs that you may have forgotten› Prepare for exams (certification, interview, or university-level exams)› Maintain and also enrich your knowledge in SQL

Category : Education

Related searches

Reviews (29)

Bl. S. Mar 4, 2016     

You should tell the user that you want a particular column name prior to running the query. I shouldn't have to run the query and then realize you wanted a particular column name afterwards. In one problem the solution column name is spelled incorrectly (TotaRevenue), which then leads to me getting an incorrect answer. Either tell the user exactly what you want as a column name or don't do a check for it.

Fow. T. Apr 11, 2018     

I used this a while ago, and this has been the best way to learn SQL hands down. It doesn't feed answers to you, and encourages the user to do their own research instead of relying on multiple choices (which tends to be the standard for app based learning). I wish they would make more with other languages

And. M. Oct 29, 2015     

I rarely leave reviews but I really do like this app. Good flow and makes you really figure things out for yourself. It'd be great if it could go deeper with more advanced topics, triggers etc would be fantastic. Spent at least 5 hours with this. I like how it doesn't give you a solution so you can't just give up. This would be great for other languages too.

sha. s. Aug 6, 2015     

I am a complete beginner with not even 1% of SQL knowledge, I just downloaded this app to see how the tutorials are. Trust me this is the bestest app to learn SQL. The references and the examples are explained in layman language. Plus once you start reading, you actually do not feel like stopping. It catches your attention. The best thing is that you feel as if you're working on a live production database. Truely Awesome....

Tim. R. Mar 10, 2017     

Unlike other apps, this let's you actually write and test basic code - great! Please add some more advanced stuff because I finished the course in no time. A random questions section would also be very useful, that allows you to bring all the learnings together and try to remember them for different types of problems.

Que. B. Aug 14, 2015     

Been able to use the app well but I had a little programming in college and I'm pretty good at setting up spreadsheet formulas. I think a real beginner would have trouble figuring out how to proceed with syntax and setting up the mathematical functions needed in the solutions. One thing that might help is to add an option for a certain number of tries and then you can see the solution formula. Seeing the solution after getting the correct answer would be nice too, as it would show formatting suggestions.

Coo. L. Oct 7, 2015     

I was looking for a good interactive tutorial for SQL and this has it ALL. Information to reference AND actual exercises THAT ARE INTERACTIVE. I've had so much trouble finding coding apps because I learn from DOING - not just reading. This has that. ON MY PHONE. MORE of this guys. Excellent app. Will pay for more coding tutorial apps like this.

Joh. L. May 15, 2015     

SQL is easy to learn but the app lacks detail instructions about halfway through the app. I had to look up this and that to complete the lessons because they failed provide the info. And the app doesn't allow you to retry old lessons. One time, I was allowed to pass a lesson even though I noticed a mistake with what I wrote, the app only compares the results and not what you wrote.

Lor. H. Mar 25, 2016     

Allows for some good practice and v. nice that it doesn't require internet so the app can be used on the train. The Google+ sign in doesn't work so I had to start over when I got a new phone which was a bummer (but good for brushing up on earlier concepts). Other raters are correct that it won't give you the answers, but it does tell you where you messed up so you can re-work. I think that's more valuable since that what you'll get/ will need to do in reality.

I. W. I. K. Jan 21, 2018     

This is my favorite practice app so far but...this is not for beginners! First you have to learn SQL elsewhere, then you can use this to practice. I like the questions, although there should be more levels and questions and better language. Also, when you don't know the answers it should have a help center pointing to a lesson, explain whats the goal and how to solve or figure it out...you can't be left guessing... understanding that's the path to learn.

Mic. Jun 20, 2016     

Well structured, good basic content, very nice usability including handy links to the relevant help topics for that particular question. Great for learning to be typing out queries instead of selecting from multichoice. Awesome to include keyword prompts/autocompletion so i could type out queries quickly on my phone.

A. G. u. Nov 16, 2015     

...it's definitely not for complete beginners. One question said "do not use the less than or equals operators" - there was nothing in the help section that explained what could be used instead - I used the "between" function, but only because I already knew it. A complete beginner would not. A more comprehensive help section would greatly improve an already fantastic app

Dra. F. Jan 27, 2017     

I thoroughly enjoy using this app. It's a great way to learn SQL in an efficient way. However there are three things that can be improved upon: you need an SQL testing ground feature where you can practice on your own writing some SQL queries. Secondly, sometimes I want to re-write the answer for a specific question to see if there multiple ways to get the correct answer. Thirdly, it would be nice if we could see the query result time to see if the sql we write is optimal, fast and efficient.

Wan. P. Sep 29, 2016     

I studied SQL in class a few years ago and somehow because I haven't been practicing, I had forgotten a lot about sytanx in SQL but with this app, it has been helpful in doing revision. It keeps giving me a challenge to solve a problem. So wonderful.

ubn. Apr 12, 2016     

So far so good, except now I'm stuck and despite rereading the material and trying to figure out my error all I kept getting presented with is "syntax" error and the app doesn't allow you to see a solution at all. If this was added it'd be worth using but quite frankly, now that I can't progress due to the lack of direction it's pretty worthless.

T.. G. May 15, 2016     

There are a lot of good and clever practice problems. But sometimes the wording doesn't make sense. 2 questions may be worded the same way but looking for different results. You can't see any answers or useful hints. And you can't review questions already correctly answered. U can waste a lot of time with this app

Sha. M. Feb 25, 2016     

Really love this app. It allows you to learn at your own pace and keeps it enjoyable almost like playing a game. Just one improvement could be added an option that could give the answer if you are stuck. Got stuck on the last sorting example. Keep up the good work much love.

Iri. S. Jan 9, 2017     

So easy to use and learn. Very convenient. I like the shortcuts and being able to actually put the information to use and practice. Also really useful to see the results your query generates after each attempt. This app is gold :) I had no SQL experience prior to this, and this app makes learning it so easy and effective. Looking forward to the update for more info!

Del. Apr 20, 2016     

This app is perfect for someone who learns best by doing, like myself. There are no answers or hints provided, you have to figure each and every answer out your self - with in-app resources and guides of course. I just finished all of the levels, and at times I got extremely frustrated because I just couldn't seem to figure out some of the questions. The frustration was worth it though, I really got a better grasp of certain functions and the fact that there are more than one way to get to the same answer!

Sat. V. C. Jun 27, 2016     

Seen quite a few wrong queries. Suggest to refrain using this. Sorry for the negative review, but I can't stand it.

A. G. u. Jul 7, 2016     

I completed all the exercises minus one. The solution was too tricky and not documented. Completely beyond the scope of this tool. The documentation is good but not complete. Adding the option to run own test queries would make a 5-star app.

M.. A. Mar 19, 2016     

it teaches you the basics through assignments which is a very efficient way to learn if compared with the traditional most common way which focus on teaching you the syntax of any programing language mostly and without any practicality which leaves you lost in the end cause you don't know what to do exactly with what you've learned and as a result you tend to forget it quickly, hope to see a lot more apps like this in the future, Keep up the good work :)

raj. g. Jul 2, 2017     

This is great app to practice SQL. I don't think it is for beginners. You should first do a course using solo learn app, you will get the knowledge of commands. Then you can start using this app.

Nab. T. Apr 17, 2017     

It's good enough to practice on the go, but people need a "Hint" button. Some exercises are hard for some people and they get really frustrated about it that they can't find out what they should be doing. Would be 5 stars if that function is implemented.

lou. l. Mar 13, 2016     

The most glaring problem with this app is that it does a poor job teaching the content. Descriptions are short and generally insufficient, and some are even missing outright. The content itself is shallow and barely goes beyond basic queries. If you're reading this, move on to another app.

Muk. K. Apr 24, 2017     

Excellent app with great introductory examples. I'd have loved to learn SQL this was, but sadly, we didn't have smartphones back then. I'll definitely recommend this as a supplementary learning tool. I'd even be willing to pay for it, it's that good :)

Cra. C. Sep 30, 2015     

Set out as a bit of a game, this app makes it easy to learn, tells you what sort of error you made and shows you what the results should be, but doesn't spoon feed you. Unfortunately when you set new column titles, it doesn't always clue you in to what the title should be, leading you to have to cheat to get the trivial detail right.

Bli. C. Dec 1, 2016     

This is hands down the best sql-teaching app out there. Sure there were a few questions asking you to convert bytes to megabits and kilobits which required googling, but other than that this is AN AMAZING APP! GET IT!

Hem. N. Jun 29, 2016     

Doesn't have all the funtions that are required. I am even unable to open tab table to see all the tables