OIM3600 - Computer Science for Business Students

Session 18 (10/30)

Today's Agenda

• Welcome/News/Announcements
• Class Review
• Lecture
  • Database and SQL (cont.)
    • Python x SQL
  • Internet (if time permits)

Welcome/News/Announcements

• Homework - SQL: due 11/03, Sunday
• Following schedules:
  • Week 10: Web Dev (HTML, CSS, JavaScript)
  • Week 11 & 12：Flask Web Application, Final Project
  • Week 13: CS x Business, Project Presentations
• 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
• Database and SQL

Improve VS Code Experience

• Appearance
  • Themes: VS Code Themes
  • Fonts: Coding Fonts, 142 Programming Fonts
• Extensions:
  • Code Formatting: Black Formatter/Ruff, isort, Prettier
  • Documentation: Markdown All in One, Better Comments, Code Spell Checker
  • Utility: Live Server, Rainbow CSV, Edit csv, SQLite Viewer, Draw.io
  • Fun: Power Mode, vscode-faker

Lecture

• Database and SQL (cont.)
  • Python x SQL
• Internet (if time permits)