brendenwest/it222

Database-driven Analysis

IT 222 - Designing Database Solutions

Class Details

• Location: Virtual
• Time: Tues 5:30 - 7:05 pm
• Dates: June 26 - Aug. 18, 2023
• Instructor: Brenden West
• Email: [email protected]
• Credits: 5
• ITC Tutoring Slack - https://tinyurl.com/saea74l

Summary

Focuses on database-driven solutions for business intelligence reporting and data analysis.

Requirements

Students should have prior experience with relational databases, SQL, and basic computer management through IT 120 and IT 221, each with a 2.0, or Instructor's permission.

Students will perform extensive hands-on development throughout this course and will require;

• A computer onto which they can install software,
• A working internet connection
• A syntax-highlighting text editor
• A free https://datacamp.com/ account
• A free https://supabase.com/ account
• Tableau Desktop (free for students at https://www.tableau.com/academic/students#form)

This course will use a range of online materials as needed, including textbooks available free online through O'Reilly for Higher Education

Students can access O'Reilly for Higher Education with these steps:

• Follow the above link
• In the "Select institution" drop-down menu, select "not listed"
• Create new account (first time) using your @seattlecolleges.edu email address.

Class Structure and Topics

Course instruction will be virtual hybrid with a Zoom session at scheduled class times to review new material, answer questions, and resolve any issues with completing the homework.

Throughout the week students can reach out to me directly in the SCC tutoring Slack team with questions.

Each week, we'll cover a new topic, building on the previous week's work. We will cover the following topics, although the order and precise list is subject to revision:

• Overview of relational DB systems
• Defining a relational database structure
• Creating a database & importing data
• Performing data analysis with SQL
• Business Intelligence reporting

Grading

Grades will be based on assignments (85%) and quizzes (15%). There is no final exam.

Weekly assignments will be posted on Canvas and are designed to exercise the skill and concepts covered that week. Assignments are generally due by the following Monday and late submissions may be subject to a 10% penalty. Assignments turned in more than 2 weeks late will not be accepted nor graded.

Your submissions should be your own work: plagiarism, including use of AI tools, may incur a grade penalty.

Reference

• SQL for Data Analysis
• SQL for Data Analytics
• Practical SQL
• SQL Pocket Guide, 4th Ed.

ADA Accessibility

Students with documented disabilities requesting class accommodations, requiring special arrangements in case of building evacuation, or have emergency medical information the instructor should know about are asked to contact the disability support services office (DSS) in Rm. 1112. Once the disability is verified with DSS you will be given a letter of accommodation that should be handed to your instructor