SQL for Data Analytics · How the course works
How the course works
There are two places you'll be this quarter: Canvas and this site.
Canvas is where the due dates, the assignments you turn things in to, announcements, and your grades live.
This site is where the actual course is. The video lessons, the written lessons, and the practice are all here.
In Canvas you'll see one assignment for each unit, with a due date on it. The assignment links to that unit on this site. You work through the lessons here and do the unit's practice here. Then you go back to that assignment in Canvas and turn in your practice file.
The course is broken into units, and each unit is about one topic. Every unit works basically the same way.
- Lessons. Mostly videos, with some written material and a few small query boxes where you can try things out. Nothing on a lesson page is graded or turned in.
- Practice. A page of questions for the unit, at the bottom of the unit's menu. Every unit ends with one, including this one. This is the part you turn in. The practice for this unit walks you through exactly how that works.
Watch a lesson, try things out, move on to the next one. When you've been through the lessons, do the practice.
I'd really suggest you don't save a whole unit for one sitting. A little bit most days works a lot better than a lot the night before it's due, and the very first video in Unit 01 is about why.
There are no scheduled class meetings in this course. No lectures, and no set time you need to be on Zoom every week. You work through each unit on your own schedule, as long as things are in by the due dates in Canvas.
There are two times you will meet with me. One is a short one-on-one check-in around the middle of the quarter, and the other is the final exam at the end. I'll let you know when those are coming a few weeks in advance, and for the check-in you'll pick a time that works for you.
Don't stay stuck on stuff.
It's worth spending 20 or 30 minutes struggling with something and trying to figure it out yourself. That's part of learning it. But if you've tried a few things and it's still not working, come talk to somebody. I would much rather you get in touch with me than stay stuck on something for weeks.
- Office hours. This is time where I'm just hanging out in my Zoom room, waiting for people to come by with questions. It's part of what you're paying for, so use it. The times and the Zoom link are here. If you join the Zoom and end up in a waiting room, that just means I'm with another student. Give me five or ten minutes.
- Tutors. We have really good tutors in this program. Any tutor listed for "All SDEV classes" can help you with this course, and the tutoring schedule is in Canvas. They're usually more available than I am, and for most of the questions you'll have, they're as good as me.
- Email or Teams. I'm generally around on weekdays, and I'll usually get back to you within a day. If it's been more than two days, email me again, because it means I missed it.
One thing to know: I don't give a lot of written feedback on practice. The site tells you right away whether a query did what the question asked. So if something isn't making sense, you need to come to me or to a tutor. I'm always happy to help, but I don't know that you need help unless you show up and tell me.
Start early, and reach out early.
- Technology from the library. If your laptop dies halfway through the quarter, or your internet is bad, or you need a webcam, the Green River library can check equipment out to you. The link is in Canvas.
- W3Schools. W3Schools SQL is like a reference book. We're going to cover a lot of commands this quarter, and when you forget exactly how a WHERE clause works, it's a lot faster to look it up there than to dig back through my videos. It's not the easiest place to learn something the first time, so start with the lessons. It's great for reminding yourself later.
- LinkedIn Learning. You have free access through the school, and it has a lot of good video courses if you want a second explanation of something. The link for how to get access is in Canvas.
- AI. If you already pay for an AI tool, you're welcome to use it. The smarter models tend to be better for this kind of work. If you don't have one, the free version of Gemini probably gives you the most use without paying. Just remember what I said about using AI. Try things yourself first, and don't turn in AI's work as your own.