Mark Fontenot

...computer scientist turned engineering educator...

  • Home
  • About Me
  • Teaching
    • CS 3200 – Database Design – Fall 2022
    • Data Structures (SMU)
      • CS 2341 – Spring 2022
      • CS 2341 – Fall 2021
      • CS 2341 – Spring 2021
      • CS 2341 – Spring 2020
      • CS 2341 – Fall 2020
      • CS 2341 – Spring 2020
      • CS 2341 – Fall 2019
      • CSE 2341 – Spring 2019
      • CSE 2341 – Spring 2018
      • CSE 2341 – Fall 2017
      • CSE 2341 – Spring 2017
      • CSE 2341 – Fall 2016
      • CSE 2341 – Spring 2016
      • CSE 2341 – Fall 2015
      • CSE 2341 – Spring 2015
    • Database Concepts (SMU)
      • CSE 3330 – Spring 2019
      • CSE 3330 – Spring 2018
      • CSE 3330 – Fall 2017
      • CSE 3330 – Spring 2017
      • CSE 3330 – Spring 2016
      • CSE 3330 – Fall 2015
      • CSE 3330 – Spring 2015
    • Programming Concepts (SMU)
      • CS 1342 – May Term 22
      • CS 1342 – Summer 2019
      • CSE 1342 – Summer 2018
      • CSE 1342 – Summer 2018 (SMU in Germany)
      • CSE 1342 – Summer 2017
      • CSE 1342 – Summer 2016 in Weimar
      • CSE 1342 – Summer 2014
    • Algorithms (SMU)
      • CS 3353 – Spring 2022
      • CS 3353 – Fall 2021
      • CS 3353 – Spring 2021
    • Introduction to Engineering Design (SMU)
  • Research
    • PhD Programs in CS or Engineering Education
  • CV
    • Education
    • Experience
    • Research
    • Consulting
    • Service
    • Honors and Awards
You are here: Home / Teaching / Database Concepts (SMU) / CSE 3330 – Fall 2017

CSE 3330 – Fall 2017

Welcome to Database Concepts!

Docs and Handouts

  • Syllabus
  • H01 – Day 1
  • H02 – Vagrant, Virtual Box, and Getting Set Up
  • H03 – Vagrant Wrap up
  • H04 – The Relational Model
  • H05 – Relational Model and Relational Algebra Extra Reading
  • H06 – Basic Relational Algebra Practice
  • H07 – Keys in the Relational Model
  • H08 – More Relational Algebra Practice
  • H09 – SQL 01
  • H10 – SQL 02 – Joins
  • H11 – SQL 03 – Constraints and Keys
  • H12 – Setting up AWS EC2 Instance
  • H13 – MySQL from your HOST OS
  • H14 – PHP Tutorial
  • H15 – RESTful API Intro
  • H16 – SLIM Framework
  • H17 – SLIM Framework Slides
  • H18 – Up and Running with SLIM 3 walk through
  • H19 – More Slim

Homework Assignments

  • Homework 01 – Due Sept 15, 2017

Extra Help

  • MySQL SQL Language Documentation
  • SQL Joins – check out youtube or smu.edu/lynda
  • SLIM Framework Documentation

The Semester Project

Recent Posts

  • Gearing Up for Spring 22 Data Structures January 10, 2022
  • Adding Timeout to Github Actions September 21, 2021
  • Old Python2 Code Causing you a Headache? Convert Python3 Automagically! May 2, 2021
  • What are the gcc system include paths? February 2, 2021
  • Customizing CLion January 31, 2020

Important Links

  • CS 3200 – Database Design – Spring 2023

Follow me on Twitter

Tweets by @MarkTheSpot

Blogs and Things I Read

  • Coding Horror
  • Data Science Reader
  • Hacker Noon
  • List of Awesome Lists
  • Medium Blogs
  • Organizing Creativity
  • R-Bloggers
  • Towards Data Science

Tags

17S 17Su-Germany 1342su14 c catch clion coding cpp cs3353 cse1341 cse2341 cse3330 csed databases DataStructures docker education Fall2014 fall2016 highered Java learning linux mysql oh-my-zsh pointers programming Python3 Software Development sql terminal zsh

Return to top of page

Copyright © 2023 · eleven40 Child Theme on Genesis Framework · WordPress · Log in