Database Concepts
Important Info
- Syllabus
- Intro Slides
- What you need for the class:
- No Textbooks (YAY!)
- A reasonably modern laptop
- Windows-based laptop or surface running Windows 8 or 10 (preferable)
- Apple MacBook or MacBook Pro running Yosemite or higher
- Linux-based Laptop running a Debian-based version of the OS (preferable) – Other versions of Linux OK – but you’re on your own as far as setup
- At least 4GB of Ram, so you can run a virtual machine
- You’ll need to install (minimally) VirtualBox and Vagrant
- During the semester (I’ll tell you when), you’ll need to get an Amazon Web Services Account so that you can access the AWS Free Tier services. More on this to come….
Handouts & Links
- Jeff Ullman’s Foundations of Computer Science – Chapter 8 – The Relational Data Model
- Provides a concise, readable introduction to the theory of the relational data model
- Also covers relational algebra
- Relational Algebra In Class Exercise
- Setting up your development environment
- Setting up a LAMP Server on Ubuntu
- MySQL Materials
- Basic MySQL Tutorial
- mysql client CLI Cheat Sheet
- mysql client in batch mode (so you can provide a script file with the MySQL commands)
- SQL Handout 01
- SQL Handout 02
- SQL – Select – Slides
- SQL – Joins & Nested Queries
- MySQL Sample Employee Database
- PHP & REST API Materials
- Anatomy of a Modern PHP Application
- REST API – Dr. Dobbs (really in depth article)
- Some REST Best Practices
- PHP Best Practices – A Short, Practical guide for Common and Confusing PHP Tasks
- PHP The Right Way
- About the Slim Framework
- Note: You always want to make sure you’re using or referring to things related to Slim 3. There are some substantial differences between Slim 3 and older versions that will cause you some ‘heartburn’.
- The Slim Framework – A MicroFramework for PHP
- Bookshelf – a sample Slim web app
- REST API in Slim Framework
- In case you hosed your <doc root>/public/index.php, here’s a copy of the original. You need to download, unzip, and put the file inside the <doc root>/public directory. If you don’t want to loose what’s there already, change the file name. Original Slim index.php file
- Fontenot’s Slide Decks
- Slide Decks from Lab
- Week of March 14 – Now What???
- Dabbling with Machine Learning
Homework
Various slide decks and handouts have contained problems at the end of them. Consider this the homework.
SQL Homework Assignment and Skeleton SQL File