STUDENT_NAME - Place your name in this line.
NOTE: To begin using this repository locally on your computer, you should first install git and Visual Studio Code. See the Software Resources section of this page.
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 TABLEetc. - DML (Data Manipulation Language) -
INSERT INTOetc. - Queries -
SELECTetc. - Stored Procedures (sprocs) -
CREATE PROCEDUREetc. - Triggers -
CREATE TRIGGERetc.
- DDL (Data Definition Language) -
Recommended tools for this course include:
- SQL Server 2022 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.
Other recommended resources include: