Skip to main content
Side panel
Library
Online Learning Orientation
College Syllabus
Online Tutoring
Class Cancellations
Student Services
Academic & Career Advising
Academic Success Coaching
My Success
Tutoring Center
Writing & Reading Center
Help
Student Knowledgebase
Faculty Knowledgebase
Keep Learning
Keep Teaching
Submit a Ticket
More
Search
Close
Search
Toggle search input
You are currently using guest access
Log in
Library
Online Learning Orientation
College Syllabus
Online Tutoring
Class Cancellations
Student Services
Collapse
Expand
Academic & Career Advising
Academic Success Coaching
My Success
Tutoring Center
Writing & Reading Center
Help
Collapse
Expand
Student Knowledgebase
Faculty Knowledgebase
Keep Learning
Keep Teaching
Submit a Ticket
Open course index
Home
NMC Community
Teaching SOLUTIONS
CIT178 Sample
Week 15: IT Specialist 201 Database certification exam (4/26-5/5)
Video: Certification Test Preparation
Video: Certification Test Preparation
Click on
Video: Certification Test Preparation
to open the resource.
◄ EXTRA CREDIT: Test of Everyday Reasoning with Numeracy (TER-N) 20 Points
Jump to...
Jump to...
Livestream Link for Office Hours
News & Announcements from your instructor
Student Questions/Answers
EXTRA CREDIT: Test of Everyday Reasoning with Numeracy (TER-N) 20 Points
IT Specialist Database Exam
Video: Certification Test Preparation
IT Specialist Database exam objectives
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
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
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)
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)
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)
Michael Fudge - Part 1: Create Table (DDL) and Insert Data (DML)
Michael Fudge Part 3: Alter table (DDL), Insert, Update and Delete data (DML)
How to Solve SQL Problems
Video: Week 14 Overview
Commit final project to GitHub and provide a link to your repository here!
Directions for ePortfolio
Dropbox for e-Portfolio link
Video: Week 13 Overview
Register at Certiport for your exam (www.certiport.com)
EXTRA CREDIT: CIT Industry Night Out - 20 Fathoms (4/21)
Lecture/Demo: Chapter 16: How to Manage Transactions and Locking
Chapter 16 Textbook Assignment Directions
Dropbox for Chapter 16 Textbook Assignment
Lecture/Demo: Chapter 17: How to Manage Database Security
Chapter 17: Textbook Assignment Directions
Dropbox for Chapter 17 Textbook Assignment
Unit 5 Quiz (chapters 15,16 and 17)
Term Project Showcase Directions
Discussion Forum: Final Project showcase (click for directions)
Chapter 16 slides
Chapter 16 Exercise Solutions
Chapter 17 slides
Chapter 17 Exercise Solutions
Video: Week 12 Overview
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
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
Video: Week 11 Overview
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 4 Quiz (chapters 9,13,14)
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
Video: Week 10 Overview
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
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
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
Video: Week 9 Overview
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 3 Quiz (covers chapters 5,6,7)
Chapter 6 slides
Chapter 06 Textbook Examples
SQL Server Queries Part 11 - Subqueries (Wise Owl Youtube Video)
Video: Week 8 Overview
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)
SQL Server Extensions (Extra Credit Assignment)
Dropbox for SQL Server Extensions (Extra Credit Assignment)
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)
Video: Week 7 Overview
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 Mini-Showcase 1 Directions
Discussion Forum: Final Project mini showcase. Click to see directions and the grading rubric
Murach Chapter 7 slides
Chapter 07 Textbook Examples
Video: Week 6 Overview
Lecture/Demo: Chapter 11 Creating a Database and its' Tables using SQL
Textbook Assignment Directions - Chapter 11
Dropbox for Chapter 11 Textbook Assignment
Lecture/Demo: Chapter 12 Creating a Database and its' Tables using SSMS
Textbook Assignment Directions - Chapter 12
Dropbox for Chapter 12 Textbook Assignment
Final Project Milestone #2 Directions - Creating tables and constraints (not due until 3/6)
Dropbox for Final Project Milestone #2
Unit 2 Quiz (covers chapters 8,10,11,12)
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
Video: Week 5 Overview
Final Project Milestone #1 Directions
Dropbox for Final Project Milestone #1
Discussion: Legal and ethical issues involved in data sharing
Video: Week 4 Overview
Lecture/Demo: Chapter 8
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
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
Video: Week 3 Overview
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 1 Quiz (chapters 1,2,3,4)
How's this online class going so far?
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)
Video: Week 2 Overview
Lecture/Demo: Chapter 2 Key Points
Chapter 2 Textbook Assignment Directions
Dropbox for Chapter 2 textbook assignment
Filegroup backup and restores
Lecture/Demo: Chapter 3 Key Points
Chapter 3 Textbook Assignment Directions
Dropbox for Chapter 3 Textbook Assignment
SQL LIKE Operator
SQL Wildcard Characters
Chapter 2 terms
Murach Chapter 2 slides
Chapter 3 terms
Murach Chapter 3 slides
With Ties Information
w3schools SQL Tutorial
Video: Course Overview
Instructor Welcome Message
Course Syllabus
College Syllabus
Course Assignment Schedule
Campus Safety Video
Student Profile Glossary
Discussion Forum: Class Introductions
Lecture/Demo: Chapter 1 Key Points
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
Chapter 1 Terms
Chapter 1 terms
Murach Chapter 1 slides
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
Murach database download
Northwind & Pub sample databases
WorldWideImporters Full OLTP Database
World Wide Importers sample database
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
FreeDataGenerator.com
GenerateData.com
IT Specialist Database Exam ►
Copyright © Northwestern Michigan College (2024). All rights reserved.