RECAP 10/23/19: SQL Workshop

In this fall quarter workshop, we introduced SQL and some of its main syntax, as well as how to download MySQL. About 30 members attended, but for those who missed it, here is a brief overview of what we discussed. For your reference, we have also included links to MySQL and the complete slides from the workshop.

Covered in Workshop:

  • Database Management System Overview
    • Hierarchical vs. relational
  • Syntax (Insert, Update, Select, etc.)
  • Joining Techniques
  • Keys, Composite Keys, Foreign Keys

MySQL Download,   Workshop Slides

Recap 10/16/2019: Marketing with Data Guest Speaker: Stewart Pearson

For this week’s guest lecture, we had Stewart Pearson coming over to talk about what he has discovered working as a marketing specialist for years in different countries. The topics include agencies, advertising and brands in the golden age and a case study of Coca-Cola…

Covered in Guest Lecture:

  • How advertising agencies evolved
  • Advertising, brands and culture in the golden age
  • Impact of competing emotionally
  • Why Pepsi failed and why Coca-Cola continues
  • The functions of advertising in our culture and commerce
  • Advertising Today
  • Most Effective Advertising: Long-Term
  • Agencies Today
  • Challenges Today

Guest Lecture Slide