Dan Gilleland - Place your name in this line.
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
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.
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.
- DDL (Data Definition Language) -
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:
- 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:
- 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:
- Want a short way to get a
git log
result that looks cool? See this article