So, in my personal experience, I have found that SQL is one of the more difficult concepts to understand. Out of all of the other concepts I have learned, this one has proven to take the most time, practice, money, and patience and I still am not always one hundred percent confident on it.
In this post, I am going to introduce my top five guides that I used when learning SQL. All five of them have their strengths, and if you are in the process of learning this concept, I highly encourage you to check them out.
Also, feel free to comment telling me if you found this post helpful or informational. I’d love to hear your own experience with SQL as well!
Codecadmy is a very well-known and highly-rated online coding school, designed to teach you various web development and coding languages in individual, fast paced courses. This site offers both free and paid courses, with each course starting from scratch. This is also a great site to start at if you are at an intermediate level, as they offer a wide range of difficulty in their selections. The majority of their courses are set up for beginners and work you up to an advanced level.
This site is also a well-known coding instructional site that offers a wide range of coding courses and certificates. Their SQL courses are very informative and easy-to-understand and are short and to the point. Unlike Codecademy’s courses, Udemy offers shorter courses that are less extensive. The courses are set up by experience, and a beginner’s course will work you up to an experienced beginner’s level before directing you to the next course. Since the courses are less extensive, they are fairly inexpensive and also offer discounts for students.
W3Schools is not quite as well known as the previous options, but it is just as extensive and informational. While these courses are directed more towards the beginner and do go at a slower pace, they do give you a very in-depth understanding of each concept and allow plenty of time for review and practice. For especially difficult concepts like SQL, I would highly recommend W3Schools because you will develop a well-rounded understanding and implementation of each concept and idea taught.
4. Khan Academy
I used to use Khan Academy for my high school Pre-Calc problems, but more recently, I have used it to learn SQL. Khan Academy teaches primarily through tutorial videos and is less of a hands on style than the other tutorials. However, it does provide a very in-depth study and the tutor system that the website provides offers the unique experience of talking with coding experts. I would recommend this guide if you learn best through videos or if you are comfortable asking questions as a way of learning.
5. SQL Interview Problems and Solutions
I found this guide very helpful as I neared the end of my courses and learning of SQL. It is one thing to simply take a few courses on a database and to be able to recognize small things. However, it is a whole other skill to be able to talk about SQL and demonstrate your real-life understanding of it. This guide provides you with interview problems and questions so that you are prepared to use your newly-learned skills in a job scenario or environment and I found it helpful to give me a final review of what I had learned.