DB Weekly Schedule

Fall 2023

Class Zoom Link https://sbuniv.zoom.us/j/93079706491?pwd=T3psMjAzMkRNaUtadDZuWFVhRmVyUT09

Week 15 of 12/4/23

Verse of the week Ecclesiastes 9:11

Objectives:

• Database backup and recovery
• Review for final exam

Resources:

• database import, backup, and recovery examples
• final exam study guide

Assignments:

• Finish assignment #12

Week 14 of 11/27/23

Verse of the week Ecclesiastes 8:15

Objectives:

• Database Access from PHP

Resources:

• PHP connects to MySQL
• CGI interface
• PHP tutorial
• example app (code)

Assignments:

• Assignment #12 (due 12/1/22)

• environment setup guide
• setup public_html (video demo)
• XAMPP install on Windows (video demo)
• walk-through video: part 1 part 2 

• PHP exercise

Week 13 of 11/13/23

Verse of the week: Romans 1:20 Ecclesiastes 1:9

Objectives:

• Finish transactions
• Indices and Views
• Introduce term project

Resources:

• Why transactions? (slides)
• Transactions case study (repo, live demo)
• Views and indices (slides)
• transaction note template
• isolation levels explained as if you were building a snowman 
• understand isolation levels and read phenomena
• additional exercise problems
• in-class exercise
• your life in weeks

Week 12 of 11/6/23

Verse of the week: Proverbs 4:23-25

Objectives:

• Transactions
• Indices and Views

Resources:

• Why transactions? (slides)
• Transactions case study (repo, live demo)
• Views and indices (slides)
• Movie reviews case study
• Why don't DBMS's support ASSERTION

Assignments:

• Assignment #11 (due 11/15/23)

Week 11 of 10/30/23

Verse of the week: Proverbs 25

Objectives:

• Constraints

Resources:

• Check Constraints (slides, case study repo)
• Assertions and Triggers (slides, case study repo)
• SQLite Check Constraints (tutorial)
• SQLite Triggers (tutorial)
• DBMS feature comparisons

Assignments:

• Assignment #10 (due11/8/23)

Week 10 of 10/23/23

Verse of the week: 2 Timothy 4:3-4

Objectives:

• Database declaration and modification
• Database Constraints

Resources:

• Database declaration (slides)
• Database modification (slides, case study, git repo)
• Key Constraints (slides, case study repo)
• why not use VARCHAR for everything?
• quotation marks

• delimited identifiers?
• single v.s. double quotes

Assignments:

• Assignment #9 (due 10/31/23 11/1/23)

Week 9 of 10/6/23

verse of the week 1 Samuel 2:30

Objectives:

• Keys and weak entity sets
• Database declaration

Resources:

• more on ER slides
• Database declaration (slides)
• battleship DB design case study

Assignments:

• Assignment #8 (due Wednesday 10/25/23)

Week 8 of 10/9/23

verse of the week 1 John 4:20-21

Objectives:

• Keys and weak entities
• Midterm exam

Resources:

• more on ER slides

Week 7 of 10/2/23

Verse of the week John 16:14

Objectives:

• Database design with ER models

Resources:

• more on ER slides
• IMDB case study
• midterm study guide with sample questions

Assignments:

• Assignment #7 (due Wednesday 10/11/23)

Week 6 of 9/25/23

Verse of the week: Proverbs 20:24

Objectives:

• Database design with ER models

Resources:

• ER modeling - Entity and Relationship
• ER modeling - Relationship Types
• ER modeling - Exercises
• Outer join examples

Assignments:

• Assignment #6 (Battleships) due Monday 10/2/23

Week 5 of 9/18/23

Verse of the week: Ephesians 5:21

Objectives:

• SQL grouping
• SQL exercise

Resources:

• SQL: group and aggregation (slides)
• IMDb practice questions (15 questions)
• SQL practice questions (42 questions)
• online SQL sandbox https://sqliteonline.com/

Assignments:

• Assignment #5 due Monday 9/25/23
• Assignment #5 due Monday 9/25/23

Week 4 of 9/11/23

Verse of the week: Proverbs 11:1

Objectives:

• SQL grouping

Resources:

• SQL: group and aggregation (slides)
• SQL tutorials on w3schools
• SQL exercises on w3schools
• Introduction to MySQL

Assignments:

• Assignment #4 (first 5 problems) due Monday 9/18/23, correction due 9/25/23

Week 3 of 9/4/23

Verse of the week: Proverbs 30:7-9

Objectives:

• Structured Query Language (SQL)

Resources:

• SQL: join and subquery (slides)
• SQL exercises on w3schools
• SQL practice questions (42 questions)
• homework-related exercise problems

Assignments:

• Assignment #3 due Monday 9/11/22, please submit a pdf or a snapshot of your work on Blackboard.

Week 2 of 8/28/23

Verse of the week: Proverbs 23:23

Objectives:

• Structured Query Language (SQL)

Resources:

• Relational algebra (slides)
• SQL: intro (slides)
• SQL practice questions (20 questions)

Assignments:

• Assignment #2 due Wednesday 9/6/23, please submit a PDF or a snapshot of your work on Blackboard.

Week 1 of 8/21/23

Verse of the week: John 8:31-32

Objectives:

• Syllabus
• Relational Algebra

Resources:

• Syllabus

• Introduction (slides)

• contact list app pseudo-code

• Relational algebra (slides)
• example

Assignments:

• Read Chapter 1 of "A First Course in Database Systems" and http://philip.greenspun.com/sql/introduction.html
• Assignment #1 due end of Monday 8/28/23. Please submit a digital (pdf/jpg) of your work on Blackboard.