DMIT-1508 - Instructor Workbook (Sep 2023)

Dan Gilleland - Place your name in this line.

Schedule

The following schedule is subject to change. Consult the course outline for the mark distribution. See the Agenda for details on upcoming and completed topics.

gantt
    dateFormat  YYYY-MM-DD
    title       DMIT-1508 | Scheduled Topics & Assessments
    %% excludes    weekends
    %% (`excludes` accepts specific dates in YYYY-MM-DD format, days of the week ("sunday") or "weekends", but not the word "weekdays".)

    section Topics
    %% done - for finished tasks
    %% active - for current tasks
    %% crit - for red outline/background
    Intro & Workbook          :active,  part0, 2023-09-01, 2023-09-08
    Practice Assignment       :crit, active, about, 2023-09-06, 2023-09-11
    Database Design           :         part1, 2023-09-11, 2023-09-22
    DDL Commands              :         part2, 2023-09-25, 2023-10-02
    SQL Queries               :         part3, 2023-10-03, 2023-10-20
    DML Commands              :         part4, 2023-10-23, 2023-10-27
    SPROCs                    :         part5, 2023-10-30, 2023-11-24
    Triggers                  :         part6, 2023-11-27, 2023-12-01

    section Labs
    Lab 1, due Sep 29  :     2023-09-18, 2023-09-29
    Lab 2A, due Oct 13 :     2023-10-02, 2023-10-13
    Lab 2B, due Oct 31 :     2023-10-16, 2023-10-31
    Lab 3, due Nov 24  :     2023-10-30, 2023-11-24
    Lab 4, due Dec 08  :     2023-11-30, 2023-12-08

    section Quizzes
    Quiz 1, Oct 17 :milestone, 2023-10-17, 0d
    Quiz 2, Nov 07 :milestone, 2023-11-07, 0d
    Quiz 3, Dec 05 :milestone, 2023-12-05, 0d
    Quiz 4, Dec 13 :milestone, 2023-12-13, 0d

Inside this repository

This repository is your Student Workbook (:notebook:) for participating in the in-class demos and for completing practice homework.

⚠️ Do NOT use this repository for any assignments that are worth marks. For submitting any work that is worth marks in this course, only use repositories set up/approved by your instructor. ⚠️

The files in this repository branch are my in-class examples. There are some (old) unofficial website notes. Additionally, you can find online notes at the MS Teams Site for the course. Also be sure to checkout out the Learning Outcomes that I use in class.

Outline

The general topics in this workbook include

• Normalization
• SQL statements for
  • DDL (Data Definition Language) - CREATE TABLE etc.
  • DML (Data Manipulation Language) - INSERT INTO etc.
  • Queries - SELECT etc.
  • Stored Procedures (sprocs) - CREATE PROCEDURE etc.
  • Triggers - CREATE TRIGGER etc.

---

Software and Resources

Recommended tools for this course include:

• SQL Server 2019 or higher, Developer Edition
  • If you are installing SQL Server on a Mac, follow the instructions in this article:
    • How to Install SQL Server on a Mac
  • You might also find this video useful:
    • Step By Step Guide To Install MSSQL Server On Mac Using Docker (20 min, 27 sec)
• Git for Windows/macOS/Linux
• GitHub CLI
• Visual Studio Code as your primary editor
  • Begin your journey with VS Code with these introductory videos.
  • Alternate SQL Editors:
    • Sql Server Management Studio (SSMS)
    • Azure Data Studio
• LucidChart or Draw.io (VS Code Extension vs. desktop vs. online versions)
  • LucidChart has a free version available for students and educators. Learn more and sign up here.

There is a Wininstall package for this course.

Other recommended resources include:

• Learn Markdown

Cool Stuff

• Want a short way to get a git log result that looks cool? See this article