OIM3600 - Computer Science for Business Students

Session 19 (11/04)

Today's Agenda

• Welcome/News/Announcements
• Class Review
• Lecture
  • Database and SQL
    • Transactions
    • SQL Injection Attack
  • Internet
  • OpenAI API Quick Start (if time permits)

Welcome/News/Announcements

• Please sign up for GitHub Student Developer Pack
• Following Topics:
  • Frontend Development (HTML, CSS, JavaScript)
  • Web Application
  • Final Project
  • CS x Business (suggestions?)
• 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), Sorting (selection sort, bubble sort, merge sort, etc)
• API
• Database and SQL

Lecture

• Database and SQL (cont.)
  • Transactions
  • SQL Injection Attack
  • drawdb.app - Free online database diagram editor and SQL generator.
• Internet

What is the Internet?