SQL for Data Analytics · About the midterm check-in

About the midterm check-in

What it is

The midterm check-in is a 15-minute meeting with me, one-on-one on Zoom. It has two parts:

  • Queries. One or two questions you answer by writing a query on Northwind while we talk. This part takes about 5 to 10 minutes.
  • How the course is going. A short talk about where you are in the course.

You will be asked to share your entire screen in Zoom and turn on your webcam for the duration of the meeting.

Live technical interviewing is stressful enough on its own, so I'm not going to go heavy on the questions. The check-in is also a chance for me to see how everybody is doing.

How it counts

You get credit for booking a time, showing up on time, and taking part, whether or not you get the queries right.

Getting stuck on the queries doesn't mean you failed. It tells you what to work on before the final, which will have questions like these.

As a reminder, the final exam is half your course grade. If you've been doing the work and can answer questions like these without AI by the end of the quarter, you're in a good spot. If not, now is the time to lock in.

The points and dates for the check-in are in Canvas.

How to get ready

Do the midterm review. It's this week's assignment. It gives you one SQL question at a time on Northwind, covering Units 02 to 05.

The review keeps track of how you do in five categories. A category is done once you've gotten three of its questions right without opening the second hint. For credit, get all five done, and try to finish before your check-in.

To turn in the review, download your progress from it and upload the file to the Midterm review assignment in Canvas. You can upload it as many times as you like. The last one counts.

Booking

Book your check-in on Calendly. The times are during my office hours on November 3 and November 5.

To join, use the Zoom link on the office hours page.

If none of the times work for you, email me at kflint-blanchard@greenriver.edu or reach out on Teams with a few days and times that do, and we'll work out another time to meet.

What to have ready
  • Zoom, with your camera and screen sharing working. You will be asked to share your entire screen in Zoom and turn on your webcam for the duration of the meeting. If you haven't used Zoom much, Zoom's own help pages cover getting started with the app and sharing your screen, and you can join a test meeting to check your setup.
  • This page, open in your browser. You'll write your queries in its last section, "The query box for the check-in."

I'll give you the questions once we start.

The query box for the check-in

During the check-in, you'll write your queries in the box below. It has Northwind loaded. Try a few queries in it before your check-in so you know how it works.

The Tables panel on the right lists every table and its columns. If you don't see it, click the blue Tables button in the bottom right corner. The diagram under the box shows how the Northwind tables connect.

Write your check-in queries here. They aren't graded or turned in.
⌘/Ctrl + Enter

Northwind

Click a table to see a few of its rows.

Loading Northwind…