CSE 3330 – Spring 2018

Handouts & Docs

• Syllabus
• Setting up Docker and MySQL
• Midterm Group Knowledge Base – Google Doc

Notes

• The Relational Model
  • Slides
  • Extra Reading on the Relational Model and Relational Algebra
  • Exercises 01
• SQL
  • Getting Started with SQL (READING for Class on Feb 8)
  • SQL Intro Slides
  • Classic Models Setup in Docker and Queries
  • Docker Cheat Sheet
  • More info about the Classic Models Database
  • Learn More about MySQL
  • Extra Queries for Classic Models
  • More Classic Models Queries (In Class) – Also HW1
• MySQL
  • Adding a new user to MySQL
  • MySQL Workbench
  • Sample Database Schema for In Class Exercise
• Docker
  • Docker for Beginners – this may be the best Docker Tutorial I’ve read.  Definitely check it out.
  • Docker Hub <- Make an account here.
• AWS – Amazon Web Services
  • http://aws.amazon.com <- Make an Account on here.  Will require a credit card to create the account (at least it did the last time I created one), but we will stick with Free Tier services, or VERY cheap services (<$10/month for 3 months… way less than the cost of a text book).
• Node
  • Slide Set on Node JS
  • Hapi.JS Slides
• Docker Compose
  • Slides
  • GitHub Repo – Sample Project Setup – https://github.com/MarkFontenot/s18-cse3330.git
    • clone this repo and then look at the stuff in the projectComposeBase directory
    • From the base of that folder, docker-compose up
    • Once it all starts, you should be able to go to 127.0.0.1:3000/getData in your browser to see a message about the result of adding 1 to 1 (see the code…)
    • You can also use curl to test the URL end points
    • You should also be able to connect to the MySQL instance in the MySQL container through MySQL Workbench with host of 127.0.0.1 and port 3306.
      • user: mark   password: abc123  (unless you change it in the dockerfile).