CIT178 Sample: Term Project Mini-Showcase 1 Directions | NMC Learning Management System (Moodle)

Expand Collapse Welcome to CIT 178 Relational Databases Highlighted

Livestream Link for Office Hours
News & Announcements from your instructor
Student Questions/Answers
Course Grading Scale Your final grade i...
EXTRA CREDIT: Test of Everyday Reasoning with Numeracy (TER-N) 20 Points

Expand Collapse Week 15: IT Specialist 201 Database certification exam (4/26-5/5) Highlighted

Video: Certification Test Preparation
IT Specialist Database Exam

Expand Collapse IT Specialist 201 Database Exam Information and Resources Highlighted

Video: Certification Test Preparation
GMETRIX Practice Tests To see a video walkthrou...
Exam Prep
IT Specialist Database exam objectives
Quick Summaries
Handout: SQL Quick Reference
Handout: SQL Operators (summary)
Handout: SQL Server Functions (summary)
SQL Server Glossary of Terminology (from Microsoft's website)
SQL Server Cheatsheet
Basic SQL Cheatsheet
SQL Commands Cheatsheet
Web Documents and Handouts organized by exam obje...
1. Database Design
2. Database Object Management using DDL
Clustered and Nonclustered Indexes
Heaps - tables without clustered indexes
Create Unique Indexes
Create Filtered Indexes
3. Data Retrieval
4. Data Manipulation using DML
5. Troubleshooting
Video Tutorialsorganized by exam objectives
Database Design...
Understanding SQL Server Backup and Restore (youtube video)
SQL Server Part 3 - System Databases, Backing Up and Restoring (WiseOwl Youtube Video)
SQL Server Part 4 - Databases, Logins, Users, Roles and Schemas (Wise Owl Youtube Video)
SQL Server Part 5 - Basic Table Design, Data Types and Constraints (Wise Owl Youtube Video)
SQL Server Part 6 - Designing and Creating a Relational Database (Wise Owl Youtube Video)
SQL Server Programming Part 1 - Stored Procedure Basics (Wise Owl Youtube Video)
SQL Server Programming Part 2 - Stored Procedure Parameters (Wise Owl Youtube Video)
SQL Server Programming Part 3 - Variables (Wise Owl Youtube Video)
SQL Server Programming Part 4 - Output Parameters & Return Values (Wise Owl Youtube Video)
SQL Server Programming Part 5 - IF Statements (Wise Owl Youtube Video)
SQL Server Programming Part 6 - WHILE Loops (Wise Owl Youtube Video)
SQL Server Programming Part 7 - User Defined Functions (Wise Owl Youtube Video)
SQL Server Programming Part 8 - Temporary Tables (Wise Owl Youtube Video)
SQL Server Programming Part 9 - Table Variables (Wise Owl Youtube Video)
SQL Server Programming Part 13 - Dynamic SQL (Wise Owl Youtube Video)
SQL Server Programming Part 14 - Transactions (Wise Owl Youtube Video)
SQL Server Programming Part 15 - DML Triggers (Wise Owl Youtube Video)
SQL Server Programming Part 16 - DDL Triggers (Wise Owl Youtube Video)
Database Object Management using DDL...
DDL Commands In SQL
Michael Fudge - Part 1: Create Table (DDL) and Insert Data (DML)
Michael Fudge - Part 2: ALTER TABLE and add CONSTRAINTS
Michael Fudge Part 3: Alter table (DDL), Insert, Update and Delete data (DML)
Data Retrieval...
SQL Server Queries Part 5 - CASE Expressions (Wise Owl Youtube video)
SQL Server Queries Part 6 - JOINS (Inner and Outer Joins) Wise Owl Youtube Video
SQL Server Queries Part 7 - Using Functions in Queries (Wise Owl Youtube Video)
SQL Server Part 7 - Computed Columns (Wise Owl Youtube Video)
SQL Server Queries Part 8 - Text Calculations (Wise Owl Youtube Video)
SQL Server Queries Part 9 - Date Calculations (Wise Owl Youtube Video)
SQL Server Queries Part 10 - GROUP BY and HAVING (Wise Owl Youtube Video)
SQL Server Queries Part 11 - Subqueries (Wise Owl Youtube Video)
SQL Server Queries Part 12 - Correlated Subqueries (Wise Owl Youtube Video)
SQL Server UNION Query Example (youtube video)
SQL UNION, INTERSECT, EXCEPT (youtube video)
Data Manipulation using DML...
Michael Fudge - Part 1: Create Table (DDL) and Insert Data (DML)
Michael Fudge Part 3: Alter table (DDL), Insert, Update and Delete data (DML)
Troubleshooting...
How to Solve SQL Problems

Expand Collapse Week 14(4/24-5/7): Project Showcase Peer Review, GitHub and ePortfolio Highlighted

Video: Week 14 Overview
Job Preparation Activities
Commit final project to GitHub and provide a link to your repository here!
Directions for ePortfolio
Dropbox for e-Portfolio link

Expand Collapse Week 13(4/17-4/24) Chapter 16 Transaction Processing, Chapter 17 Database Security and Term Project Showcase Highlighted

Video: Week 13 Overview
Register at Certiport for your exam (www.certiport.com)
EXTRA CREDIT: CIT Industry Night Out - 20 Fathoms (4/21)
Chapter 16: How to Manage Transactions & Locki...
Lecture/Demo: Chapter 16: How to Manage Transactions and Locking
Chapter 16 Textbook Assignment Directions
Dropbox for Chapter 16 Textbook Assignment
Chapter 17: How to Manage Database Security
Lecture/Demo: Chapter 17: How to Manage Database Security
Chapter 17: Textbook Assignment Directions
Dropbox for Chapter 17 Textbook Assignment
Unit Test
Unit 5 Quiz (chapters 15,16 and 17)
Term Project
Term Project Showcase Directions
Discussion Forum: Final Project showcase (click for directions)
Course Resources... (copy) (copy) (copy)
Chapter 16 slides
Chapter 16 Exercise Solutions
Chapter 17 slides
Chapter 17 Exercise Solutions

Expand Collapse Week 12 (4/10-4/17): Chapter 15 - Coding Procedures, Functions and Triggers Highlighted

Video: Week 12 Overview
Chapter 15: Coding Procedures, Functions and Trigg...
Lecture/Demo: Chapter 15 How to code stored procedures, functions and triggers
Textbook Assignment Directions
Dropbox for Chapter 15 Textbook Assignment
Final Project Milestone #3 Lab Assignment
Dropbox for Milestone #3 Assignment Scripts
Course Resources... (copy) (copy)
Choice between SPs, Functions, Views, and Triggers
SQL Server Programming Part 1 - Stored Procedure Basics (Wise Owl Youtube Video)
SQL Server Programming Part 2 - Stored Procedure Parameters (Wise Owl Youtube Video)
SQL Server Programming Part 7 - User Defined Functions (Wise Owl Youtube Video)
SQL Server Programming Part 15 - DML Triggers (Wise Owl Youtube Video)
SQL Server Programming Part 16 - DDL Triggers (Wise Owl Youtube Video)
Creating simple stored procedures
Simple Insert, Update and Delete Trigger Tutorial
SQL file that creates the db and tables for the trigger exercise
Murach Chapter 15 slides
Chapter 15 Exercise Solutions

Expand Collapse Week 11 (4/3-4/10): Chapter 14 - Coding Scripts Highlighted

Video: Week 11 Overview
Chapter 14: How to Code Scripts
Lecture/Demo: Chapter 14 How to Code Scripts
Chapter 14 Textbook Assignment Directions
Dropbox for Chapter 14 Textbook Assignment
Chapter 14 Lab Assignment
Dropbox for Chapter 14 Lab Assignment Scripts
EXTRA CREDIT: CIT Industry Night Out - Disability Networks (4/5)
EXTRA CREDIT: CIT Fun Night (4/8)
Unit Test
Unit 4 Quiz (chapters 9,13,14)
Course Resources... (copy)
SQL Server Programming Part 3 - Variables (Wise Owl Youtube Video)
SQL Server Programming Part 5 - IF Statements (Wise Owl Youtube Video)
SQL Server Programming Part 6 - WHILE Loops (Wise Owl Youtube Video)
SQL Server Programming Part 8 - Temporary Tables (Wise Owl Youtube Video)
SQL Server Programming Part 9 - Table Variables (Wise Owl Youtube Video)
SQL Server Programming Part 11 - Common Table Expressions (CTEs) (Wise Owl Youtube Video)
SQL Server Programming Part 12 - Cursors (Wise Owl Youtube Video)
Murach Chapter 14 slides
Chapter 14 Exercise Solutions

Expand Collapse Week 10 (3/20-3/27): Chapter 13 - Views and Chapter 9 Functions Highlighted

Video: Week 10 Overview
Chapter 9: How to work with Functions
Lecture/Demo: Chapter 9 How to Work with Functions
Chapter 9 Textbook Assignment Directions
Wages script (need for textbook assignment)
Dropbox for Chapter 9 Textbook Assignment
Chapter 9 Lab Assignment Directions
Dropbox for Chapter 9 Lab Assignment Scripts
Chapter 13: How to work with Views
Lecture/Demo: Chapter 13 How to Work with Views
Chapter 13 Textbook Assignment Directions
Dropbox for Chapter 13 Textbook Assignment
Final Project Milestone #3 Directions - Creating Views
Dropbox for Final Project Milestone #3 View Scripts
Course Resources...
Youtube Video: SQL Server Queries Part 7 - Using Functions in Queries (Wise Owl Tutorials)
Youtube Video: SQL Server Queries Part 5 - CASE Expressions (Wise Owl Tutorials)
Murach Chapter 9 slides
SQL Server Developers Factsheet
SQL Server Functions - cheat sheet
SQL Server Date time Function Cheat Sheet
Chapter 09 Exercise Solutions
Creating Views
Murach Chapter 13 slides
Chapter 13 Exercise Solutions

Expand Collapse Week 9 (3/13-3/20): Chapter 6 Subqueries Highlighted

Video: Week 9 Overview
Chapter 6: Subqueries
Lecture/Demo: Chapter 6 How to Code Subqueries
Textbook Assignment Directions
Dropbox for Chapter 6 Textbook Assignment
Lab Assignment Directions
Dropbox for Chapter 6 Lab Assignment
Unit Test
Unit 3 Quiz (covers chapters 5,6,7)
Course Resources... (copy) (copy)
Chapter 6 slides
Chapter 06 Textbook Examples
SQL Server Queries Part 11 - Subqueries (Wise Owl Youtube Video)

Expand Collapse Week 8(3/6-3/13): Chapter 5: Summary Queries Highlighted

Video: Week 8 Overview
Chapter 5: Summary (Aggregate) Queries
Lecture/Demo: Chapter 5 Aggregate (Summary) Queries
Chapter 5 Textbook Assignment Directions
Dropbox for Chapter 5 Textbook Assignment
Final Project Milestone #3 Directions - Aggregate Functions
Dropbox for Final Project Milestone #3 Assignment - Creating Aggregate (Summary) Queries
Ch 5 Jeopardy (optional)
Extra Credit (copy)
SQL Server Extensions (Extra Credit Assignment)
Dropbox for SQL Server Extensions (Extra Credit Assignment)
Course Resources... (copy)
Murach Chapter 5 slides (abridged)
Chapter 05 Textbook Examples
Youtube Video: SQL Server Queries Part 10 - GROUP BY and HAVING (WIseOwl Tutorials)
Youtube Video: SQL Aggregation queries using Group By, Sum, Count and Having
SQL Server Queries Part 10 - GROUP BY and HAVING (Wise Owl Youtube Video) (copy)
SQL Server Queries Part 12 - Correlated Subqueries (Wise Owl Youtube Video) (copy)

Expand Collapse Week 7 (2/27-3/6): Chapter 7 - Inserting, Updating and Deleting Data and Term Project Milestone #2 Highlighted

Video: Week 7 Overview
Chapter 7: Inserting, Updating and Deleting Data
Lecture/Demo: Chapter 7 Inserting, Updating and Deleting Data
Textbook Assignment Directions
Dropbox for Chapter 7 Textbook Assignment
Final Project Milestone #2 Directions - Adding Data to Tables
Dropbox for Final Project Assignment - Adding Data to Tables
Term Project
Term Project Mini-Showcase 1 Directions
Discussion Forum: Final Project mini showcase. Click to see directions and the grading rubric
Course Resources...
Murach Chapter 7 slides
Chapter 07 Textbook Examples

Expand Collapse Week 6 (2/20-2/27): Chapter 11 - Creating tables using SQL and Chapter 12: Creating tables using SSMS Highlighted

Video: Week 6 Overview
Chapter 11: Creating Tables Using SQL
Lecture/Demo: Chapter 11 Creating a Database and its' Tables using SQL
Textbook Assignment Directions - Chapter 11
Dropbox for Chapter 11 Textbook Assignment
Chapter 12: Creating Tables Using SSMS
Lecture/Demo: Chapter 12 Creating a Database and its' Tables using SSMS
Textbook Assignment Directions - Chapter 12
Dropbox for Chapter 12 Textbook Assignment
Term Project
Final Project Milestone #2 Directions - Creating tables and constraints (not due until 3/6)
Dropbox for Final Project Milestone #2
Unit Test
Unit 2 Quiz (covers chapters 8,10,11,12)
Course Resources... (copy)
Tutorial on constraints
SQL Server Part 5 - Basic Table Design, Data Types and Constraints (Wise Own Youtube Video)
SQL Server Part 6 - Designing and Creating a Relational Database (Wise Own Youtube Video)
Murach Chapter 11 slides
Chapter 11 Exercise Solutions
Murach Chapter 12 slides
Chapter 12 Exercise Solutions

Expand Collapse Week 5(2/13-2/20) Database Design Lab for Term Project Milestone: Database Design Highlighted

Video: Week 5 Overview
Term Project (copy)
Final Project Milestone #1 Directions
Dropbox for Final Project Milestone #1
Discussion
Discussion: Legal and ethical issues involved in data sharing

Expand Collapse Week 4 (2/6-2/13): Chapter 8 - Data Types and Chapter 10: Database Design Highlighted

Video: Week 4 Overview
Chapter 8: Data Types
Lecture/Demo: Chapter 8
Chapter 10 Database Design
Lecture/Demo: Chapter 10 Database Design
Chapter 10 Textbook Assignment Directions
Dropbox for Chapter 10 Textbook Assignment
Functional Dependency in DBMS
Database Normalization and Primary Keys
Course Resources... (copy) (copy)
Chapter 8 Terms
Murach Chapter 8 slides
Chapter 08 Textbook Examples
A Simple Guide to Five Normal Forms in Relational Database Theory
Normalization Exercise
Murach Chapter 10 slides
Chapter 10 Exercise Solutions

Expand Collapse Week 3 (1/30-2/6): Chapter 4-Retrieving Data from Multiple Tables Highlighted

Video: Week 3 Overview
Chapter 4 Retrieving Data from Multiple Tables
Lecture/Demo: Chapter 4 Key Points
Chapter 4 Textbook Assignment Directions
Dropbox for Chapter 4 Textbook Assignment
Chapter 4 Lab Assignment Directions
Dropbox for Chapter 4 Lab Assignment
Unit Test
Unit 1 Quiz (chapters 1,2,3,4)
How's this online class going so far?
Course Resources... (copy) (copy) (copy) (copy)
Chapter 4 terms
Murach Chapter 4 slides
Youtube Video: SQL SERVER UNION QUERY EXAMPLE
Youtube Video: SQL UNION, INTERSECT, EXCEPT
Youtube Video: SQL Server Queries Part 1 - Writing Basic Queries (from WiseOwl)
Youtube Video: SQL Server Queries Part 6 - JOINS (Inner and Outer Joins) (from WiseOwl)
Youtube Video: SQL Server Queries Part 2 - ORDER BY (Sorting in Queries) (from WiseOwl)
Youtube Video: SQL Server Queries Part 3 - WHERE (Criteria in Queries) (from WiseOwl)
Youtube Video: SQL Server Queries Part 4 - Calculated Columns in Queries (from WiseOwl)

Expand Collapse Week 2 (1/23-1/30): Chapter 2- Using SSMS & Chapter 3 - Retrieving data from a single table Highlighted

Video: Week 2 Overview
Chapter 2 Using SSMS (copy)
Lecture/Demo: Chapter 2 Key Points
Chapter 2 Textbook Assignment Directions
Dropbox for Chapter 2 textbook assignment
Filegroup backup and restores
Chapter 3 Retrieving Data from a Single Table
Lecture/Demo: Chapter 3 Key Points
Chapter 3 Textbook Assignment Directions
Dropbox for Chapter 3 Textbook Assignment
SQL LIKE Operator
SQL Wildcard Characters
Course Resources... (copy) (copy) (copy)
Chapter 2 terms
Murach Chapter 2 slides
Chapter 3 terms
Murach Chapter 3 slides
With Ties Information
w3schools SQL Tutorial

Expand Collapse Week 1 (1/14-1/23): Course Information, Chapter 1- Intro to Relational DB & SQL Highlighted

Video: Course Overview
Instructor Welcome Message
Course Syllabus
College Syllabus
Course Assignment Schedule
Campus Safety Video
Student Profile Glossary
Discussion Forum: Class Introductions
Chapter 1 Relational Databases & SQL
Lecture/Demo: Chapter 1 Key Points
Required Software and Database files
Directions:1) SQL Server must be installed first ...
1. Link to SQL Server Developer Edition Download
2. Link to SSMS download
3. Murach database download
4. Northwind and Pub database download
5. Link to WorldWide Importer database download
Course Resources... (copy) (copy) (copy) (copy)
Chapter 1 Terms
Chapter 1 terms
Murach Chapter 1 slides

Expand Collapse OPTIONAL: Database Resources and Software Highlighted

SQL Server Resources...
Murach Textbook Website
eBook: MS SQL Server (tutorialspoint)
eBook: Introducing Microsoft SQL Server 2016
Handout: SQL Quick Reference
Handout: SQL Server Functions
Handout: SQL Operators
Handout: SQL Server Data Types
Steve Stedman SQL JOIN Posters
Database Files and Test Data Resources
Murach database download
Northwind & Pub sample databases
WorldWideImporters Full OLTP Database
World Wide Importers sample database
Software Resources
SQL Server Developer and Express Downloads
Download SSMS
Microsoft Imagine NMC Web Store
Free Code Format - Code Conversion Utility
LucidChart
Get a Free LucidChart Account
Draw.io online charting tool
Office 365 Download Site
Test Data
FreeDataGenerator.com
GenerateData.com

Expand Collapse Extras Highlighted