OIM3600 - Computer Science for Business Students

Session 17 (10/28)

Today's Agenda

• Welcome/News/Announcements
• Class Review
• Lecture
  • Database and SQL

Welcome/News/Announcements

• Homework - SQL: due 11/03, Sunday
• Schedule for the rest of the semester:
  • Week 10: Web Dev (HTML, CSS, JavaScript)
  • Week 11: Flask Web Application, Introducing Final Project
  • Week 12: Working on Project
  • Week 13: CS x Business, Project Presentations (voluntary)
• Communications:
  • Slack - for debugging, clarifications, real-time discussion, casual chat, etc.
  • Email - specify course # in subject title, e.g., "OIM3600: GitHub settings"
  • Meet with me in person during office hours at least once this semester.
• Questions?

What we have learned so far

• Code represent:
• Programming Tools: VSCode, Git/GitHub
• Programming Basics:
  • Variables, Expressions, Statements
  • Types: int, float, str, bool, None, list, dict, tuple, set
  • Functions, Conditional, Iterations
• Algorithms
  • Search (linear, binary), Sortings(selection sort, bubble sort, merge sort, etc)
• API

Lecture - Database and SQL

• Download SQLite tool:
  • sqlite-tools-win-x64.zip for Windows
  • sqlite-tools-osx-x64.zip for macOS
  • Extract the command-line shell program (sqlite3) to OIM3600/data folder.
• Download the following data files (to the OIM3600/data folder):
  • countries.csv
  • shows.db

SQLite

• SQLite is a open-source, serverless, zero-configuration, transactional SQL database engine.

  • "SQLite just works."

• Commands:
  • .open, .tables, .schema, .import, .mode, .header, .output, .quit
  • SELECT, FROM, WHERE, ORDER BY, LIMIT, JOIN, GROUP BY, HAVING, UNION, EXCEPT, INTERSECT
  • CREATE TABLE, INSERT INTO, UPDATE, DELETE, DROP TABLE
  • Commands used in class
• Resources
  • Appropriate Uses For SQLite
  • Sqlime - Online SQLite playground