SQL for Data Analytics · Syllabus
Syllabus
The syllabus is the official document for this class. It's the agreement between me and you about how I'm going to run it, and at the end of the day it's what decides things. So please read the whole thing.
SDEV 201 - SQL for Data Analytics (11566)
Fall 2026, 5 credits
Async online in Canvas
Prerequisite: CS 108, CS 109, or CS 120/ENGR 120 with a grade of 2.0 or higher; or instructor consent.
Course website located in Canvas, https://egator.greenriver.edu
Course Description
Structured Query Language (SQL) is used to extract and analyze data stored in databases. Hands-on experience with extracting data and organizing it into meaningful information in realistic scenarios.
Instructor Information
Instructor: Keller Flint-Blanchard - kflint-blanchard@greenriver.edu
Contact hours: Weekdays from 9am to 5pm via email or Microsoft Teams. Students can expect a response within 1-2 business days.
Office Hours
All office hours are on Zoom, and it's always the same Zoom room, whether you're dropping in or you booked a time.
Join office hours on Zoom: https://zoom.us/j/6106963583?pwd=VkFBczBxRUpMN0pHcHVDNGlHWVpndz09
Meeting ID: 610 696 3583
Passcode: spaceship
To join by phone: +1 253 215 8782 (Tacoma), then enter the meeting ID. The passcode by phone is 526534394.
Drop-in. During drop-in hours I'm sitting in the Zoom room with nothing scheduled, waiting for people to show up. You don't need to book anything. Just join. You may have to wait a few minutes in the Zoom waiting room. I'll admit you as soon as I'm done with whoever I'm talking to.
By appointment. Outside of drop-in hours, you need an appointment. Book one here. Appointments must be booked at least 4 hours in advance. Each one is 15 minutes. That's the time you're guaranteed. If nobody is booked after you, we can usually keep going.
| Drop-in | By appointment | |
|---|---|---|
| Tuesday | 9am to 10am | 9am to 1pm |
| Thursday | 11am to 12pm | 11am to 6pm |
If none of these 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.
Assigned Texts and Required Course Materials
No textbook is required for this course. Required readings will be provided online in Canvas by the instructor at no additional cost to the student.
Students will need access to a laptop or desktop computer with a modern web browser and an internet connection. The SQL practice in this course runs in the browser on the course website, so there is nothing to install to get started. Later in the quarter students may be asked to install a database and MySQL Workbench, both of which are free. If so, the instructor will give notice ahead of time and provide instructions.
The following course learning outcomes, program-learning outcomes, and campus-wide learning outcomes will be assessed by the course assignments and exams.
Course Outcomes
Students who successfully complete this class will be able to:
- Explain the structure of tables and the function of keys in a relational database.
- Use diagrams to show how tables in a relational database relate to one another.
- Interpret business information requests to produce accurate SQL statements.
- Construct SQL queries to retrieve data from one or more tables in a database.
- Produce SQL queries using logical operators, expressions, and filters.
Program Outcomes
- Extract data from a database using a relational database language.
- Perform basic data analysis techniques such as filtering, aggregation, and joins.
- Understand and demonstrate basic programming and database constructs.
College-wide Outcomes
- Responsibility encompasses those behaviors and dispositions necessary for students to be effective members of a community. This outcome is designed to help students recognize the value of a commitment to those responsibilities which will enable them to work successfully individually and with others.
- Critical Thinking finds expression in all disciplines and everyday life. It is characterized by an ability to reflect upon thinking patterns, including the role of emotions on thoughts, and to rigorously assess the quality of thought through its work products. Critical thinkers routinely evaluate thinking processes and alter them, as necessary, to facilitate an improvement in their thinking and potentially foster certain dispositions or intellectual traits over time.
Statement of Instructional Methods
Instructional methods used in this course include video-based lessons, written lessons, interactive student practice, and 1:1 meetings with the instructor. The instructor will record lessons that will be made available on the course website. Student engagement with the instructor, the materials, and the practice activities are essential to succeeding in this class.
Modality Statement
This course is fully online, which means we will work through Canvas with no regularly scheduled lectures. Assignments, announcements, and due dates are posted in Canvas. Lessons and practice are on the course website, which is linked from Canvas. Classroom engagement and activities will be facilitated over Canvas or during scheduled Zoom meetings.
There are two times during the quarter when students will meet with the instructor: a one-on-one midterm check-in, and the final exam. Both are described under Course Policies below, and the dates will be announced well in advance.
- Due Dates: All assessments are due before Midnight on the assigned date, unless otherwise specified.
- Late Assignments: Late work will be accepted up to 48 hours after the due date on Canvas with no grade penalty. Anything submitted after that will receive a penalty of 50%.
- Extensions: If you need an extension, you are welcome to request one on any assignment. However given the 48-hour late window, this should rarely be necessary. Email me in advance of the deadline letting me know which assignment you would like extended (by 5pm on the day the assignment is due at the absolute latest). I will typically grant a 4-day extension for occasional requests. Frequent extension requests are less likely to be approved. If you need more than 4 days, request it in your email and I will approve/reject on a case-by-case basis.
- Final Deadline: All work must be submitted by the last day of the quarter to receive any credit, late or otherwise. I may not be able to grant extensions on work submitted during finals week due to time constraints, even if they are requested in advance.
- Midterm Check-in:
- Around the middle of the quarter you will meet with me one-on-one for a short check-in on Zoom. We'll talk through how the course is going, look at some of the work you've done so far, and I'll ask you a few questions to get a sense of your understanding.
- The check-in is part of your coursework grade. You'll sign up for a time slot, and I'll let you know when sign-ups open a few weeks in advance.
- You will be asked to share your entire screen in Zoom and turn on your webcam for the duration of the meeting.
- Final Exam:
- This class will have a final exam at the end of the quarter. While it is not intended to be especially challenging, passing will require a solid understanding of concepts covered during class as well as the ability to write and interpret SQL queries without external resources. You will be given extensive opportunities to practice on similar questions and get support before the final.
- The final can be taken in-person on paper during finals week (recommended for most students) or completed online via a 1:1 Zoom technical interview with the instructor.
- The exam consists of straightforward questions covering the full course scope. Each question is scored as correct or incorrect. There is no partial credit per question, each will have a clear, definitive solution.
Plagiarism occurs when you knowingly submit someone else's ideas or words (or code) as your own. Plagiarism is an act of intentional deception that not only is dishonest; it robs you of the most important product of education. If I suspect that you have plagiarized, I will talk with you one-on-one and ask you to show me that the work in question is your own. If you are found guilty of academic dishonesty, you will receive a zero for that assignment.
- All code you submit must be your own work. Any duplicated, revised or obfuscated assignments will receive a zero.
- You may not have another person "walk you through" an assignment by writing code at your keyboard or telling you what to type in line-by-line. This includes current or former students, tutors, friends, paid consultants, people on the internet, or anyone else.
- If you adapt code from a website, you must cite your source(s).
- AI use will be permitted in this class but be careful how you use it. AI should not substitute for understanding or being able to apply concepts yourself. You are expected to understand and be able to explain any work you submit. If I suspect you are over-relying on AI without understanding the material, I may speak with you during a check-in or in a separate meeting. If I find that you do not understand or cannot explain the material you submitted, it may be considered academic dishonesty and receive a zero.
Final grades are calculated using weighted categories as outlined in the grade categories table (see below), where each category contributes a specific percentage to the overall course grade. The weighted percentage score will be translated as shown below:
| Grade | GPA | Grade | GPA | Grade | GPA |
|---|---|---|---|---|---|
| 95-100 | 4.0 | 84 | 2.9 | 73 | 1.8 |
| 94 | 3.9 | 83 | 2.8 | 72 | 1.7 |
| 93 | 3.8 | 82 | 2.7 | 71 | 1.6 |
| 92 | 3.7 | 81 | 2.6 | 70 | 1.5 |
| 91 | 3.6 | 80 | 2.5 | 69 | 1.4 |
| 90 | 3.5 | 79 | 2.4 | 68 | 1.3 |
| 89 | 3.4 | 78 | 2.3 | 67 | 1.2 |
| 88 | 3.3 | 77 | 2.2 | 66 | 1.1 |
| 87 | 3.2 | 76 | 2.1 | 65 | 1.0 |
| 86 | 3.1 | 75 | 2.0 | 0-64 | 0.0 |
| 85 | 3.0 | 74 | 1.9 |
Grade Categories
| Category | Percentage of Final Grade |
|---|---|
| Coursework (practices, assignments, and the midterm check-in) | 50% |
| Final Exam | 50% |
Note: Course schedule subject to change at instructor's discretion.
| Week | Topic |
|---|---|
| 1 | Introduction to Data Analytics and Relational Data |
| 2 | Basic Querying |
| 3 | Grouping and Aggregation |
| 4 | Data Analytics with SQL |
| 5 | Table Joins |
| 6 | Practice & Midterm |
| 7 | Creating Tables & One to Many Relationships |
| 8 | Many to Many Relationships & Entity Relationship Diagrams |
| 9 | Database Design |
| 10 | Subqueries |
| Finals | Final Exam |
Midterm check-in meetings are scheduled around the middle of the quarter. Exact dates for the check-in and the final exam will be announced in Canvas.