Enhance your SQL skills with accessible online resources, interactive databases, and structured practice tests. Maintain consistent practice to solidify your understanding and proficiency in SQL.
Key Insights
- Access interactive SQL practice through Mode.com's free public warehouse, featuring a browser-based interface to explore and query Postgres databases.
- Utilize sqlcourse.com for hands-on exercises and reference guides, along with a comprehensive downloadable cheat sheet listing essential SQL commands.
- Challenge your SQL knowledge using LeapCode's structured study plan, recommended for use after gaining initial proficiency to effectively assess your skills.
Note: These materials offer prospective students a preview of how our classes are structured. Students enrolled in this course will receive access to the full set of materials, including video lectures, project-based assignments, and instructor feedback.
At the very last slide, I’ve got some learning resources for you. So there's sqlcourse.com, and there's some examples where they'll give you a sample table, and on the website, you can type in some queries to practice. There's also this reference here that you can check out as well.
There's a cheat sheet. Oh yeah, earlier, people were asking, is there a list of all the things you can do? This cheat sheet is good for that, where it lists the commands and you can read it here on the page or you can download the PDF. You do have to enter your email address, but you can always unsubscribe or you can just read on the page.
Now, for anybody that asks, is there another way that I can practice this stuff? Not just with your training database, but is there another source of data? There's a website called mode.com, which uses PostgreSQL. You can create a free account and browse their public warehouse of data. So it's like an online database.
You create a free account and you can query. You don't use DBeaver to connect to it. You just use their web interface, but you browse the database on the right instead of the left.
Ooh, they just moved sides. And then you can write your queries and hit run, and you just do it in the browser. If you wanna see a demonstration of it, I have a little video here where I did a short, kind of free seminar on just general SQL, but that is linked right to the part where I start talking about mode.com. So you can just watch that part where I talk about how to use mode.com. If you wanna see me teaching about it, you can watch that little YouTube video right there.
Also, LeapCode—has anybody heard of LeapCode? It's a place where you can test your knowledge. What I would say is don't do LeapCode right away, because after you’ve improved and feel like you want to try out a test, you can go through what they call a study plan. It’s a way to take some tests where you study and then take the test and see how you do. So learn SQL when you wanna challenge yourself to see how well you'll do on their tests, then you could do the LeapCode study plan and see how well you can do.
But I would come back to that later. That's why I put that at the end. So go through and practice.
We keep our training database up. So you can do this. You can go back over the exercise materials whenever you want.
Go back over the slides. All the slides are available as a PDF copy in the files. So you always have the slides up here at the top.
You've got your query written and execution order PDF. It's the same PDF in all three levels just to make it easy for you to find. It's a great resource for you so that whenever you forget the order, you can see it enough times and do it enough times to burn it into your brain. Eventually you'll just remember it off the top of your head.
Just a matter of practice and time. So anything with coding—the more you do it, the more you’re going to drill it into your brain. Don't take off a month and come back to this in a month.
You're gonna forget a lot of the stuff you learned. Stay in it, do it frequently. Even if it's just a little bit such as taking a couple of days each week to spend some time in SQL, trying some stuff out.
Even if you're just going back over the exercises, just stay in it so you don't forget the stuff.
