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, got some learning resources for you. So there's sqlcourse.com and there's some examples where they'll give you like a sample table and in the website, you can kind of type in some queries to practice some things. There's also this reference here that you can check out as well.
There's a cheat sheet. Oh yeah, earlier people were asking like, is there like a list of like all the stuff 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 put in your email address, but you can always unsubscribe or you can just read on the page.
Now, for anybody that asks about, 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 and they have a free public warehouse where you can go in and it uses Postgres. So you can go in and 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 like a short, like kind of free seminar on just general SQL, but that is linked right to the part where I start talking about mode.com. And so you can just watch that later part of it where I talk about how to do 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 gotten better and you wanna feel like you wanna try out a test, you can go through their, they call it a study plan, but it's a way to like take some tests and you kind of 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 things whenever you want.
Go back over the slides. All the slides are in a copy of a PDF 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 until you burn that order into your brain, but you see that enough times, you do enough times, 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 gonna 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, like take a couple of days each week and 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.